OHDSI Home | Forums | Wiki | Github

Death events in CDM V6

(Ajit Londhe) #1

Hi all,

In the CDM V6 wiki, the following convention is established for death:

The DEATH_DATETIME in the PERSON table should not be used as the way to find all deaths

  • select * from PERSON where death_datetime is not null should not be the practice
  • Rather, deaths should be found through the OBSERVATION table and the PERSON table is only used to determine which death date should be used in analysis

If the person table has the best available death dates for all dead patients, what is the consequence of simply querying from PERSON.death_datetime to find all dead patients? Certainly that query alone can’t get you death cause(s) or other context, but would it really be a faulty query if all you’re trying to do is identify who is dead and when?


(Christian Reich) #2


You are absolutely right. We are in the process of revising these definitions. Please hold on.

Whether or not your query is legitimate depends on whether death is captured with sufficient sensitivity. Has nothing to do with death per so.

(Ajit Londhe) #3

Thanks @Christian_Reich! I’ve opened a Git issue: