This shows you the differences between two versions of the page.
Next revision | Previous revision Next revision Both sides next revision | ||
documentation:cdm:person [2014/11/17 19:44] cgreich created |
documentation:cdm:person [2017/01/08 19:16] cgreich |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== PERSON ===== | + | ===== 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 25: | Line 28: | ||
==== Conventions ==== | ==== Conventions ==== | ||
- | Each person record has associated demographic attributes which are assumed to be constant for the patient throughout the course of their periods of observation. All other patient-related data domains have a foreign-key reference to the person domain. | + | * All tables representing patient-related Domains have a foreign-key reference to the person_id field in the PERSON table. |
+ | * Each person record has associated demographic attributes which are assumed to be constant for the patient throughout the course of their periods of observation. For example, the location or gender is expected to have a unique value per person, even though in life these data may change over time. | ||
+ | * Valid Gender, Race and Ethnicity Concepts each belong to their own Domain. | ||
+ | * Ethnicity in the OMOP CDM follows the OMB Standards for Data on Race and Ethnicity: Only distinctions between Hispanics and Non-Hispanics are made. | ||
+ | * Additional information is stored through references to other tables, such as the home address (location_id) or the primary care provider. | ||
+ | * The Provider refers to the primary care provider (General Practitioner). | ||
+ | * The Care Site refers to where the Provider typically provides the primary care. |