CDM 5.2.2 Drug Reaction Extend

Tables (6)

drug_exposure

  • drug_exposure_id — INTEGER — Primary key — NOT NULL
  • person_id — INTEGER — Foreign key → person.person_id — 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 — Foreign key → visit_occurrence.visit_occurrence_id
  • drug_source_value — VARCHAR(50)
  • drug_source_concept_id — INTEGER
  • route_source_value — VARCHAR(50)
  • dose_unit_source_value — VARCHAR(50)

drug_exposure_list

  • drug_exposure_list_id — INTEGER — Primary key — NOT NULL — 기록지 날짜 기준 30일 이내에 먹은 약물에 대해서 포함
  • drug_reaction_id — INTEGER — Foreign key → drug_reaction.drug_reaction_id — NOT NULL
  • drug_exposure_id — INTEGER — Foreign key → drug_exposure.drug_exposure_id — NOT NULL

drug_reaction

  • drug_reaction_id — INTEGER — Primary key — NOT NULL
  • note_id — INTEGER — Foreign key → note.note_id — NOT NULL
  • person_id — INTEGER — Foreign key → person.person_id — NOT NULL
  • visit_occurrence_id — INTEGER — Foreign key → visit_occurrence.visit_occurrence_id — NOT NULL
  • reaction_concept_id — INTEGER
  • grade — VARCHAR(5)
  • code_source_value (reaction_source_value) — VARCHAR(MAX)
  • reaction_start_date — DATE
  • reaction_end_date — DATE
  • Field (reaction_current_status) — VARCHAR(100) — end_date unknown or ongoing
  • Field (reaction_domain_concept_id) — INTEGER — derived from note or condition?

note

  • note_id — INTEGER — Primary key — NOT NULL
  • person_id — INTEGER — Foreign key → person.person_id — 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 — Foreign key → visit_occurrence.visit_occurrence_id
  • note_source_value — VARCHAR(50)

person

  • person_id — INTEGER — Primary key — 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

visit_occurrence

  • visit_occurrence_id — INTEGER — Primary key — NOT NULL
  • person_id — INTEGER — Foreign key → person.person_id — 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