OHDSI Home | Forums | Wiki | Github

How to calculate Quantity and effective_drug_dose in Drug_exposure table?

We ask about the ‘quantity’ and ‘effective_drug_dose’ columns in the drug_exposure table.

We read the CDM documentation 5.1 and understood that ‘Quantity’ is calculated as the total number of drugs at the time of prescription and ‘effective_drug_dose’ is calculated by calculating the dose of the prescribed amount per day.

For example, if a doctor prescribes a patient to Tylenol Tab 250mg, 3 tablets a day for 7 days, We calculated it as follows.

  • Quantity = 1tablets * 3 times * 7 days
  • Effective_drug_dose = 250mg * 3 times

But, If you want to know the total dose prescribed to the patient(Quantity * effective_drug_dose), you may not be able to calculate it because of the duplication of 3 times.

We wondering how to calculate the ‘Quantity’ and ‘effective_drug_dose’ columns in drug_exposure table at other institutions.

ex) Tylenol Tab 250mg, 3 tablets a day for 7 days

  • Quantity = ?
  • Effective_drug_dose = ?

For our purposes, effective_drug_dose is the amount of a single dose - for your example 250 mg; for me likely 15 mg/kg. :slight_smile: - not the total daily dose. That would solve your problem with the “double counting” of the frequency when you estimate the total dose over the life of the prescription. But it does mean you need to account for frequency if you want to compute the total dose for another interval (all assuming the recipient took all of the intended doses in that interval).

t