Skip to main content

Avatar Cal-PM 2024 Update 40

Product Requirements and Recommendations

Avatar Cal-PM required
RADplus required

Recommended Update Level

Avatar Cal-PM 2024 Monthly Release 2024.01.01
RADplus 2024 Monthly Release 2024.01.01

Product Update Description

A "duplicate key error" that may occur on the SYSTEM.edi_ca_csi_records table during a Data Warehouse "Incremental Data Load" is resolved.

Required Updates

None

Included Updates

None

Details

NEW0 CHANGED0 FIXED1
Fixed (1)
SQL Table validations
An issue is resolved where the table column ‘index_counter’ was not displaying correctly with decimal data in the 'SYSTEM.edi_ca_csi_records' table.
Topics
• Database Management
 
Acceptance Tests

AV-96198 Summary | Details
SQL Table validations
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • Admission
  • Admission (Outpatient)
  • Crystal Report Viewer
  • Crystal Reports or other SQL Reporting tool (SDK_AVCALPM Namespace)
  • CSI Admission
  • CSI Submission
  • Program Maintenance
Scenario 1: SYSTEM.edi_ca_csi_records - field validation
Specific Setup:
  • Program Maintenance:
  • Identify an existing CSI program or create a new CSI program where the field 'Mental Health Program (CSI)' is set to "Yes". Note the program code / description.
  • Admission:
  • Admit a new client to the CSI program identified above. Note the client's id/ name, admission date.
  • CSI Admission:
  • CSI admission is filed for the client admitted above. Note the data entry date when the CSI admission is filed.
  • CSI Submission:
  • The CSI submission is filed for the client with the 'Through Date' that covers the 'CSI Admission' filed above.
Steps
  1. Open the 'Crystal Report' or any other SQL data viewer.
  2. Query the 'SYSTEM.edi_ca_csi_records' table specific to the 'index_counter' containing data.
  3. Verify the table column 'index_counter' is displayed correctly with decimal data.
  4. Close the report.
Topics
• Database Management