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