Here are the case when RxNorm extension doesn't solve the problem:
We have drugs with the dosage written in relative units, something like
"bevacizumab 5 mg/kg" (kg of patient weight) and we don't know the patient weight, And actually we don't have to, because relative dosage is more useful for the subsequent studies to know the exact intensity of the therapy.
And of course we can't map it to any RxNorm (Extension),
so we map it to the Clinical Drug Form. but then, how to preserve the Quantity?
We know that the patient got this 5 mg/kg daily,
so we can map to to "Bevacizumab injectable solution", put "5" in Quantity in drug_exposure, but then it will be treated as 5 mg ("mg" is a unit in drug_strength for "bevacizumab Injectable solution"), that is wrong.
We can populate the dose_unit_source_value, but I think nobody looks there.
And again, I think there's no such a rule: to ignore the units in drug_strength if dose_unit_source_value is populated.
So, @schuemie, your suggestion might be really helpful here. And then we can add flag how do we populate the drug_exposure: looking on the dosage from drug_strength or on the dosage from the drug_exposure,
this way the elegant way of RxNorm Extension will be used in the most of the cases, but the complicated cases will be proceeded straightforward with the dosage in drug_exposure.
@Christian_Reich, @aostropolets, @abedtash_hamed, @Alexdavv, @ericaVoss