documentation:cdm:dose_era
This is an old revision of the document!
===== DOSE_ERA table A Dose Era is defined as a span of time when the Person is assumed to be exposed to a constant dose of a specific active ingredient.
| Field | Required | Type | Description |
|---|---|---|---|
| dose_era_id | Yes | integer | A unique identifier for each Dose Era. |
| person_id | Yes | integer | 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. |
| drug_concept_id | Yes | integer | A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies for the active Ingredient Concept. |
| unit_concept_id | Yes | integer | A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies for the unit concept. |
| dose_value | Yes | float | The numeric value of the dose. |
| dose_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 utilization of a drug. |
| dose_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. |
Conventions
- Dose Eras will be derived from records in the DRUG_EXPOSURE table and the Dose information from the DRUG_DOSE table using a standardized algorithm.
- Each Dose Era corresponds to one or many Drug Exposures that form a continuous interval and contain the same Drug Ingredient (active compound) at the same effective dose.
- Dose Form information is not taken into account. So, if the patient changes between different formuations, or different manufacturers with the same formuation, the Dose Era is still spanning the entire time of exposure to the Ingredient.
documentation/cdm/dose_era.1417813907.txt.gz · Last modified: by cgreich