Re: [gpc-informatics] #252

[Debbie Yoshihara]

I've reset my password to TRAC, but it doesn't work, so I'll post the 
results for #252 here.

* Generic WI query text */
/* Query 1a */
select count(distinct a.patient_num)
 from observation_fact a, patient_dimension b
where
 a.patient_num = b.patient_num and
 a.start_date >= to_date('12/01/2012','MM/DD/YYYY') and
 a.concept_cd = 'BIO|BMI_PERCENTILE' and
 a.nval_num > 5 and
 b.birth_date >= to_date('04/01/1994','MM/DD/YYYY');
/* April 16, 2015, 80304 rows */

/* Query 1b */
select count(distinct a.patient_num)
 from observation_fact a, patient_dimension b
where a.patient_num = b.patient_num and
 a.start_date >= to_date('12/01/2012','MM/DD/YYYY') and
 a.concept_cd = 'BIO|BMI' and
 a.nval_num >= 18.5 and
 b.birth_date <= to_date('04/01/1995','MM/DD/YYYY');
/* April 16, 2015 290887 rows */

/* For Question 2, since at WI we have other criteria */
/* I could not put it into XML format, so I'm giving */
/* the sql query text w/o the WI criteria */


--
Debbie Yoshihara Informatics Specialist
SMPH-IT, Biomedical Informatics Services
School of Medicine and Public Health, UW-Madison
dlyos...@wisc.edu
Tel:(608)263-5643

_______________________________________________
Gpc-dev mailing list
Gpc-dev@listserv.kumc.edu
http://listserv.kumc.edu/mailman/listinfo/gpc-dev