Observational Health Data Sciences and Informatics

• Requesters: Christian Reich, Klaus Bonadt

We propose to abolish the effective_drug_dose field from the DRUG_EXPOSURE table or renaming it to drug_strength_value and possibly adding a effective_drug_form field.

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.