Skip to main content

Avatar CWS 2024 Update 28

  1. Last updated
  2. Save as PDF

Product Requirements and Recommendations

Avatar CWS required
RADplus required

Recommended Update Level

Avatar CWS 2024 Monthly Release 2024.01.01
RADplus 2024 Monthly Release 2024.01.01

Product Update Description

An error 'Unexpected error executing SqlCompute code for field 'service_display': [UNDEFINED]' produced on table "SYSTEM.tx_plan_recovery_plan" is resolved.

Required Updates

None

Included Updates

None

Details
NEW0 CHANGED0 FIXED1
Fixed (1)
SQL Table validation - SYSTEM.tx_plan_recovery_plan
An issue is resolved where data could not be retrieved from the SYSTEM.tx_plan_recovery_plan table. KB0076535 v0.01
Topics
• Database Management • Treatment Plan
 
Acceptance Tests
AV-97122 Summary | Details
SQL Table validation - SYSTEM.tx_plan_recovery_plan
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • Treatment Plan
Scenario 1: Verify the Treatment Plan form is checking for required fields when it is submitted
Specific Setup:
  • An application with the new 'Treatment Plan' form must be used.
  • Note: If using the old 'Client Treatment Plan' form disregard this test.
Steps
  1. Open the 'Treatment Plan' form for any client and episode.
  2. Click the [Submit] button.
  3. Verify an error is received warning about missing required fields.
  4. Click the [T] button in the 'Plan Date' field to input today's date.
  5. Enter desired text into the 'Plan Name' field.
  6. Select any value from the 'Plan Type' field.
  7. Select "Draft" from the 'Treatment Plan Status' field.
  8. Add at least 1 row in the 'Problems' grid.
  9. Select "Final" from the ''Treatment Plan Status' field.
  10. Click [Submit].
  11. Verify the form files without errors.
  12. Open the 'Crystal Report' or any other SQL data viewer.
  13. Run the SQL query to retrieve data from the 'SYSTEM.tx_plan' table.
  14. Verify that the data successfully retrieved from the table.
  15. Close the report.
Scenario 2: SYSTEM.tx_plan_recovery_plan - 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.tx_plan_recovery_plan' table. Include the 'service_display' field in the query.
  3. Verify that the data was successfully retrieved from the table.
  4. Close the report.
Topics
• Database Management • Treatment Plan