Descrizione

A system-generated unique identifier for each drug utilization event. (Type bigint)

Tipo di dati

integer

Alias

UMLS CUI [1,1]

C0332157

UMLS CUI [1,2]

C0013227

UMLS CUI [1,3]

C1300638

Descrizione

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 bigint)

Tipo di dati

integer

Alias

UMLS CUI [1]

C2348585

Descrizione

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. Concepts are members of the Clinical Drug or Pack, Branded Drug or Pack, Drug Component or Ingredient classes. Note: If only the drug class is known, the DRUG_CONCEPT_ID field should contain 0.

Tipo di dati

integer

Alias

UMLS CUI [1,1]

C0013227

UMLS CUI [1,2]

C0178566

UMLS CUI [1,3]

C1300638

Descrizione

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.

Tipo di dati

date

Alias

UMLS CUI [1,1]

C0013227

UMLS CUI [1,2]

C0332157

UMLS CUI [1,3]

C0808070

Descrizione

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.

Tipo di dati

datetime

Alias

UMLS CUI [1,1]

C0013227

UMLS CUI [1,2]

C0332157

UMLS CUI [1,3]

C0808070

UMLS CUI [1,4]

C1301880

Descrizione

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.)

Tipo di dati

date

Alias

UMLS CUI [1,1]

C0013227

UMLS CUI [1,2]

C0332157

UMLS CUI [1,3]

C0806020

Descrizione

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.

Tipo di dati

datetime

Alias

UMLS CUI [1,1]

C0013227

UMLS CUI [1,2]

C0332157

UMLS CUI [1,3]

C0806020

UMLS CUI [1,4]

C1522314

Descrizione

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

Tipo di dati

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

Descrizione

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.

Tipo di dati

integer

Alias

UMLS CUI [1,1]

C0013227

UMLS CUI [1,2]

C0332307

UMLS CUI [1,3]

C0178566

UMLS CUI [1,4]

C1300638

Descrizione

The reason the medication was stopped, where available. Reasons include regimen completed, changed, removed, etc. (Type varchar(20))

Tipo di dati

text

Alias

UMLS CUI [1,1]

C0392360

UMLS CUI [1,2]

C1947925

UMLS CUI [1,3]

C0013227

Descrizione

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.

Tipo di dati

integer

Alias

UMLS CUI [1,1]

C0807726

UMLS CUI [1,2]

C0013227

Descrizione

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

Tipo di dati

float

Alias

UMLS CUI [1,1]

C0013227

UMLS CUI [1,2]

C1265611

Descrizione

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

Tipo di dati

integer

Alias

UMLS CUI [1,1]

C1561604

UMLS CUI [1,2]

C0439228

UMLS CUI [1,3]

C0013227

Descrizione

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

Tipo di dati

text

Alias

UMLS CUI [1,1]

C1519316

UMLS CUI [1,2]

C1521941

Descrizione

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'.

Tipo di dati

integer

Alias

UMLS CUI [1,1]

C1533734

UMLS CUI [1,2]

C0449444

UMLS CUI [1,3]

C0178566

UMLS CUI [1,4]

C1300638

Descrizione

An identifier assigned to a particular quantity or lot of Drug product from the manufacturer. (Type varchar(50))

Tipo di dati

text

Alias

UMLS CUI [1]

C2826710

Descrizione

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.

Tipo di dati

integer

Alias

UMLS CUI [1,1]

C1138603

UMLS CUI [1,2]

C1300638

Descrizione

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.

Tipo di dati

integer

Alias

UMLS CUI [1,1]

C1512346

UMLS CUI [1,2]

C2745955

UMLS CUI [1,3]

C1300638

Descrizione

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

Tipo di dati

integer

Alias

UMLS CUI [1,1]

C1512346

UMLS CUI [1,2]

C1522508

UMLS CUI [1,3]

C1300638

Descrizione

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 varchar50))

Tipo di dati

text

Alias

UMLS CUI [1,1]

C0013227

UMLS CUI [1,2]

C0449416

UMLS CUI [1,3]

C1522609

Descrizione

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 (for more information see https://github.com/OHDSI/CommonDataModel/wiki/DRUG_EXPOSURE). 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.

Tipo di dati

integer

Alias

UMLS CUI [1,1]

C0013227

UMLS CUI [1,2]

C0449416

UMLS CUI [1,3]

C0178566

UMLS CUI [1,4]

C1300638

Descrizione

The information about the route of administration as detailed in the source. (Type varchar(50))

Tipo di dati

text

Alias

UMLS CUI [1,1]

C1533734

UMLS CUI [1,2]

C0449444

UMLS CUI [1,3]

C0449416

Descrizione

The information about the dose unit as detailed in the source. (Type varchar(50))

Tipo di dati

text

Alias

UMLS CUI [1,1]

C3174092

UMLS CUI [1,2]

C1519795

UMLS CUI [1,3]

C0449416