Re: [Gnumed-devel] Medication lists - Duration - Started

[Karsten Hilbert]

On Mon, Jul 29, 2013 at 05:39:40PM +0000, Jim Busser wrote:

> This existing requirement for me to input, in the case of medications 
> initiated *outside* the praxis, by some *outside* clinician, months or years 
> ago,
> 
>       clin_when (date started)
> 
>  is continuing to prove highly frustrating for the sense of risk that it 
> creates around perpetuating within (and flowing outside) the praxis this 
> pseudo-accurate information ...
> 
> Until this issue is within GNUmed resolved, can I
> 
> 1) remove the constraint clin_when NOT NULL, and
> 
> 2) at my next GNUmed database upgrade,
> 
>       replace all missing values for clin_when with January 1, 1900
>       reapply the constraint
>       perform the upgrade
>       remove the constraint
>       replace all values for clin_when with NULL where clin_when = January 1, 
> 1900
> 
> ? 

It'll bite you in various places.

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346