ID

35035

Description

OMOP Common Data Model (CDM) Drug Exposure The 'Drug' 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. Radiological devices ingested or applied locally do not count as Drugs. Drug Exposure is inferred from clinical events associated with orders, prescriptions written, pharmacy dispensings, procedural administrations, and other patient-reported information, for example: The 'Prescription' section of an EHR captures prescriptions written by physicians or from electronic ordering systems; The 'Medication list' section of an EHR for both non-prescription products and medications prescribed by other providers; Prescriptions filled at dispensing providers such as pharmacies, and then captured in reimbursement claim systems; Drugs administered as part of a Procedure, such as chemotherapy or vaccines. The Observational Medical Outcomes Partnership (OMOP) was a public-private partnership established to inform the appropriate use of observational healthcare databases for studying the effects of medical products. © 2014 Observational Health Data Sciences and Informatics. This work is based on work by the Observational Medical Outcomes Partnership (OMOP) and used under license from the FNIH at http://omop.fnih.org/publiclicense. Version updated on 12.02.2019, from https://github.com/OHDSI/CommonDataModel/wiki/DRUG_EXPOSURE. The Drug Concept with the most detailed content of information is preferred during the mapping process. These are indicated in the CONCEPT_CLASS_ID field of the Concept and are recorded in the following order of precedence: 'Branded Pack', 'Clinical Pack', 'Branded Drug', 'Clinical Drug', 'Branded Drug Component', 'Clinical Drug Component', 'Branded Drug Form', 'Clinical Drug Form', and only if no other information is available 'Ingredient'. Note: If only the drug class is known, the DRUG_CONCEPT_ID field should contain 0. A Drug Type is assigned to each Drug Exposure to track from what source the information was drawn or inferred from. The valid CONCEPT_CLASS_ID for these Concepts is 'Drug Type'.

Link

http://omop.fnih.org/publiclicense

Keywords

Versions (3)
  1. 1/4/17 1/4/17 -
  2. 2/12/19 2/12/19 -
  3. 2/28/19 2/28/19 -
Copyright Holder

Observational Medical Outcomes Partnership (OMOP)

Uploaded on

February 12, 2019

DOI

To request one please log in.

License

Creative Commons BY-NC 3.0
Model comments :

You can comment on the data model here. Via the speech bubbles at the itemgroups and items you can add comments to those specificially.

Back to model comments
Itemgroup comments for :

Item comments for :

In order to download data models you must be logged in. Please log in or register for free.

OMOP Common Data Model (CDM) Drug Exposure

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 belonging to the 'Drug' domain. Valid Concepts for the DRUG_CONCEPT_ID field belong to the 'Drug' domain. Most Concepts in the Drug domain are based on RxNorm, but some may come from other sources. Concepts are members of the Clinical Drug or Pack, Branded Drug or Pack, Drug Component or Ingredient classes.

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]
C0808070
Drug exposure start datetime
Description

The start date and time for the current instance of Drug utilization. Valid entries include a start datetime of a prescription, the date and time a prescription was filled, or the date and time on which a Drug administration procedure was recorded.

Data type

datetime

Alias
UMLS CUI [1,1]
C0013227
UMLS CUI [1,2]
C0332157
UMLS CUI [1,3]
C0808070
UMLS CUI [1,4]
C1301880
Drug exposure end date
Description

The end date for the current instance of Drug utilization. Depending on different sources, it could be a known or an inferred date and denotes the last day at which the patient was still exposed to Drug. The DRUG_EXPOSURE_END_DATE denotes the day the drug exposure ended for the patient. This could be that the duration of DRUG_SUPPLY was reached (in which case DRUG_EXPOSURE_END_DATETIME = DRUG_EXPOSURE_START_DATETIME + DAYS_SUPPLY -1 day), or because the exposure was stopped (medication changed, medication discontinued, etc.)

Data type

date

Alias
UMLS CUI [1,1]
C0013227
UMLS CUI [1,2]
C0332157
UMLS CUI [1,3]
C0806020
Drug exposure end datetime
Description

The end date and time for the current instance of Drug utilization. Depending on different sources, it could be a known or an inferred date and time and denotes the last day at which the patient was still exposed to Drug.

Data type

datetime

Alias
UMLS CUI [1,1]
C0013227
UMLS CUI [1,2]
C0332157
UMLS CUI [1,3]
C0806020
UMLS CUI [1,4]
C1522314
verbatim end date
Description

