documentation:cdm:person
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
| documentation:cdm:person [2014/11/17 19:44] – created cgreich | documentation:cdm:person [2017/09/25 15:00] (current) – clairblacketer | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ===== PERSON ===== | + | ===== PERSON |
| + | **THIS IS OUTDATED. All documentation is now on the [[https:// | ||
| + | |||
| + | This table changed in version 5.1 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 13: | ||
| |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 29: | ||
| ==== 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 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. | ||
| + | * 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 | ||
| + | * The Provider refers to the primary care provider (General Practitioner). | ||
| + | * The Care Site refers to where the Provider typically provides the primary care. | ||
documentation/cdm/person.1416253467.txt.gz · Last modified: by cgreich