Re: [Gnumed-devel] the state of test measurement storage and display in GNUmed

[Busser, Jim]

On 2013-11-26, at 1:57 PM, Jim Busser <address@hidden> wrote:

and then copying its pk into the column

clin.test_type.fk_meta_test_type

Client 1.4.1 now expresses the clin.test_type column

conversion_unit

as "Base unit" but this remains ambiguous as to whether it might relate to the actual units in which the measurements are being reported.

As an example, height may be recorded as 6 feet, of which the actual base (of feet) might be inches, despite which the unit selected for this test_type column might better be "m".

So … can both the column name, and the representation (label) in the GUI, be changed to

reference_unit

and the schema Description changed so that 'basic' becomes 'chosen reference'

"the chosen reference unit for this test type, preferably SI, used for comparing results delivered in differing units, this does not relate to what unit the test provider delivers results in but rather the unit we think those results need to be converted to in order to be comparable to OTHER results"

It would mean having to update some occurrences of conversion_unit within the client in

gmPathLab.py
gmMeasurementWidgets.py
wxgMeasurementTypeEAPnl.py
Gnumed.wxGladeWidgets.wxgMeasurementTypeEAPnl-pysrc.html
Gnumed.business.gmPathLab-pysrc.html
Gnumed.wxpython.gmMeasurementWidgets-pysrc.html
gnumed-schema.html

and some within the bootstrapper in

gmClinicalData.sql
gmClinicalViews.sql
gnumed-schema.html
gmMeasurements.sql
test_data-James_Kirk.sql
test_data-USS_Enterprise.sql
v9-clin-v_test_results.sql
v10-clin-v_test_results.sql
v11-clin-test_type-dynamic.sql
v11-clin-v_test_results.sql
v11-clin-v_unified_test_types-dynamic.sql
v13-clin-v_test_results.sql
v15-clin-v_test_results.sql
v16-clin-v_test_results.sql
v16-clin-v_test_types.sql
v18-clin-v_test_results.sql
v18-clin-v_test_types.sql

plus the fingerprint although perhaps that will be automatic.

-- Jim