(for Cohort:) A foreign key to a record in the COHORT_DEFINITION table containing relevant Cohort Definition information.
cohort.cohort_definition_id#1 AS CohortDefinition
(for Cohort:) A foreign key to the subject in the cohort. These could be referring to records in the PERSON, PROVIDER, VISIT_OCCURRENCE table.
(for CohortDefinition:) A foreign key to the Concept to which defines the domain of subjects that are members of the cohort (e.g., Person, Provider, Visit).
cohort_definition.subject_concept_id#10 AS Concept
(for CohortDefinition:) Type defining what kind of Cohort Definition the record represents and how the syntax may be executed
cohort_definition.definition_type_concept_id#8 AS Concept
(reversed relation, for ConditionOccurrence:) A foreign key identifier to the Person who is experiencing the condition. The demographic details of that Person are stored in the PERSON table.
(reversed relation, for ConditionOccurrence:) A foreign key to the visit in the VISIT_OCCURRENCE table during which the Condition was determined (diagnosed).
(reversed relation, for ConditionOccurrence:) A foreign key to the visit in the VISIT_DETAIL table during which the Condition was determined (diagnosed).
condition_occurrence.person_id#13 AS Person
condition_occurrence.visit_occurrence_id#23 AS VisitOccurrence
condition_occurrence.visit_detail_id#24 AS VisitDetail
(for ConditionOccurrence:) A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies belonging to the 'Condition' domain.
(for DeviceExposure:) A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies belonging to the 'Device' domain.
(for DrugExposure:) A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies belonging to the 'Drug' domain.
(for Measurement:) A foreign key to the standard measurement concept identifier in the Standardized Vocabularies. These belong to the 'Measurement' domain, but could overlap with the 'Observation' domain (see #3 below).
(for NoteNlp:) A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the normalized concept for the extracted term. Domain of the term is represented as part of the Concept table.
(for Observation:) A foreign key to the standard observation concept identifier in the Standardized Vocabularies.
(for ProcedureOccurrence:) A foreign key that refers to a standard procedure Concept identifier in the Standardized Vocabularies.
(for Specimen:) A foreign key referring to a Standard Concept identifier in the Standardized Vocabularies for the Specimen.
(for VisitDetail:) A foreign key that refers to a visit Concept identifier in the Standardized Vocabularies belonging to the 'Visit' Vocabulary.
(for VisitOccurrence:) A foreign key that refers to a visit Concept identifier in the Standardized Vocabularies belonging to the 'Visit' Vocabulary.
(for ConditionEra:) A foreign key that refers to a standard Condition Concept identifier in the Standardized Vocabularies.
(for DoseEra:) A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies for the active Ingredient Concept.
(for DrugEra:) A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies for the Ingredient Concept.
(for Cost:) A foreign key that refers to a Standard Cost Concept identifier in the Standardized Vocabularies belonging to the 'Cost' vocabulary.
(for Metadata:) A foreign key that refers to a Standard Metadata Concept identifier in the Standardized Vocabularies.
(for ConceptClass:) A foreign key that refers to an identifier in the [CONCEPT](https://github.com/OHDSI/CommonDataModel/wiki/CONCEPT) table for the unique Concept Class the record belongs to.
(for ConceptSynonym:) A foreign key to the Concept in the CONCEPT table.
(for Domain:) A foreign key that refers to an identifier in the [CONCEPT](https://github.com/OHDSI/CommonDataModel/wiki/CONCEPT) table for the unique Domain Concept the Domain record belongs to.
(for DrugStrength:) A foreign key to the Concept in the CONCEPT table representing the identifier for Branded Drug or Clinical Drug Concept.
(for Relationship:) A foreign key that refers to an identifier in the CONCEPT table for the unique relationship concept.
(for Vocabulary:) A foreign key that refers to a standard concept identifier in the CONCEPT table for the Vocabulary the VOCABULARY record belongs to.
condition_occurrence.condition_concept_id#14 AS Concept
device_exposure.device_concept_id#30 AS Concept
drug_exposure.drug_concept_id#45 AS Concept
measurement.measurement_concept_id#73 AS Concept
note_nlp.note_nlp_concept_id#113 AS Concept
observation.observation_concept_id#123 AS Concept
procedure_occurrence.procedure_concept_id#168 AS Concept
specimen.specimen_concept_id#182 AS Concept
visit_detail.visit_detail_concept_id#221 AS Concept
visit_occurrence.visit_concept_id#240 AS Concept
condition_era.condition_concept_id#257 AS Concept
metadata.metadata_concept_id#360 AS Concept
concept_class.concept_class_concept_id#383 AS Concept
concept_synonym.concept_id#390 AS Concept
drug_strength.drug_concept_id#396 AS Concept
relationship.relationship_concept_id#413 AS Concept
vocabulary.vocabulary_concept_id#427 AS Concept
(for ConditionOccurrence:) A foreign key to the predefined Concept identifier in the Standardized Vocabularies reflecting the source data from which the Condition was recorded, the level of standardization, and the type of occurrence. These belong to the 'Condition Type' vocabulary
(for DeviceExposure:) A foreign key to the predefined Concept identifier in the Standardized Vocabularies reflecting the type of Device Exposure recorded. It indicates how the Device Exposure was represented in the source data and belongs to the 'Device Type' domain.
(for DrugExposure:) A foreign key to the predefined Concept identifier in the Standardized Vocabularies reflecting the type of Drug Exposure recorded. It indicates how the Drug Exposure was represented in the source data and belongs to the 'Drug Type' vocabulary.
(for Measurement:) A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the provenance from where the Measurement record was recorded. These belong to the 'Meas Type' vocabulary
(for Note:) A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the type, origin or provenance of the Note. These belong to the 'Note Type' vocabulary
(for Observation:) A foreign key to the predefined concept identifier in the Standardized Vocabularies reflecting the type of the observation.
(for ProcedureOccurrence:) A foreign key to the predefined Concept identifier in the Standardized Vocabularies reflecting the type of source data from which the procedure record is derived, belonging to the 'Procedure Type' vocabulary.
(for Specimen:) A foreign key referring to the Concept identifier in the Standardized Vocabularies reflecting the system of record from which the Specimen was represented in the source data.
(for VisitDetail:) A foreign key to the predefined Concept identifier in the Standardized Vocabularies reflecting the type of source data from which the visit record is derived belonging to the 'Visit Type' vocabulary.
(for VisitOccurrence:) A foreign key to the predefined Concept identifier in the Standardized Vocabularies reflecting the type of source data from which the visit record is derived belonging to the 'Visit Type' vocabulary.
(for Cost:) A foreign key identifier to a concept in the CONCEPT table for the provenance or the source of the COST data and belonging to the 'Cost Type' vocabulary
(for Metadata:) A foreign key that refers to a Standard Type Concept identifier in the Standardized Vocabularies.
condition_occurrence.condition_type_concept_id#19 AS Concept
device_exposure.device_type_concept_id#35 AS Concept
drug_exposure.drug_type_concept_id#51 AS Concept
measurement.measurement_type_concept_id#77 AS Concept
observation.observation_type_concept_id#126 AS Concept
procedure_occurrence.procedure_type_concept_id#171 AS Concept
specimen.specimen_type_concept_id#183 AS Concept
visit_detail.visit_detail_type_concept_id#226 AS Concept
visit_occurrence.visit_type_concept_id#245 AS Concept
cost.cost_type_concept_id#280 AS Concept
metadata.metadata_type_concept_id#361 AS Concept
(for ConditionOccurrence:) A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies reflecting the point of care at which the Condition was diagnosed.
condition_occurrence.condition_status_concept_id#20 AS Concept
(for ConditionOccurrence:) A foreign key to the Provider in the PROVIDER table who was responsible for capturing (diagnosing) the Condition.
(for DeviceExposure:) A foreign key to the provider in the PROVIDER table who initiated or administered the Device.
(for DrugExposure:) A foreign key to the provider in the PROVIDER table who initiated (prescribed or administered) the Drug Exposure.
(for Measurement:) A foreign key to the provider in the PROVIDER table who was responsible for initiating or obtaining the measurement.
(for Note:) A foreign key to the Provider in the PROVIDER table who took the Note.
(for Observation:) A foreign key to the provider in the PROVIDER table who was responsible for making the observation.
(for Person:) A foreign key to the primary care provider the person is seeing in the provider table.
(for ProcedureOccurrence:) A foreign key to the provider in the PROVIDER table who was responsible for carrying out the procedure.
(for SurveyConduct:) A foreign key to the provider in the provider table who was associated with the survey completion.
(for VisitDetail:) A foreign key to the provider in the provider table who was associated with the visit.
(for VisitOccurrence:) A foreign key to the provider in the provider table who was associated with the visit.
condition_occurrence.provider_id#22 AS Provider
device_exposure.provider_id#38 AS Provider
drug_exposure.provider_id#59 AS Provider
procedure_occurrence.provider_id#174 AS Provider
survey_conduct.provider_id#202 AS Provider
visit_detail.provider_id#227 AS Provider
visit_occurrence.provider_id#246 AS Provider
(for ConditionOccurrence:) A foreign key to a Condition Concept that refers to the code used in the source.
(for DeviceExposure:) A foreign key to a Device Concept that refers to the code used in the source.
(for DrugExposure:) A foreign key to a Drug Concept that refers to the code used in the source.
(for Measurement:) A foreign key to a Concept in the Standard Vocabularies that refers to the code used in the source.
(for NoteNlp:) A foreign key to a Concept that refers to the code in the source vocabulary used by the NLP system
(for Observation:) A foreign key to a Concept that refers to the code used in the source.
(for ProcedureOccurrence:) A foreign key to a Procedure Concept that refers to the code used in the source.
(for Specimen:) The Specimen identifier as it appears in the source data.
(for VisitDetail:) A foreign key to a Concept that refers to the code used in the source.
(for VisitOccurrence:) A foreign key to a Concept that refers to the code used in the source.
(for Cost:) A foreign key to a Cost Concept that refers to the code used in the source.
(for SourceToConceptMap:) A foreign key to the Source Concept that is being translated into a Standard Concept.
condition_occurrence.condition_source_concept_id#26 AS Concept
device_exposure.device_source_concept_id#42 AS Concept
drug_exposure.drug_source_concept_id#63 AS Concept
measurement.measurement_source_concept_id#88 AS Concept
note_nlp.note_nlp_source_concept_id#114 AS Concept
observation.observation_source_concept_id#136 AS Concept
procedure_occurrence.procedure_source_concept_id#178 AS Concept
specimen.specimen_source_id#190 AS Thing
visit_detail.visit_detail_source_concept_id#230 AS Concept
visit_occurrence.visit_source_concept_id#249 AS Concept
cost.cost_source_concept_id#281 AS Concept
source_to_concept_map.source_concept_id#415 AS Concept
(reversed relation, for DeviceExposure:) A foreign key identifier to the Person who is subjected to the Device. The demographic details of that Person are stored in the PERSON table.
(reversed relation, for DeviceExposure:) A foreign key to the visit in the VISIT_OCCURRENCE table during which the Device was used.
(reversed relation, for DeviceExposure:) A foreign key to the visit detail record in the VISIT_DETAIL table during which the Device was used.
device_exposure.visit_occurrence_id#39 AS VisitOccurrence
device_exposure.visit_detail_id#40 AS VisitDetail
(for DeviceExposure:) A UDI or equivalent identifying the instance of the Device used in the Person.
device_exposure.unique_device_id#36 AS Thing
(reversed relation, for DrugExposure:) A foreign key identifier to the Person who is subjected to the Drug. The demographic details of that Person are stored in the PERSON table.
(reversed relation, for DrugExposure:) A foreign key to the Visit in the VISIT_OCCURRENCE table during which the Drug Exposure was initiated.
(reversed relation, for DrugExposure:) A foreign key to the Visit Detail in the VISIT_DETAIL table during which the Drug Exposure was initiated.
drug_exposure.visit_occurrence_id#60 AS VisitOccurrence
drug_exposure.visit_detail_id#61 AS VisitDetail
(for DrugExposure:) A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies reflecting the route of administration and belonging to the 'Route' domain.
drug_exposure.route_concept_id#57 AS Concept
(for FactRelationship:) A foreign key to a Standard Concept ID of relationship in the Standardized Vocabularies.
(for ConceptRelationship:) A unique identifier to the type or nature of the Relationship as defined in the [RELATIONSHIP](https://github.com/OHDSI/CommonDataModel/wiki/RELATIONSHIP) table.
fact_relationship.relationship_concept_id#70 AS Concept
concept_relationship.relationship_id#386 AS Relationship
(reversed relation, for Measurement:) A foreign key identifier to the Person about whom the measurement was recorded. The demographic details of that Person are stored in the PERSON table.
(reversed relation, for Measurement:) A foreign key to the Visit in the VISIT_OCCURRENCE table during which the Measurement was recorded.
(reversed relation, for Measurement:) A foreign key to the Visit Detail in the VISIT_DETAIL table during which the Measurement was recorded.
measurement.visit_occurrence_id#85 AS VisitOccurrence
measurement.visit_detail_id#86 AS VisitDetail
(for Measurement:) A foreign key identifier to the predefined Concept in the Standardized Vocabularies reflecting the mathematical operator that is applied to the value_as_number. Operators are <, <=, =, >=, > and these concepts belong to the 'Meas Value Operator' domain.
measurement.operator_concept_id#78 AS Concept
(for Measurement:) A foreign key to a Measurement result represented as a Concept from the Standardized Vocabularies (e.g., positive/negative, present/absent, low/high, etc.). These belong to the 'Meas Value' domain
(for Observation:) A foreign key to an observation result stored as a Concept ID. This is applicable to observations where the result can be expressed as a Standard Concept from the Standardized Vocabularies (e.g., positive/negative, present/absent, low/high, etc.).
(for Metadata:) A foreign key to a metadata value stored as a Concept ID.
measurement.value_as_concept_id#80 AS Concept
observation.value_as_concept_id#129 AS Concept
metadata.value_as_concept_id#364 AS Concept
(for Measurement:) A foreign key to a Standard Concept ID of Measurement Units in the Standardized Vocabularies that belong to the 'Unit' domain.
(for Observation:) A foreign key to a Standard Concept ID of measurement units in the Standardized Vocabularies.
(for Specimen:) A foreign key to a Standard Concept identifier for the Unit associated with the numeric quantity of the Specimen collection.
(for DoseEra:) A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies for the unit concept.
measurement.unit_concept_id#81 AS Concept
observation.unit_concept_id#131 AS Concept
(reversed relation, for Note:) A foreign key identifier to the Person about whom the Note was recorded. The demographic details of that Person are stored in the PERSON table.
(reversed relation, for Note:) A foreign key to the Visit in the VISIT_OCCURRENCE table when the Note was taken.
(reversed relation, for Note:) A foreign key to the Visit in the VISIT_DETAIL table when the Note was taken.
note.visit_occurrence_id#104 AS VisitOccurrence
(for Note:) A foreign key identifier to the event (e.g. Measurement, Procedure, Visit, Drug Exposure, etc) record during which the note was recorded.
(for Observation:) A foreign key to an event table (e.g., PROCEDURE_OCCURRENCE_ID).
(for Cost:) A foreign key identifier to the event (e.g. Measurement, Procedure, Visit, Drug Exposure, etc) record for which cost data are recorded.
observation.observation_event_id#139 AS Thing
(for Note:) A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the field to which the note_event_id is referring.
(for Cost:) A foreign key identifier to a concept in the CONCEPT table representing the identity of the field represented by COST_EVENT_ID
note.note_event_field_concept_id#94 AS Concept
cost.cost_event_field_concept_id#278 AS Concept
(for Note:) A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the HL7 LOINC Document Type Vocabulary classification of the note.
(for Concept:) The attribute or concept class of the Concept. Examples are 'Clinical Drug', 'Ingredient', 'Clinical Finding' etc.
note.note_class_concept_id#98 AS Concept
concept.concept_class_id#371 AS ConceptClass
(for Note:) A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the note character encoding type
(for Note:) A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the language of the note
(for ConceptSynonym:) A foreign key to a Concept representing the language.
concept_synonym.language_concept_id#392 AS Concept
(reversed relation, for NoteNlp:) A foreign key to the Note table note the term was
(for NoteNlp:) A foreign key to the predefined Concept in the Standardized Vocabularies representing the section of the extracted term.
note_nlp.section_concept_id#109 AS Concept
(reversed relation, for Observation:) 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.
(reversed relation, for Observation:) A foreign key to the visit in the VISIT_OCCURRENCE table during which the observation was recorded.
(reversed relation, for Observation:) A foreign key to the visit in the VISIT_DETAIL table during which the observation was recorded.
observation.visit_occurrence_id#133 AS VisitOccurrence
observation.visit_detail_id#134 AS VisitDetail
(for Observation:) A foreign key to a Standard Concept ID for a qualifier (e.g., severity of drug-drug interaction alert)
observation.qualifier_concept_id#130 AS Concept
(for Observation:) A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies referring to the field represented in the OBSERVATION_EVENT_ID.
observation.obs_event_field_concept_id#140 AS Concept
(reversed relation, for ObservationPeriod:) 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.
observation_period.person_id#143 AS Person
(for ObservationPeriod:) A foreign key identifier to the predefined concept in the Standardized Vocabularies reflecting the source of the observation period information, belonging to the 'Obs Period Type' vocabulary
observation_period.period_type_concept_id#146 AS Concept
(for Person:) A foreign key that refers to an identifier in the CONCEPT table for the unique gender of the person.
(for Provider:) The gender of the Provider.
provider.gender_concept_id#344 AS Concept
(for Person:) A foreign key that refers to an identifier in the CONCEPT table for the unique race of the person, belonging to the 'Race' vocabulary.
(for Person:) A foreign key that refers to the standard concept identifier in the Standardized Vocabularies for the ethnicity of the person, belonging to the 'Ethnicity' vocabulary.
person.ethnicity_concept_id#155 AS Concept
(for Person:) A foreign key to the place of residency for the person in the location table, where the detailed address information is stored.
(for CareSite:) A foreign key to the geographic Location in the LOCATION table, where the detailed address information is stored.
(for LocationHistory:) A foreign key to the location table.
location_history.location_id#331 AS Location
(for Person:) A foreign key to the site of primary care in the care_site table, where the details of the care site are stored.
(for VisitDetail:) A foreign key to the care site in the care site table that was visited.
(for VisitOccurrence:) A foreign key to the care site in the care site table that was visited.
(for Provider:) A foreign key to the main Care Site where the provider is practicing.
visit_detail.care_site_id#228 AS CareSite
visit_occurrence.care_site_id#247 AS CareSite
(for Person:) A foreign key to the gender concept that refers to the code used in the source.
(for Provider:) A foreign key to a Concept that refers to the code used in the source.
person.gender_source_concept_id#161 AS Concept
provider.gender_source_concept_id#349 AS Concept
(for Person:) A foreign key to the race concept that refers to the code used in the source.
person.race_source_concept_id#163 AS Concept
(for Person:) A foreign key to the ethnicity concept that refers to the code used in the source.
person.ethnicity_source_concept_id#165 AS Concept
(reversed relation, for ProcedureOccurrence:) 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.
(reversed relation, for ProcedureOccurrence:) A foreign key to the Visit in the VISIT_OCCURRENCE table during which the Procedure was carried out.
(reversed relation, for ProcedureOccurrence:) A foreign key to the Visit Detail in the VISIT_DETAIL table during which the Procedure was carried out.
procedure_occurrence.person_id#167 AS Person
procedure_occurrence.visit_occurrence_id#175 AS VisitOccurrence
procedure_occurrence.visit_detail_id#176 AS VisitDetail
(for ProcedureOccurrence:) A foreign key to a Standard Concept identifier for a modifier to the Procedure (e.g. bilateral). These concepts are typically distinguished by 'Modifier' concept classes (e.g., 'CPT4 Modifier' as part of the 'CPT4' vocabulary).
procedure_occurrence.modifier_concept_id#172 AS Concept
(reversed relation, for Specimen:) A foreign key identifier to the Person for whom the Specimen is recorded.
(for Specimen:) A foreign key to a Standard Concept identifier for the anatomic location of specimen collection.
specimen.anatomic_site_concept_id#188 AS Concept
(for Specimen:) A foreign key to a Standard Concept identifier for the Disease Status of specimen collection.
specimen.disease_status_concept_id#189 AS Concept
(reversed relation, for SurveyConduct:) A foreign key identifier to the Person in the PERSON table about whom the survey was completed.
(reversed relation, for SurveyConduct:) A foreign key to the VISIT_OCCURRENCE table during which the survey was completed
survey_conduct.visit_occurrence_id#217 AS VisitOccurrence
(for SurveyConduct:) A foreign key to the predefined Concept identifier in the Standardized Vocabularies reflecting the name and identity of the survey.
survey_conduct.survey_concept_id#197 AS Concept
(for SurveyConduct:) A foreign key to the predefined Concept identifier in the Standardized Vocabularies indicating whether the survey was completed with assistance.
survey_conduct.assisted_concept_id#203 AS Concept
(for SurveyConduct:) A foreign key to the predefined Concept identifier in the Standardized Vocabularies reflecting the respondent type. Example: Research Associate, Patient.
survey_conduct.respondent_type_concept_id#204 AS Concept
(for SurveyConduct:) A foreign key to the predefined Concept identifier in the Standardized Vocabularies that refers to a certain timing. Example: 3 month follow-up, 6 month follow-up.
survey_conduct.timing_concept_id#205 AS Concept
(for SurveyConduct:) A foreign key to the predefined Concept identifier in the Standardized Vocabularies reflecting the data collection method (e.g. Paper, Telephone, Electronic Questionnaire).
survey_conduct.collection_method_concept_id#206 AS Concept
(for SurveyConduct:) A foreign key to a predefined Concept that refers to the code for the survey name/title used in the source.
survey_conduct.survey_source_concept_id#212 AS Concept
(for SurveyConduct:) A foreign key to the predefined Concept identifier in the Standardized Vocabularies reflecting the validation status of the survey.
survey_conduct.validated_survey_concept_id#214 AS Concept
(for SurveyConduct:) A foreign key to the visit in the VISIT_OCCURRENCE table during which treatment was carried out that relates to this survey.
survey_conduct.response_visit_occurrence_id#218 AS VisitOccurrence
(reversed relation, for VisitDetail:) 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.
(reversed relation, for VisitDetail:) A foreign key that refers to the record in the VISIT_OCCURRENCE table. This is a required field, because for every visit_detail is a child of visit_occurrence and cannot exist without a corresponding parent record in visit_occurrence.
visit_detail.visit_occurrence_id#237 AS VisitOccurrence
(for VisitDetail:) A foreign key to the predefined concept in the 'Place of Service' Vocabulary reflecting the admitting source for a visit.
visit_detail.admitted_from_concept_id#232 AS Concept
(for VisitDetail:) A foreign key to the predefined concept in the 'Place of Service' Vocabulary reflecting the discharge disposition for a visit.
(for VisitOccurrence:) A foreign key to the predefined concept in the Place of Service Vocabulary reflecting the discharge disposition for a visit.
visit_detail.discharge_to_concept_id#234 AS Concept
visit_occurrence.discharge_to_concept_id#252 AS Concept
(for VisitDetail:) A foreign key to the VISIT_DETAIL table of the visit immediately preceding this visit
visit_detail.preceding_visit_detail_id#235 AS VisitDetail
(for VisitDetail:) A foreign key to the VISIT_DETAIL table record to represent the immediate parent visit-detail record.
visit_detail.visit_detail_parent_id#236 AS VisitDetail
(reversed relation, for VisitOccurrence:) 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.
visit_occurrence.person_id#239 AS Person
(for VisitOccurrence:) A foreign key to the predefined concept in the Place of Service Vocabulary reflecting the admitting source for a visit.
visit_occurrence.admitting_source_concept_id#250 AS Concept
(for VisitOccurrence:) A foreign key to the VISIT_OCCURRENCE table of the visit immediately preceding this visit
visit_occurrence.preceding_visit_occurrence_id#254 AS VisitOccurrence
(reversed relation, for ConditionEra:) A 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.
(reversed relation, for DoseEra:) A 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.
(reversed relation, for DrugEra:) A foreign key identifier to the Person who is subjected to the Drug during the fDrug Era. The demographic details of that Person are stored in the PERSON table.
(reversed relation, for Cost:) A unique identifier for each PERSON.
(for Cost:) A foreign key identifier to the concept representing the 3-letter code used to delineate international currencies, such as USD for US Dollar. These belong to the 'Currency' vocabulary
(for Cost:) A foreign key referring to a Standard Concept ID in the Standardized Vocabularies for Revenue codes belonging to the 'Revenue Code' vocabulary.
cost.revenue_code_concept_id#288 AS Concept
(for Cost:) A foreign key referring to a Standard Concept ID in the Standardized Vocabularies for DRG codes belonging to the 'DRG' vocabulary.
(for Cost:) A foreign key to the PAYER_PLAN_PERIOD table, where the details of the Payer, Plan and Family are stored. Record the payer_plan_id that relates to the payer who contributed to the paid_by_payer field.
(reversed relation, for PayerPlanPeriod:) A foreign key identifier to the Person covered by the payer. The demographic details of that Person are stored in the PERSON table.
cost.payer_plan_period_id#292 AS PayerPlanPeriod
payer_plan_period.person_id#294 AS Person
(for PayerPlanPeriod:) A foreign key identifier to the person_id in person table, for the person who is the primary subscriber/contract owner for the record in the payer_plan_period table. Maybe the same person or different person, depending on who is the primary subscriber/contract owner.
payer_plan_period.contract_person_id#295 AS Person
(for PayerPlanPeriod:) A foreign key that refers to a standard Payer concept identifier in the Standarized Vocabularies
payer_plan_period.payer_concept_id#298 AS Concept
(for PayerPlanPeriod:) A foreign key to a payer concept that refers to the code used in the source.
payer_plan_period.payer_source_concept_id#300 AS Concept
(for PayerPlanPeriod:) A foreign key that refers to a standard plan concept identifier that represents the health benefit plan in the Standardized Vocabularies.
payer_plan_period.plan_concept_id#301 AS Concept
(for PayerPlanPeriod:) A foreign key to a plan concept that refers to the plan code used in the source data.
payer_plan_period.plan_source_concept_id#303 AS Concept
(for PayerPlanPeriod:) A foreign key to a standard concept representing the reason justifying the contract between person_id and contract_person_id.
payer_plan_period.contract_concept_id#304 AS Concept
(for PayerPlanPeriod:) A foreign key to a concept that refers to the code used in the source as the reason justifying the contract.
payer_plan_period.contract_source_concept_id#306 AS Concept
(for PayerPlanPeriod:) A foreign key that refers to a concept identifier that represents the sponsor in the Standardized Vocabularies.
payer_plan_period.sponsor_concept_id#307 AS Concept
(for PayerPlanPeriod:) A foreign key to a sponsor concept that refers to the sponsor code used in the source data.
payer_plan_period.sponsor_source_concept_id#309 AS Concept
(for PayerPlanPeriod:) A foreign key that refers to a standard termination reason that represents the reason for the termination in the Standardized Vocabularies.
payer_plan_period.stop_reason_concept_id#311 AS Concept
(for PayerPlanPeriod:) A foreign key to a stop-coverage concept that refers to the code used in the source.
payer_plan_period.stop_reason_source_concept_id#313 AS Concept
(for CareSite:) A foreign key that refers to a Place of Service Concept ID in the Standardized Vocabularies.
care_site.place_of_service_concept_id#316 AS Concept
(for LocationHistory:) The type of relationship between location and entity.
location_history.relationship_type_concept_id#332 AS Concept
(for LocationHistory:) The domain of the entity that is related to the location. Either PERSON, PROVIDER, or CARE_SITE.
(for Concept:) A foreign key to the [DOMAIN](https://github.com/OHDSI/CommonDataModel/wiki/DOMAIN) table the Concept belongs to.
location_history.domain_id#333 AS Domain
(for LocationHistory:) The unique identifier for the entity. References either person_id, provider_id, or care_site_id, depending on domain_id.
(for Provider:) A foreign key to a Standard Specialty Concept ID in the Standardized Vocabularies.
provider.specialty_concept_id#341 AS Concept
provider.specialty_source_concept_id#347 AS Concept
(for Concept:) A foreign key to the [VOCABULARY](https://github.com/OHDSI/CommonDataModel/wiki/VOCABULARY) table indicating from which source the Concept has been adapted.
(for ConceptAncestor:) A foreign key to the concept in the concept table for the higher-level concept that forms the ancestor in the relationship.
concept_ancestor.ancestor_concept_id#377 AS Concept
(for ConceptAncestor:) A foreign key to the concept in the concept table for the lower-level concept that forms the descendant in the relationship.
concept_ancestor.descendant_concept_id#378 AS Concept
(for DrugStrength:) A foreign key to the Concept in the CONCEPT table, representing the identifier for drug Ingredient Concept contained within the drug product.
drug_strength.ingredient_concept_id#397 AS Concept
(for DrugStrength:) A foreign key to the Concept in the CONCEPT table representing the identifier for the Unit for the absolute amount of active ingredient.
drug_strength.amount_unit_concept_id#399 AS Concept
(for DrugStrength:) A foreign key to the Concept in the CONCEPT table representing the identifier for the numerator Unit for the concentration of active ingredient.
drug_strength.numerator_unit_concept_id#401 AS Concept
(for DrugStrength:) A foreign key to the Concept in the CONCEPT table representing the identifier for the denominator Unit for the concentration of active ingredient.
drug_strength.denominator_unit_concept_id#403 AS Concept
(for Relationship:) The identifier for the relationship used to define the reverse relationship between two concepts.
relationship.reverse_relationship_id#412 AS Thing
(for SourceToConceptMap:) A foreign key to the VOCABULARY table defining the vocabulary of the source code that is being translated to a Standard Concept.
source_to_concept_map.source_vocabulary_id#416 AS Vocabulary
(for SourceToConceptMap:) A foreign key to the target Concept to which the source code is being mapped.
source_to_concept_map.target_concept_id#418 AS Concept
(for SourceToConceptMap:) A foreign key to the VOCABULARY table defining the vocabulary of the target Concept.
source_to_concept_map.target_vocabulary_id#419 AS Vocabulary
(for Cohort:) The date when the Cohort Definition criteria for the Person, Provider or Visit first match.
(for ConditionOccurrence:) The date when the instance of the Condition is recorded.
(for DeviceExposure:) The date the Device or supply was applied or used.
(for DrugExposure:) 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.
(for ObservationPeriod:) The start date of the observation period for which data are available from the data source.
(for VisitDetail:) The start date of the visit.
(for VisitOccurrence:) The start date of the visit.
(for PayerPlanPeriod:) The start date of the payer plan period.
(for LocationHistory:) The date the relationship started.
condition_occurrence.condition_start_date#15 AS date
device_exposure.device_exposure_start_date#31 AS date
drug_exposure.drug_exposure_start_date#46 AS date
observation_period.observation_period_start_date#144 AS date
visit_detail.visit_detail_start_date#222 AS date
visit_occurrence.visit_start_date#241 AS date
payer_plan_period.payer_plan_period_start_date#296 AS date
(for Cohort:) The date when the Cohort Definition criteria for the Person, Provider or Visit no longer match or the Cohort membership was terminated.
(for ConditionOccurrence:) The date when the instance of the Condition is considered to have ended.
(for DeviceExposure:) The date use of the Device or supply was ceased.
(for DrugExposure:) The end date for the current instance of Drug utilization. Depending on different sources, it could be a known or an inferred date and denotes the last day at which the patient was still exposed to Drug.
(for ObservationPeriod:) The end date of the observation period for which data are available from the data source.
(for VisitDetail:) The end date of the visit. If this is a one-day visit the end date should match the start date.
(for VisitOccurrence:) The end date of the visit. If this is a one-day visit the end date should match the start date.
(for PayerPlanPeriod:) The end date of the payer plan period.
(for LocationHistory:) The date the relationship ended.
condition_occurrence.condition_end_date#17 AS date
device_exposure.device_exposure_end_date#33 AS date
drug_exposure.drug_exposure_end_date#48 AS date
observation_period.observation_period_end_date#145 AS date
visit_detail.visit_detail_end_date#224 AS date
visit_occurrence.visit_end_date#243 AS date
payer_plan_period.payer_plan_period_end_date#297 AS date
(for CohortDefinition:) A unique identifier for each Cohort.
(for ConditionOccurrence:) A unique identifier for each Condition Occurrence event.
(for DeviceExposure:) A system-generated unique identifier for each Device Exposure.
(for DrugExposure:) A system-generated unique identifier for each Drug utilization event.
(for Measurement:) A unique identifier for each Measurement.
(for Note:) A unique identifier for each note.
(for NoteNlp:) A unique identifier for each term extracted from a note.
(for Observation:) A unique identifier for each observation.
(for ObservationPeriod:) A unique identifier for each observation period.
(for Person:) A unique identifier for each person.
(for ProcedureOccurrence:) A system-generated unique identifier for each Procedure Occurrence.
(for Specimen:) A unique identifier for each specimen.
(for SurveyConduct:) Unique identifier for each completed survey.
(for VisitDetail:) A unique identifier for each Person's visit or encounter at a healthcare provider.
(for VisitOccurrence:) A unique identifier for each Person's visit or encounter at a healthcare provider.
(for ConditionEra:) A unique identifier for each Condition Era.
(for DoseEra:) A unique identifier for each Dose Era.
(for DrugEra:) A unique identifier for each Drug Era.
(for Cost:) A unique identifier for each COST record.
(for PayerPlanPeriod:) A identifier for each unique combination of payer, plan, family code and time span.
(for CareSite:) A unique identifier for each Care Site.
(for Location:) A unique identifier for each geographic location.
(for Provider:) A unique identifier for each Provider.
(for Concept:) A unique identifier for each Concept across all domains.
(for ConceptClass:) A unique key for each class.
(for Domain:) A unique key for each domain.
(for Relationship:) The type of relationship captured by the relationship record.
(for Vocabulary:) A unique identifier for each Vocabulary, such as ICD9CM, SNOMED, Visit.
cohort_definition.cohort_definition_id#5 AS int|str
condition_occurrence.condition_occurrence_id#12 AS int|str
device_exposure.device_exposure_id#28 AS int|str
drug_exposure.drug_exposure_id#43 AS int|str
measurement.measurement_id#71 AS int|str
observation.observation_id#121 AS int|str
observation_period.observation_period_id#142 AS int|str
procedure_occurrence.procedure_occurrence_id#166 AS int|str
survey_conduct.survey_conduct_id#195 AS int|str
visit_detail.visit_detail_id#219 AS int|str
visit_occurrence.visit_occurrence_id#238 AS int|str
condition_era.condition_era_id#255 AS int|str
payer_plan_period.payer_plan_period_id#293 AS int|str
concept_class.concept_class_id#381 AS int|str
relationship.relationship_id#408 AS int|str
(for CohortDefinition:) A short description of the Cohort.
(for CareSite:) The verbatim description or name of the Care Site as in data source
(for Provider:) A description of the Provider.
(for CdmSource:) The full name of the source
(for Metadata:) The name of the Concept stored in metadata_concept_id or a description of the data being stored.
(for Concept:) An unambiguous, meaningful and descriptive name for the Concept.
(for ConceptClass:) The name describing the Concept Class, e.g. "Clinical Finding", "Ingredient", etc.
(for ConceptSynonym:) The alternative name for the Concept.
(for Domain:) The name describing the Domain, e.g. "Condition", "Procedure", "Measurement" etc.
(for Relationship:) The text that describes the relationship type.
(for Vocabulary:) The name describing the vocabulary, for example "International Classification of Diseases, Ninth Revision, Clinical Modification, Volume 1 and 2 (NCHS)" etc.
cohort_definition.cohort_definition_name#6 AS str
concept_class.concept_class_name#382 AS str
concept_synonym.concept_synonym_name#391 AS str
relationship.relationship_name#409 AS str
(for CohortDefinition:) A complete description of the Cohort definition
cohort_definition.cohort_definition_description#7 AS str
(for CohortDefinition:) Syntax or code to operationalize the Cohort definition
cohort_definition.cohort_definition_syntax#9 AS str
(for CohortDefinition:) A date to indicate when the Cohort was initiated in the COHORT table
cohort_definition.cohort_initiation_date#11 AS date
(for ConditionOccurrence:) The date and time when the instance of the Condition is recorded.
(for DeviceExposure:) The date and time the Device or supply was applied or used.
(for DrugExposure:) The start date and time for the current instance of Drug utilization. Valid entries include a start datetime of a prescription, the date and time a prescription was filled, or the date and time on which a Drug administration procedure was recorded.
(for VisitDetail:) The date and time of the visit started.
(for VisitOccurrence:) The date and time of the visit started.
(for ConditionEra:) The 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.
(for DoseEra:) The 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.
(for DrugEra:) The 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 conutilization of a Drug.
condition_occurrence.condition_start_datetime#16 AS datetime
device_exposure.device_exposure_start_datetime#32 AS datetime
drug_exposure.drug_exposure_start_datetime#47 AS datetime
visit_detail.visit_detail_start_datetime#223 AS datetime
visit_occurrence.visit_start_datetime#242 AS datetime
condition_era.condition_era_start_datetime#258 AS date
dose_era.dose_era_start_datetime#266 AS date
drug_era.drug_era_start_datetime#271 AS date
(for DeviceExposure:) The date and time use of the Device or supply was ceased.
(for DrugExposure:) The end date and time for the current instance of Drug utilization. Depending on different sources, it could be a known or an inferred date and time and denotes the last day at which the patient was still exposed to Drug.
(for VisitDetail:) The date and time of the visit end.
(for VisitOccurrence:) The date and time of the visit end.
(for ConditionEra:) The 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.
(for DoseEra:) The 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.
(for DrugEra:) The 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.
condition_occurrence.condition_end_datetime#18 AS datetime
device_exposure.device_exposure_end_datetime#34 AS datetime
drug_exposure.drug_exposure_end_datetime#49 AS datetime
visit_detail.visit_detail_end_datetime#225 AS datetime
visit_occurrence.visit_end_datetime#244 AS datetime
condition_era.condition_era_end_datetime#259 AS date
dose_era.dose_era_end_datetime#267 AS date
drug_era.drug_era_end_datetime#272 AS date
(for ConditionOccurrence:) The reason that the Condition was no longer present, as indicated in the source data.
(for DrugExposure:) The reason the Drug was stopped. Reasons include regimen completed, changed, removed, etc.
condition_occurrence.stop_reason#21 AS str
(for ConditionOccurrence:) The source code for the Condition as it appears in the source data. This code is mapped to a Standard Condition Concept in the Standardized Vocabularies and the original code is stored here for reference.
(for DeviceExposure:) The source code for the Device as it appears in the source data. This code is mapped to a Standard Device Concept in the Standardized Vocabularies and the original code is stored here for reference.
(for DrugExposure:) The source code for the Drug as it appears in the source data. This code is mapped to a Standard Drug concept in the Standardized Vocabularies and the original code is, stored here for reference.
(for Measurement:) The Measurement name as it appears in the source data. This code is mapped to a Standard Concept in the Standardized Vocabularies and the original code is stored here for reference.
(for Note:) The source value associated with the origin of the Note
(for Observation:) The observation code as it appears in the source data. This code is mapped to a Standard Concept in the Standardized Vocabularies and the original code is, stored here for reference.
(for Person:) 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.
(for ProcedureOccurrence:) The source code for the Procedure as it appears in the source data. This code is mapped to a standard procedure Concept in the Standardized Vocabularies and the original code is, stored here for reference. Procedure source codes are typically ICD-9-Proc, CPT-4, HCPCS or OPCS-4 codes.
(for Specimen:) The Specimen value as it appears in the source data. This value is mapped to a Standard Concept in the Standardized Vocabularies and the original code is, stored here for reference.
(for VisitDetail:) The source code for the visit as it appears in the source data.
(for VisitOccurrence:) The source code for the visit as it appears in the source data.
(for Cost:) The source value for the cost as it appears in the source data
(for CareSite:) The identifier for the Care Site in the source data, stored here for reference.
(for Location:) The verbatim information that is used to uniquely identify the location as it appears in the source data.
(for Provider:) The identifier used for the Provider in the source data, stored here for reference.
condition_occurrence.condition_source_value#25 AS str
device_exposure.device_source_value#41 AS str
drug_exposure.drug_source_value#62 AS str
measurement.measurement_source_value#87 AS str
observation.observation_source_value#135 AS str
procedure_occurrence.procedure_source_value#177 AS str
specimen.specimen_source_value#191 AS str
visit_detail.visit_detail_source_value#229 AS str
visit_occurrence.visit_source_value#248 AS str
care_site.care_site_source_value#318 AS str
location.location_source_value#328 AS str
provider.provider_source_value#345 AS str
(for ConditionOccurrence:) The source code for the condition status as it appears in the source data. This code is mapped to a Standard Concept in the Standardized Vocabularies and the original code is stored here for reference.
condition_occurrence.condition_status_source_value#27 AS str
(for DeviceExposure:) The number of individual Devices used in the exposure.
(for DrugExposure:) The quantity of drug as recorded in the original prescription or dispensing record.
(for ProcedureOccurrence:) The quantity of procedures ordered or administered.
(for Specimen:) The amount of specimen collection from the person during the sampling procedure.
procedure_occurrence.quantity#173 AS int
(for DrugExposure:) The known end date of a drug_exposure as provided by the source.
drug_exposure.verbatim_end_date#50 AS date
(for DrugExposure:) The number of refills after the initial prescription. The initial prescription is not counted, values start with null.
(for DrugExposure:) The number of days of supply of the medication as prescribed. This reflects the intention of the provider for the length of exposure.
(for DrugExposure:) The directions ('signetur') on the Drug prescription as recorded in the original prescription (and printed on the container) or dispensing record.
(for DrugExposure:) An identifier assigned to a particular quantity or lot of Drug product from the manufacturer.
(for DrugExposure:) The information about the route of administration as detailed in the source.
drug_exposure.route_source_value#64 AS str
(for DrugExposure:) The information about the dose unit as detailed in the source.
drug_exposure.dose_unit_source_value#65 AS str
(for FactRelationship:) The concept representing the domain of fact one, from which the corresponding table can be inferred.
fact_relationship.domain_concept_id_1#66 AS int
(for FactRelationship:) The unique identifier in the table corresponding to the domain of fact one.
(for FactRelationship:) The concept representing the domain of fact two, from which the corresponding table can be inferred.
fact_relationship.domain_concept_id_2#68 AS int
(for FactRelationship:) The unique identifier in the table corresponding to the domain of fact two.
(for Measurement:) The date of the Measurement.
(for Note:) The date the note was recorded.
(for NoteNlp:) The date of the note processing.Useful for data provenance.
(for Observation:) The date of the observation.
(for ProcedureOccurrence:) The date on which the Procedure was performed.
(for Specimen:) The date the specimen was obtained from the Person.
observation.observation_date#124 AS date
procedure_occurrence.procedure_date#169 AS date
(for Measurement:) The date and time of the Measurement. Some database systems don't have a datatype of time. To accommodate all temporal analyses, datatype datetime can be used (combining measurement_date and measurement_time [forum discussion](http://forums.ohdsi.org/t/date-time-and-datetime-problem-and-the-world-of-hours-and-1day/314))
(for Note:) The date and time the note was recorded.
(for NoteNlp:) The date and time of the note processing. Useful for data provenance.
(for Observation:) The date and time of the observation.
(for ProcedureOccurrence:) The date and time on which the Procedure was performed.
(for Specimen:) The date and time on the date when the Specimen was obtained from the person.
(for Metadata:) The date and time associated with the metadata
measurement.measurement_datetime#75 AS datetime
observation.observation_datetime#125 AS datetime
procedure_occurrence.procedure_datetime#170 AS datetime
specimen.specimen_datetime#185 AS datetime
metadata.metadata_datetime#366 AS datetime
(for Measurement:) The time of the Measurement. This is present for backwards compatibility and will be deprecated in an upcoming version
(for Measurement:) A Measurement result where the result is expressed as a numeric value.
(for Observation:) The observation result stored as a number. This is applicable to observations where the result is expressed as a numeric value.
observation.value_as_number#127 AS float
(for Measurement:) The lower limit of the normal range of the Measurement result. The lower range is assumed to be of the same unit of measure as the Measurement value.
(for Measurement:) The upper limit of the normal range of the Measurement. The upper range is assumed to be of the same unit of measure as the Measurement value.
(for Measurement:) The source code for the unit as it appears in the source data. This code is mapped to a standard unit concept in the Standardized Vocabularies and the original code is stored here for reference.
(for Observation:) The source code for the unit as it appears in the source data. This code is mapped to a standard unit concept in the Standardized Vocabularies and the original code is, stored here for reference.
(for Specimen:) The information about the Unit as detailed in the source.
observation.unit_source_value#137 AS str
(for Measurement:) The source value associated with the content of the value_as_number or value_as_concept_id as stored in the source data.
measurement.value_source_value#90 AS str
(for Note:) The title of the Note as it appears in the source.
(for Note:) The content of the Note.
(for NoteNlp:) A small window of text surrounding the term.
(for NoteNlp:) Character offset of the extracted term in the input note.
(for NoteNlp:) Raw text extracted from the NLP tool.
(for NoteNlp:) Name and version of the NLP system that extracted the term.Useful for data provenance.
(for NoteNlp:) A summary modifier that signifies presence or absence of the term for a given patient. Useful for quick querying.
(for NoteNlp:) An optional time modifier associated with the extracted term. (for now “past” or “present” only). Standardize it later.
(for NoteNlp:) A compact description of all the modifiers of the specific term extracted by the NLP system. (e.g. “son has rash” ? “negated=no,subject=family, certainty=undef,conditional=false,general=false”).
(for Observation:) The observation result stored as a string. This is applicable to observations where the result is expressed as verbatim text.
(for Metadata:) The metadata value stored as a string.
(for Observation:) The source value associated with a qualifier to characterize the observation
observation.qualifier_source_value#138 AS str
(for Observation:) The observation result stored as a datetime value. This is applicable to observations where the result is expressed as a point in time.
observation.value_as_datetime#141 AS int
(for Person:) 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.
(for Provider:) The year of birth of the Provider.
(for Person:) 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.
(for Person:) 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.
(for Person:) The date and time of birth of the person.
(for Person:) The date and time of death of the person.
(for Person:) 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.
(for Provider:) The gender code for the Provider as it appears in the source data, stored here for reference.
(for Person:) 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.
(for Person:) 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.
person.ethnicity_source_value#164 AS str
(for ProcedureOccurrence:) The source code for the qualifier as it appears in the source data.
procedure_occurrence.modifier_source_value#179 AS str
(for Specimen:) The information about the anatomic site as detailed in the source.
specimen.anatomic_site_source_value#193 AS str
(for Specimen:) The information about the disease status as detailed in the source.
specimen.disease_status_source_value#194 AS str
(for SurveyConduct:) Date on which the survey was started.
survey_conduct.survey_start_date#198 AS date
(for SurveyConduct:) Date and time the survey was started.
survey_conduct.survey_start_datetime#199 AS datetime
(for SurveyConduct:) Date on which the survey was completed.
survey_conduct.survey_end_date#200 AS date
(for SurveyConduct:) Date and time the survey was completed.
survey_conduct.survey_end_datetime#201 AS datetime
(for SurveyConduct:) Source value representing whether patient required assistance to complete the survey. Example: “Completed without assistance”, ”Completed with assistance”.
survey_conduct.assisted_source_value#207 AS str
(for SurveyConduct:) Source code representing role of person who completed the survey.
survey_conduct.respondent_type_source_value#208 AS str
(for SurveyConduct:) Text string representing the timing of the survey. Example: Baseline, 6-month follow-up.
survey_conduct.timing_source_value#209 AS str
(for SurveyConduct:) The collection method as it appears in the source data.
survey_conduct.collection_method_source_value#210 AS str
(for SurveyConduct:) The survey name/title as it appears in the source data.
survey_conduct.survey_source_value#211 AS str
(for SurveyConduct:) Unique identifier for each completed survey in source system.
survey_conduct.survey_source_identifier#213 AS str
(for SurveyConduct:) Source value representing the validation status of the survey.
survey_conduct.validated_survey_source_value#215 AS int
(for SurveyConduct:) Version number of the questionnaire or survey used.
survey_conduct.survey_version_number#216 AS str
(for VisitDetail:) The source code for the admitting source as it appears in the source data.
visit_detail.admitted_from_source_value#231 AS str
(for VisitDetail:) The source code for the discharge disposition as it appears in the source data.
(for VisitOccurrence:) The source code for the discharge disposition as it appears in the source data.
visit_detail.discharge_to_source_value#233 AS str
visit_occurrence.discharge_to_source_value#253 AS str
(for VisitOccurrence:) The source code for the admitting source as it appears in the source data.
visit_occurrence.admitting_source_value#251 AS str
(for ConditionEra:) The number of individual Condition Occurrences used to construct the condition era.
condition_era.condition_occurrence_count#260 AS int
(for DoseEra:) The numeric value of the dose.
(for DrugEra:) The number of individual Drug Exposure occurrences used to construct the Drug Era.
(for DrugEra:) The number of days that are not covered by DRUG_EXPOSURE records that were used to make up the era record.
(for Cost:) The actual financial cost amount
(for Cost:) The first date of service of the clinical event corresponding to the cost as in table capturing the information (e.g. date of visit, date of procedure, date of condition, date of drug etc).
(for Cost:) The date a bill was generated for a service or encounter
(for Cost:) The date payment was received for a service or encounter
(for Cost:) The source value for the Revenue code as it appears in the source data, stored here for reference.
cost.revenue_code_source_value#290 AS str
(for Cost:) The source value for the 3-digit DRG source code as it appears in the source data, stored here for reference.
(for PayerPlanPeriod:) The source code for the payer as it appears in the source data.
payer_plan_period.payer_source_value#299 AS str
(for PayerPlanPeriod:) The source code for the Person's health benefit plan as it appears in the source data.
payer_plan_period.plan_source_value#302 AS str
(for PayerPlanPeriod:) The source code representing the reason justifying the contract. Usually it is family relationship like a spouse, domestic partner, child etc.
payer_plan_period.contract_source_value#305 AS int
(for PayerPlanPeriod:) The source code for the Person's sponsor of the health plan as it appears in the source data.
payer_plan_period.sponsor_source_value#308 AS str
(for PayerPlanPeriod:) The source code for the Person's family as it appears in the source data.
payer_plan_period.family_source_value#310 AS str
(for PayerPlanPeriod:) The reason for stop-coverage as it appears in the source data.
payer_plan_period.stop_reason_source_value#312 AS str
(for CareSite:) The source code for the Place of Service as it appears in the source data, stored here for reference.
care_site.place_of_service_source_value#319 AS str
(for Location:) The address field 1, typically used for the street address, as it appears in the source data.
(for Location:) The address field 2, typically used for additional detail such as buildings, suites, floors, as it appears in the source data.
(for Location:) The city field as it appears in the source data.
(for Location:) The state field as it appears in the source data.
(for Location:) The zip or postal code.
(for Location:) The county.
(for Location:) The country
(for Location:) The geocoded latitude
(for Location:) The geocoded longitude
(for Provider:) The National Provider Identifier (NPI) of the provider.
(for Provider:) The Drug Enforcement Administration (DEA) number of the provider.
(for Provider:) The source code for the Provider specialty as it appears in the source data, stored here for reference.
provider.specialty_source_value#346 AS str
(for CdmSource:) An abbreviation of the name
cdm_source.cdm_source_abbreviation#351 AS str
(for CdmSource:) The name of the organization responsible for the development of the CDM instance
(for CdmSource:) A description of the source data origin and purpose for collection. The description may contain a summary of the period of time that is expected to be covered by this dataset.
cdm_source.source_description#353 AS str
(for CdmSource:) URL or other external reference to location of source documentation
cdm_source.source_documentation_reference#354 AS str
(for CdmSource:) URL or other external reference to location of ETL specification documentation and ETL source code
(for CdmSource:) The date for which the source data are most current, such as the last day of data capture
cdm_source.source_release_date#356 AS date
(for CdmSource:) The date when the CDM was instantiated
(for CdmSource:) The version of CDM used
(for CdmSource:) The version of the vocabulary used
cdm_source.vocabulary_version#359 AS str
(for Metadata:) The date associated with the metadata
(for Concept:) This flag determines where a Concept is a Standard Concept, i.e. is used in the data, a Classification Concept, or a non-standard Source Concept. The allowables values are 'S' (Standard Concept) and 'C' (Classification Concept), otherwise the content is NULL.
(for Concept:) The concept code represents the identifier of the Concept in the source vocabulary, such as SNOMED-CT concept IDs, RxNorm RXCUIs etc. Note that concept codes are not unique across vocabularies.
(for Concept:) The date when the Concept was first recorded. The default value is 1-Jan-1970, meaning, the Concept has no (known) date of inception.
(for ConceptRelationship:) The date when the instance of the Concept Relationship is first recorded.
(for DrugStrength:) The date when the Concept was first recorded. The default value is 1-Jan-1970.
(for SourceToConceptMap:) The date when the mapping instance was first recorded.
concept_relationship.valid_start_date#387 AS date
drug_strength.valid_start_date#405 AS date
source_to_concept_map.valid_start_date#420 AS date
(for Concept:) The date when the Concept became invalid because it was deleted or superseded (updated) by a new concept. The default value is 31-Dec-2099, meaning, the Concept is valid until it becomes deprecated.
(for ConceptRelationship:) The date when the Concept Relationship became invalid because it was deleted or superseded (updated) by a new relationship. Default value is 31-Dec-2099.
(for DrugStrength:) The date when the concept became invalid because it was deleted or superseded (updated) by a new Concept. The default value is 31-Dec-2099.
(for SourceToConceptMap:) The date when the mapping instance became invalid because it was deleted or superseded (updated) by a new relationship. Default value is 31-Dec-2099.
concept_relationship.valid_end_date#388 AS date
drug_strength.valid_end_date#406 AS date
source_to_concept_map.valid_end_date#421 AS date
(for Concept:) Reason the Concept was invalidated. Possible values are D (deleted), U (replaced with an update) or NULL when valid_end_date has the default value.
(for ConceptRelationship:) Reason the relationship was invalidated. Possible values are 'D' (deleted), 'U' (replaced with an update) or NULL when valid_end_date has the default value.
(for DrugStrength:) Reason the concept was invalidated. Possible values are 'D' (deleted), 'U' (replaced with an update) or NULL when valid_end_date has the default value.
(for SourceToConceptMap:) 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.
concept_relationship.invalid_reason#389 AS str
source_to_concept_map.invalid_reason#422 AS str
(for ConceptAncestor:) The minimum separation in number of levels of hierarchy between ancestor and descendant concepts. This is an attribute that is used to simplify hierarchic analysis.
concept_ancestor.min_levels_of_separation#379 AS int
(for ConceptAncestor:) The maximum separation in number of levels of hierarchy between ancestor and descendant concepts. This is an attribute that is used to simplify hierarchic analysis.
concept_ancestor.max_levels_of_separation#380 AS int
(for ConceptRelationship:) A foreign key to a Concept in the [CONCEPT](https://github.com/OHDSI/CommonDataModel/wiki/CONCEPT) table associated with the relationship. Relationships are directional, and this field represents the source concept designation.
concept_relationship.concept_id_1#384 AS int
(for ConceptRelationship:) A foreign key to a Concept in the [CONCEPT](https://github.com/OHDSI/CommonDataModel/wiki/CONCEPT) table associated with the relationship. Relationships are directional, and this field represents the destination concept designation.
concept_relationship.concept_id_2#385 AS int
(for DrugStrength:) The numeric value associated with the amount of active ingredient contained within the product.
(for DrugStrength:) The numeric value associated with the concentration of the active ingredient contained in the product
drug_strength.numerator_value#400 AS float
(for DrugStrength:) The amount of total liquid (or other divisible product, such as ointment, gel, spray, etc.).
drug_strength.denominator_value#402 AS float
(for DrugStrength:) The number of units of Clinical of Branded Drug, or Quantified Clinical or Branded Drug contained in a box as dispensed to the patient
(for Relationship:) Defines whether a relationship defines concepts into classes or hierarchies. Values are 1 for hierarchical relationship or 0 if not.
(for Relationship:) Defines whether a hierarchical relationship contributes to the concept_ancestor table. These are subsets of the hierarchical relationships. Valid values are 1 or 0.
relationship.defines_ancestry#411 AS str
(for SourceToConceptMap:) The source code being translated into a Standard Concept.
source_to_concept_map.source_code#414 AS str
(for SourceToConceptMap:) An 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.
source_to_concept_map.source_code_description#417 AS str
(for Vocabulary:) External reference to documentation or available download of the about the vocabulary.
vocabulary.vocabulary_reference#425 AS str
(for Vocabulary:) Version of the Vocabulary as indicated in the source.
vocabulary.vocabulary_version#426 AS str