stable_2020-11-05

Generic datamodel/etl changes

• Data Quality framework: Major update which implements many new measures and rules to check the datawarehouse quality in hospitals
• Created a method to update the ssis solution with pre-build .ispac files for servers where this can't be build locally
• Added logic to update the new text-analysis-pipeline service if implemented on the server

New or significantly updated categories:

• New field [dbo].[f_medication_request].[indication_id] has been added
  • Together with new dimension table [dbo].[d_medication_indication]
  • Contains information about the ailment of why a medication is prescribed
• New view fields: [dbo].[concept].[temporal_granularity] and [dbo].[concept].[paragraph_label]
  • Together with new dimesnion table [dbo].[d_concept_temporal_granularity]
  • paragraph_label comees from existing dimension [dbo].[d_concept_paragraph]
• Added administrative categories from IQVIA BE implementations to generic datamodel
  • f_administrative_diagnosis table and administrative_diagnosis view
  • f_administrative_invoice table and administrative_invoice view
  • f_administrative_medication table and administrative_medication view
  • f_administrative_procedure table and administrative_procedure view
• Removed fields
  • DW_ADMISSION_DIM_TAG.TAGS
  • DW_LAB_DIM_TAG.TAGS

EHR-specific datamodel/etl changes

hix

• Fixed an issue where diagnosis records coming from dbc's don't have an ICD-10 code
• Added if exist check for EPISODE_DBCPER
• Added additional form entry descriptions
• Further improved form entry ordering

clarity

• Improved surgery procedure descriptions
• Fixed an issue with allergy reaction truncation

CTcue application integrations

• Patient birth and deceased dates are now loaded with a time of 12:00 to fix issues with timezone conversions
  • this fix causes a historic patient reload in ES
• Fixed an issue where concept start dates where different from report start dates