Information about the site of care
Fields
A system-generated unique identifier for each care site. A care site is the place where the provider delivered the healthcare to the person.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | care_site | care_site_id |
Total: 2
| Table | Field | Name |
|---|---|---|
| person | care_site_id | fpk_person_care_site |
| provider | care_site_id | fpk_provider_care_site |
The identifier for the care site as it appears in the source data, stored here for reference.
string| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | care_site | care_site_source_value |
Refers to: location / location_id
A foreign key to the geographic location in the location table, where the detailed address information is stored.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | care_site | location_id |
Refers to: organization / organization_id
A foreign key to the organization in the organization table, where the detailed information is stored.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | care_site | organization_id |
A foreign key to the predefined concept identifier in the vocabulary reflecting the place of service.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | care_site | place_of_service_concept_id |
The source code for the place of service as it appears in the source data, stored here for reference.
string| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | care_site | place_of_service_source_value |
Person, Provider or Visit cohorts
Fields
A foreign key to a standard cohort concept identifier in the vocabulary. Cohort concepts identify the cohorts: whether they are defined through persons, providers or visits, or any combination thereof.
integerThe date when the cohort definition criteria for the person, provider or visit no longer match or the cohort membership was terminated.
dateA system-generated unique identifier for each cohort record.
integerThe date when the cohort definition criteria for the person, provider or visit first match.
dateThe reason for the end of a cohort membership other than defined by the cohort definition criteria as it appears in the source data.
stringA foreign key to the subject in the cohort. These could be referring to records in the Person, Provider, Visit Occurrence table.
integerContains all Concepts across domains, including the name (description), their source (called Concept Type), their identifier in the source (called Source Code), their level in the hierarchy and their class.
Fields
The category or class of the concept along both the hierarchical tree as well as different domains within a vocabulary. Examples are “Clinical Drug”, “Ingredient”, “Clinical Finding” etc.
stringThe concept code represents the identifier of the concept in the source data it originates from, such as SNOMED-CT concept IDs, RxNorm RXCUIs etc. Note that concept codes are not unique across vocabularies.
string| Model | Table | Field | Comment |
|---|---|---|---|
| PCORnet v1 | encounter | drg | Explicitly maps to concept_id 3040646. |
A system-generated unique identifier for each concept across all domains.
integerTotal: 6
| Table | Field | Name |
|---|---|---|
| concept_ancestor | ancestor_concept_id | fpk_concept_ancestor_concept_1 |
| concept_ancestor | descendant_concept_id | fpk_concept_ancestor_concept_2 |
| concept_relationship | concept_id_1 | fpk_concept_relationship_c_1 |
| concept_relationship | concept_id_2 | fpk_concept_relationship_c_2 |
| concept_synonym | concept_id | fpk_concept_synonym_concept |
| source_to_concept_map | target_concept_id | fpk_source_to_concept_map_c_1 |
The level of hierarchy associated with the concept. Different concept levels are assigned to concepts to depict their seniority in a clearly defined hierarchy, such as drugs, conditions, etc. A concept level of 0 is assigned to concepts that are not part of a standard vocabulary, but are part of the vocabulary for reference purposes (e.g. drug form).
integerAn unambiguous, meaningful and descriptive name for the concept.
stringReason the concept was invalidated. Possible values are D (deleted), U (replaced with an update) or NULL when valid_end_date has the default value.
stringThe date when the concept became invalid because it was deleted or superseded (updated) by a new concept. The default value is 31-Dec-2099.
dateThe date when the concept was first recorded.
dateRefers to: vocabulary / vocabulary_id
A foreign key to the vocabulary table indicating from which source the concept has been adapted.
integerContains the ancestry relationship of Concepts that have one or several hierarchical Relationships among them for fast lookup of hierarchical tree information, such as drug classes.
Fields
Refers to: concept / concept_id
A foreign key to the concept code in the concept table for the higher-level concept that forms the ancestor in the relationship.
integerRefers to: concept / concept_id
A foreign key to the concept code in the concept table for the lower-level concept that forms the descendant in the relationship.
integerThe maximum separation in number of levels of hierarchy between ancestor and descendant concepts. This is an optional attribute that is used to simplify hierarchic analysis.
numberThe minimum separation in number of levels of hierarchy between ancestor and descendant concepts. This is an optional attribute that is used to simplify hierarchic analysis.
numberContains the Relationship between any two Concepts and the type of the Relationship.
Fields
Refers to: concept / concept_id
A foreign key to the concept in the concept table associated with the relationship. Relationships are directional, and this field represents the source concept designation.
integerRefers to: concept / concept_id
A foreign key to the concept in the concept table associated with the relationship. Relationships are directional, and this field represents the destination concept designation.
integerReason the relationship was invalidated. Possible values are D (deleted), U (replaced with an update) or NULL when valid_end_date has the default value.
stringRefers to: relationship / relationship_id
The type of relationship as defined in the relationship table.
integerThe date when the relationship became invalid because it was deleted or superseded (updated) by a new relationship. Default value is 31-Dec-2099.
dateThe date when the instance of the relationship is first recorded.
dateContains any number of synonymous names (descriptions) for the Concepts.
Fields
Refers to: concept / concept_id
A foreign key to the concept in the concept table.
integerA system-generated unique identifier for each concept synonym.
integerThe alternative name for the concept.
stringA Condition Era is defined as a span of time when the Person is assumed to have a given condition.
Fields
A foreign key that refers to a standard condition concept identifier in the vocabulary.
integerThe end date for the condition era constructed from the individual instances of condition occurrences. It is the end date of the final continuously recorded instance of the condition.
dateA system-generated unique identifier for each condition era.
integerThe start date for the condition era constructed from the individual instances of condition occurrences. It is the start date of the very first chronologically recorded instance of the condition.
dateThe number of individual condition occurrences used to construct the condition era.
numberA foreign key to the predefined concept identifier in the vocabulary reflecting the parameters used to construct the condition era.
integerA foreign key identifier to the person who is experiencing the condition during the condition era. The demographic details of that person are stored in the person table.
integerA diagnosis or condition that has been recorded about a person at a certain time
Fields
Refers to: provider / provider_id
A foreign key to the provider in the provider table who was responsible for determining (diagnosing) the condition.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | condition_occurrence | associated_provider_id |
A foreign key that refers to a standard condition concept identifier in the vocabulary.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PCORnet v1 | diagnosis | dx | |
| PEDSnet v1 | condition_occurrence | condition_concept_id |
The date when the instance of the condition is considered to have ended. This is not typically recorded.
date| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | condition_occurrence | condition_end_date |
A system-generated unique identifier for each condition occurrence event.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | condition_occurrence | condition_occurrence_id |
The source code for the condition as it appears in the source data. This code is mapped to a standard condition concept in the vocabulary and the original code is, stored here for reference. Condition source codes are typically ICD-9-CM diagnosis codes from medical claims or discharge status/disposition codes from EHRs.
string| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | condition_occurrence | condition_source_value |
The date when the instance of the condition is recorded.
date| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | condition_occurrence | condition_start_date |
A foreign key to the predefined concept identifier in the vocabulary reflecting the source data from which the condition was recorded, the level of standardization, and the type of occurrence. Conditions are defined as primary or secondary diagnoses, problem lists and person statuses.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | condition_occurrence | condition_type_concept_id |
A foreign key identifier to the person who is experiencing the condition. The demographic details of that person are stored in the person table.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PCORnet v1 | diagnosis | patid | |
| PEDSnet v1 | condition_occurrence | person_id |
The reason, if available, that the condition was no longer recorded, as indicated in the source data. Valid values include discharged, resolved, etc.
string| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | condition_occurrence | stop_reason |
Refers to: visit_occurrence / visit_occurrence_id
A foreign key to the visit in the visit table during which the condition was determined (diagnosed).
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PCORnet v1 | diagnosis | encounterid | |
| PEDSnet v1 | condition_occurrence | visit_occurrence_id |
Time and cause of death of the Person
Fields
A foreign key referring to a standard concept identifier in the vocabulary for conditions.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | death | cause_of_death_concept_id |
The source code for the cause of death as it appears in the source data. This code is mapped to a standard concept in the vocabulary and the original code is, stored here for reference.
string| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | death | cause_of_death_source_value |
The date the person deceased. If the precise date including day or month is not known or not allowed, December is used as the default month, and the last day of the month the default day.
date| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | death | death_date |
A foreign key referring to the predefined concept identifier in the vocabulary reflecting how the death was represented in the source data.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | death | death_type_concept_id |
A foreign key identifier to the deceased person. The demographic details of that person are stored in the person table.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | death | person_id |
Fields
datestringintegerFor each Drug Exposure record additional information about cost and payments
Fields
List price of a drug set by the manufacturer.
numberThe portion of the drug expenses due to the dispensing fee charged by the pharmacy, typically a fixed amount.
numberA system-generated unique identifier for each drug cost record.
integerRefers to: drug_exposure / drug_exposure_id
A foreign key identifier to the drug record for which cost data are recorded.
integerThe portion of the drug expenses due to the cost charged by the manufacturer for the drug, typically a percentage of the Average Wholesale Price.
numberThe amount paid by a secondary payer through the coordination of benefits.
numberThe amount paid by the payer (insurer). If there is more than one payer, several drug_cost records indicate that fact.
numberThe amount paid by the person as a joint assumption of risk. Typically, this is a percentage of the expenses defined by the payer plan (policy) after the person’s deductible is exceeded.
numberThe amount paid by the person as a fixed contribution to the expenses. Copay does not contribute to the out of pocket expenses.
numberThe amount paid by the person that is counted toward the deductible defined by the payer plan (policy).
numberRefers to: payer_plan_period / payer_plan_period_id
A foreign key to the payer_plan_period table, where the details of the payer, plan and family are stored.
integerThe total amount paid by the person as a share of the expenses, excluding the copay.
numberThe total amount paid for the expenses of drug exposure.
numberAssociation between a Person and a Drug over a specific time period
Fields
A foreign key that refers to a standard concept identifier in the vocabulary for the drug concept.
integerThe end date for the drug era constructed from the individual instance of drug exposures. It is the end date of the final continuously recorded instance of utilization of a drug.
dateA system-generated unique identifier for each drug era.
integerThe start date for the drug era constructed from the individual instances of drug exposures. It is the start date of the very first chronologically recorded instance of utilization of a drug.
dateThe number of individual drug exposure occurrences used to construct the drug era.
numberA foreign key to the predefined concept identifier in the vocabulary reflecting the parameters used to construct the drug era.
integerA foreign key identifier to the person who is subjected to the drug during the drug era. The demographic details of that person are stored in the person table.
integerAssociation between a Person and a Drug at a specific time
Fields
The number of days of supply of the medication as recorded in the original prescription or dispensing record.
numberA foreign key that refers to a standard concept identifier in the vocabulary for the drug concept.
integerThe end date for the current instance of drug utilization. It is not available from all sources.
dateA system-generated unique identifier for each drug utilization event.
integerTotal: 1
| Table | Field | Name |
|---|---|---|
| drug_cost | drug_exposure_id | fpk_drug_cost_id |
The start date for the current instance of drug utilization. Valid entries include a start date of a prescription, the date a prescription was filled, or the date on which a drug administration procedure was recorded.
dateThe source code for the drug as it appears in the source data. This code is mapped to a standard drug concept in the vocabulary and the original code is, stored here for reference.
stringA foreign key to the predefined concept identifier in the vocabulary reflecting the type of drug exposure recorded. It indicates how the drug exposure was represented in the source data: as medication history, filled prescriptions, etc.
integerA foreign key identifier to the person who is subjected to the drug. The demographic details of that person are stored in the person table.
integerRefers to: provider / provider_id
A foreign key to the provider in the provider table who initiated (prescribed) the drug exposure.
integerThe quantity of drug as recorded in the original prescription or dispensing record.
numberThe number of refills after the initial prescription. The initial prescription is not counted, values start with 0.
numberA foreign key to the predefined concept identifier in the vocabulary reflecting the condition that was the cause for initiation of the drug exposure. Note that this is not a direct reference to a specific condition record in the condition table, but rather a condition concept in the vocabulary.
integerThe directions (“signetur”) on the drug prescription as recorded in the original prescription (and printed on the container) or dispensing record.
stringThe reason the medication was stopped, where available. Reasons include regimen completed, changed, removed, etc.
stringRefers to: visit_occurrence / visit_occurrence_id
A foreign key to the visit in the visit table during which the drug exposure initiated.
integerFields
stringnumberstringstringnumberintegerintegerstringdatedatePhysical addresses of patients, organizations and care sites
Fields
The address field 1, typically used for the street address, as it appears in the source data.
string| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | location | address_1 |
The address field 2, typically used for additional detail such as buildings, suites, floors, as it appears in the source data.
string| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | location | address_2 |
The city field as it appears in the source data.
string| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | location | city |
The county. The county information is necessary because not all zip codes fall into one and the same county.
string| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | location | county |
A system-generated unique identifier for each geographic location.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | location | location_id |
Total: 3
| Table | Field | Name |
|---|---|---|
| care_site | location_id | fpk_care_site_location |
| organization | location_id | fpk_organization_location |
| person | location_id | fpk_person_location |
The verbatim information that is used to uniquely identify the location as it appears in the source data.
string| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | location | location_source_value |
The state field as it appears in the source data.
string| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | location | state |
The zip code. For US addresses, valid zip codes can be 3, 5 or 9 digits long, depending on the source data.
string| Model | Table | Field | Comment |
|---|---|---|---|
| PCORnet v1 | encounter | facility_location | |
| PEDSnet v1 | location | zip |
Observations are clinical facts, such as laboratory tests, signs/symptoms, which are not captured within other CDM tables
Fields
Refers to: provider / provider_id
A foreign key to the provider in the provider table who was responsible for making the observation.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | observation | associated_provider_id |
A foreign key to the standard observation concept identifier in the vocabulary.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PCORnet v1 | vital | bp_position | Maps to the concept_id values under the ���BP Position� concept class. |
| PEDSnet v1 | observation | observation_concept_id |
The date of the observation.
date| Model | Table | Field | Comment |
|---|---|---|---|
| PCORnet v1 | vital | measure_date | |
| PEDSnet v1 | observation | observation_date |
A system-generated unique identifier for each observation.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | observation | observation_id |
The observation code as it appears in the source data. This code is mapped to a standard concept in the vocabulary and the original code is, stored here for reference.
string| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | observation | observation_source_value |
The time of the observation.
time| Model | Table | Field | Comment |
|---|---|---|---|
| PCORnet v1 | vital | measure_time | |
| PEDSnet v1 | observation | observation_time |
A foreign key to the predefined concept identifier in the vocabulary reflecting the type of the observation.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | observation | observation_type_concept_id |
A foreign key identifier to the person about whom the observation was recorded. The demographic details of that person are stored in the person table.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PCORnet v1 | vital | patid | |
| PEDSnet v1 | observation | person_id |
The upper limit of the normal range of the observation. It is not applicable if the observation results are non- numeric or categorical, and must be in the same units of measure as the observation value.
number| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | observation | range_high |
The lower limit of the normal range of the observation. It is not applicable if the observation results are non- numeric or categorical, and must be in the same units of measure as the observation value.
number| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | observation | range_low |
A foreign key to the predefined concept identifier in the vocabulary reflecting the condition that was associated with the observation. Note that this is not a direct reference to a specific condition record in the condition table, but rather a condition concept in the vocabulary.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | observation | relevant_condition_concept_id |
A foreign key to a standard concept identifier of measurement units in the vocabulary.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | observation | unit_concept_id |
The source code for the unit as it appears in the source data. This code is mapped to a standard unit concept in the vocabulary and the original code is, stored here for reference.
string| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | observation | unit_source_value |
A foreign key to an observation result stored as a concept identifier. This is applicable to observations where the result can be expressed as a standard concept from the vocabulary (e.g., positive/negative, present/absent, low/high, etc.).
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PCORnet v1 | demographic | biobank_flag | Explicitly maps to concept_id 4001345 in the ���Biobank_flag� concept class. |
| PCORnet v1 | encounter | discharge_disposition | Explicitly maps to concept_id 44813951 in the ���Discharge Disposition� concept class. |
| PCORnet v1 | encounter | discharge_status | Explicitly maps to concept_id 4137274 in the ���Discharge Status� concept class. |
| PCORnet v1 | encounter | admitting_source | Explicitly maps to concept_id 4145666 in the ���Admitting Source� concept class. |
| PCORnet v1 | encounter | raw_discharge_disposition | |
| PCORnet v1 | encounter | raw_discharge_status | |
| PCORnet v1 | encounter | raw_admitting_source | |
| PCORnet v1 | enrollment | chart | Explicitly maps to concept_id 4030450 in the ���Chart Availability� concept class. |
| PEDSnet v1 | observation | value_as_concept_id |
The observation result stored as a number. This is applicable to observations where the result is expressed as a numeric value.
number| Model | Table | Field | Comment |
|---|---|---|---|
| PCORnet v1 | vital | ht | Explicitly maps to concept_id 3036277. |
| PCORnet v1 | vital | wt | Explicitly maps to concept_id 3025315. |
| PCORnet v1 | vital | original_bmi | Explicitly maps to concept_id 3038553. |
| PCORnet v1 | vital | diastolic | Explicitly maps to concept_id 3012888. |
| PCORnet v1 | vital | systolic | Explicitly maps to concept_id 3004249. |
| PEDSnet v1 | observation | value_as_number |
The observation result stored as a string. This is applicable to observations where the result is expressed as verbatim text, such as in radiology or pathology reports.
string| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | observation | value_as_string |
Refers to: visit_occurrence / visit_occurrence_id
A foreign key to the visit in the visit table during which the observation was recorded.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PCORnet v1 | vital | encounterid | |
| PEDSnet v1 | observation | visit_occurrence_id |
Time intervals during which health care information, such as drugs, conditions, and other clinical observations, may be available
Fields
The end date of the observation period for which data are available from the data source.
date| Model | Table | Field | Comment |
|---|---|---|---|
| PCORnet v1 | enrollment | enr_end_date | |
| PEDSnet v1 | observation_period | observation_period_end_date |
A system-generated unique identifier for each observation period.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | observation_period | observation_period_id |
The start date of the observation period for which data are available from the data source.
date| Model | Table | Field | Comment |
|---|---|---|---|
| PCORnet v1 | enrollment | enr_start_date | |
| PEDSnet v1 | observation_period | observation_period_start_date |
A foreign key identifier to the person for whom the observation period is defined. The demographic details of that person are stored in the person table.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PCORnet v1 | enrollment | patid | |
| PEDSnet v1 | observation_period | person_id |
Information about health care organizations
Fields
Refers to: location / location_id
A foreign key to the geographic location of the administrative offices of the organization in the location table, where the detailed address information is stored.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | organization | location_id |
A system-generated unique identifier for each organization. Here, an organization is defined as a collection of one or more care sites that share a single EHR database.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | organization | organization_id |
Total: 1
| Table | Field | Name |
|---|---|---|
| care_site | organization_id | fpk_care_site_organization |
The identifier for the organization in the source data, stored here for reference.
string| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | organization | organization_source_value |
A foreign key that refers to a place of service concept identifier in the vocabulary.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | organization | place_of_service_concept_id |
The source code for the place of service as it appears in the source data, stored here for reference.
string| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | organization | place_of_service_source_value |
Information about the coverage plan of the person
Fields
The source code for the person’s family as it appears in the source data.
stringThe end date of the payer plan period.
dateA system-generated identifier for each unique combination of payer, plan, family code and time span.
integerTotal: 2
| Table | Field | Name |
|---|---|---|
| drug_cost | payer_plan_period_id | fpk_drug_cost_period |
| procedure_cost | payer_plan_period_id | fpk_procedure_cost_period |
The start date of the payer plan period.
dateThe source code for the payer as it appears in the source data.
stringA foreign key identifier to the person covered by the payer. The demographic details of that person are stored in the person table.
integerThe source code for the person’s coverage plan as it appears in the source data.
stringDemographic information about a Person
Fields
Refers to: care_site / care_site_id
A foreign key to the primary care site in the care site table, where the details of the care site are stored.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | person | care_site_id |
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.
number| Model | Table | Field | Comment |
|---|---|---|---|
| PCORnet v1 | demographic | birth_date | |
| PEDSnet v1 | person | day_of_birth |
A foreign key that refers to the standard concept identifier in the vocabulary for the ethnicity of the person.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PCORnet v1 | demographic | hispanic | Limited to the concept_id values under the ���Hispanic� concept class. |
| PEDSnet v1 | person | ethnicity_concept_id |
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.
string| Model | Table | Field | Comment |
|---|---|---|---|
| PCORnet v1 | demographic | raw_hispanic | |
| PEDSnet v1 | person | ethnicity_source_value |
A foreign key that refers to a standard concept identifier in the vocabulary for the gender of the person.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PCORnet v1 | demographic | sex | Maps to the concept_id values under the ���Gender� concept class. |
| PEDSnet v1 | person | gender_concept_id |
The source code for the gender of the person as it appears in the source data. The person gender is mapped to a standard gender concept in the vocabulary and the corresponding concept identifier is, stored here for reference.
string| Model | Table | Field | Comment |
|---|---|---|---|
| PCORnet v1 | demographic | raw_sex | |
| PEDSnet v1 | person | gender_source_value |
Refers to: location / location_id
A foreign key to the place of residency for the person in the location table, where the detailed address information is stored.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | person | location_id |
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.
number| Model | Table | Field | Comment |
|---|---|---|---|
| PCORnet v1 | demographic | birth_date | |
| PEDSnet v1 | person | month_of_birth |
A system-generated unique identifier for each person.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PCORnet v1 | demographic | patid | |
| PEDSnet v1 | person | person_id |
Total: 10
| Table | Field | Name |
|---|---|---|
| condition_era | person_id | fpk_condition_era_person |
| condition_occurrence | person_id | fpk_condition_person |
| death | person_id | fpk_death_person |
| drug_era | person_id | fpk_drug_era_person |
| drug_exposure | person_id | fpk_drug_person |
| observation | person_id | fpk_observation_person |
| observation_period | person_id | fpk_observation_period_person |
| payer_plan_period | person_id | fpk_payer_plan_period |
| procedure_occurrence | person_id | fpk_procedure_person |
| visit_occurrence | person_id | fpk_visit_person |
An encrypted key derived from the person identifier in the source data. This is necessary when a drug safety issue requires a link back to the person data at the source dataset. No value with any medical or demographic significance must be stored.
stringRefers to: provider / provider_id
A foreign key to the primary care provider the person is seeing in the provider table.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | person | provider_id |
A foreign key that refers to a standard concept identifier in the vocabulary for the race of the person.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PCORnet v1 | demographic | race | Limited to the concept_id values under the ���Race� concept class. |
| PEDSnet v1 | person | race_concept_id |
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 code is, stored here for reference.
string| Model | Table | Field | Comment |
|---|---|---|---|
| PCORnet v1 | demographic | raw_race | |
| PEDSnet v1 | person | race_source_value |
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.
number| Model | Table | Field | Comment |
|---|---|---|---|
| PCORnet v1 | demographic | birth_date | |
| PEDSnet v1 | person | year_of_birth |
For each Procedure additional information about cost and payments
Fields
A foreign key referring to a standard concept identifier in the vocabulary for disease classes, such as DRGs and APCs.
integerThe source code for the disease class as it appears in the source data, stored here for reference.
stringThe amount paid by a secondary payer through the coordination of benefits.
numberThe amount paid by the payer (insurer). If there is more than one payer, several procedure_cost records indicate that fact.
numberThe amount paid by the person as a joint assumption of risk. Typically, this is a percentage of the expenses defined by the payer plan (policy) after the person’s deductible is exceeded.
numberThe amount paid by the person as a fixed contribution to the expenses. Copay does not contribute to the out_of_pocket expenses.
numberThe amount paid by the person that is counted toward the deductible defined by the payer plan (policy).
numberRefers to: payer_plan_period / payer_plan_period_id
A foreign key to the payer_plan_period table, where the details of the payer, plan and family are stored.
integerA system-generated unique identifier for each procedure cost record.
integerRefers to: procedure_occurrence / procedure_occurrence_id
A foreign key identifier to the procedure record for which cost data are recorded.
integerA foreign key referring to a standard concept identifier in the vocabulary for revenue codes.
integerThe source code for the revenue code as it appears in the source data, stored here for reference.
stringThe total amount paid by the person as a share of the expenses, excluding the copay.
numberThe total amount paid for the expenses of the procedure.
numberProcedures carried out on the Person
Fields
Refers to: provider / provider_id
A foreign key to the provider in the provider table who was responsible for carrying out the procedure.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | procedure_occurrence | associated_provider_id |
A foreign key identifier to the person who is subjected to the procedure. The demographic details of that person are stored in the person table.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PCORnet v1 | procedure | patid | |
| PEDSnet v1 | procedure_occurrence | person_id |
A foreign key that refers to a standard procedure concept identifier in the vocabulary.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PCORnet v1 | procedure | px | |
| PEDSnet v1 | procedure_occurrence | procedure_concept_id |
The date on which the procedure was performed.
date| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | procedure_occurrence | procedure_date |
A system-generated unique identifier for each procedure occurrence.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | procedure_occurrence | procedure_occurrence_id |
Total: 1
| Table | Field | Name |
|---|---|---|
| procedure_cost | procedure_occurrence_id | fpk_procedure_cost_id |
The source code for the procedure as it appears in the source data. This code is mapped to a standard procedure concept in the vocabulary and the original code is, stored here for reference. Procedure source codes are typically ICD-9-Proc, CPT-4 or HCPCS codes.
string| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | procedure_occurrence | procedure_source_value |
The date on which the procedure was performed.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | procedure_occurrence | procedure_type_concept_id |
A foreign key to the predefined concept identifier in the vocabulary reflecting the condition that was the cause for initiation of the procedure. Note that this is not a direct reference to a specific condition record in the condition table, but rather a condition concept in the vocabulary.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | procedure_occurrence | relevant_condition_concept_id |
Refers to: visit_occurrence / visit_occurrence_id
A foreign key to the visit in the visit table during which the procedure was carried out.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PCORnet v1 | procedure | encounterid | |
| PEDSnet v1 | procedure_occurrence | visit_occurrence_id |
Information about health care providers
Fields
Refers to: care_site / care_site_id
A foreign key to the main care site where the provider is practicing.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | provider | care_site_id |
The Drug Enforcement Administration (DEA) number of the provider.
string| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | provider | dea |
The National Provider Identifier (NPI) of the provider.
string| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | provider | npi |
A system-generated unique identifier for each provider.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | provider | provider_id |
Total: 5
| Table | Field | Name |
|---|---|---|
| condition_occurrence | associated_provider_id | fpk_condition_provider |
| drug_exposure | prescribing_provider_id | fpk_drug_provider |
| observation | associated_provider_id | fpk_observation_provider |
| person | provider_id | fpk_person_provider |
| procedure_occurrence | associated_provider_id | fpk_procedure_provider |
The identifier used for the provider in the source data, stored here for reference.
string| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | provider | provider_source_value |
A foreign key to a standard provider’s specialty concept identifier in the vocabulary.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | provider | specialty_concept_id |
The source code for the provider specialty as it appears in the source data, stored here for reference.
string| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | provider | specialty_source_value |
List of all types of Relationships in the Concept Relationship Table and their names (descriptions).
Fields
Defines whether a hierarchical relationship contributes to the concept_ancestor table. These are subsets of the hierarchical relationships. Valid values are Y or NULL.
integerDefines whether a relationship defines concepts into classes or hierarchies. Values are Y for hierarchical relationship or NULL if not.
integerThe type of relationship captured by the relationship record.
integerTotal: 1
| Table | Field | Name |
|---|---|---|
| concept_relationship | relationship_id | fpk_concept_relationship_id |
The text that describes the relationship type.
stringMapping between codes used in source data and Concepts in the Standard Vocabulary.
Fields
Reason the mapping instance was invalidated. Possible values are D (deleted), U (replaced with an update) or NULL when valid_end_date has the default value.
stringA string identifying the observational data element being translated. Examples include ‘DRUG’, ‘CONDITION’, ‘PROCEDURE’, ‘PROCEDURE DRUG’ etc. It is important to pick the appropriate mapping record when the same source code is being mapped to different concepts in different contexts. As an example a procedure code for drug administration can be mapped to a procedure concept or a drug concept or both.
stringA boolean value identifying the primary mapping relationship for those sets where the source_code, the source_vocabulary_id and the mapping type is identical (one-to-many mappings). The ETL will only consider the primary map. Permitted values are Y and NULL.
stringThe source code being translated into a standard concept.
stringAn optional description for the source code. This is included as a convenience to compare the description of the source code to the name of the concept.
stringRefers to: vocabulary / vocabulary_id
A foreign key to the vocabulary table defining the vocabulary of the source code that is being mapped to the standard vocabulary.
integerRefers to: concept / concept_id
A foreign key to the concept to which the source code is being mapped.
integerRefers to: vocabulary / vocabulary_id
A foreign key to the vocabulary table defining the vocabulary of the target concept.
integerThe date when the mapping instance became invalid because it was deleted or superseded (updated) by a new relationship. Default value is 31-Dec-2099.
dateThe date when the mapping instance was first recorded.
dateVisits for health care services of the Person
Fields
A foreign key to the care site in the care site table that was visited.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PCORnet v1 | encounter | facilityid | |
| PEDSnet v1 | visit_occurrence | care_site_id |
A foreign key identifier to the person for whom the visit is recorded. The demographic details of that person are stored in the person table.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PCORnet v1 | encounter | patid | |
| PEDSnet v1 | visit_occurrence | person_id |
A foreign key that refers to a place of service concept identifier in the vocabulary.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PCORnet v1 | encounter | enc_type | Limited to concept_id values under the ���Encounter Type� concept class. |
| PCORnet v1 | encounter | raw_enc_type | |
| PEDSnet v1 | visit_occurrence | place_of_service_concept_id |
The source code used to reflect the type or source of the visit in the source data. Valid entries include office visits, hospital admissions, etc. These source codes can also be type-of service codes and activity type codes.
string| Model | Table | Field | Comment |
|---|---|---|---|
| PEDSnet v1 | visit_occurrence | place_of_service_source_value |
The end date of the visit. If this is a one-day visit the end date should match the start date.
date| Model | Table | Field | Comment |
|---|---|---|---|
| PCORnet v1 | encounter | discharge_date | |
| PEDSnet v1 | visit_occurrence | visit_end_date |
A system-generated unique identifier for each person’s visit or encounter at a healthcare provider.
integer| Model | Table | Field | Comment |
|---|---|---|---|
| PCORnet v1 | encounter | encounterid | |
| PEDSnet v1 | visit_occurrence | visit_occurrence_id |
Total: 4
| Table | Field | Name |
|---|---|---|
| condition_occurrence | visit_occurrence_id | fpk_condition_visit |
| drug_exposure | visit_occurrence_id | fpk_drug_visit |
| observation | visit_occurrence_id | fpk_observation_visit |
| procedure_occurrence | visit_occurrence_id | fpk_procedure_visit |
The start date of the visit.
date| Model | Table | Field | Comment |
|---|---|---|---|
| PCORnet v1 | encounter | admit_date | |
| PEDSnet v1 | visit_occurrence | visit_start_date |
Contains a list of sources for the various Concepts. Many Concepts are derived from national or industry initiatives, such as the ICD diagnostic codes. Others are created by OMOP.
Fields
A unique identifier for each vocabulary.
integerTotal: 3
| Table | Field | Name |
|---|---|---|
| concept | vocabulary_id | fpk_concept_vocabulary |
| source_to_concept_map | source_vocabulary_id | fpk_source_to_concept_map_v_1 |
| source_to_concept_map | target_vocabulary_id | fpk_source_to_concept_map_v_2 |
The name describing the vocabulary, for example “SNOMED-CT”, “ICD-9”, “Visit”, etc.
string