Open stephanieshong opened 1 year ago
The EPISODE table aggregates lower-level clinical events (VISIT_OCCURRENCE, DRUG_EXPOSURE, PROCEDURE_OCCURRENCE, DEVICE_EXPOSURE) into a higher-level abstraction representing clinically and analytically relevant disease phases, outcomes and treatments. There is a lot of forum posts about this topic. We may need to revisit this topic and regroup our thoughts.
NOTE: Episode of Caree has been determined to be out-of-scope (8/24/2023) in Year 1 & Year 2 contract.
Episode of care visit dates - the visit dates across all claims should be considered to build the episode of care start date and end date if the visit dates overlap and/or if the date has one day difference in date. Episode of care visit start date and end_date should be added to the visit_occurrence to indicate if this visit was a part of a Episode event.