: Record Table 935

Record Table 935

Title:	OMOP Person
Access field:	20142 (Present in OMOP dataset)

Table name

omop_person

Table group

OMOP

Debut

Feb 2023

Row count

502,000+

Parent table

n/a

Version

Sep 2024

Size

38MB

Stability

Complete

Cost Tier

dX o2 s2

This item is regarded as restricted and will be supplied to researchers only when absolutely necessary.

18 Columns

#	Column	Type	Notes
1	birth_datetime	timestamp	The date and time of birth of the person.
2	care_site_id	integer	A foreign key to the site of primary care in the care_site table, where the details of the care site are stored.
3	day_of_birth	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.
4	eid	integer	A unique identifier for each person.
5	ethnicity_concept_id	integer	A foreign key that refers to the standard concept identifier in the Standardized Vocabularies for the ethnicity of the person.
6	ethnicity_source_concept_id	integer	A foreign key to the ethnicity concept that refers to the code used in the source.
7	ethnicity_source_value	string	The source code for the ethnicity of the person as it appears in the source data. The person ethnicity is mapped to a standard ethnicity concept in the Standardized Vocabularies and the original code is, stored here for reference.
8	gender_concept_id	integer	A foreign key that refers to an identifier in the CONCEPT table for the unique gender of the person.
9	gender_source_concept_id	integer	A foreign key to the gender concept that refers to the code used in the source.
10	gender_source_value	string	The source code for the gender of the person as it appears in the source data. The person's gender is mapped to a standard gender concept in the Standardized Vocabularies; the original value is stored here for reference.
11	location_id	integer	A foreign key to the place of residency for the person in the location table, where the detailed address information is stored.
12	month_of_birth	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.
13	person_source_value	string	An (encrypted) key derived from the person identifier in the source data. This is necessary when a use case requires a link back to the person data at the source dataset.
14	provider_id	integer	A foreign key to the primary care provider the person is seeing in the provider table.
15	race_concept_id	integer	A foreign key that refers to an identifier in the CONCEPT table for the unique race of the person.
16	race_source_concept_id	integer	A foreign key to the race concept that refers to the code used in the source.
17	race_source_value	string	The source code for the race of the person as it appears in the source data. The person race is mapped to a standard race concept in the Standardized Vocabularies and the original value is stored here for reference.
18	year_of_birth	integer	The year of birth of the person. For data sources with date of birth, the year is extracted. For data sources where the year of birth is not available, the approximate year of birth is derived based on any age group categorization available.

Column

Type

Notes

birth_datetime

timestamp

The date and time of birth of the person.

care_site_id

integer

A foreign key to the site of primary care in the care_site table, where the details of the care site are stored.

day_of_birth

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.

eid

integer

A unique identifier for each person.

ethnicity_concept_id

integer

A foreign key that refers to the standard concept identifier in the Standardized Vocabularies for the ethnicity of the person.

ethnicity_source_concept_id

integer

A foreign key to the ethnicity concept that refers to the code used in the source.

ethnicity_source_value

string

The source code for the ethnicity of the person as it appears in the source data. The person ethnicity is mapped to a standard ethnicity concept in the Standardized Vocabularies and the original code is, stored here for reference.

gender_concept_id

integer

A foreign key that refers to an identifier in the CONCEPT table for the unique gender of the person.

gender_source_concept_id

integer

A foreign key to the gender concept that refers to the code used in the source.

gender_source_value

string

The source code for the gender of the person as it appears in the source data. The person's gender is mapped to a standard gender concept in the Standardized Vocabularies; the original value is stored here for reference.

location_id

integer

A foreign key to the place of residency for the person in the location table, where the detailed address information is stored.

month_of_birth

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.

person_source_value

string

An (encrypted) key derived from the person identifier in the source data. This is necessary when a use case requires a link back to the person data at the source dataset.

provider_id

integer

A foreign key to the primary care provider the person is seeing in the provider table.

race_concept_id

integer

A foreign key that refers to an identifier in the CONCEPT table for the unique race of the person.

race_source_concept_id

integer

A foreign key to the race concept that refers to the code used in the source.

race_source_value

string

The source code for the race of the person as it appears in the source data. The person race is mapped to a standard race concept in the Standardized Vocabularies and the original value is stored here for reference.

year_of_birth

integer

The year of birth of the person. For data sources with date of birth, the year is extracted. For data sources where the year of birth is not available, the approximate year of birth is derived based on any age group categorization available.

Table ID	Table	Title
924	omop_condition_era	OMOP Condition Era
925	omop_condition_occurrence	OMOP Condition Occurrence
926	omop_death	OMOP Death
927	omop_device_exposure	OMOP Device Exposure
928	omop_dose_era	OMOP Dose Era
929	omop_drug_era	OMOP Drug Era
930	omop_drug_exposure	OMOP Drug Exposure
931	omop_measurement	OMOP Measurement
932	omop_note	OMOP Note
933	omop_observation	OMOP Observation Period
934	omop_observation_period	OMOP Observation
936	omop_procedure_occurrence	OMOP Procedure Occurrence
937	omop_specimen	OMOP Specimen
938	omop_visit_detail	OMOP Visit Detail
939	omop_visit_occurrence	OMOP Visit Occurrence

Table ID

Table

Title

924

omop_condition_era

OMOP Condition Era

925

omop_condition_occurrence

OMOP Condition Occurrence

926

omop_death

OMOP Death