English

OMOP Common Data Model (CDM) Drug Exposure

1 forms  
Drug Exposure
Description

Drug Exposure

Alias
UMLS CUI-1
C0013227
UMLS CUI-2
C0332157
Drug Exposure ID
Description

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

Data type

integer

Alias
UMLS CUI [1,1]
C0332157
UMLS CUI [1,2]
C0013227
UMLS CUI [1,3]
C1300638
Person ID
Description

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.

Data type

integer

Alias
UMLS CUI [1]
C2348585
Drug concept ID
Description

A foreign key that refers to a standard concept identifier in the Standardized Vocabularies for the drug concept.

Data type

integer

Alias
UMLS CUI [1,1]
C0013227
UMLS CUI [1,2]
C0178566
UMLS CUI [1,3]
C1300638
Drug exposure start date
Description

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.

Data type

date

Alias
UMLS CUI [1,1]
C0013227
UMLS CUI [1,2]
C0332157
UMLS CUI [1,3]
C0011008
Drug exposure stop date
Description

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

Data type

date

Alias
UMLS CUI [1,1]
C0013227
UMLS CUI [1,2]
C0332157
UMLS CUI [1,3]
C0011008
Drug type concept ID
Description

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.

Data type

integer

Alias
UMLS CUI [1,1]
C0013227
UMLS CUI [1,2]
C0332307
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Stop reason
Description

The reason the medication was stopped, where available. Reasons include regimen completed, changed, removed, etc.

Data type

text

Alias
UMLS CUI [1,1]
C0392360
UMLS CUI [1,2]
C1947925
UMLS CUI [1,3]
C0013227
refills
Description

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

Data type

integer

Alias
UMLS CUI [1,1]
C0807726
UMLS CUI [1,2]
C0013227
Drug quantity
Description

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

Data type

float

Alias
UMLS CUI [1,1]
C0013227
UMLS CUI [1,2]
C1265611
Days supply
Description

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

Data type

integer

Alias
UMLS CUI [1,1]
C1561604
UMLS CUI [1,2]
C0439228
UMLS CUI [1,3]
C0013227
Sig
Description

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

Data type

text

Alias
UMLS CUI [1,1]
C1519316
UMLS CUI [1,2]
C1521941
Route concept
Description

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

Data type

integer

Alias
UMLS CUI [1,1]
C1533734
UMLS CUI [1,2]
C0449444
UMLS CUI [1,3]
C0178566
Effective drug dose
Description

Numerical value of drug dose for this drug_exposure record.

Data type

float

Alias
UMLS CUI [1,1]
C1280519
UMLS CUI [1,2]
C3174092
Dose unit concept ID
Description

A foreign key to a predefined concept in the Standardized Vocabularies reflecting the unit the effective_drug_dose value is expressed.

Data type

integer

Alias
UMLS CUI [1,1]
C3174092
UMLS CUI [1,2]
C1519795
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Lot number
Description

An identifier to determine where the product originated

Data type

text

Alias
UMLS CUI [1]
C2826710
Provider ID
Description

A foreign key to the provider in the provider table who initiated (prescribed) the drug exposure.

Data type

integer

Alias
UMLS CUI [1,1]
C1138603
UMLS CUI [1,2]
C1300638
Visit occurrence ID
Description

A foreign key to the visit in the visit table during which the drug exposure initiated.

Data type

integer

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C2745955
UMLS CUI [1,3]
C1300638
Drug source value
Description

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.

Data type

text

Alias
UMLS CUI [1,1]
C0013227
UMLS CUI [1,2]
C0449416
UMLS CUI [1,3]
C1522609
Drug source concept ID
Description

A foreign key to a drug concept that refers to the code used in the source.

Data type

integer

Alias
UMLS CUI [1,1]
C0013227
UMLS CUI [1,2]
C0449416
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Route source value
Description

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

Data type

text

Alias
UMLS CUI [1,1]
C1533734
UMLS CUI [1,2]
C0449444
UMLS CUI [1,3]
C0449416
UMLS CUI [1,4]
C1522609
Dose unit source value
Description

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

Data type

text

Alias
UMLS CUI [1,1]
C3174092
UMLS CUI [1,2]
C1519795
UMLS CUI [1,3]
C0449416
UMLS CUI [1,4]
C1522609
Back to the top of the page

Similar models

OMOP Common Data Model (CDM) Drug Exposure

1 forms
Name
Type
Description | Question | Decode (Coded Value)
Data type
Alias
Item Group
Drug Exposure
C0013227 (UMLS CUI-1)
C0332157 (UMLS CUI-2)
Drug Exposure ID
Item
Drug Exposure ID
integer
C0332157 (UMLS CUI [1,1])
C0013227 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Person ID
Item
Person ID
integer
C2348585 (UMLS CUI [1])
Drug concept ID
Item
Drug concept ID
integer
C0013227 (UMLS CUI [1,1])
C0178566 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Drug exposure start date
Item
Drug exposure start date
date
C0013227 (UMLS CUI [1,1])
C0332157 (UMLS CUI [1,2])
C0011008 (UMLS CUI [1,3])
Drug exposure stop date
Item
Drug exposure stop date
date
C0013227 (UMLS CUI [1,1])
C0332157 (UMLS CUI [1,2])
C0011008 (UMLS CUI [1,3])
Drug type concept ID
Item
Drug type concept ID
integer
C0013227 (UMLS CUI [1,1])
C0332307 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Stop reason
Item
Stop reason
text
C0392360 (UMLS CUI [1,1])
C1947925 (UMLS CUI [1,2])
C0013227 (UMLS CUI [1,3])
refills
Item
refills
integer
C0807726 (UMLS CUI [1,1])
C0013227 (UMLS CUI [1,2])
Drug quantity
Item
Drug quantity
float
C0013227 (UMLS CUI [1,1])
C1265611 (UMLS CUI [1,2])
Days supply
Item
Days supply
integer
C1561604 (UMLS CUI [1,1])
C0439228 (UMLS CUI [1,2])
C0013227 (UMLS CUI [1,3])
Sig
Item
Sig
text
C1519316 (UMLS CUI [1,1])
C1521941 (UMLS CUI [1,2])
Route concept
Item
Route concept
integer
C1533734 (UMLS CUI [1,1])
C0449444 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
Effective drug dose
Item
Effective drug dose
float
C1280519 (UMLS CUI [1,1])
C3174092 (UMLS CUI [1,2])
Dose unit concept ID
Item
Dose unit concept ID
integer
C3174092 (UMLS CUI [1,1])
C1519795 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Lot number
Item
Lot number
text
C2826710 (UMLS CUI [1])
Provider ID
Item
Provider ID
integer
C1138603 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Visit occurrence ID
Item
Visit occurrence ID
integer
C1512346 (UMLS CUI [1,1])
C2745955 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Drug source value
Item
Drug source value
text
C0013227 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
C1522609 (UMLS CUI [1,3])
Drug source concept ID
Item
Drug source concept ID
integer
C0013227 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Route source value
Item
Route source value
text
C1533734 (UMLS CUI [1,1])
C0449444 (UMLS CUI [1,2])
C0449416 (UMLS CUI [1,3])
C1522609 (UMLS CUI [1,4])
Dose unit source value
Item
Dose unit source value
text
C3174092 (UMLS CUI [1,1])
C1519795 (UMLS CUI [1,2])
C0449416 (UMLS CUI [1,3])
C1522609 (UMLS CUI [1,4])
Back to the top of the page