Is it possible to specify “relative dates” in any of the occurrence tables?
Some organizations cannot share absolute dates for privacy purposes.
One workaround is to specify a relative date to a point in time.
For example, we would like to indicate that a drug was given 10 days following a patient diagnosis.
In this case, we would like to have:
- CONDITION_OCCURRENCE.condition_start_datetime = 0 (to indicate that this is the significant event for which all other occurrences are relative.)
- DRUG_EXPOSURE.drug_exposure_start_datetime = 14
If a drug was given 5 days prior to the diagnosis then
- DRUG_EXPOSURE.drug_exposure_start_datetime = -5 (where negative means the number of days prior).
While we could consider other methods, we need a means by which we do not have to specify absolute days.