Re: [Gnumed-devel] Open Source Health Informatics, London, 30th Sep 2010

[Sebastian Hilbert]

Am Samstag 14 August 2010, 14:15:50 schrieb Luke Kenneth Casson Leighton:
> On Sat, Aug 14, 2010 at 12:30 AM, Jim Busser <address@hidden> 
wrote:
> > It is only request_id (not lab_request_id) that is non-NULL, unique so we
> > just need a way to supply a unique value maybe
> > 
> >        CONCATENATE ("gm-", NUM_TO_TEXT (pk_item))
> > 
> >        ... or "gm-" could instead be some configurable per-praxis value.
> 
>  ok - i'll go through it again: if CONCATENATE ("gm-", NUM_TO_TEXT
> (pk_item)) is to go into clin.lab_request.request_id, what do you do
> when you get an observational report from the lab?  overwrite
> clin.lab_request.request_id with OBR003??
> 
Just a side note. If you feel something cannot be stuffed into the existing 
database tables feel free to suggest improvements. Let me says that this 
ordering part for Germany has not yet seen actual use so the table are not set 
in stone.

Sebastian