OHDSI / Themis

Repository for OMOP CDM conventions as defined by THEMIS. These can be reference lists of concepts, pieces of standardized code for data generation or quality certification, and debates.

Apache License 2.0

28 stars 9 forks source link

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

Closed assimilateDave closed 6 months ago

assimilateDave commented 7 months ago

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?

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.

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 https://github.com/OHDSI/CommonDataModel/issues/210

clairblacketer commented 7 months ago

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

MaximMoinat commented 7 months ago

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.