For EMR data, the standard approach we have adopted is to combine all the fact tables and then calculate last date as observation_period_end_date for each patient. For the records coming from drug_exposure, should days_supply and refills be included to calculate the observation_period_end_date in observation_period?
@Christian_Reich: Yes I have:
Don’t consider days_supply for the calculation of the observation period. The patient may not be observable during the following “days_supply period.” The same applies for refills.
BTW: days_supply refers to a single prescription, it must not contain days from refills! Otherwise we would calculate a wrong daily dosage! If you want to record refills, use the drug_exposure_end_date.