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