[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

From: J Busser
Subject: [Gnumed-devel] Test results schema question re method of acquiring the result
Date: Thu, 23 Sep 2004 09:23:39 -0700

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?

reply via email to

[Prev in Thread] Current Thread [Next in Thread]