| # | 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 | ethnicity_concept_id | integer | A foreign key that refers to the standard concept identifier in the Standardized Vocabularies for the ethnicity of the person. |
| 5 | ethnicity_source_concept_id | integer | A foreign key to the ethnicity concept that refers to the code used in the source. |
| 6 | 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. |
| 7 | gender_concept_id | integer | A foreign key that refers to an identifier in the CONCEPT table for the unique gender of the person. |
| 8 | gender_source_concept_id | integer | A foreign key to the gender concept that refers to the code used in the source. |
| 9 | 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. |
| 10 | 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. |
| 11 | 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. |
| 12 | person_id | integer | A unique identifier for each person. |
| 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. |
