ID

19496

Description

OMOP Common Data Model (CDM) Drug Exposure The DRUG_EXPOSURE table captures records about the inferred utilization of a biochemical substance with a physiological therapeutic effect when ingested or otherwise introduced into the body. Drugs include prescription and over-thecounter 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 patientreported information. 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.

Lien

http://omop.fnih.org/publiclicense

Mots-clés

Versions (3)
  1. 04/01/2017 04/01/2017 -
  2. 12/02/2019 12/02/2019 -
  3. 28/02/2019 28/02/2019 -
Téléchargé le

4 janvier 2017

DOI

Pour une demande vous connecter.

Licence

Creative Commons BY-NC 3.0
Modèle Commentaires :

Ici, vous pouvez faire des commentaires sur le modèle. À partir des bulles de texte, vous pouvez laisser des commentaires spécifiques sur les groupes Item et les Item.

Retour au modèle Commentaires
Groupe Item commentaires pour :

Item commentaires pour :

Vous devez être connecté pour pouvoir télécharger des formulaires. Veuillez vous connecter ou s’inscrire gratuitement.

OMOP Common Data Model (CDM) Drug Exposure

Anglais

OMOP Common Data Model (CDM) Drug Exposure

1 Formulaires  
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.

Type de données

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.

Type de données

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.

Type de données

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.

Type de données

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.

Type de données

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.

Type de données

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.

Type de données

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.

Type de données

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.

Type de données

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.

Type de données

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.

Type de données

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.

Type de données

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.

Type de données

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.

Type de données

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

Type de données

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.

Type de données

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.

Type de données

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.

Type de données

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.

Type de données

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.

Type de données

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.

Type de données

text

Alias
UMLS CUI [1,1]
C3174092
UMLS CUI [1,2]
C1519795
UMLS CUI [1,3]
C0449416
UMLS CUI [1,4]
C1522609
Retour au début de la page

Similar models

OMOP Common Data Model (CDM) Drug Exposure

1 Formulaires
Name
Type
Description | Question | Decode (Coded Value)
Type de données
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])
Retour au début de la page 

Contact

Utilisez ce formulaire pour les retours, les questions et les améliorations suggérées.

Les champs marqués d’un * sont obligatoires.

Aide

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