How to populate month or date in death_date if only year or year/month are provided

[assimilateDave]

#Populating the month and/or year in death_date when this is not known or provided in source data

CDM or THEMIS convention?

THEMIS Issue - currently documented in the CDM webpage
https://ohdsi.github.io/CommonDataModel/cdm54.html#death

Table or Field level?

Field level

Is this a general convention?

No

Summary of issues

• Day, month, and year are expected in the death_date field.
• Some source data may not have complete datestamp of the deceased persons death date. An approximation of that date should be used.
• This issue was discussed thoroughly and ratified and could be documented as a Themis convention instead of in the CDM since it may not be applicable to all use cases and data sources.

Summary of answer

• If the precise date include day or month is not known or not allowed, December is used as the default month, and the last day of the month the default day.

Related links

• https://ohdsi.github.io/CommonDataModel/cdm54.html#death

Other comments/notes

• I could not find a directly related issue discussing the use of December and last day of month as defaults in the forums or issues. However it is in the CDM doc as stated and is in an issue/proposal supporting the change to death_datetime in CDM v6 Store death causes in condition_occurrence table CommonDataModel#210

[clairblacketer]

This looks good to me, I am going to move it to Needs Docs

[MaximMoinat]

Issue # and location

Themis issue #104

Issue summary

The death.death_date field has day resolution. Some source data may not have complete datestamp of the deceased persons death date. An approximation of that date should be used.

Convention type

Table

CDM table

death

CDM field

death_date

Links to issue discussion

CDM Documentation

Provenance of data

General

The ratified convention

If the precise date include day or month is not known or not allowed, December is used as the default month, and the last day of the month the default day.

Date of ratification/published

NA

Downstream implications

NA

Link to DQD check

Yes - plausibleDuringLife and plausibleBeforeDeath

Related conventions/further information

NA

#Tags
death, death_date, default