Top

PEDSnet v3.5 - BIGINT Testing

Tables

person

Demographic information about a Person

Fields

birth_datetime

The time of birth at the birthday. In order to reduce ambiguity around timezone shifts, this field is stored and transmitted as a full date and time without timezone information or conversion. Enter as much information as is available.

Schema

care_site_id

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

Schema

day_of_birth

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.

Schema

ethnicity_concept_id

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

Schema

ethnicity_source_concept_id

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

Schema

ethnicity_source_value

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 Vocabulary and the original code is, stored here for reference.

Schema

gender_concept_id

A foreign key that refers to a standard concept identifier in the Vocabulary for the gender of the person.

Schema

gender_source_concept_id

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

Schema

gender_source_value

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 Vocabulary; the original value is stored here for reference.

Schema

language_concept_id

A foreign key that refers to the standard concept identifier in the Vocabulary for the language of the person.

Schema

language_source_concept_id

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

Schema

language_source_value

The source code for the language of the person as it appears in the source data.

Schema

location_id

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

Schema

month_of_birth

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.

Schema

person_id

A unique identifier for each person; this is created by each contributing site. Note: This is not a value found in the EHR. However, a map to patient ID or MRN from the EHR must be kept at the site and not shared with the data coordinating center for re-identification in the future.

Schema

person_source_value

An encrypted key derived from the person identifier in the source data. For site-specific data extracts, this may be identical to the person_id.

Schema

pn_gestational_age

The post-menstrual age in weeks of the person at birth, if known.

Schema

provider_id

Foreign key to the primary care provider ��� the person is seeing in the provider table.

Schema

race_concept_id

A foreign key that refers to a standard concept identifier in the Vocabulary for the race of the person.

Schema

race_source_concept_id

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

Schema

race_source_value

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 Vocabulary and the original value is stored here for reference.

Schema

year_of_birth

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.

Schema