#145: transform i2b2 query results to PCORNet CDM --------------------------+------------------------ Reporter: dconnolly | Owner: ngraham Type: enhancement | Status: assigned Priority: major | Milestone: popmednet Component: data-sharing | Resolution: Keywords: | Blocked By: 109 Blocking: 144 | --------------------------+------------------------ Changes (by dconnolly):
* owner: dconnolly => ngraham * status: new => assigned Comment: We can start on this to answer queries for #144; for example, to count unique DEMOGRAPHICS.PATID: {{{ with demographics as ( select pd.patient_num patid, case when bio.concept_cd is not null then 'Y' else 'N' end biobank_flag from blueherondata.patient_dimension pd left join blueherondata.observation_fact bio on bio.patient_num = pd.patient_num and bio.concept_cd like 'KUMC|BSR|SAMPLE_DESC:%' ) select count(distinct d.patid) from demographics d; }}} Not directly related to #144 perhaps, but by way of example of integrating info from the fact table: {{{ with demographics as ( select pd.patient_num patid, case when bio.concept_cd is not null then 'Y' else 'N' end biobank_flag from blueherondata.patient_dimension pd left join blueherondata.observation_fact bio on bio.patient_num = pd.patient_num and bio.concept_cd like 'KUMC|BSR|SAMPLE_DESC:%' ) select count(distinct d.patid) from demographics d where biobank_flag = 'Y'; }}} -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/145#comment:3> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics _______________________________________________ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev