Our approach is to apply a series of validation/cleansing steps to copies of Clarity/Administrative data in our staging tables, and then apply two sets of transformations - one that generates the i2b2 content, the other generating the Pcornet content.
Certain synthetic data that are generated in intermediate steps are common to both - e.g., surrogate patient IDs and encounter IDs happen to be shared between the PCORNET and I2b2 data models. So the end-result is identical to first transforming into i2b2, and then transforming I2b2 into PCORNET (which would involve swiveling the entire data model) - and the ETL code architecture is much cleaner. -----Original Message----- From: GPC Informatics [mailto:[email protected]] Sent: Tuesday, January 17, 2017 4:34 PM To: [email protected]; [email protected]; [email protected] Cc: [email protected]; [email protected]; Nadkarni, Prakash Subject: Re: [gpc-informatics] #503: UMN CDM ETL reflects data quality of i2b2 store? #503: UMN CDM ETL reflects data quality of i2b2 store? --------------------------+------------------------- Reporter: rwaitman | Owner: rwaitman Type: design-issue | Status: assigned Priority: major | Milestone: cdm-cycle3 Component: data-quality | Resolution: Keywords: | Blocked By: Blocking: | --------------------------+------------------------- Changes (by dconnolly): * owner: jdale => rwaitman * status: new => assigned Comment: At HackathonFour, Russ took the ball to follow with Tim and G. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/503#comment:10> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics ________________________________ Notice: This UI Health Care e-mail (including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521 and is intended only for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If you are not the intended recipient, any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately and delete or destroy all copies of the original message and attachments thereto. Email sent to or from UI Health Care may be retained as required by law or regulation. Thank you. ________________________________ _______________________________________________ Gpc-dev mailing list [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev
