Skip to main content

Avatar PM 2023 Update 126

  1. Last updated
  2. Save as PDF

Product Requirements and Recommendations

Avatar PM required
RADplus required

Recommended Update Level

Avatar 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

None

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-91755 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 New
SYSTEM.view_episode_summary_admit data_entry_timezone_info_all New
SYSTEM.view_episode_summary_admit data_entry_time_j New
SYSTEM.view_episode_summary_admit data_entry_offset New
SYSTEM.view_episode_summary_admit data_entry_timezone_short New