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

[Karsten Hilbert]

On Mon, Apr 29, 2013 at 03:09:41AM +0000, Jim Busser wrote:

> Look at what's already in GNUmed:

> # to query all substances taken by all patients (non-distinct)
> select *
> from
>       clin.substance_intake
> --> generates 19 results
> 
> 
> # to query all directly-referenced substances taken by all patients
> select *
> from
>       clin.substance_intake
>               inner join
>       ref.consumable_substance
>               on 
> (clin.substance_intake.fk_substance=ref.consumable_substance.pk)
> ORDER BY clin_when
> 
> # to query all indirectly-referenced (via brand) substances taken by all 
> patients
> select age(date_trunc('day',now()),date_trunc('day', intake.clin_when)), 
> atc_code, brand.description AS brand, brand.preparation AS form, schedule, 
> aim, duration, intake_is_approved_of, discontinued, narrative
> from
>       clin.substance_intake AS intake
>               inner join
>               ref.lnk_substance2brand
>                       on (intake.fk_drug_component=ref.lnk_substance2brand.pk)
>               inner join
>               ref.branded_drug AS brand
>                       on (brand.pk=ref.lnk_substance2brand.fk_brand)
> ORDER BY clin_when

Some of the above may in one form or another make for a
good/interesting set of statistics run from the report
generator, no ?  Care to reformat them as such inside that
plugin and contribute via list mail ?

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