search

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

Data Ingestion and Harmonization
41 stars 12 forks source link

Death record requirements in OMOP #39

Closed DaveraGabriel closed 2 years ago

DaveraGabriel commented 4 years ago

OMOP requires a date / time stamp for death in order to support analyses. In many cases, as with data coming from the ACT CDM, there will not be this level of detail. Rather, at times there is only a record that asserts that a person is "known deceased." The reason for this is that most of the them, death is not occurring in a hospital. As such death records are not a part of a legal EMR.

Obtaining legal death records can be achieved, albeit can be cumbersome. Legal jurisdiction of death records is varied, typically at the state level. The Social Security Administration Death Master file (SSADMF) is a common source of records for research. Although updated on a weekly or monthly basis, because administrative processing of death records is so decentralized, the SSADMF often has missing records due to latency in the consolidating process variation from each state. If the identity of an individual is known, Death records can be requested from the Medicare Master Beneficiary Summary File (MMBSF)

The issue for N3C data ingestion is two fold:

 a) death records without date / time stamps cannot go onto the standard OMOP Model
 b) deaths occurring outside of hospitals will not be in EMRs

Options to consider 1) "known deceased" records with no dates could go into a N3C OMOP extension 2) Alternative sources of legal death records outside of EMRs / CDMs could be sought (SSADMF or MMBSF 3) Business rules & corollary workflows would need to be developed for any altternate sources of death records

cyaghmour commented 4 years ago

This issue also impacts PCORNET. If the PCORNET-DEATH record exists but the death_date is null: 1- should an OMOP death record be created? 2- If the answer to (1) is yes, how should the OMOP death_date be defaulted? (death_date is mandatory in OMOP)

stephanieshong commented 2 years ago

We allow missing death date if the patient is recorded as expired with the missing death date. We have made number of changes to N3C OMOP instance in order not to loose the patient expired status data. We allow null for death date.

stephanieshong commented 2 years ago

N3C allows null for death cause concept id.