stable_2021-05-20

Features

• Appointment end dates are now searchable
  • Causes a historic appointment reload during ETL
• Newly added DBC fields see the technical changelog (SQL DWH only)
  • Causes historic DBC reload during ETL in Hix & Clarity
• Hix:
  • Added a better link for admissionpart bed numbers, rooms and departments (for newer Hix versions)
    • In case a hospital uses the newly added fields can cause a historic ETL of admissionparts
  • Changed filter logic for procedures so that valid procedures are no longer deleted if linked to another procedure (Zendesk ticket #699)
    • Causes a bigger then usual update on procedures, causing longer ETL

Improvements

• Various performance and data quality improvements
• Additional checks to prevent incorrect truncations of categories
• SAP EHR: Various form and care activities improvements

Technical changelog

new tables:

• d_dbc_closure
  • related view fields: dbc.ClosureCode nvarchar(25) null and dbc.ClosureReason nvarchar(300) null
• d_dbc_referral_type
  • related view fields: dbc.referral type nvarchar(300) null

new fields:

• f_appointment.appointment_end datetime null
  • related view field appointment.EndDate datetime null
• renamed field f_appointment.appointment_dt to f_appointment.appointment_start
• DW_DBC_FACT.dbc_start datetime null as replacement of DW_DBC_FACT.START_DATE_ID int not null
  • related view field: dbc.StartDate datetime null
• DW_DBC_FACT.dbc_end datetime null as replacement of DW_DBC_FACT.END_DATE_ID int not null
  • related view field: dbc.EndDate datetime null
• DW_DBC_FACT.closure_id smallint not null
  • related view field: dbc.ClosureCode nvarchar(25) null
  • related view field: dbc.ClosureReason nvarchar(300) null
• DW_DBC_FACT.referral_dt datetime null
  • related view field: dbc.ReferralDate datetime null
• DW_DBC_FACT.referring_episode varchar (25) null
  • related view field: dbc.ReferringEpisode varchar(25) null
• DW_DBC_FACT.referring_location_id smallint not null
  • related view field: dbc.ReferringLocation nvarchar(100) null
• DW_DBC_FACT.referring_specialism_id int not null
  • related view field: dbc.ReferringSpecialismCode nvarchar(500) null
• DW_DBC_FACT.referring_practitioner_id int not null
  • related view field: dbc.ReferringPractitionerName nvarchar(100) null
  • related view field: dbc.ReferringPractitionerName nvarchar(100) null
• DW_DBC_FACT.referral_type_id smallint not null
  • related view field: dbc.ReferralType nvarchar(300) null