[Gnumed-devel] Test results schema question re method of acquiring the result

[J Busser]

How/where is the information to be stored if a doctor should want to 
manually enter into test_result data that arrived on paper from a lab 
organization?

The table supports test_type_id which uniquely identifies a 
test_result as a test of type <code> originating from a particular 
organization.

A user might be allowed to pick (or specify) the source of the 
test_result from existing values for  test_type_id or to create a new 
row in test_type.

However it might be useful/important to distinguish whether the row 
inserted into test-result had been manually entered or had come via a 
particular software module/interface/script.

Among the auditing fields is modified_by which is NOT NULL DEFAULT 
'current_user' but what value is written in here when the row is 
created as part of an import?

Should there be a field "origin" or "interface" or "source" or 
"import_method" that might usefully specify the interface or script 
though which the value as imported or -- in the case of a manual 
entry -- the widget through which the result was entered?