Avatar Data Warehouse Update 23

Last updated
Save as PDF

Product Requirements / Recommendations

Avatar Data Warehouse required
Avatar PM required
RADplus required
Avatar Cal-PM

Product Update Form Description

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.

Included Updates

2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 11.1, 12, 13, 13.1, 14, 15, 16, 17, 18, 19, 20, 21

Required Updates

Avatar Data Warehouse Update 21

Details

NEW0 CHANGED0 FIXED2

Fixed (2)

AV-71278 Details \| User Acceptance Tests Data Warehouse - Background Journal Processing Improvements have been made to the Data Warehouse "Background Journal Process" to address issues where errors could occur during processing when loading tables marked for full load. In addition, the process is updated to always full load the 'SYSTEM.view_episode_summary_current' and 'SYSTEM.view_episode_summary_admit' tables, to address errors that could occur processing the tables	Topics • Data Warehouse

AV-75479 Details \| User Acceptance Tests Data Warehouse - Global Mappings An issue is resolved to ensure when installing "Avatar Data Warehouse" updates, product global internal mappings load correctly.	Topics • Data Warehouse

Acceptance Tests

AV-71278 Summary | Details

Data Warehouse - Background Journal Processing

Scenario 1: Data Warehouse - 'Background Journal Process' Table load validation

Specific Setup:

Have a system that's up to date with all "Avatar Data Warehouse" updates
In form "User Definition", have a user created as designated data warehouse user [DWuser] and assign the user permissions to the following table's: 'SYSTEM.view_episode_summary_current', 'SYSTEM.view_episode_summary_admit' , 'SYSTEM.RADplus_caseload', SYSTEM.RADplus_database_locks, and SYSTEM.cw_grnote_garb_collector
Have one or more rows of data that exist in each table assigned in the first setup step. Note the number of rows in each table
In form "Data Warehouse Transient Comparison Configuration" form:
Navigate to the "Mark Tables For Full Load" section and select the [DWUser]
In the "SQL Tables" list box, select all the tables assigned in the first setup step except the 'SYSTEM.view_episode_summary_current', 'SYSTEM.view_episode_summary_admit' tables, as these will now automatically be selected for full load
Click "Mark Selected Tables for Full Load".
Have Netsmart run the "Data Warehouse" Background Journal Process
Have a report or query that will display data in the "SYSTEM.dss_inc_full_load" table. [ReportA]
Have a report or query that will display data in the "SYSTEM.dss_inc_error_log" table. [ReportB]

Steps

Open [ReportA], to display results in the "SYSTEM.dss_inc_full_load"
Click to generate the report
Validate the data results include the "SYSTEM.cw_grnote_garb_collector" table and with the expected number of rows processed
Validate the data results include the " SYSTEM.RADplus_caseload " table and with the expected number of rows processed
Validate the data results include the "SYSTEM.RADplus_database_locks" table and with the expected number of rows processed
Validate the data results include the "SYSTEM.view_episode_summary_current" table and with the expected number of rows processed
Validate the data results include the "SYSTEM.view_episode_summary_admit" table and with the expected number of rows processed
Open [ReportB] to display results from the "SYSTEM.dss_inc_error_log"
Validate there are no results, indicating all tables in step 1 were loaded successfully during the "Background Journal Process"

Topics

• Data Warehouse

AV-75479 Summary | Details

Data Warehouse - Global Mappings

Scenario 1: Data Warehouse - Validate (Internal) Global, Routine and Package Mappings

Steps

Internal Testing Only

Topics

• Data Warehouse