omopcdm
Tables (39)
care_site
- care_site_id — integer — Primary key — NOT NULL
- care_site_name — varchar(255)
- place_of_service_concept_id — integer — Foreign key → concept.concept_id
- location_id — integer — Foreign key → location.location_id
- care_site_source_value — varchar(50)
- place_of_service_source_value — varchar(50)
cdm_source
- cdm_source_name — varchar(255) — NOT NULL
- cdm_source_abbreviation — varchar(25) — NOT NULL
- cdm_holder — varchar(255) — NOT NULL
- source_description — TEXT
- source_documentation_reference — varchar(255)
- cdm_etl_reference — varchar(255)
- source_release_date — date — NOT NULL
- cdm_release_date — date — NOT NULL
- cdm_version — varchar(10)
- cdm_version_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- vocabulary_version — varchar(20) — NOT NULL
cohort
- cohort_definition_id — integer — NOT NULL
- subject_id — integer — NOT NULL
- cohort_start_date — date — NOT NULL
- cohort_end_date — date — NOT NULL
cohort_definition
- cohort_definition_id — integer — Primary key — NOT NULL
- cohort_definition_name — varchar(255) — NOT NULL
- cohort_definition_description — TEXT
- definition_type_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- cohort_definition_syntax — TEXT
- subject_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- cohort_initiation_date — date
concept
- concept_id — integer — Primary key — NOT NULL
- concept_name — varchar(255) — NOT NULL
- domain_id — varchar(20) — NOT NULL
- vocabulary_id — varchar(20) — NOT NULL
- concept_class_id — varchar(20) — NOT NULL
- standard_concept — varchar(1)
- concept_code — varchar(50) — NOT NULL
- valid_start_date — date — NOT NULL
- valid_end_date — date — NOT NULL
- invalid_reason — varchar(1)
concept_ancestor
- ancestor_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- descendant_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- min_levels_of_separation — integer — NOT NULL
- max_levels_of_separation — integer — NOT NULL
concept_class
- concept_class_id — varchar(20) — Primary key — NOT NULL
- concept_class_name — varchar(255) — NOT NULL
- concept_class_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
concept_relationship
- concept_id_1 — integer — Foreign key → concept.concept_id — NOT NULL
- concept_id_2 — integer — Foreign key → concept.concept_id — NOT NULL
- relationship_id — varchar(20) — NOT NULL
- valid_start_date — date — NOT NULL
- valid_end_date — date — NOT NULL
- invalid_reason — varchar(1)
concept_synonym
- concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- concept_synonym_name — varchar(1000) — NOT NULL
- language_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
condition_era
- condition_era_id — integer — Primary key — NOT NULL
- person_id — integer — Foreign key → person.person_id — NOT NULL
- condition_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- condition_era_start_date — date — NOT NULL
- condition_era_end_date — date — NOT NULL
- condition_occurrence_count — integer
condition_occurrence
- condition_occurrence_id — integer — Primary key — NOT NULL
- person_id — integer — Foreign key → person.person_id — NOT NULL
- condition_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- condition_start_date — date — NOT NULL
- condition_start_datetime — TIMESTAMP
- condition_end_date — date
- condition_end_datetime — TIMESTAMP
- condition_type_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- condition_status_concept_id — integer — Foreign key → concept.concept_id
- stop_reason — varchar(20)
- provider_id — integer — Foreign key → provider.provider_id
- visit_occurrence_id — integer — Foreign key → visit_occurrence.visit_occurrence_id
- visit_detail_id — integer — Foreign key → visit_detail.visit_detail_id
- condition_source_value — varchar(50)
- condition_source_concept_id — integer — Foreign key → concept.concept_id
- condition_status_source_value — varchar(50)
cost
- cost_id — integer — Primary key — NOT NULL
- cost_event_id — integer — NOT NULL
- cost_domain_id — varchar(20) — NOT NULL
- cost_type_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- currency_concept_id — integer — Foreign key → concept.concept_id
- total_charge — NUMERIC
- total_cost — NUMERIC
- total_paid — NUMERIC
- paid_by_payer — NUMERIC
- paid_by_patient — NUMERIC
- paid_patient_copay — NUMERIC
- paid_patient_coinsurance — NUMERIC
- paid_patient_deductible — NUMERIC
- paid_by_primary — NUMERIC
- paid_ingredient_cost — NUMERIC
- paid_dispensing_fee — NUMERIC
- payer_plan_period_id — integer — Foreign key → payer_plan_period.payer_plan_period_id
- amount_allowed — NUMERIC
- revenue_code_concept_id — integer — Foreign key → concept.concept_id
- revenue_code_source_value — varchar(50)
- drg_concept_id — integer — Foreign key → concept.concept_id
- drg_source_value — varchar(3)
death
- person_id — integer — Foreign key → person.person_id — NOT NULL
- death_date — date — NOT NULL
- death_datetime — TIMESTAMP
- death_type_concept_id — integer — Foreign key → concept.concept_id
- cause_concept_id — integer — Foreign key → concept.concept_id
- cause_source_value — varchar(50)
- cause_source_concept_id — integer — Foreign key → concept.concept_id
device_exposure
- device_exposure_id — integer — Primary key — NOT NULL
- person_id — integer — Foreign key → person.person_id — NOT NULL
- device_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- device_exposure_start_date — date — NOT NULL
- device_exposure_start_datetime — TIMESTAMP
- device_exposure_end_date — date
- device_exposure_end_datetime — TIMESTAMP
- device_type_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- unique_device_id — varchar(255)
- production_id — varchar(255)
- quantity — integer
- provider_id — integer — Foreign key → provider.provider_id
- visit_occurrence_id — integer — Foreign key → visit_occurrence.visit_occurrence_id
- visit_detail_id — integer — Foreign key → visit_detail.visit_detail_id
- device_source_value — varchar(50)
- device_source_concept_id — integer — Foreign key → concept.concept_id
- unit_concept_id — integer — Foreign key → concept.concept_id
- unit_source_value — varchar(50)
- unit_source_concept_id — integer — Foreign key → concept.concept_id
domain
- domain_id — varchar(20) — Primary key — NOT NULL
- domain_name — varchar(255) — NOT NULL
- domain_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
dose_era
- dose_era_id — integer — Primary key — NOT NULL
- person_id — integer — Foreign key → person.person_id — NOT NULL
- drug_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- unit_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- dose_value — NUMERIC — NOT NULL
- dose_era_start_date — date — NOT NULL
- dose_era_end_date — date — NOT NULL
drug_era
- drug_era_id — integer — Primary key — NOT NULL
- person_id — integer — Foreign key → person.person_id — NOT NULL
- drug_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- drug_era_start_date — date — NOT NULL
- drug_era_end_date — date — NOT NULL
- drug_exposure_count — integer
- gap_days — integer
drug_exposure
- drug_exposure_id — integer — Primary key — NOT NULL
- person_id — integer — Foreign key → person.person_id — NOT NULL
- drug_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- drug_exposure_start_date — date — NOT NULL
- drug_exposure_start_datetime — TIMESTAMP
- drug_exposure_end_date — date — NOT NULL
- drug_exposure_end_datetime — TIMESTAMP
- verbatim_end_date — date
- drug_type_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- stop_reason — varchar(20)
- refills — integer
- quantity — NUMERIC
- days_supply — integer
- sig — TEXT
- route_concept_id — integer — Foreign key → concept.concept_id
- lot_number — varchar(50)
- provider_id — integer — Foreign key → provider.provider_id
- visit_occurrence_id — integer — Foreign key → visit_occurrence.visit_occurrence_id
- visit_detail_id — integer — Foreign key → visit_detail.visit_detail_id
- drug_source_value — varchar(50)
- drug_source_concept_id — integer — Foreign key → concept.concept_id
- route_source_value — varchar(50)
- dose_unit_source_value — varchar(50)
drug_strength
- drug_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- ingredient_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- amount_value — NUMERIC
- amount_unit_concept_id — integer — Foreign key → concept.concept_id
- numerator_value — NUMERIC
- numerator_unit_concept_id — integer — Foreign key → concept.concept_id
- denominator_value — NUMERIC
- denominator_unit_concept_id — integer — Foreign key → concept.concept_id
- box_size — integer
- valid_start_date — date — NOT NULL
- valid_end_date — date — NOT NULL
- invalid_reason — varchar(1)
episode
- episode_id — integer — Primary key — NOT NULL
- person_id — integer — Foreign key → person.person_id — NOT NULL
- episode_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- episode_start_date — date — NOT NULL
- episode_start_datetime — TIMESTAMP
- episode_end_date — date
- episode_end_datetime — TIMESTAMP
- episode_parent_id — integer
- episode_number — integer
- episode_object_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- episode_type_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- episode_source_value — varchar(50)
- episode_source_concept_id — integer — Foreign key → concept.concept_id
episode_event
- episode_id — integer — NOT NULL
- event_id — integer — NOT NULL
- episode_event_field_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
fact_relationship
- domain_concept_id_1 — integer — NOT NULL
- fact_id_1 — integer — NOT NULL
- domain_concept_id_2 — integer — NOT NULL
- fact_id_2 — integer — NOT NULL
- relationship_concept_id — integer — NOT NULL
location
- location_id — integer — Primary key — NOT NULL
- address_1 — varchar(50)
- address_2 — varchar(50)
- city — varchar(50)
- state — varchar(2)
- zip — varchar(9)
- county — varchar(20)
- location_source_value — varchar(50)
- country_concept_id — integer
- country_source_value — varchar(80)
- latitude — NUMERIC
- longitude — NUMERIC
measurement
- measurement_id — integer — Primary key — NOT NULL
- person_id — integer — Foreign key → person.person_id — NOT NULL
- measurement_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- measurement_date — date — NOT NULL
- measurement_datetime — TIMESTAMP
- measurement_time — varchar(10)
- measurement_type_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- operator_concept_id — integer — Foreign key → concept.concept_id
- value_as_number — NUMERIC
- value_as_concept_id — integer — Foreign key → concept.concept_id
- unit_concept_id — integer — Foreign key → concept.concept_id
- range_low — NUMERIC
- range_high — NUMERIC
- provider_id — integer — Foreign key → provider.provider_id
- visit_occurrence_id — integer — Foreign key → visit_occurrence.visit_occurrence_id
- visit_detail_id — integer — Foreign key → visit_detail.visit_detail_id
- measurement_source_value — varchar(50)
- measurement_source_concept_id — integer — Foreign key → concept.concept_id
- unit_source_value — varchar(50)
- unit_source_concept_id — integer — Foreign key → concept.concept_id
- value_source_value — varchar(50)
- measurement_event_id — integer
- meas_event_field_concept_id — integer — Foreign key → concept.concept_id
metadata
- metadata_id — integer — Primary key — NOT NULL
- metadata_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- metadata_type_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- name — varchar(250) — NOT NULL
- value_as_string — varchar(250)
- value_as_concept_id — integer — Foreign key → concept.concept_id
- value_as_number — NUMERIC
- metadata_date — date
- metadata_datetime — TIMESTAMP
note
- note_id — integer — Primary key — NOT NULL
- person_id — integer — Foreign key → person.person_id — NOT NULL
- note_date — date — NOT NULL
- note_datetime — TIMESTAMP
- note_type_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- note_class_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- note_title — varchar(250)
- note_text — TEXT — NOT NULL
- encoding_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- language_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- provider_id — integer — Foreign key → provider.provider_id
- visit_occurrence_id — integer — Foreign key → visit_occurrence.visit_occurrence_id
- visit_detail_id — integer — Foreign key → visit_detail.visit_detail_id
- note_source_value — varchar(50)
- note_event_id — integer
- note_event_field_concept_id — integer
note_nlp
- note_nlp_id — integer — Primary key — NOT NULL
- note_id — integer — Foreign key → note.note_id — NOT NULL
- section_concept_id — integer — Foreign key → concept.concept_id
- snippet — varchar(250)
- offset — varchar(50)
- lexical_variant — varchar(250) — NOT NULL
- note_nlp_concept_id — integer — Foreign key → concept.concept_id
- note_nlp_source_concept_id — integer — Foreign key → concept.concept_id
- nlp_system — varchar(250)
- nlp_date — date — NOT NULL
- nlp_datetime — TIMESTAMP
- term_exists — varchar(1)
- term_temporal — varchar(50)
- term_modifiers — varchar(2000)
observation
- observation_id — integer — Primary key — NOT NULL
- person_id — integer — Foreign key → person.person_id — NOT NULL
- observation_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- observation_date — date — NOT NULL
- observation_datetime — TIMESTAMP
- observation_type_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- value_as_number — NUMERIC
- value_as_string — varchar(60)
- value_as_concept_id — Integer — Foreign key → concept.concept_id
- qualifier_concept_id — integer — Foreign key → concept.concept_id
- unit_concept_id — integer — Foreign key → concept.concept_id
- provider_id — integer — Foreign key → provider.provider_id
- visit_occurrence_id — integer — Foreign key → visit_occurrence.visit_occurrence_id
- visit_detail_id — integer — Foreign key → visit_detail.visit_detail_id
- observation_source_value — varchar(50)
- observation_source_concept_id — integer — Foreign key → concept.concept_id
- unit_source_value — varchar(50)
- qualifier_source_value — varchar(50)
- value_source_value — varchar(50)
- observation_event_id — integer
- obs_event_field_concept_id — integer — Foreign key → concept.concept_id
observation_period
- observation_period_id — integer — Primary key — NOT NULL
- person_id — integer — Foreign key → person.person_id — NOT NULL
- observation_period_start_date — date — NOT NULL
- observation_period_end_date — date — NOT NULL
- period_type_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
payer_plan_period
- payer_plan_period_id — integer — Primary key — NOT NULL
- person_id — integer — Foreign key → person.person_id — NOT NULL
- payer_plan_period_start_date — date — NOT NULL
- payer_plan_period_end_date — date — NOT NULL
- payer_concept_id — integer — Foreign key → concept.concept_id
- payer_source_value — varchar(50)
- payer_source_concept_id — integer — Foreign key → concept.concept_id
- plan_concept_id — integer — Foreign key → concept.concept_id
- plan_source_value — varchar(50)
- plan_source_concept_id — integer — Foreign key → concept.concept_id
- sponsor_concept_id — integer — Foreign key → concept.concept_id
- sponsor_source_value — varchar(50)
- sponsor_source_concept_id — integer — Foreign key → concept.concept_id
- family_source_value — varchar(50)
- stop_reason_concept_id — integer — Foreign key → concept.concept_id
- stop_reason_source_value — varchar(50)
- stop_reason_source_concept_id — integer — Foreign key → concept.concept_id
person
- person_id — integer — Primary key — NOT NULL
- gender_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- year_of_birth — integer — NOT NULL
- month_of_birth — integer
- day_of_birth — integer
- birth_datetime — TIMESTAMP
- race_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- ethnicity_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- location_id — integer — Foreign key → location.location_id
- provider_id — integer — Foreign key → provider.provider_id
- care_site_id — integer — Foreign key → care_site.care_site_id
- person_source_value — varchar(50)
- gender_source_value — varchar(50)
- gender_source_concept_id — integer — Foreign key → concept.concept_id
- race_source_value — varchar(50)
- race_source_concept_id — integer — Foreign key → concept.concept_id
- ethnicity_source_value — varchar(50)
- ethnicity_source_concept_id — integer — Foreign key → concept.concept_id
procedure_occurrence
- procedure_occurrence_id — integer — Primary key — NOT NULL
- person_id — integer — Foreign key → person.person_id — NOT NULL
- procedure_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- procedure_date — date — NOT NULL
- procedure_datetime — TIMESTAMP
- procedure_end_date — date
- procedure_end_datetime — TIMESTAMP
- procedure_type_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- modifier_concept_id — integer — Foreign key → concept.concept_id
- quantity — integer
- provider_id — integer — Foreign key → provider.provider_id
- visit_occurrence_id — integer — Foreign key → visit_occurrence.visit_occurrence_id
- visit_detail_id — integer — Foreign key → visit_detail.visit_detail_id
- procedure_source_value — varchar(50)
- procedure_source_concept_id — integer — Foreign key → concept.concept_id
- modifier_source_value — varchar(50)
provider
- provider_id — integer — Primary key — NOT NULL
- provider_name — varchar(255)
- npi — varchar(20)
- dea — varchar(20)
- specialty_concept_id — integer — Foreign key → concept.concept_id
- care_site_id — integer — Foreign key → care_site.care_site_id
- year_of_birth — integer
- gender_concept_id — integer — Foreign key → concept.concept_id
- provider_source_value — varchar(50)
- specialty_source_value — varchar(50)
- specialty_source_concept_id — integer — Foreign key → concept.concept_id
- gender_source_value — varchar(50)
- gender_source_concept_id — integer — Foreign key → concept.concept_id
relationship
- relationship_id — varchar(20) — Primary key — NOT NULL
- relationship_name — varchar(255) — NOT NULL
- is_hierarchical — varchar(1) — NOT NULL
- defines_ancestry — varchar(1) — NOT NULL
- reverse_relationship_id — varchar(20) — NOT NULL
- relationship_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
source_to_concept_map
- source_code — varchar(50) — NOT NULL
- source_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- source_vocabulary_id — varchar(20) — NOT NULL
- source_code_description — varchar(255)
- target_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- target_vocabulary_id — varchar(20) — Foreign key → vocabulary.vocabulary_id — NOT NULL
- valid_start_date — date — NOT NULL
- valid_end_date — date — NOT NULL
- invalid_reason — varchar(1)
specimen
- specimen_id — integer — Primary key — NOT NULL
- person_id — integer — Foreign key → person.person_id — NOT NULL
- specimen_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- specimen_type_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- specimen_date — date — NOT NULL
- specimen_datetime — TIMESTAMP
- quantity — NUMERIC
- unit_concept_id — integer — Foreign key → concept.concept_id
- anatomic_site_concept_id — integer — Foreign key → concept.concept_id
- disease_status_concept_id — integer — Foreign key → concept.concept_id
- specimen_source_id — varchar(50)
- specimen_source_value — varchar(50)
- unit_source_value — varchar(50)
- anatomic_site_source_value — varchar(50)
- disease_status_source_value — varchar(50)
visit_detail
- visit_detail_id — integer — Primary key — NOT NULL
- person_id — integer — Foreign key → person.person_id — NOT NULL
- visit_detail_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- visit_detail_start_date — date — NOT NULL
- visit_detail_start_datetime — TIMESTAMP
- visit_detail_end_date — date — NOT NULL
- visit_detail_end_datetime — TIMESTAMP
- visit_detail_type_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- provider_id — integer — Foreign key → provider.provider_id
- care_site_id — integer — Foreign key → care_site.care_site_id
- visit_detail_source_value — varchar(50)
- visit_detail_source_concept_id — Integer — Foreign key → concept.concept_id
- admitted_from_concept_id — Integer — Foreign key → concept.concept_id
- admitted_from_source_value — varchar(50)
- discharged_to_source_value — varchar(50)
- discharged_to_concept_id — integer — Foreign key → concept.concept_id
- preceding_visit_detail_id — integer — Foreign key → visit_detail.visit_detail_id
- parent_visit_detail_id — integer — Foreign key → visit_detail.visit_detail_id
- visit_occurrence_id — integer — Foreign key → visit_occurrence.visit_occurrence_id — NOT NULL
visit_occurrence
- visit_occurrence_id — integer — Primary key — NOT NULL
- person_id — integer — Foreign key → person.person_id — NOT NULL
- visit_concept_id — integer — Foreign key → concept.concept_id — NOT NULL
- visit_start_date — date — NOT NULL
- visit_start_datetime — TIMESTAMP
- visit_end_date — date — NOT NULL
- visit_end_datetime — TIMESTAMP
- visit_type_concept_id — Integer — Foreign key → concept.concept_id — NOT NULL
- provider_id — integer — Foreign key → provider.provider_id
- care_site_id — integer — Foreign key → care_site.care_site_id
- visit_source_value — varchar(50)
- visit_source_concept_id — integer — Foreign key → concept.concept_id
- admitted_from_concept_id — integer — Foreign key → concept.concept_id
- admitted_from_source_value — varchar(50)
- discharged_to_concept_id — integer — Foreign key → concept.concept_id
- discharged_to_source_value — varchar(50)
- preceding_visit_occurrence_id — integer — Foreign key → visit_occurrence.visit_occurrence_id
vocabulary
- vocabulary_id — varchar(20) — Primary key — NOT NULL
- vocabulary_name — varchar(255) — NOT NULL
- vocabulary_reference — varchar(255)
- vocabulary_version — varchar(255)
- vocabulary_concept_id — integer — Foreign key → concept.concept_id — NOT NULL