What to do when year_of_birth is missing from the source and cannot be derived

[burrowse]

What to do when year_of_birth is missing from the source and cannot be derived

CDM or THEMIS convention?

CDM

Is this a general convention?

Yes (in that it affects the overall population of records in the CDM)

Summary of issues

• There may be cases in the source data where the year of birth is not explicitly available and cannot be derived from other sources such as age buckets or categorization.

Summary of answer

• If no year of birth is available the person and accompanying data should be dropped from the CDM instance.
• Reasons for removal of persons should be documented in the ETL documentation and METADATA table (insert row in METADATA where metadata.name='count of removed persons' and metada.value_as_string='xyz' where xyz is a number (e.g., 12)

Related links

• CDM Website: https://ohdsi.github.io/CommonDataModel/cdm54.html#person
• OHDSI Forums(Mandatory Fields in the person table): https://forums.ohdsi.org/t/mandatory-fields-in-the-person-table/1618/20
• Eliminating persons in Themis: https://forums.ohdsi.org/t/eliminating-persons-themis-wg3-topic-2/3974/14
• Persons Not have year_of_birth: https://forums.ohdsi.org/t/person-not-have-year-of-birth/16566/5
• Missing birth date: https://forums.ohdsi.org/t/missing-birth-date/18251
• https://github.com/OHDSI/Themis/issues/9

[clairblacketer]

Create a general convention page on the CDM about rules of person inclusion