Skip to main content

Avatar Cal-PM 2024 Update 41

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

An error "An unexpected error occurred executing SqlComputeCode" produced on the 'SYSTEM.mhsa_compile_error' and 'SYSTEM.billing_medical_rev_assign' tables is resolved.

Required Updates

None

Included Updates

None

Details

NEW0 CHANGED0 FIXED1
Fixed (1)
SQL Table Validation - Data Retrieval
An issue is resolved where an error “An unexpected error occurred executing SqlComputeCode” was produced on the ‘SYSTEM.mhsa_compile_error’ and ‘SYSTEM.billing_medical_rev_assign’ tables.
Topics
• Database Management
 
Acceptance Tests

AV-96593 Summary | Details
SQL Table Validation - Data Retrieval
Scenario 1: SYSTEM.mhsa_compile_error - Validating Data Retrieval
Specific Setup:
  • Tester has access to the 'Crystal Report' or any other SQL data viewer for the system.
Steps
  1. Open the 'Crystal Report' or any other SQL data viewer.
  2. Run the SQL query to retrieve data from the 'SYSTEM.mhsa_compile_error' table.
  3. Verify that the data was successfully retrieved from the table.
  4. Close the report.
Scenario 2: SYSTEM.billing_medical_rev_assign - Validating Data Retrieval
Specific Setup:
  • Tester has access to the 'Crystal Report' or any other SQL data viewer for the system.
Steps
  1. Open the 'Crystal Report' or any other SQL data viewer.
  2. Run the SQL query to retrieve data from the 'SYSTEM.billing_medical_rev_assign' table.
  3. Verify that the data was successfully retrieved from the table.
  4. Close the report.
Topics
• Database Management