Hello!
I was investigating how to build Death table. And I got very interesting question. Sometimes death could be defined from death diagnoses, which should go to “cause_concept_id” in the Death table.
Ex. ICD9CM code = 798.0 (‘Sudden death, cause unknown’) belongs to Condition domain.
My questions is: if a cause of death belongs to ‘Condition’ domain should we add a record, associated with this code, to cdm Condition_occurrene table as well?
My thoughts:
- In conventions of the Condition_occurrence table there are no restrictions on the diagnoses indicating death.
- As far as I know, in the case of multiple death diagnoses on the same death_date, in the Death table should be just one cause of death per person. We could pull all other death causes belonging to Condition domain to Condition_occurrence table. In this case, we will have all causes of death in our CDM and will not loose any information.
Looking forward hearing from you!