[Gnumed-devel] Schema question re labs

[James Busser]

In

	http://salaam.homeunix.com/~ncq/gnumed/schema/devel/gnumed- 
schema.html#clin.table.lab-request

there is a field

        request_id

which the schema description says

	ID this request had when sent to the lab LDT: 8310 HL7:  
OBR.filler_order_number

Is this what, in Germany, appears on the labels that you affix to  
your blood tubes, and is this then the number that is input in the  
praxis? In Canada, we would not et this information (which is decided  
by the lab) until the result came back.

There is also a field

        lab_request_id

which is the

        "ID this request had internally at the lab LDT: 8311"

which, therefore, is not something that the praxis controls. In BC  
Canada, it is however possible for the lab to accept --- on the paper  
requisition that we complete and provide to the patient --- a  
reference number that we ourselves can assign, and which the lab will  
return in field ORC 004 (subject to confirmation).

A candidate reference number that may be good to send would be the pk  
which is automatically generated in the table ... any reason it would  
be any bad idea to use this?