Avatar Data Warehouse Release Notes
Requirements
Products
The following products are required before loading any Avatar Data Warehouse updates:
- RADplus
- Avatar PM
- Avatar Data Warehouse
Releases
Individual
A list of individual updates for the Avatar Data Warehouse product. Each update may include other updates.
Avatar Data Warehouse Update 26 Feb 9, 2024
The following changes are made: 1) The Data Warehouse has been updated to support new functionality within the 2024.1.001 Data Warehouse Incremental Middleware. 2) The Data Warehouse background process has been improved to stay in sync with changes within myAvatar. 3) The error "[UNDEFINED]Compare+21^DssLiabilityUpdate" which can occur when liability is being calculated for a service has been resolved. 4) An issue has been resolved where the 'Data Warehouse Transient Comparison Configuration' form was not displaying all transient fields for selected tables within the 'Compare Columns' field.
Progress Notes Data Warehouse
Avatar Data Warehouse Update 25 Jul 12, 2023
Avatar Data Warehouse Update 24 Mar 2, 2023
Avatar Data Warehouse Update 23 Jun 27, 2022
The following changes are made: 1)The data warehouse mappings were corrected for each namespace. 2)The tables 'SYSTEM.view_episode_summary_current' and 'SYSTEM.view_episode_summary_admit' will always be marked for a full load during the Data Warehouse middleware load. 3)An issue where table views are not marked for full load during the background journal process has been resolved. 4)Performance improvements have been made to the Data Warehouse background journal process.
Data Warehouse
Avatar Data Warehouse Update 21 Jun 8, 2021
An issue is resolved where, under certain conditions, temporary table entries were not fully cleaned up.
Avatar Data Warehouse Update 20 Nov 24, 2020
The following changes are made: 1) Performance improvements have been made to the Data Warehouse background journal process. 2) The table 'SYSTEM.billing_guar_order_history' will always be marked for a full load during the Data Warehouse middleware load.
Avatar Data Warehouse Update 19 Apr 20, 2020
The issue is resolved where incorrect table rows may be picked up in tables where the ID key consists of only the facility.
Avatar Data Warehouse Update 18 Jan 20, 2020
The following issues are resolved: 1) The issue where table rows in child namespaces may not get picked up properly. In addition, a new field 'Ignore data entry properties in 'SYSTEM.billing_tx_charge_detail'' has been added to the 'Data Warehouse System Defaults' form. This will allow the background process to not flag table rows if only the data entry fields in the 'SYSTEM.billing_tx_charge_detail' table has changed.
Avatar Data Warehouse Update 17 Sep 3, 2019
An issue is resolved where the Data Warehouse background journal process may error after an Avatar update is installed which modifies a table selected for the Data Warehouse load.
Avatar Data Warehouse Update 16 Jul 26, 2019
The following changes have been made: 1) The issue is resolved where the Data Warehouse load incorrectly loads 837 Professional rows into 837 Institutional only tables. 2) The issue is resolved where the error '[UNDEFINED]Pre+16^DssLiabilityUpdate' may occur when calculating client liability. 3) The issue is resolved where the table 'STATEFORM.diagnosis_code_list' may not load correctly. 4) The issue is resolved where the error '[SYNTAX]ValidateGlobal+118^DSSJournalFileDump' may occur. 5) The issue is resolved in the 'Data Warehouse System Defaults' form where defaults information may be filed incorrectly. 6) The issue is resolved where the same row may be sent in consecutive Data Warehouse loads.
Data Warehouse