At a high level, our common approach (#160<https://informatics.gpcnetwork.org/trac/Project/ticket/160>) is: code to load the SSDMF data into i2b2 is in the HERON ETL code, and code to to from i2b2 into CDM is in i2p-transform.
In detail: Code to "Update patient_dimension.death_date from SSDMF." starts at line 149 of ssdmf_load.sql<https://github.com/kumc-bmi/heron/blob/master/heron_load/ssdmf_load.sql>. Then i2p-transform puts it into the CDM DEATH table from there. We forked i2p-transform before they supported the death table, so we put it in a supplementary cdm_postproc.sql<https://github.com/kumc-bmi/i2p-transform/blob/master/Oracle/cdm_postproc.sql> file: insert into death select pd.patient_num, pd.death_date, 'N' death_date_impute, 'UN' death_source, -- TODO: We have SSMDF and EMR sources at least 'E' death_match_confidence from "&&i2b2_data_schema".patient_dimension pd where pd.vital_status_cd = 'y'; Looking at the issue we raised<https://github.com/SCILHS/i2p-transform/issues/3>, I see they "translated Jeff's simple Death transform from MSSQL to the Oracle script" on Sep 1. -- Dan ________________________________ From: [email protected] [[email protected]] on behalf of Debbie Yoshihara [[email protected]] Sent: Tuesday, November 15, 2016 9:07 AM To: gpc-dev Subject: CDM Death Table and SSDI Hi, How are sites incorporating the SSDI information into the CDM Death Table? Of the EHR patients that have a death date and a social security number, 63% matched exactly to the SSDI information. There are patients who have erroneous death dates (Jan 01, 1901), so I'm thinking I'll use the SSDI information for those death dates. What other rules/algorithms are people using? --- Debbie Yoshihara University of Wisconsin - Madison
_______________________________________________ Gpc-dev mailing list [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev
