This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
documentation:cdm:person [2014/12/06 17:04] cgreich [PERSON] |
documentation:cdm:person [2017/01/08 19:16] cgreich |
||
---|---|---|---|
Line 1: | Line 1: | ||
===== PERSON table ===== | ===== PERSON table ===== | ||
+ | |||
+ | This table changed in version 5.X of the OMOP CDM. The name of the field time_of_birth was changed to birth_datetime. | ||
+ | ---- | ||
The Person Domain contains records that uniquely identify each patient in the source data who is time at-risk to have clinical observations recorded within the source systems. | The Person Domain contains records that uniquely identify each patient in the source data who is time at-risk to have clinical observations recorded within the source systems. | ||
Line 9: | Line 12: | ||
|month_of_birth|No|integer|The month of birth of the person. For data sources that provide the precise date of birth, the month is extracted and stored in this field.| | |month_of_birth|No|integer|The month of birth of the person. For data sources that provide the precise date of birth, the month is extracted and stored in this field.| | ||
|day_of_birth|No|integer|The day of the month of birth of the person. For data sources that provide the precise date of birth, the day is extracted and stored in this field.| | |day_of_birth|No|integer|The day of the month of birth of the person. For data sources that provide the precise date of birth, the day is extracted and stored in this field.| | ||
- | |time_of_birth|No|time|The time of birth at the birth day| | + | |birth_datetime|No|datetime|The date and time of birth of the person.| |
|race_concept_id|Yes|integer|A foreign key that refers to an identifier in the CONCEPT table for the unique race of the person.| | |race_concept_id|Yes|integer|A foreign key that refers to an identifier in the CONCEPT table for the unique race of the person.| | ||
|ethnicity_concept_id|Yes|integer|A foreign key that refers to the standard concept identifier in the Standardized Vocabularies for the ethnicity of the person.| | |ethnicity_concept_id|Yes|integer|A foreign key that refers to the standard concept identifier in the Standardized Vocabularies for the ethnicity of the person.| | ||
Line 32: | Line 35: | ||
* The Provider refers to the primary care provider (General Practitioner). | * The Provider refers to the primary care provider (General Practitioner). | ||
* The Care Site refers to where the Provider typically provides the primary care. | * The Care Site refers to where the Provider typically provides the primary care. | ||
- |