Skip to main content

Avatar Data Warehouse Update 27

  1. Last updated
  2. Save as PDF

Product Requirements and Recommendations

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

Product Update Description

The following changes are made: 1) An issue has been resolved where mapped tables were not correctly setting up inserts and deletes for the Data Warehouse load. 2) Avatar Data Warehouse has been updated to improve resiliency when comparing liability changes for the 'SYSTEM.billing_tx_charge_detail' table.

Required Updates

None

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, 23, 24, 26

Details
NEW0 CHANGED0 FIXED1
Fixed (1)
Data Warehouse - 'SYSTEM.RADplus_IMO_results' table
An issue is resolved to ensure that updates to the 'SYSTEM.RADplus_IMO_results' table(s), are picked up during "Data Warehouse" middleware processing. In addition, The "Data Warehouse" process is updated to address an issue that could occur when analyzing liability changes that determine table row inserts, for the 'SYSTEM.billing_tx_charge_detail' table
Topics
• Data Warehouse
 
Acceptance Tests
AV-96059 Summary | Details
Data Warehouse - 'SYSTEM.RADplus_IMO_results' table
Scenario 1: Data Warehouse - 'Background Journal' and 'Middleware' Processing - Table row validations
Specific Setup:
  • Have any desired tables selected for "Data Warehouse" processing in the "Data Warehouse Transient Comparison Configuration" form that contain data.
  • In addition, have the following table data included for "Data Warehouse" processing:
  • Data submitted in the "SYSTEM.RADplus_IMO_results" table in the "PM" and "MSO" applications
  • Data submitted in the "SYSTEM.billing_tx_charge_detail" table
  • Liabilities have been updated on the system via the "Liability Update" form.
  • Data submitted in the "SYSTEM.cw_patient_notes' in 'CWS"
  • Also include the corresponding CDR table "CWSSYSTEM.cw_patient_notes" in "PM"
  • Have a database program to query the Middleware SQL Server to display the table row data for the tables that were selected in the middleware process and also to query the "SYSTEM.dss_completion_flag" and the "SYSTEM.dss_inc_full_load_history" tables
Steps
  1. Netsmart has run or set up a background process to run the middleware "Background Journal Process" process to select table rows based on the tables selected for data warehouse, noted in the set up
  2. Validate the process completes successfully
  3. Run the report to display data table rows in the "SYSTEM.dss_inc_full_load" table
  4. Validate the report includes the expected tables queued for data warehouse processing based on the tables selected for data warehouse in the setup
  5. Netsmart has run or set up a background process to run "StartDssIncQueueManager" executable that will start the "Data Warehouse" Middleware to process and move selected data tables to the SQL Server Middleware server
  6. Validate the process completes successfully
  7. Run the report or query to display data in the "SYSTEM.dss_inc_error_log" table
  8. Validate the report indicates that there are no errors
  9. Run the report to display data table rows in the "SYSTEM.dss_inc_full_load_history" table
  10. Validate the report includes the expected data rows for the tables selected for processing in the setup
  11. Open the program used to query data on the SQL server
  12. Navigate to and select the folder where the data tables reside
  13. Execute a query to display field data filed in the "dss_completion_flag" table.
  14. Validate all the data rows for all the table(s) selected in the set up are present on the report, as expected.
  15. Validate for each table row. "dss_status" field value is set to"1", indicating success
  16. Execute a query to display data in the 'DW.dss_inc_full_load_history table'
  17. Validate data displays the same rows for the table, displayed in step 2b
  18. Execute a query to display data in the "SYSTEM.RADplus_IMO_results" table in the "PM" application
  19. Validate data displays the same rows for the table, displayed in step 2b
  20. Execute a query to display data in the "SYSTEM.RADplus_IMO_results" table in the "MSO" application
  21. Validate data displays the same rows for the table, displayed in step 2b
  22. Execute a query to display data in the "SYSTEM.cw_patient_notes' in the "CWS" application
  23. Validate data displays the same rows for the table, displayed in step 2b
  24. Execute a query to display data in the "CWSSYSTEM.cw_patient_notes" in the "PM" application
  25. Validate data displays the same rows for the table, displayed in step 2b
  26. Execute a query to display data in the "SYSTEM.billing_tx_charge_detail" table
  27. Validate data displays the same rows for the table, displayed in step 2b
Topics
• Data Warehouse