The known end date of a drug exposure as provided by the source.

Data type

date

Alias
UMLS CUI [1,1]
C0013227
UMLS CUI [1,2]
C0332157
UMLS CUI [1,3]
C0806020
UMLS CUI [1,4]
C1709908
UMLS CUI [1,5]
C0449416
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 and belongs to the 'Drug Type' vocabulary.

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. The content of the refills field determines the current number of refills, not the number of remaining refills. For example, for a drug prescription with 2 refills, the content of this field for the 3 Drug Exposure events are null, 1 and 2.

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 prescribed. This reflects the intention of the provider for the length of exposure. When the native data suggests a drug exposure has a days supply less than 0, drop the record as unknown if a person has received the drug or not (THEMIS issue #24). If a patient has multiple records on the same day for the same drug or procedures the ETL should not de-dupe them unless there is probable reason to believe the item is a true data duplicate.

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 ID
Description

A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies reflecting the route of administration and belonging to the 'Route' domain. The ROUTE_CONCEPT_ID refers to a Standard Concepts of the 'Route' domain. Note: Route information can also be inferred from the Drug product itself by determining the Drug Form of the Concept, creating some partial overlap of the same type of information. Therefore, route information should be stored in DRUG_CONCEPT_ID (as a drug with corresponding Dose Form). The ROUTE_CONCEPT_ID could be used for storing more granular forms e.g. 'Intraventricular cardiac'.

Data type

integer

Alias
UMLS CUI [1,1]
C1533734
UMLS CUI [1,2]
C0449444
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Lot number
Description

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

Data type

text

Alias
UMLS CUI [1]
C2826710
Provider ID
Description

A foreign key to the provider in the PROVIDER table who initiated (prescribed or administered) the Drug Exposure. If possible, the prescribing or administering provider (physician or nurse) is recorded in the PROVIDER_ID field through a reference to the provider table.

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_OCCURRENCE table during which the Drug Exposure was initiated. If possible, the visit in which the drug was prescribed or delivered is recorded in the VISIT_OCCURRENCE_ID field through a reference to the visit table.

Data type

integer

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C2745955
UMLS CUI [1,3]
C1300638
Visit detail ID
Description

A foreign key to the Visit Detail in the VISIT_DETAIL table during which the Drug Exposure was initiated.

Data type

integer

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C1522508
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. Source drug identifiers, including NDC codes, Generic Product Identifiers, etc. are mapped to Standard Drug Concepts in the Standardized Vocabularies (e.g., based on RxNorm). When the Drug Source Value of the code cannot be translated into Standard Drug Concept IDs, a Drug exposure entry is stored with only the corresponding SOURCE_CONCEPT_ID and DRUG_SOURCE_VALUE and a DRUG_CONCEPT_ID of 0.

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
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
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])
C0808070 (UMLS CUI [1,3])
Drug exposure start datetime
Item
Drug exposure start datetime
datetime
C0013227 (UMLS CUI [1,1])
C0332157 (UMLS CUI [1,2])
C0808070 (UMLS CUI [1,3])
C1301880 (UMLS CUI [1,4])
Drug exposure end date
Item
Drug exposure end date
date
C0013227 (UMLS CUI [1,1])
C0332157 (UMLS CUI [1,2])
C0806020 (UMLS CUI [1,3])
Drug exposure end datetime
Item
Drug exposure end datetime
datetime
C0013227 (UMLS CUI [1,1])
C0332157 (UMLS CUI [1,2])
C0806020 (UMLS CUI [1,3])
C1522314 (UMLS CUI [1,4])
Verbatim end date
Item
verbatim end date
date
C0013227 (UMLS CUI [1,1])
C0332157 (UMLS CUI [1,2])
C0806020 (UMLS CUI [1,3])
C1709908 (UMLS CUI [1,4])
C0449416 (UMLS CUI [1,5])
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 ID
Item
Route concept ID
integer
C1533734 (UMLS CUI [1,1])
C0449444 (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])
Visit detail ID
Item
Visit detail ID
integer
C1512346 (UMLS CUI [1,1])
C1522508 (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])
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])
Back to the top of the page 

Contact

Please use this form for feedback, questions and suggestions for improvements.

Fields marked with * are required.

Help

Do you need help on how to use the search function? Please watch the corresponding tutorial video for more details and learn how to use the search function most efficiently.

Watch Tutorial