OMOP CDM

Tables (39)

CARE_SITE

  • care_site_id — integer — NOT NULL
  • care_site_name — varchar(255)
  • place_of_service_concept_id — integer
  • location_id — integer
  • 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 — CLOB
  • 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 — 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 — NOT NULL
  • cohort_definition_name — varchar(255) — NOT NULL
  • cohort_definition_description — CLOB
  • definition_type_concept_id — integer — NOT NULL
  • cohort_definition_syntax — CLOB
  • subject_concept_id — integer — NOT NULL
  • cohort_initiation_date — date

CONCEPT

  • concept_id — integer — 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 — NOT NULL
  • descendant_concept_id — integer — NOT NULL
  • min_levels_of_separation — integer — NOT NULL
  • max_levels_of_separation — integer — NOT NULL

CONCEPT_CLASS

  • concept_class_id — varchar(20) — NOT NULL
  • concept_class_name — varchar(255) — NOT NULL
  • concept_class_concept_id — integer — NOT NULL

CONCEPT_RELATIONSHIP

  • concept_id_1 — integer — NOT NULL
  • concept_id_2 — integer — 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 — NOT NULL
  • concept_synonym_name — varchar(1000) — NOT NULL
  • language_concept_id — integer — NOT NULL

CONDITION_ERA

  • condition_era_id — integer — NOT NULL
  • person_id — integer — NOT NULL
  • condition_concept_id — integer — NOT NULL
  • condition_era_start_date — TIMESTAMP — NOT NULL
  • condition_era_end_date — TIMESTAMP — NOT NULL
  • condition_occurrence_count — integer

CONDITION_OCCURRENCE

  • condition_occurrence_id — integer — NOT NULL
  • person_id — integer — NOT NULL
  • condition_concept_id — integer — 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 — NOT NULL
  • condition_status_concept_id — integer
  • stop_reason — varchar(20)
  • provider_id — integer
  • visit_occurrence_id — integer
  • visit_detail_id — integer
  • condition_source_value — varchar(50)
  • condition_source_concept_id — integer
  • condition_status_source_value — varchar(50)

COST

  • cost_id — integer — NOT NULL
  • cost_event_id — integer — NOT NULL
  • cost_domain_id — varchar(20) — NOT NULL
  • cost_type_concept_id — integer — NOT NULL
  • currency_concept_id — integer
  • total_charge — float
  • total_cost — float
  • total_paid — float
  • paid_by_payer — float
  • paid_by_patient — float
  • paid_patient_copay — float
  • paid_patient_coinsurance — float
  • paid_patient_deductible — float
  • paid_by_primary — float
  • paid_ingredient_cost — float
  • paid_dispensing_fee — float
  • payer_plan_period_id — integer
  • amount_allowed — float
  • revenue_code_concept_id — integer
  • revenue_code_source_value — varchar(50)
  • drg_concept_id — integer
  • drg_source_value — varchar(3)

DEATH

  • person_id — integer — NOT NULL
  • death_date — date — NOT NULL
  • death_datetime — TIMESTAMP
  • death_type_concept_id — integer
  • cause_concept_id — integer
  • cause_source_value — varchar(50)
  • cause_source_concept_id — integer

DEVICE_EXPOSURE

  • device_exposure_id — integer — NOT NULL
  • person_id — integer — NOT NULL
  • device_concept_id — integer — 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 — NOT NULL
  • unique_device_id — varchar(255)
  • production_id — varchar(255)
  • quantity — integer
  • provider_id — integer
  • visit_occurrence_id — integer
  • visit_detail_id — integer
  • device_source_value — varchar(50)
  • device_source_concept_id — integer
  • unit_concept_id — integer
  • unit_source_value — varchar(50)
  • unit_source_concept_id — integer

DOMAIN

  • domain_id — varchar(20) — NOT NULL
  • domain_name — varchar(255) — NOT NULL
  • domain_concept_id — integer — NOT NULL

DOSE_ERA

  • dose_era_id — integer — NOT NULL
  • person_id — integer — NOT NULL
  • drug_concept_id — integer — NOT NULL
  • unit_concept_id — integer — NOT NULL
  • dose_value — float — NOT NULL
  • dose_era_start_date — TIMESTAMP — NOT NULL
  • dose_era_end_date — TIMESTAMP — NOT NULL

DRUG_ERA

  • drug_era_id — integer — NOT NULL
  • person_id — integer — NOT NULL
  • drug_concept_id — integer — NOT NULL
  • drug_era_start_date — TIMESTAMP — NOT NULL
  • drug_era_end_date — TIMESTAMP — NOT NULL
  • drug_exposure_count — integer
  • gap_days — integer

DRUG_EXPOSURE

  • drug_exposure_id — integer — NOT NULL
  • person_id — integer — NOT NULL
  • drug_concept_id — integer — 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 — NOT NULL
  • stop_reason — varchar(20)
  • refills — integer
  • quantity — float
  • days_supply — integer
  • sig — CLOB
  • route_concept_id — integer
  • lot_number — varchar(50)
  • provider_id — integer
  • visit_occurrence_id — integer
  • visit_detail_id — integer
  • drug_source_value — varchar(50)
  • drug_source_concept_id — integer
  • route_source_value — varchar(50)
  • dose_unit_source_value — varchar(50)

DRUG_STRENGTH

  • drug_concept_id — integer — NOT NULL
  • ingredient_concept_id — integer — NOT NULL
  • amount_value — float
  • amount_unit_concept_id — integer
  • numerator_value — float
  • numerator_unit_concept_id — integer
  • denominator_value — float
  • denominator_unit_concept_id — integer
  • box_size — integer
  • valid_start_date — date — NOT NULL
  • valid_end_date — date — NOT NULL
  • invalid_reason — varchar(1)

EPISODE

  • episode_id — NUMBER(19) — NOT NULL
  • person_id — NUMBER(19) — NOT NULL
  • episode_concept_id — integer — NOT NULL
  • episode_start_date — date — NOT NULL
  • episode_start_datetime — TIMESTAMP
  • episode_end_date — date
  • episode_end_datetime — TIMESTAMP
  • episode_parent_id — NUMBER(19)
  • episode_number — integer
  • episode_object_concept_id — integer — NOT NULL
  • episode_type_concept_id — integer — NOT NULL
  • episode_source_value — varchar(50)
  • episode_source_concept_id — integer

EPISODE_EVENT

  • episode_id — NUMBER(19) — NOT NULL
  • event_id — NUMBER(19) — NOT NULL
  • episode_event_field_concept_id — integer — 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 — 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 — float
  • longitude — float

MEASUREMENT

  • measurement_id — integer — NOT NULL
  • person_id — integer — NOT NULL
  • measurement_concept_id — integer — NOT NULL
  • measurement_date — date — NOT NULL
  • measurement_datetime — TIMESTAMP
  • measurement_time — varchar(10)
  • measurement_type_concept_id — integer — NOT NULL
  • operator_concept_id — integer
  • value_as_number — float
  • value_as_concept_id — integer
  • unit_concept_id — integer
  • range_low — float
  • range_high — float
  • provider_id — integer
  • visit_occurrence_id — integer
  • visit_detail_id — integer
  • measurement_source_value — varchar(50)
  • measurement_source_concept_id — integer
  • unit_source_value — varchar(50)
  • unit_source_concept_id — integer
  • value_source_value — varchar(50)
  • measurement_event_id — NUMBER(19)
  • meas_event_field_concept_id — integer

METADATA

  • metadata_id — integer — NOT NULL
  • metadata_concept_id — integer — NOT NULL
  • metadata_type_concept_id — integer — NOT NULL
  • name — varchar(250) — NOT NULL
  • value_as_string — varchar(250)
  • value_as_concept_id — integer
  • value_as_number — float
  • metadata_date — date
  • metadata_datetime — TIMESTAMP

NOTE

  • note_id — integer — NOT NULL
  • person_id — integer — NOT NULL
  • note_date — date — NOT NULL
  • note_datetime — TIMESTAMP
  • note_type_concept_id — integer — NOT NULL
  • note_class_concept_id — integer — NOT NULL
  • note_title — varchar(250)
  • note_text — CLOB — NOT NULL
  • encoding_concept_id — integer — NOT NULL
  • language_concept_id — integer — NOT NULL
  • provider_id — integer
  • visit_occurrence_id — integer
  • visit_detail_id — integer
  • note_source_value — varchar(50)
  • note_event_id — NUMBER(19)
  • note_event_field_concept_id — integer

NOTE_NLP

  • note_nlp_id — integer — NOT NULL
  • note_id — integer — NOT NULL
  • section_concept_id — integer
  • snippet — varchar(250)
  • offset — varchar(50)
  • lexical_variant — varchar(250) — NOT NULL
  • note_nlp_concept_id — integer
  • note_nlp_source_concept_id — integer
  • 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 — NOT NULL
  • person_id — integer — NOT NULL
  • observation_concept_id — integer — NOT NULL
  • observation_date — date — NOT NULL
  • observation_datetime — TIMESTAMP
  • observation_type_concept_id — integer — NOT NULL
  • value_as_number — float
  • value_as_string — varchar(60)
  • value_as_concept_id — Integer
  • qualifier_concept_id — integer
  • unit_concept_id — integer
  • provider_id — integer
  • visit_occurrence_id — integer
  • visit_detail_id — integer
  • observation_source_value — varchar(50)
  • observation_source_concept_id — integer
  • unit_source_value — varchar(50)
  • qualifier_source_value — varchar(50)
  • value_source_value — varchar(50)
  • observation_event_id — NUMBER(19)
  • obs_event_field_concept_id — integer

OBSERVATION_PERIOD

  • observation_period_id — integer — NOT NULL
  • person_id — integer — NOT NULL
  • observation_period_start_date — date — NOT NULL
  • observation_period_end_date — date — NOT NULL
  • period_type_concept_id — integer — NOT NULL

PAYER_PLAN_PERIOD

  • payer_plan_period_id — integer — NOT NULL
  • person_id — integer — NOT NULL
  • payer_plan_period_start_date — date — NOT NULL
  • payer_plan_period_end_date — date — NOT NULL
  • payer_concept_id — integer
  • payer_source_value — varchar(50)
  • payer_source_concept_id — integer
  • plan_concept_id — integer
  • plan_source_value — varchar(50)
  • plan_source_concept_id — integer
  • sponsor_concept_id — integer
  • sponsor_source_value — varchar(50)
  • sponsor_source_concept_id — integer
  • family_source_value — varchar(50)
  • stop_reason_concept_id — integer
  • stop_reason_source_value — varchar(50)
  • stop_reason_source_concept_id — integer

PERSON

  • person_id — integer — NOT NULL
  • gender_concept_id — integer — NOT NULL
  • year_of_birth — integer — NOT NULL
  • month_of_birth — integer
  • day_of_birth — integer
  • birth_datetime — TIMESTAMP
  • race_concept_id — integer — NOT NULL
  • ethnicity_concept_id — integer — NOT NULL
  • location_id — integer
  • provider_id — integer
  • care_site_id — integer
  • person_source_value — varchar(50)
  • gender_source_value — varchar(50)
  • gender_source_concept_id — integer
  • race_source_value — varchar(50)
  • race_source_concept_id — integer
  • ethnicity_source_value — varchar(50)
  • ethnicity_source_concept_id — integer

PROCEDURE_OCCURRENCE

  • procedure_occurrence_id — integer — NOT NULL
  • person_id — integer — NOT NULL
  • procedure_concept_id — integer — NOT NULL
  • procedure_date — date — NOT NULL
  • procedure_datetime — TIMESTAMP
  • procedure_end_date — date
  • procedure_end_datetime — TIMESTAMP
  • procedure_type_concept_id — integer — NOT NULL
  • modifier_concept_id — integer
  • quantity — integer
  • provider_id — integer
  • visit_occurrence_id — integer
  • visit_detail_id — integer
  • procedure_source_value — varchar(50)
  • procedure_source_concept_id — integer
  • modifier_source_value — varchar(50)

PROVIDER

  • provider_id — integer — NOT NULL
  • provider_name — varchar(255)
  • npi — varchar(20)
  • dea — varchar(20)
  • specialty_concept_id — integer
  • care_site_id — integer
  • year_of_birth — integer
  • gender_concept_id — integer
  • provider_source_value — varchar(50)
  • specialty_source_value — varchar(50)
  • specialty_source_concept_id — integer
  • gender_source_value — varchar(50)
  • gender_source_concept_id — integer

RELATIONSHIP

  • relationship_id — varchar(20) — 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 — NOT NULL

SOURCE_TO_CONCEPT_MAP

  • source_code — varchar(50) — NOT NULL
  • source_concept_id — integer — NOT NULL
  • source_vocabulary_id — varchar(20) — NOT NULL
  • source_code_description — varchar(255)
  • target_concept_id — integer — NOT NULL
  • target_vocabulary_id — varchar(20) — NOT NULL
  • valid_start_date — date — NOT NULL
  • valid_end_date — date — NOT NULL
  • invalid_reason — varchar(1)

SPECIMEN

  • specimen_id — integer — NOT NULL
  • person_id — integer — NOT NULL
  • specimen_concept_id — integer — NOT NULL
  • specimen_type_concept_id — integer — NOT NULL
  • specimen_date — date — NOT NULL
  • specimen_datetime — TIMESTAMP
  • quantity — float
  • unit_concept_id — integer
  • anatomic_site_concept_id — integer
  • disease_status_concept_id — integer
  • 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 — NOT NULL
  • person_id — integer — NOT NULL
  • visit_detail_concept_id — integer — 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 — NOT NULL
  • provider_id — integer
  • care_site_id — integer
  • visit_detail_source_value — varchar(50)
  • visit_detail_source_concept_id — Integer
  • admitted_from_concept_id — Integer
  • admitted_from_source_value — varchar(50)
  • discharged_to_source_value — varchar(50)
  • discharged_to_concept_id — integer
  • preceding_visit_detail_id — integer
  • parent_visit_detail_id — integer
  • visit_occurrence_id — integer — NOT NULL

VISIT_OCCURRENCE

  • visit_occurrence_id — integer — NOT NULL
  • person_id — integer — NOT NULL
  • visit_concept_id — integer — 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 — NOT NULL
  • provider_id — integer
  • care_site_id — integer
  • visit_source_value — varchar(50)
  • visit_source_concept_id — integer
  • admitted_from_concept_id — integer
  • admitted_from_source_value — varchar(50)
  • discharged_to_concept_id — integer
  • discharged_to_source_value — varchar(50)
  • preceding_visit_occurrence_id — integer

VOCABULARY

  • vocabulary_id — varchar(20) — NOT NULL
  • vocabulary_name — varchar(255) — NOT NULL
  • vocabulary_reference — varchar(255)
  • vocabulary_version — varchar(255)
  • vocabulary_concept_id — integer — NOT NULL