National-Clinical-Cohort-Collaborative / Data-Ingestion-and-Harmonization

Data Ingestion and Harmonization
41 stars 12 forks source link

TriNetX Vital Status / Death Date mapping ignored #51

Open DaveraGabriel opened 4 years ago

DaveraGabriel commented 4 years ago

Mapping validation session / review determined that Vital Status would be ignored. Matvey Paluchuk stated he believed this field would be very sparsely populated in most cases. Subsequent mapping validation session (for ACT) regarding vital status data determined that this decision should be revisited for TriNetX.

OMOP has 2 fields to capture death date. Depending on the data, may need to parse into following fields: Death.death_date Death.death_datetime If death_Date is NULL in, we cannot create a OMOP record in death table. SEE Vital_Status comment.