I have a question:
If we don’t have end_date information for condition_exposure, how to build table “condition_era”?
The simple method is to just to set the END_DATE to the START_DATE (i.e. coalesce(condition_end_date, condition_start_date)). Then just stitch together the eras using a 30 day gap.