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 = ?