DOSE_ERA

Table Description

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.

ETL Conventions

Dose Eras will be derived from records in the DRUG_EXPOSURE table and the Dose information from the DRUG_STRENGTH table using a standardized algorithm. Dose Form information is not taken into account. So, if the patient changes between different formulations, or different manufacturers with the same formulation, the Dose Era is still spanning the entire time of exposure to the Ingredient.

CDM Field	User Guide	ETL Conventions	Datatype	Required	Primary Key	Foreign Key	FK Table	FK Domain
dose_era_id			integer	Yes	Yes	No
person_id			integer	Yes	No	Yes	PERSON
drug_concept_id	The Concept Id representing the specific drug ingredient.		integer	Yes	No	Yes	CONCEPT	Drug
unit_concept_id	The Concept Id representing the unit of the specific drug ingredient.		integer	Yes	No	Yes	CONCEPT	Unit
dose_value	The numeric value of the dosage of the drug_ingredient.		float	Yes	No	No
dose_era_start_date	The date the Person started on the specific dosage, with at least 31 days since any prior exposure.		date	Yes	No	No
dose_era_end_date		The date the Person was no longer exposed to the dosage of the specific drug ingredient. An era is ended if there are 31 days or more between dosage records.	date	Yes	No	No