Descripción

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

Tipo de datos

integer

Alias

UMLS CUI [1,1]

C0332157

UMLS CUI [1,2]

C0013227

UMLS CUI [1,3]

C1300638

Descripción

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.

Tipo de datos

integer

Alias

UMLS CUI [1]

C2348585

Descripción

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.

Tipo de datos

integer

Alias

UMLS CUI [1,1]

C0013227

UMLS CUI [1,2]

C0178566

UMLS CUI [1,3]

C1300638

Descripción

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 de datos

date

Alias

UMLS CUI [1,1]

C0013227

UMLS CUI [1,2]

C0332157

UMLS CUI [1,3]

C0808070

Descripción

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 de datos

datetime

Alias

UMLS CUI [1,1]

C0013227

UMLS CUI [1,2]

C0332157

UMLS CUI [1,3]

C0808070

UMLS CUI [1,4]

C1301880

Descripción

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 de datos

date

Alias

UMLS CUI [1,1]

C0013227

UMLS CUI [1,2]

C0332157

UMLS CUI [1,3]

C0806020

Descripción

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 de datos

datetime

Alias

UMLS CUI [1,1]

C0013227

UMLS CUI [1,2]

C0332157

UMLS CUI [1,3]

C0806020

UMLS CUI [1,4]

C1522314

Descripción

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

Tipo de datos

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

Descripción

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 de datos

integer

Alias

UMLS CUI [1,1]

C0013227

UMLS CUI [1,2]

C0332307

UMLS CUI [1,3]

C0178566

UMLS CUI [1,4]

C1300638

Descripción

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

Tipo de datos

text

Alias

UMLS CUI [1,1]

C0392360

UMLS CUI [1,2]

C1947925

UMLS CUI [1,3]

C0013227

Descripción

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 de datos

integer

Alias

UMLS CUI [1,1]

C0807726

UMLS CUI [1,2]

C0013227

Descripción

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

Tipo de datos

float

Alias

UMLS CUI [1,1]

C0013227

UMLS CUI [1,2]

C1265611

Descripción

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.

Tipo de datos

integer

Alias

UMLS CUI [1,1]

C1561604

UMLS CUI [1,2]

C0439228

UMLS CUI [1,3]

C0013227

Descripción

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

Tipo de datos

text

Alias

UMLS CUI [1,1]

C1519316

UMLS CUI [1,2]

C1521941

Descripción

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 de datos

integer

Alias

UMLS CUI [1,1]

C1533734

UMLS CUI [1,2]

C0449444

UMLS CUI [1,3]

C0178566

UMLS CUI [1,4]

C1300638

Descripción

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

Tipo de datos

text

Alias

UMLS CUI [1]

C2826710

Descripción

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 de datos

integer

Alias

UMLS CUI [1,1]

C1138603

UMLS CUI [1,2]

C1300638

Descripción

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 de datos

integer

Alias

UMLS CUI [1,1]

C1512346

UMLS CUI [1,2]

C2745955

UMLS CUI [1,3]

C1300638

Descripción

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

Tipo de datos

integer

Alias

UMLS CUI [1,1]

C1512346

UMLS CUI [1,2]

C1522508

UMLS CUI [1,3]

C1300638

Descripción

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.

Tipo de datos

text

Alias

UMLS CUI [1,1]

C0013227

UMLS CUI [1,2]

C0449416

UMLS CUI [1,3]

C1522609

Descripción

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.

Tipo de datos

integer

Alias

UMLS CUI [1,1]

C0013227

UMLS CUI [1,2]

C0449416

UMLS CUI [1,3]

C0178566

UMLS CUI [1,4]

C1300638

Descripción

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

Tipo de datos

text

Alias

UMLS CUI [1,1]

C1533734

UMLS CUI [1,2]

C0449444

UMLS CUI [1,3]

C0449416

Descripción

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

Tipo de datos

text

Alias

UMLS CUI [1,1]

C3174092

UMLS CUI [1,2]

C1519795

UMLS CUI [1,3]

C0449416