|Subject:||[Gnumed-devel] Test results schema question re method of acquiring the result|
|Date:||Thu, 23 Sep 2004 09:23:39 -0700|
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?
|[Prev in Thread]||Current Thread||[Next in Thread]|