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)

AV-96198 Details \| User Acceptance Tests 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:

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

Open the 'Crystal Report' or any other SQL data viewer.
Query the 'SYSTEM.edi_ca_csi_records' table specific to the 'index_counter' containing data.
Verify the table column 'index_counter' is displayed correctly with decimal data.
Close the report.

Topics

• Database Management