gnumed-devel
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


From: Karsten Hilbert
Subject: Re: [Gnumed-devel] import patient data - basic procedure
Date: Mon, 29 Apr 2013 12:14:06 +0200
User-agent: Mutt/1.5.21 (2010-09-15)

The following was misaligned. It should have been:

> > Background details:
> > 
> > 1. Creating usable patient's data requires inserting records to both
> > dem.identity and dem.names tables.
> 
> That is correct. It requires 2 (or three) SQL statements:
> 
>       set default_transaction_read_only to off;
>       insert into dem.identity (gender, dob) values ('m/f/tf/tm/h', now() - 
> age);
>       insert into dem.names (id_identity, lastnames, firstnames) values 
> (pk_of_identity, 'Last Name', 'First Name');
> 
> > 2. Creating an encounter which is properly placed in EMR tree requires
> > adding an episode.
> 
> Correct.
> 
> > But you cannot add episode until you have encounter.
> 
> True. That does not mean a catch-22, however:
> 
> 1) create encounter
> 2) create episode linked to encounter
> 
> Done. Yes, it requires 3 SQL statements.
> 
>       set default_transaction_read_only to off;
>       INSERT INTO clin.encounter (fk_patient) values ('pk of the patient you 
> are interested in');
>       INSERT INTO clin.episode (fk_encounter, description) values 
> (pk_of_encounter, 'new episode');

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



reply via email to

[Prev in Thread] Current Thread [Next in Thread]