: Record Table 930

Record Table 930

Title:	OMOP Drug Exposure
Access field:	20142 (Present in OMOP dataset)

Table name

omop_drug_exposure

Table group

OMOP

Debut

Feb 2023

Row count

55,000,000+

Parent table

n/a

Version

Sep 2024

Size

5GB

Stability

Complete

Cost Tier

dX o2 s2

This item is regarded as restricted and will be supplied to researchers only when absolutely necessary.

23 Columns

#	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	eid	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.
13	lot_number	integer	An identifier assigned to a particular quantity or lot of Drug product from the manufacturer.
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 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.

Column

Type

Notes

days_supply

integer

The number of days of supply of the medication as recorded in the original prescription or dispensing record.

dose_unit_source_value

integer

The information about the dose unit as detailed in the source.

drug_concept_id

integer

A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies for the Drug concept.

drug_exposure_end_date

date

The end date for the current instance of Drug utilization. It is not available from all sources.

drug_exposure_end_datetime

timestamp

The end date and time for the current instance of Drug utilization. It is not available from all sources.

drug_exposure_id

integer

A system-generated unique identifier for each Drug utilization event.

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.

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.

drug_source_concept_id

integer

A foreign key to a Drug Concept that refers to the code used in the source.

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.

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.

eid

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.

lot_number

integer

An identifier assigned to a particular quantity or lot of Drug product from the manufacturer.

provider_id

integer

A foreign key to the provider in the provider table who initiated (prescribed or administered) the Drug Exposure.

quantity

float

The quantity of drug as recorded in the original prescription or dispensing record.

refills

integer

The number of refills after the initial prescription. The initial prescription is not counted, values start with 0.

route_concept_id

integer

A foreign key to a predefined concept in the Standardized Vocabularies reflecting the route of administration.

route_source_value

integer

The information about the route of administration as detailed in the source.

sig

string

The directions on the Drug prescription as recorded in the original prescription (and printed on the container) or dispensing record.

stop_reason

string

The reason the Drug was stopped. Reasons include regimen completed, changed, removed, etc.

verbatim_end_date

integer

visit_detail_id

integer

visit_occurrence_id

integer

A foreign key to the visit in the visit table during which the Drug Exposure was initiated.

Table ID	Table	Title
924	omop_condition_era	OMOP Condition Era
925	omop_condition_occurrence	OMOP Condition Occurrence
926	omop_death	OMOP Death
927	omop_device_exposure	OMOP Device Exposure
928	omop_dose_era	OMOP Dose Era
929	omop_drug_era	OMOP Drug Era
931	omop_measurement	OMOP Measurement
932	omop_note	OMOP Note
933	omop_observation	OMOP Observation Period
934	omop_observation_period	OMOP Observation
935	omop_person	OMOP Person
936	omop_procedure_occurrence	OMOP Procedure Occurrence
937	omop_specimen	OMOP Specimen
938	omop_visit_detail	OMOP Visit Detail
939	omop_visit_occurrence	OMOP Visit Occurrence

Table ID

Table

Title

924

omop_condition_era

OMOP Condition Era

925

omop_condition_occurrence

OMOP Condition Occurrence

926

omop_death

OMOP Death