User Tools

Site Tools


documentation:cdm:drug_era

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
documentation:cdm:drug_era [2015/07/13 00:58]
cgreich
documentation:cdm:drug_era [2017/09/25 15:09] (current)
clairblacketer
Line 1: Line 1:
 ===== DRUG_ERA table ===== ===== DRUG_ERA table =====
 +**THIS IS OUTDATED. All documentation is now on the [[https://​github.com/​OHDSI/​CommonDataModel/​wiki|github wiki]]. Please refer there or to the [[projects:​workgroups:​cdm-wg|CDM working group]] for more information**
 +
 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.  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^ ^Field^Required^Type^Description^
Line 12: Line 14:
   * Drug Eras are derived from records in the DRUG_EXPOSURE table using a standardized algorithm.   * 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).   * 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_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.
   * The Drug Era Start Date is the start date of the first Drug Exposure.   * 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:+  * 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 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). ​     * For Procedure Drugs, usually the drug is administered on a single date (i.e., the administration date). ​
-    * A standard Persistence Window of 30 days (slack) is permitted between two subsequent such extrapolated ​Drug Exposure ​records to be considered to be merged into a single Drug Era. +    * 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. 
-  * 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 ​records ​is abandoned. +  * 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. 
-  * The difference between Persistence Window and Gap Days is that the former is the maximum drug-free time allowed between two subsequent ​drug records, while the latter is the sum of actual ​drug_free ​days for the given Drug Era under the above assumption of non-stockpiling. +  * The difference between Persistence Window and Gap Days is that the former is the maximum drug-free time allowed between two subsequent ​DRUG_EXPOSURE ​records, while the latter is the sum of actual ​drug-free ​days for the given Drug Era under the above assumption of non-stockpiling. 
-  * The choice of a standard Persistence Window of 30 and the non-stockpiling assumption is arbitrary, but has been shown to deliver good results in drug-outcome estimation. Other problems, such as estimation of drug compliance, my require a different or drug-dependent Persistence Window. Researchers ​should ​consider creating their own Drug Eras with different parameters as Cohorts and store them in the COHORT table.+  * The choice of a standard Persistence Window of 30 and the non-stockpiling assumption is arbitrary, but has been shown to deliver good results in drug-outcome estimation. Other problems, such as estimation of drug compliance, my require a different or drug-dependent Persistence Window/​stockpiling assumption. Researchers ​are encouraged to consider creating their own Drug Eras with different parameters as Cohorts and store them in the COHORT table. 
 + 
 +{{:​documentation:​cdm:​drugera.jpg?​nolink&​800|Application to Drug Era rules to generation of two Lisinopril eras.}}
documentation/cdm/drug_era.1436749125.txt.gz · Last modified: 2015/07/13 00:58 by cgreich