How to populate birth_datetime when day_of_birth/month_of_birth/time of birth is not provided in the source

[burrowse]

How to populate birth_datetime when day_of_birth/month_of_birth/time of birth is not provided in the source

CDM or THEMIS convention?

Themis

Is this a general convention?

No

Summary of issues

• Populating the birth_datetime field when day_of_birth/month_of_birth/time of birth is not provided in the source and only year_of_birth is available/populated

Summary of answer

Use the following logic to infer the date:

• If day_of_birth is null and month_of_birth is not null then use the first of the month in that year.
• If month_of_birth is null or if day_of_birth AND month_of_birth are both null and the person has records during their year of birth then use the date of the earliest record, otherwise use the 15th of June of that year.
• If time of birth is not given use midnight (00:00:0000).

Related links

• CDM Website: https://ohdsi.github.io/CommonDataModel/cdm54.html#person

[MaximMoinat]

Issue # and location

93 Themis Github

Issue Summary How to populate the birth_datetime field when any or all of day/month/time of birth is not provided in the source.

Convention type Table specific

CDM table Person

CDM field birth_datetime

Links to issue discussion NA

Provenance of data General

The ratified convention Use the following logic to infer the birth_datetime value:

• If only year of birth is given and the person has records during their year of birth - then use the date of the earliest record
• If only year of birth is given, and there are no records during their year of birth, use the 15th of June of that year.
• If year of birth and month of birth are given, but no day of birth, then use the first day of the month in that year.
• If time of birth is not given use midnight (00:00:0000).

Date of ratification/published 2021-09-25 (CDM v5.4 release)

Downstream implications No, birth_datetime is little used in OHDSI tooling.

Link to DQD check plausibleAfterBirth

*Related conventions/further information NA

#Tags person, birth, dob

[clairblacketer]

This looks good to me @MaximMoinat and @burrowse ! I will move it to over to be built.

[clairblacketer]

Opened PR #117

[clairblacketer]

reopening as it may not be necessary to provide guidance for non-required fields