Features
New searchable fields:
location
inadmission
(link to zendesk)- You can now search for an
appointment
'sduration
- You can now search for an
appointment
'sappointment code
Note: the above changes require a historic admission and appointment load, which may take additional time during the first ETL after rollout
Specific to HiX EHR:
- added various new form entries (where
VRLIJST_VRAGEN.CONTROLID
ends with44
. These mainly store measurements. - added additional PDF metadata
- Preoperative screenings are now available as forms (link to zendesk)
- You can now search for LSP medication
- You can now search for the verification date and verification setting
Important note: Adding the LSP medication will result in duplicates that will be found. Except if you are specifically searching for LSP data, you may want to exclude this from your search. Do this by filtering on the 3 other categories in medication request (thuismedicatie
, opname medicatie
, Geverifieerde thuismedicatie bij opname
)
Improvements
- various monitoring and operational improvements, allowing potential data issues to be caught more quickly
- sped up data extraction from source for various tables
- SAP EHR: additions to the datamodel for admissions, procedures, measurements and forms
Bug fixes
Clarity EHR:
- fixed an issue where
ENROLL_INFO
form rows were always marked as changed regardless of whether they were recently updated or not - fixed an issue where category
care activity
did not correctly contain expensive medication events- causes a partial reload of care activities
- fixed an issue where the deceased status of a patient could be incorrect
Technical changelog
new tables:
d_medication_verification_setting
- related view field:
medication_request.VerificationSetting nvarchar(150) null
- related view field:
new fields:
DW_ADMISSION_FACT.LOCATION_ID smallint not null
- related view field
admission.Location nvarchar(100) null
- related view field
f_medication_request.verification_dt datetime null
- related view field:
medication_request.VerificationDate datetime null
- related view field:
appointment.Duration int null
appointment.AppointmentCode nvarchar(50) null
removed fields:
DW_ADMPART_FACT.LOCATION_ID smallint not null
- related view field
admissionpart.Location nvarchar(100) null
- related view field
changed objects:
- removal of
DW_APPT_*
structure in favor of the newer convention:f_appointment
for facts, andd_appointment_*
for dimensions