Description

A unique identifier for each drug era.

Type de données

integer

Alias

UMLS CUI [1,1]

C0013227

UMLS CUI [1,2]

C1948053

UMLS CUI [1,3]

C1300638

Description

A foreign key identifier to the person who is subjected to the drug during the drug era. The demographic details of that person are stored in the person table.

Type de données

integer

Alias

UMLS CUI [1]

C2348585

Description

A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies for the Ingredient Concept. The drug_concept_id field only contains Concepts that have the concept_class 'Ingredient'. The Ingredient is derived from the Drug Concepts in the DRUG_EXPOSURE table that are aggregated into the Drug Era record.

Type de données

integer

Alias

UMLS CUI [1,1]

C0013227

UMLS CUI [1,2]

C0178566

UMLS CUI [1,3]

C1300638

Description

The start date for the Drug Era constructed from the individual instances of Drug Exposures. It is the start date of the very first chronologically recorded instance of conutilization of a Drug. The Drug Era Start Date is the start date of the first Drug Exposure.

Type de données

datetime

Alias

UMLS CUI [1,1]

C0013223

UMLS CUI [1,2]

C1948053

UMLS CUI [1,3]

C0808070

UMLS CUI [1,4]

C1301880

Description

The end date for the drug era constructed from the individual instance of drug exposures. It is the end date of the final continuously recorded instance of utilization of a drug. The Drug Era End Date is the end date of the last Drug Exposure. The End Date of each Drug Exposure is either taken from the field drug_exposure_end_date or, as it is typically not available, inferred using the following rules: For pharmacy prescription data, the date when the drug was dispensed plus the number of days of supply are used to extrapolate the End Date for the Drug Exposure. Depending on the country-specific healthcare system, this supply information is either explicitly provided in the day_supply field or inferred from package size or similar information. For Procedure Drugs, usually the drug is administered on a single date (i.e., the administration date). A standard Persistence Window of 30 days (gap, slack) is permitted between two subsequent such extrapolated DRUG_EXPOSURE records to be considered to be merged into a single Drug Era.

Type de données

datetime

Alias

UMLS CUI [1,1]

C0013223

UMLS CUI [1,2]

C1948053

UMLS CUI [1,3]

C0806020

UMLS CUI [1,4]

C1522314

Description

The number of individual drug exposure occurrences used to construct the drug era.

Type de données

integer

Alias

UMLS CUI [1,1]

C0332157

UMLS CUI [1,2]

C0013227

UMLS CUI [1,3]

C0750480

Description

The number of days that are not covered by DRUG_EXPOSURE records that were used to make up the era record. The Gap Days determine how many total drug-free days are observed between all Drug Exposure events that contribute to a DRUG_ERA record. It is assumed that the drugs are "not stockpiled" by the patient, i.e. that if a new drug prescription or refill is observed (a new DRUG_EXPOSURE record is written), the remaining supply from the previous events is abandoned.

Type de données

integer

Alias

UMLS CUI [1,1]

C0013227

UMLS CUI [1,2]

C0332157

UMLS CUI [1,3]

C3887622

UMLS CUI [1,4]

C0439228

UMLS CUI [1,5]

C0750480