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