Re: [Gnumed-devel] unmatched [path] results (was tracking status of "blob" style path results)

[J Busser]

At 9:43 AM +0100 2/14/05, Karsten Hilbert wrote:
> Either 1 of two situations exist:
> >         - the results format has enough metadata to allow us to infer (HL7), or
> >  specifies a priori (?? LDT), what coding system is being used,
> No it does not. LDT does not specify a coding system. In fact,
> no coding system is even used.
>
> Notice that a test_result code does not have to have a coding
> system for it to be imported. Such things can be added at a
> convenient time (eg never in a busy practice) !

If LDT (and therefore the source of your results) uses no coding 
system, do you rely on the fact that the lab *surely* (??) uses some 
arbitrary labelling system ("code") of its own e.g. haemoglobin may 
be "Hgb", haematocrit may be "Hct" and it is with these that you 
populate test_type for that particular test_org?

And so in test_type is the value for coding_system kept "NULL"?

PS in the table test_result the field id should be renamed pk
(better now, than later ;-))