Sidebar
documentation:cdm:drug_era
This is an old revision of the document!
DRUG_ERA table
A Drug Era is defined as a span of time when the Person is assumed to be exposed to a particular active ingredient. A Drug Era is not the same as a Drug Exposure: Exposures are individual records corresponding to the source when Drug was delivered to the Person, while successive periods of Drug Exposures are combined under certain rules to produce continuous Drug Eras.
| Field | Required | Type | Description |
|---|---|---|---|
| drug_era_id | Yes | integer | A unique identifier for each Drug Era. |
| person_id | Yes | integer | A foreign key identifier to the Person who is subjected to the Drug during the fDrug Era. The demographic details of that Person are stored in the PERSON table. |
| drug_concept_id | Yes | integer | A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies for the Ingredient Concept. |
| drug_era_start_date | Yes | date | 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. |
| drug_era_end_date | Yes | date | 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. |
| drug_exposure_count | No | integer | The number of individual Drug Exposure occurrences used to construct the Drug Era. |
| gap_days | No | integer | The number of days that are not covered by DRUG_EXPOSURE records that were used to make up the era record. |
Conventions
- Drug Eras are derived from records in the DRUG_EXPOSURE table using a standardized algorithm.
- Each Drug Era corresponds to one or many Drug Exposures that form a continuous interval and contain the same Drug Ingredient (active compound).
- The drug_concept_id field only contains Concepts that have the concept_class 'Ingredient'. The Ingredient is derived from the Drugs in the DRUG_EXPOSURE table that are aggregated into the Drug Era record.
- The Drug Era Start Date is the start date of the first Drug Exposure.
- 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 prescriptions 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, the days_supply are either explicitly provided or are inferred from package size or similar information.
- For Procedure Drugs, usually the drug is administered on a single date (i.e., the administration date).
- The Gap Days determine how much drug-free days are tolerated between two Drug Exposures, without interrupting a Drug Era. Typically, this is set to 30, but could be different for Drugs that are very acute or chronic in their administration or for whom the daily dosing is variable.
documentation/cdm/drug_era.1436748154.txt.gz · Last modified: 2015/07/13 00:42 by cgreich
