I'm guessing a bit, here... GPC is supposed to align with PCORI CDM; i.e. we're supposed to be able to answer queries w.r.t. that data model.
The PCORI CDM doesn't use an EAV table like i2b2, redcap, and similar systems; it uses ordinary row modelling. So it has a DEMOGRAPHIC table with columns for birth_date, sex, ethinicity (HISPANIC), race, and a few others. So when we report results from our i2b2 data, we'll need to construct rows of that form. So the PATIENTS query Jim sketched, to me, looks like a projection of "select * from CDM.DEMOGRAPHIC" into the i2b2 star schema. When that's represented as an i2b2 counting query, the results would be a count of the number of patients where we have data mapped for all those columns (even if the data is some sort of "unknown" or "not recorded" marker). Or it could be a PDO query (e.g. for the timeline) and the expected results would be, more or less, a PCORI CDM DEMOGRAPHICS table. -- Dan ________________________________________ From: GPC Informatics [[email protected]] Sent: Thursday, June 12, 2014 1:31 PM To: [email protected]; Dan Connolly; [email protected] Cc: [email protected] Subject: Re: [gpc-informatics] #114: Milestone 2.7 GPC harmonizes with PCORI CDM V1.0 #114: Milestone 2.7 GPC harmonizes with PCORI CDM V1.0 ----------------------------------------------+---------------------------- Reporter: campbell | Owner: campbell Type: task | Status: accepted Priority: major | Milestone: initial-data- Component: data-stds | domains Keywords: PCORI CDM V1, GPC data standards | Resolution: Blocking: | Blocked By: 17, 23, 67, | 120 ----------------------------------------------+---------------------------- Comment (by nathan.wilson): Quick Question. What is the purpose of each test and what are the expected/anticipated results for each test in the Milestone_27_TestSQLv4 document? -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/114#comment:19> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics _______________________________________________ Gpc-dev mailing list [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev
