metav2

Tables (19)

care_site

  • care_site_id — int — Primary key — NOT NULL
  • location_id — int — Foreign key → location.location_id — NOT NULL
  • care_site_name — varchar
  • care_site_source_value — varchar
  • place_of_service_source_value — varchar

concept

  • concept_id — varchar — Primary key — NOT NULL
  • concept_name — varchar
  • domain_id — varchar
  • vocabulary_id — varchar
  • concept_class_id — varchar
  • standard_concept — varchar
  • concept_code — varchar
  • valid_start_date — date
  • valid_end_date — date
  • invalid_reason — varchar

condition_occurrence

  • visit_occurrence_id (visit_occurrence_id2) — int — Foreign key → visit_occurrence.visit_occurrence_id — NOT NULL
  • concept_id (concept_id2) — varchar — Foreign key → concept.concept_id — NOT NULL
  • condition_occurrence_id — int
  • person_id — int
  • condition_concept_id — int
  • condition_start_date — date
  • condition_start_datetime — datetime2
  • condition_end_date — date
  • condition_end_datetime — datetime2
  • condition_type_souce_value — varchar
  • stop_reason — varchar
  • provider_id — int
  • visit_detail_id — int
  • condition_source_value — varchar
  • condition_status_source_value — varchar

cost

  • cost_id — int
  • cost_event_id — int
  • cost_domain_id — varchar
  • cost_type_concept_id — int
  • currency_concept_id — int
  • 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 — int
  • amount_allowed — float
  • revenue_code_concept_id — int
  • reveue_code_source_value — varchar
  • drg_concept_id — int
  • drg_source_value — varchar
  • device_exposure_id — int — Foreign key → device_exposure.device_exposure_id — NOT NULL
  • visit_occurrence_id (visit_occurrence_id2) — int — Foreign key → device_exposure.visit_occurrence_id — NOT NULL
  • concept_id (concept_id2) — varchar — Foreign key → device_exposure.concept_id — NOT NULL
  • drug_exposure_id — int — Foreign key → drug_exposure.drug_exposure_id — NOT NULL
  • visit_occurrence_id (visit_occurrence_id22) — int — Foreign key → drug_exposure.visit_occurrence_id — NOT NULL
  • concept_id (concept_id3) — varchar — Foreign key → drug_exposure.concept_id — NOT NULL
  • concept_id (concept_id22) — varchar — Foreign key → drug_exposure.concept_id — NOT NULL
  • procedure_occurrence_id — int — Foreign key → procedure_occurrence.procedure_occurrence_id — NOT NULL
  • visit_occurrence_id (visit_occurrence_id23) — int — Foreign key → procedure_occurrence.visit_occurrence_id — NOT NULL
  • concept_id (concept_id23) — varchar — Foreign key → procedure_occurrence.concept_id — NOT NULL

death

  • person_id — int — Foreign key → person.person_id — NOT NULL
  • care_site_id (care_site_id2) — int — Foreign key → person.care_site_id — NOT NULL
  • death_date — date
  • death_datetime — datetime2
  • death_type_source_value (death_type_concept_id) — int
  • cause_source_value — varchar

device_exposure

  • device_exposure_id — int — Primary key — NOT NULL
  • visit_occurrence_id (visit_occurrence_id2) — int — Foreign key → visit_occurrence.visit_occurrence_id — NOT NULL
  • concept_id — varchar — Foreign key → concept.concept_id — NOT NULL
  • person_id — int
  • device_exposure_start_date — date
  • device_exposure_start_datetime — datetime2
  • device_exposure_end_date — date
  • device_exposure_end_datetime — datetime2
  • device_type_source_value — varchar
  • unique_device_id — varchar
  • quantity — int
  • provider_id — int
  • visit_occurrence_id — int
  • visit_detail_id — int
  • device_source_value — varchar

drug_exposure

  • drug_exposure_id — int — Primary key — NOT NULL
  • visit_occurrence_id (visit_occurrence_id2) — int — Foreign key → visit_occurrence.visit_occurrence_id — NOT NULL
  • concept_id — varchar — Foreign key → concept.concept_id — NOT NULL
  • concept_id (concept_id2) — varchar — Foreign key → concept.concept_id — NOT NULL
  • person_id — int
  • drug_exposure_start_date — date
  • drug_exposure_start_datetime — datetime2
  • drug_exposure_end_date — date
  • drug_exposure_end_datetime — datetime2
  • verbatim_end_date — date
  • drug_type_source_value — varchar
  • stop_reason — varchar
  • refills — int
  • quantity — float
  • days_supply — int
  • sig — varchar
  • lot_number — varchar
  • provider_id — int
  • visit_detail_id — int
  • drug_source_value — varchar
  • route_source_value — varchar
  • dose_unit_source_value — varchar

location

  • location_id — int — Primary key — NOT NULL
  • address_1 — varchar
  • address_2 — varchar
  • city — varchar
  • state — varchar
  • zip — varchar
  • county — varchar
  • location_source_value — varchar

measurement

  • visit_occurrence_id (visit_occurrence_id2) — int — Foreign key → visit_occurrence.visit_occurrence_id — NOT NULL
  • concept_id (concept_id2) — varchar — Foreign key → concept.concept_id — NOT NULL
  • measurement_id — int
  • person_id — int
  • measurement_concept_id — int
  • measurement_date — date
  • measurement_datetime — datetime2
  • measurement_time — varchar
  • measurement_type_source_value — varchar
  • value_as_number — float
  • range_low — float
  • range_high — float
  • provider_id — int
  • visit_detail_id — int
  • measurement_source_value — varchar
  • unit_source_value — varchar
  • value_source_value — varchar
  • exam_gb — varchar

note

  • visit_occurrence_id (visit_occurrence_id2) — int — Foreign key → visit_occurrence.visit_occurrence_id — NOT NULL
  • note_id — int
  • person_id — int
  • note_date — date
  • note_datetime — datetime2
  • note_type_source_value — varchar
  • note_title — varchar
  • note_text — varchar
  • encoding_source_value — varchar
  • language_concept_id (language_source_value) — varchar
  • provider_id — int
  • visit_detail_id — int
  • note_source_value — varchar

observation

  • visit_occurrence_id (visit_occurrence_id2) — int — Foreign key → visit_occurrence.visit_occurrence_id — NOT NULL
  • observation_id — int
  • person_id — int
  • observation_date — date
  • observation_datetime — datetime2
  • observation_type_source_value — varchar
  • value_as_number — float
  • value_as_string — varchar
  • unit_concept_id — int
  • provider_id — int
  • visit_detail_id — int
  • observation_source_value — varchar
  • unit_source_value — varchar
  • qualifier_source_value — varchar

observation_period

  • observation_period_id — int
  • person_id — int
  • observation_period_start_date — date
  • observation_period_end_date — date
  • period_type_concept_id — int

payer_plan_period

  • person_id (person_id2) — int — Foreign key → person.person_id — NOT NULL
  • payer_plan_period_id — int
  • person_id — int
  • payer_plan_period_start_date — date
  • payer_plan_period_end_date — date
  • payer_source_value — varchar
  • plan_source_value — varchar
  • sponsor_source_value — varchar
  • family_source_value — varchar
  • stop_reason_source_value — varchar

person

  • person_id — int — Primary key — NOT NULL
  • provider_id (provider_id2) — int — Foreign key → provider.provider_id — NOT NULL
  • location_id (location_id2) — int — Foreign key → location.location_id — NOT NULL
  • care_site_id (care_site_id2) — int — Foreign key → provider.care_site_id — NOT NULL
  • year_of_birth — int
  • month_of_birth — int
  • day_of_birth — int
  • birth_datetime — datetime2
  • ethnicity_concept_id — int
  • location_id — int
  • care_site_id — int
  • gender_source_value — varchar
  • race_source_value — varchar
  • ethnicity_source_value — varchar

procedure_occurrence

  • procedure_occurrence_id — int — Primary key — NOT NULL
  • visit_occurrence_id (visit_occurrence_id2) — int — Foreign key → visit_occurrence.visit_occurrence_id — NOT NULL
  • concept_id (concept_id2) — varchar — Foreign key → concept.concept_id — NOT NULL
  • person_id — int
  • procedure_date — date
  • procedure_datetime — datetime2
  • procedure_type_source_value — varchar
  • quantity — int
  • provider_id — int
  • visit_occurrence_id — int
  • visit_detail_id — int
  • procedure_source_value — varchar
  • procedure_source_concept_id — int
  • modifier_source_value — varchar

provider

  • provider_id — int — Primary key — NOT NULL
  • care_site_id (care_site_id2) — int — Foreign key → care_site.care_site_id — NOT NULL
  • provider_name — varchar
  • NPI — varchar
  • DEA — varchar
  • year_of_birth — int
  • provider_source_value — varchar
  • specialty_source_value — varchar
  • gender_source_value — varchar

specimen

  • person_id (person_id2) — int — Foreign key → person.person_id — NOT NULL
  • concept_id — varchar — Foreign key → concept.concept_id — NOT NULL
  • specimen_id — int
  • person_id — int
  • specimen_type_source_value — varchar
  • specimen_date — date
  • specimen_datetime — datetime2
  • quantity — float
  • specimen_source_id — varchar
  • specimen_source_value — varchar
  • unit_source_value — varchar
  • anatomic_site_source_value — varchar
  • disease_status_source_value — varchar

visit_detail

  • visit_detail_id — int — Primary key — NOT NULL
  • visit_occurrence_id — int — Primary key — NOT NULL
  • person_id (person_id2) — int — Foreign key → person.person_id — NOT NULL
  • provider_id (provider_id2) — int — Foreign key → person.provider_id — NOT NULL
  • care_site_id (care_site_id2) — int — Foreign key → person.care_site_id — NOT NULL
  • visit_detail_start_date — date
  • visit_detail_start_datetime — datetime2
  • visit_detail_end_date — date
  • visit_detail_end_datetime — datetime2
  • preceding_visit_detail_id — int
  • visit_detail_source_value — varchar
  • admitting_source_value — varchar
  • discharge_to_source_value — varchar
  • visit_detail_parent_id — int
  • visit_type_source_value — varchar

visit_occurrence

  • visit_occurrence_id (visit_occurrence_id2) — int — Foreign key → visit_detail.visit_occurrence_id — NOT NULL
  • person_id (person_id2) — int — Foreign key → visit_detail.person_id — NOT NULL
  • provider_id (provider_id2) — int — Foreign key → visit_detail.provider_id — NOT NULL
  • care_site_id (care_site_id2) — int — Foreign key → visit_detail.care_site_id — NOT NULL
  • visit_start_date — date
  • visit_start_datetime — datetime2
  • visit_end_date — date
  • visit_end_datetime — datetime2
  • visit_type_source_value — varchar
  • visit_source_value — varchar
  • admitting_source_value — varchar
  • discharge_to_source_value — varchar
  • preceding_visit_occurrence_id — int