| # | Column | Type | Notes |
|---|
| 1 | days_supply | integer | The number of days of supply of the medication as recorded in the original prescription or dispensing record. |
| 2 | dose_unit_source_value | integer | The information about the dose unit as detailed in the source. |
| 3 | drug_concept_id | integer | A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies for the Drug concept. |
| 4 | drug_exposure_end_date | date | The end date for the current instance of Drug utilization. It is not available from all sources. |
| 5 | drug_exposure_end_datetime | timestamp | The end date and time for the current instance of Drug utilization. It is not available from all sources. |
| 6 | drug_exposure_id | integer | A system-generated unique identifier for each Drug utilization event. |
| 7 | drug_exposure_start_date | 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. |
| 8 | drug_exposure_start_datetime | timestamp | The start date and time 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. |
| 9 | drug_source_concept_id | integer | A foreign key to a Drug Concept that refers to the code used in the source. |
| 10 | drug_source_value | string | 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. |
| 11 | drug_type_concept_id | 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. |
| 12 | lot_number | integer | An identifier assigned to a particular quantity or lot of Drug product from the manufacturer. |
| 13 | person_id | 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. |
| 14 | provider_id | integer | A foreign key to the provider in the provider table who initiated (prescribed or administered) the Drug Exposure. |
| 15 | quantity | float | The quantity of drug as recorded in the original prescription or dispensing record. |
| 16 | refills | integer | The number of refills after the initial prescription. The initial prescription is not counted, values start with 0. |
| 17 | route_concept_id | integer | A foreign key to a predefined concept in the Standardized Vocabularies reflecting the route of administration. |
| 18 | route_source_value | integer | The information about the route of administration as detailed in the source. |
| 19 | sig | string | The directions (“signetur”) on the Drug prescription as recorded in the original prescription (and printed on the container) or dispensing record. |
| 20 | stop_reason | string | The reason the Drug was stopped. Reasons include regimen completed, changed, removed, etc. |
| 21 | verbatim_end_date | integer | |
| 22 | visit_detail_id | integer | |
| 23 | visit_occurrence_id | integer | A foreign key to the visit in the visit table during which the Drug Exposure was initiated. |
