We propose to abolish the effective_drug_dose field from the DRUG_EXPOSURE table entirely. The content can be handled by the quantity table.
We need to have a way to define drug_strength if we have no product information, but only ingredients or drug forms, or if like in chemotherapies or pediatric preparations the drug strength is not defined by the product.
Currently, this information is stored as:
drug_concept_id - contains the ingredient quantity or effective drug_dose - value nowhere or dose_unit_concept_id - unit
This works well for ingredients and uni-ingredient drug forms. We should however define a single way of doing it.
Also, we have a problem with multi-ingredient drug forms, because we only have one field.
Calculation of daily or total dose of a DRUG_EXPOSURE record.
All dosing information is handled through single ingredients stored in the drug_concept_id, and the dosing in quantity (for the amount) and drug_strength.amount_unit_concept_id. See approved proposals for extension of DRUG_STRENGTH and for dosing.