Admission: admissionparts now include a bed number, also loaded to elasticsearch
new column: DW_ADMPART_FACT.BED_NUMBER NVARCHAR (15) NULL
this addition causes a historic admission+admissionpart reload
Concept: all concepts before 2020 are deleted, causing a drastic unload from elasticsearch. This is a compromise to allow new application functionality while still keeping most relevant concepts
Load improvements
prevent category counting timeouts by adding retry logic
consent filter records in elasticsearch are now countable
hard thresholds checks between dwh<>dwh_filtered count steps are now included to prevent accidentally unloading or reloading large chunks of a category
EHR-specific datamodel/etl changes
hix
Diagnosis: ICD10 records from the EPISODE_DBCPER are now available. This significantly increases the number of diagnoses users can find
Surgery: fixed an issue where surgery procedures were not correctly linked to surgeries. This fix may cause a partial historic load to elasticsearch
Report
reprocess a batch of year 2020 radiology texts, causing a slight performance hit on preprocessing/load for the first ETL run of this release
fixed an issue where various radiology texts were continuously being reprocessed and reloaded every ETL run. Average ETL duration should go down significantly after the first ETL run on this version
clarity
QA
fixed an issue where QA statuses were not added since May 2020. Causes a partial elasticsearch reload of qa
imperial system values are now converted to metric system values. Causes a partial reload of qa
it is now possible to filter on source templates to decide on how much data is staged. This currently has no impact anywhere except in OLVG
Surgery: fixed an issue where surgeries were not linked to the correct specialisms, causing an historic load