#252: collect test results of Weight and Height cohort selection queries from
all
sites
--------------------------+---------------------------------
Reporter: bokov | Owner: gkowalski
Type: task | Status: assigned
Priority: major | Milestone: obesity-survey-def
Component: data-sharing | Resolution:
Keywords: | Blocked By: 210, 250, 251
Blocking: 254 |
--------------------------+---------------------------------
Comment (by dlyoshih):
/* 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 */
--
Ticket URL:
<http://informatics.gpcnetwork.org/trac/Project/ticket/252#comment:5>
gpc-informatics <http://informatics.gpcnetwork.org/>
Greater Plains Network - Informatics
_______________________________________________
Gpc-dev mailing list
[email protected]
http://listserv.kumc.edu/mailman/listinfo/gpc-dev
