#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
