introduces ES7 and a new improved method of loading using a python backend rather than SSIS. Loads will be more reliable, faster, and users will see less intrusion during their day-to-day activities. This release is paired with a new major application version (4.0.0+).
release names now follow semantic versioning. Any hospital with a new-style name, e.g. v1.5.0, will by definition be running on ctReach v4+ and ctETL v1.5.0+
elasticsearch views are homogenized, now mirroring the exact fields present in elasticsearch, with the exception of marked_for_deletion, which is used internally in the data warehouse
all modified_dt/inserted_dt fields in the outward-facing layer of the data warehouse are now datetimeoffset fields and are UTC-based.
there are many breaking changes in the fact tables and views. For a complete list of outward-facing DDL changes, contact the data engineering team.
marked_for_deletion, which is used internally in the data warehousemodified_dt/inserted_dtfields in the outward-facing layer of the data warehouse are nowdatetimeoffsetfields and are UTC-based.