According to the conventions (see below), if a drug has more that one ingredient we create one row per ingredient in DRUG_EXPOSURE.
Do I understand right that then for each row set the drug_concept_id to the corresponding ingredient-concept_id ??
If yes, then we are missing precision on the drug_concept_id. Different ‘Branded Pack’, ‘Clinical Pack’,etc will end up having the same ingredient-concept_id combinations. Moreover, what is then the point of having that precision on compounded drugs, if in the DRUG_EXPOSURE only the high hierarchiy ingrideint is used?
- Compounded drugs
Example: Ibuprofen 20%/Piroxicam 1% Cream, 30ml in 5ml tubes.
DRUG_STRENGTH We need entries for the ingredients of Ibuprofen and Piroxicam, probably with an amount_value of 1 and a unit of mg.
DRUG_EXPOSURE The quantity refers to the total amount of the compound. Use one record in the DRUG_EXPOSURE table for each compound.
Example: 20% Ibuprofen of 30ml = 6mL, 1% Piroxicam of 30ml = 0.3mL
Ingredient dose= Depends on the drugs involved: One of the use cases above.Ibuprofen dose = 6 x 1mg x 1000 = 6000mg
Daily dose = Ibuprofen dose/drug duration
Piroxicam dose = 0.3 x 1mg x 1000 = 300mg
Daily dose = Piroxicam dose/drug duration
Note: The analytical side determines that the denominator for both ingredients in the DRUG_STRENGTH table is mg and applies the factor 1000 to convert between mL/g and mg.