CDM_5.2
Tables (13)
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 — DATETIME2 — NOT NULL
- condition_end_date — DATE
- condition_end_datetime — DATETIME2
- condition_type_concept_id — INTEGER — NOT NULL
- stop_reason — VARCHAR(20)
- provider_id — INTEGER
- visit_occurrence_id — INTEGER
- condition_source_value — VARCHAR(50)
- condition_source_concept_id — INTEGER
- condition_status_source_value — VARCHAR(50)
- condition_status_concept_id — INTEGER
death
- person_id — INTEGER — NOT NULL
- death_date — DATE — NOT NULL
- death_datetime — DATETIME2
- death_type_concept_id — INTEGER — NOT NULL
- 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 — DATETIME2 — NOT NULL
- device_exposure_end_date — DATE
- device_exposure_end_datetime — DATETIME2
- device_type_concept_id — INTEGER — NOT NULL
- unique_device_id — VARCHAR(50)
- quantity — INTEGER
- provider_id — INTEGER
- visit_occurrence_id — INTEGER
- device_source_value — VARCHAR(100)
- device_source_concept_id — 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 — DATETIME2 — NOT NULL
- drug_exposure_end_date — DATE — NOT NULL
- drug_exposure_end_datetime — DATETIME2
- verbatim_end_date — DATE
- drug_type_concept_id — INTEGER — NOT NULL
- stop_reason — VARCHAR(20)
- refills — INTEGER
- quantity — FLOAT
- days_supply — INTEGER
- sig — VARCHAR(MAX)
- route_concept_id — INTEGER
- lot_number — VARCHAR(50)
- provider_id — INTEGER
- visit_occurrence_id — INTEGER
- drug_source_value — VARCHAR(50)
- drug_source_concept_id — INTEGER
- route_source_value — VARCHAR(50)
- dose_unit_source_value — VARCHAR(50)
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
measurement
- measurement_id — INTEGER — NOT NULL
- person_id — INTEGER — NOT NULL
- measurement_concept_id — INTEGER — NOT NULL
- measurement_date — DATE — NOT NULL
- measurement_datetime — DATETIME2
- 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
- measurement_source_value — VARCHAR(50)
- measurement_source_concept_id — INTEGER
- unit_source_value — VARCHAR(50)
- value_source_value — VARCHAR(50)
note
- note_id — INTEGER — NOT NULL
- person_id — INTEGER — NOT NULL
- note_date — DATE — NOT NULL
- note_datetime — DATETIME2
- note_type_concept_id — INTEGER — NOT NULL
- note_class_concept_id — INTEGER — NOT NULL
- note_title — VARCHAR(250)
- note_text — VARCHAR(MAX)
- encoding_concept_id — INTEGER — NOT NULL
- language_concept_id — INTEGER — NOT NULL
- provider_id — INTEGER
- visit_occurrence_id — INTEGER
- note_source_value — VARCHAR(50)
observation
- observation_id — INTEGER — NOT NULL
- person_id — INTEGER — NOT NULL
- observation_concept_id — INTEGER — NOT NULL
- observation_date — DATE — NOT NULL
- observation_datetime — DATETIME2
- 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
- observation_source_value — VARCHAR(50)
- observation_source_concept_id — INTEGER
- unit_source_value — VARCHAR(50)
- qualifier_source_value — VARCHAR(50)
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
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 — DATETIME2
- 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 — DATETIME2 — NOT NULL
- procedure_type_concept_id — INTEGER — NOT NULL
- modifier_concept_id — INTEGER
- quantity — INTEGER
- provider_id — INTEGER
- visit_occurrence_id — INTEGER
- procedure_source_value — VARCHAR(50)
- procedure_source_concept_id — INTEGER
- qualifier_source_value — VARCHAR(50)
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 — DATETIME2
- 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_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 — DATETIME2
- visit_end_date — DATE — NOT NULL
- visit_end_datetime — DATETIME2
- visit_type_concept_id — INTEGER — NOT NULL
- provider_id — INTEGER
- care_site_id — INTEGER
- visit_source_value — VARCHAR(50)
- visit_source_concept_id — INTEGER
- admitting_source_concept_id — INTEGER
- admitting_source_value — VARCHAR(50)
- discharge_to_concept_id — INTEGER
- discharge_to_source_value — VARCHAR(50)
- preceding_visit_occurrence_id — INTEGER