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 nullshould 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?