#238: Q1 2015 QA Query
--------------------------+-----------------------------
Reporter: mish | Owner: jvanschyndle@…
Type: enhancement | Status: assigned
Priority: major | Milestone: data-quality3
Component: data-quality | Resolution:
Keywords: data-quality | Blocked By:
Blocking: 232, 262 |
--------------------------+-----------------------------
Comment (by lv):
Tom, are we sending you QA results to you by email or are we waiting for a
REDCap account?
MCRF changes:
Sex - value mapping
Race - value mapping
Hispanic - value mapping
Vital Status - value mapping
\GPC\Vital Signs\LOINC:3137-7\ changed to \i2b2\Visit
Details\Vitals\Height\
\GPC\Vital Signs\LOINC:3141-9\ changed to \i2b2\Visit
Details\Vitals\Weight\
\GPC\Vital Signs\LOINC:59574-4\ changed to \i2b2\Vital
Signs\LOINC:59576-9\
\i2b2_details\* changed to \i2b2\*
\GPC\* changed to \i2b2\*
Concept_Dimension.concept_code changed to Concept_Dimension.concept_cd
c.concept_code = 'ICD09:*' changed to c.concept_cd = 'ICD9CM:*'
For obesity_min_admit_date, add clause: AND b.Start_Date <> '1800-1-1'
In general Encounter Types are stored in our Visit_Dimension table;
changes were made to accommodate this.
--
Ticket URL:
<http://informatics.gpcnetwork.org/trac/Project/ticket/238#comment:13>
gpc-informatics <http://informatics.gpcnetwork.org/>
Greater Plains Network - Informatics
_______________________________________________
Gpc-dev mailing list
[email protected]
http://listserv.kumc.edu/mailman/listinfo/gpc-dev
