Hope that I don’t duplicate any topic.
If I understand correctly drug_exposure.quantity must be consistent with drug exposure dates.
I would like to know your opinion on the following questions:
If it is OK to recalculate drug_exposure.quantity = (daily dose * actual duration) and to drop source quantity, when the original prescription was stopped before the planned date (please see example below)?
What would be your recommendations on populating drug_exposure.quantity for medications without end date/ days_supply information? As we populate drug_exposure_end_date = drug_exposure_start_date for such records, which option is the best?
- drug_exposure.quantity = NULL
- drug_exposure.quantity = source quantity as it is
- drug_exposure.quantity = daily dose * 1 day
Example 1 for question 1:
- start date = 2015-05-12
- end date = 2015-09-08
- discontinue date = 2015-06-01
- duration = 30
- quantity = 60
- refills = 3
- frequency = 2 times a day
- dose = 1
As discontinue date is before end date, then the following entry could be created in Drug_exposure:
- drug_exposure_start_date = start date
- drug_exposure_end_date = discontinue date
As quantity and days_supply must be consistent with the current exposure, it
can be calculated as following:
- quantity = (drug_exposure_end_date - drug_exposure_start_date +1 day) * dose * frequency = 42
- days_supply = drug_exposure_end_date - drug_exposure_start_date +1 day = 21
- refills = NULL
Please share any experience of yours when you needed to readjust source quantity and duration values and which formulas/approaches you applied.