Sidebar
documentation:cdm:drug_exposure
This is an old revision of the document!
DRUG_EXPOSURE Table
The drug exposure domain captures records about the utilization of a Drug when ingested or otherwise introduced into the body. A Drug is a biochemical substance formulated in such a way that when administered to a Person it will exert a certain physiological effect. Drugs include prescription and over-the-counter medicines, vaccines, and large-molecule biologic therapies. Drug exposure is inferred from clinical events associated with orders, prescriptions written, pharmacy dispensings, procedural administrations, and other patient-reported information.
| Field | Required | Type | Description |
|---|---|---|---|
| drug_exposure_id | Yes | Integer | A system-generated unique identifier for each drug utilization event. |
| person_id | Yes | Integer | A foreign key identifier to the person who is subjected to the drug. The demographic details of that person are stored in the person table. |
| drug_concept_id | Yes | Integer | A foreign key that refers to a standard concept identifier in the Standardized Vocabularies for the drug concept. |
| drug_exposure_start_date | Yes | date | The start date for the current instance of drug utilization. Valid entries include a start date of a prescription, the date a prescription was filled, or the date on which a drug administration procedure was recorded. |
| drug_exposure_end_date | No | date | The end date for the current instance of drug utilization. It is not available from all sources. |
| drug_type_concept_id | Yes | integer | A foreign key to the predefined concept identifier in the Standardized Vocabularies reflecting the type of drug exposure recorded. It indicates how the drug exposure was represented in the source data: as medication history, filled prescriptions, etc. |
| stop_reason | No | varchar(20) | The reason the medication was stopped, where available. Reasons include regimen completed, changed, removed, etc. |
| refills | No | integer | The number of refills after the initial prescription. The initial prescription is not counted, values start with 0. |
| quantity | No | float | The quantity of drug as recorded in the original prescription or dispensing record. |
| days_supply | No | integer | The number of days of supply of the medication as recorded in the original prescription or dispensing record. |
| sig | No | CLOB | The directions (“signetur”) on the drug prescription as recorded in the original prescription (and printed on the container) or dispensing record. |
| route_concept_id | No | integer | A foreign key to a predefined concept in the Standardized Vocabularies reflecting the route of administration. |
| effective_drug_dose | No | float | Numerical value of drug dose for this drug_exposure record. |
| dose_unit_concept_ id | No | integer | A foreign key to a predefined concept in the Standardized Vocabularies reflecting the unit the effective_drug_dose value is expressed. |
| lot_number | No | varchar(50) | An identifier to determine where the product originated. |
| provider_id | No | integer | A foreign key to the provider in the provider table who initiated (prescribed) the drug exposure. |
| visit_occurrence_id | No | integer | A foreign key to the visit in the visit table during which the drug exposure initiated. |
| drug_source_value | No | varchar(50) | The source code for the drug as it appears in the source data. This code is mapped to a standard drug concept in the Standardized Vocabularies and the original code is, stored here for reference. |
| drug_source_concept_id | No | Integer | A foreign key to a drug concept that refers to the code used in the source. |
| route_source_value | No | varchar(50) | The information about the route of administration as detailed in the source. |
| dose_unit_source_value | No | varchar(50) | The information about the dose unit as detailed in the source. |
documentation/cdm/drug_exposure.1417681516.txt.gz · Last modified: 2014/12/04 08:25 by cgreich
