Multiple Death Records Due to Death_type or Cause - Version 5.4

Issue Name: Multiple Death Records Due to Death_type_concept or Cause_concept Version 5.4

Issue Type: Duplicate records caused by multiple standard concept_ids for death cause or death type (provenance)

Description: http://ohdsi.github.io/CommonDataModel/cdm54.html#DEATH
The table description for the Death table has the following: "A person can have up to one record if the source system contains evidence about the Death". However, an ICD diagnosis code may map to multiple SNOMED codes:

ICD10: J96.21 (Acute on chronic respiratory failure with hypoxia (HCC))
maps to
SNOMED: 389086002 (Hypoxia) and 67905004 (Acute-on-chronic respiratory failure)
This results in two records with the same death date.

Similarly, a person may have death records from multiple systems (provenance), i.e. EHR and death registry.

Suggested Solution: For OMOP version 5.4, allow multiple records in the Death table caused by either the death_type_concept_id and/or cause_concept_id. However the Death_Date(s) must match.

Possible Implications:

• CDM documentation will need to be modified.
• The rules of the DQD (Data Quality Dashboard) will have to be adjusted to match.
• Others?

Related forum post: https://forums.ohdsi.org/t/multiple-death-records-due-to-snomed-mapping/19517

Reported By: Roger Carlson