Skip to main content

Release Notes

Release notes for Bliksund Analytics Data Processing

v1.5.0 (Available next)​

Added to core layer:

  • New layer added (see docs)
  • Note: This is an early stage, and tables and columns might have bigger changes in later releases

Added to serve layer:

  • New layer added (see docs)
  • Note: This is an early stage, and tables and columns might have bigger changes in later releases

Changes to clean layer:

  • Type for column ewa_clean.emcc_tickets.sql full_emcc_mission_id_updated_at is changed from varchar(max) to datetime2
  • Added column ewa_clean.locations.house_number
  • Added column ewa_clean.locations.latitude
  • Added column ewa_clean.locations.longitude
  • Added column ewa_clean.news2.scoring_params_id
  • Added column ewa_clean.news2.scoring_params_item_id
  • Added column ewa_clean.news2.scoring_params_item_score
  • Added column ewa_clean.news2.scoring_params_item_text
  • Added column ewa_clean.news2.scoring_params_title
  • Added column ewa_clean.patients.home_house_number
  • Added column ewa_clean.patients.unknown_patient_identification_number
  • Added column ewa_clean.patients.unknown_patient_identification_type
  • Added table ewa_clean.history_of_presenting_complaint, which has been introduced to provide data related to the History of Presenting Complaint feature of EWA.

Other changes:

  • Default value for BLIKSUND_LOAD_BATCH_SIZE is changed from 500 to 10000
  • Bug fix to make sure that many duplicates of measurements are not loaded
  • Bug fix for mission data in ewa_clean.sats.gcs

Note for installation:

  • If you have installed and tested AnalyticsDataProcession the configuration for BLIKSUND_TRANSFORM_FULL_ON_START and BLIKSUND_LOAD_FULL_ON_START should be set to True. Then the tables will be deleted, and new ones are loaded. Note that the load time might be longer than before due to the full load of all tables.
  • See Installation Guide for more information

v1.4.0 (Available on 2024.12.20)​

Added to clean layer:

  • Table ewa_clean.measurements. This is a table that contains information about various measurement records taken from patients.
  • Table ewa_clean.measurement_types. This is a table (from a dbt seed) that contains the different types of measurements, and their id.
  • Column ewa_clean.sats.triage_tews_selected_params_id
  • Column ewa_clean.sats.triage_tews_selected_params_title
  • Column ewa_clean.sats.triage_tews_selected_params_item_id
  • Column ewa_clean.sats.triage_tews_selected_params_item_text
  • Column ewa_clean.sats.triage_tews_selected_params_item_score

Naming fixes applied:

  • Column ewa_clean.cardiac_arrest_forms.first_heart_rythm renamed to ewa_clean.cardiac_arrest_forms.first_heart_rhythm.
  • Column ewa_clean.cardiac_arrest_forms.prehospital_thrombolosis renamed to ewa_clean.cardiac_arrest_forms.prehospital_thrombolysis.

Note for installation:

  • If you have installed and tested AnalyticsDataProcession the configuration for BLIKSUND_TRANSFORM_FULL_ON_START should be set to True. Then the tables will be deleted, and new ones are loaded.
  • See Installation Guide for more information
  • Be aware that measurements are now added to the export. This table may consist of many rows, which can make the first run of this version slower.

v1.3.1 (2024.12.16)​

Added to clean layer:

  • Table ewa_clean.emcc_tickets. This is a table containing ticket data related to EMCC missions, including mission IDs, urgency levels, and dispatch code information.
  • Table ewa_clean.records_emcc_tickets. This is the table that will bridge the EMCC tickets to their associated records.
  • Table ewa_clean.codes_status. This is a table (from a dbt seed) that contains the different statuses and their respective codes for a mission.
  • Table ewa_clean.checklist_configuration_items. Table for the configuration of checklists.
  • Table ewa_clean.checklist_response_items. Table for the responses to a checklist.
  • Column ewa_clean.missions.mission_resource_id
  • Column ewa_clean.missions.emcc_mission_id

Upcoming deprecations:

  • Column ewa_clean.pr_medical_record_crews.name will be deleted after 2025.02.01. Use ewa_clean.pr_users.full_name instead.
  • Column ewa_clean.missions.emmc_mission_id will be deleted after 2025.02.01. Use ewa_clean.missions.emcc_mission_id instead.

Fixes applied:

  • Column ewa_clean.missions.dispatch_code now contains the dispatch code.

Note for installation:

  • If you have installed and tested AnalyticsDataProcession the configuration for BLIKSUND_TRANSFORM_FULL_ON_START should be set to True. Then the tables will be deleted, and new ones are loaded.
  • See Installation Guide for more information

v1.2.0 (2024.11.29)​

  • Table ewa_clean.cardiac_arrest_forms with information from cardiac arrest forms filled out is added to the Clean layer.
  • Table ewa_clean.urgency_levels is added to the the Clean layer.
  • Table ewa_clean.record_urgency_levels is added to the Clean layer. This is the table that will bridge the urgency levels to the records.
  • Column ewa_clean.pr_users.full_name is added to the Clean layer.
  • Column ewa_clean.pr_medical_record_crews.name will be deprecated after 2025.02.01. Use ewa_clean.pr_users.full_name instead.
  • Improve incremental load time for ewa_clean.drugs, ewa_clean.locations and ewa_clean.time.
  • Column type for ewa_clean.oxygen.quantity and ewa_clean.infusions.amount are changed from float to nvarchar(max).

Note for installation: If you have installed and tested AnalyticsDataProcession the configuration for BLIKSUND_TRANSFORM_FULL_ON_START should be set to True. Then the tables will be deleted, and new ones are loaded. See Installation Guide for more information.

v1.1.0 (2024.11.04)​

  • Added organizations and stations to schema ewa_clean, in order to see which record that belongs to which organization/health trust See Table Description.
  • Removed some tables related to personnel registration and configurable mission type from stage in order to increase transformation time and reduce storage cost. No changes in ewa_clean for this tables.

Note for installation: If you have installed and tested AnalyticsDataProcession the configuration for BLIKSUND_TRANSFORM_FULL_ON_START should be set to True. Then the tables will be deleted, and new ones are loaded. See Installation Guide for more information.

v1.0.3​

Initial version. See Model Description and Table Description.

Note for installation: This service will replace FormModuleData. If you have installed and tested FormModuleData the configuration for BLIKSUND_TRANSFORM_FULL_ON_START should be set to True. Then the Forms tables will be deleted, and new ones are loaded. See Installation Guide for more information.