Re: [Gnumed-devel] import patient data - basic procedure

[Karsten Hilbert]

On Sun, Apr 28, 2013 at 08:01:10PM +0200, Jerzy Luszawski wrote:

> ???CREATE OR REPLACE FUNCTION clin.insert_full_episode(
>   _pk_identity integer, 
>   _date timestamp with time zone,
>   _health_issue integer,
>   _episode_d text,
>   _encounter_RFE text,
>   _encounter_AOE text,
>   _encounter_type integer,
>   _s text,
>   _o text,
>   _a text,
>   _p text
>   )
>   RETURNS boolean AS
> $BODY$
> begin
> 
> -- encounter: ------------------------------------------------
> insert into clin.encounter (
>       fk_patient,
>       fk_type,
>       started,
>       reason_for_encounter,
>       assessment_of_encounter
> ) values (
>       _pk_identity,
>       _encounter_type,
>       _date,
>       _encounter_RFE,
>       _encounter_AOE
> );

Note that I have just recently discovered that GNUmed lacked
a constraint for clin.encounter.started <=
clin.encounter.last_affirmed which I am currently adding.
Just so are aware of that.

Note that the above will fail if _date is > now().

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