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. |