Skip to main content

Avatar Cal-PM 2023 Update 67

Product Requirements and Recommendations

Avatar Cal-PM required
RADplus required

Recommended Update Level

Avatar Cal-PM 2023 Monthly Release 2023.02.02
RADplus 2023 Monthly Release 2023.02.02

Product Update Description

The error 'Error in assignment', which may occur where querying the 'SYSTEM.view_episode_summary_admit' table, is resolved.

Required Updates

None

Included Updates

3, 5, 7, 8, 11, 13, 16, 17, 21, 26, 28, 32, 38, 39, 43, 45, 52, 54, 56, 61, 65

Details

NEW0 CHANGED0 FIXED1
Fixed (1)
SQL Table Validation - SYSTEM.view_episode_summary_admit table
Resolves an issue to ensure that the 'c_date_of_birth' column of the SYSTEM.view_episode_summary_admit table displays NULL value when the date of Birth field is blank for the client's admission.
Topics
• Admission • Admission (Outpatient) • Database Tables • NX • Pre Admit
 
Acceptance Tests

AV-92375 Summary | Details
SQL Table Validation - SYSTEM.view_episode_summary_admit table
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • Admission
  • Admission (Outpatient)
Scenario 1: SQL table validation - SYSTEM.view_episode_summary_admit - Outpatient Client Admission on the cache system
Specific Setup:
  • Admission:
  • Create a new client and do not enter date of birth of the client. Note the client id.
Steps
  1. Open the 'Crystal report' or any other SQL data viewer.
  2. Query the 'Select * from SYSTEM.view_episode_summary_admit' table.
  3. Verify the client without a date of birth have a blank value in the 'c_date_of_birth' field.
  4. Open the 'Admission (Outpatient)' form for the client.
  5. Edit an existing admission record.
  6. Enter desired date of birth.
  7. Open the 'Crystal report' or any other SQL data viewer.
  8. Query the 'Select * from SYSTEM.view_episode_summary_admit' table for the client.
  9. Verify the client updated with a date of birth have correct date in the 'c_date_of_birth' field.
Topics
• Admission • Admission (Outpatient) • Database Tables • NX
Table Changes

Table Column Change
SYSTEM.view_episode_summary_admit c_date_of_birth Modified
SYSTEM.view_episode_summary_admit data_entry_utc Modified
SYSTEM.view_episode_summary_admit data_entry_timezone_info_all Modified
SYSTEM.view_episode_summary_admit data_entry_time_j Modified
SYSTEM.view_episode_summary_admit data_entry_offset Modified
SYSTEM.view_episode_summary_admit data_entry_timezone_short Modified