stable_2020-04-22

Features

New searchable fields:

• location in admission (link to zendesk)
• You can now search for an appointment's duration
• You can now search for an appointment's appointment 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 with 44. 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

new fields:

• DW_ADMISSION_FACT.LOCATION_ID smallint not null
  • related view field admission.Location nvarchar(100) null
• f_medication_request.verification_dt datetime null
  • related view field: medication_request.VerificationDate datetime null
• 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

changed objects:

• removal of DW_APPT_* structure in favor of the newer convention: f_appointment for facts, and d_appointment_* for dimensions