Skip to main content

Avatar CWS 2022 Update 27

  1. Last updated
  2. Save as PDF

Product Requirements / Recommendations

Avatar CWS required
RADplus required

Product Update Form Description

An issue is resolved that may prevent the 'cw_observation_details_archive' table from being updated during a client merge or an MR# change.

Included Updates

3

Required Updates

None

Details
NEW0 CHANGED0 FIXED1
Fixed (1)
Client Observation - 'cw_observations_detail_archive' SQL table
Ensure the 'cw_observations_detail_archive' SQL table is updated properly after performing 'Change MR#' or 'Client Merge'. KB0069380 v0.01
Topics
• Change MR# • Client Merge • Client Observation • Query/Reporting
 
Acceptance Tests
AV-78752 Summary | Details
Client Observation - 'cw_observations_detail_archive' SQL table
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • Change MR#
Scenario 1: Client Merge - Validate the 'cw_observations_detail_archive' SQL table
Specific Setup:
  • A client must be enrolled in an existing episode and have 'Client Observation' records on file from 30+ days ago that display in the 'cw_observations_detail_archive' table (Client A).
  • A second client must be enrolled in an existing episode (Client B).
Steps
  1. Access Crystal Reports or other SQL Reporting tools.
  2. Select the CWS namespace.
  3. Create a report using the 'cw_observations_details_archive' SQL table.
  4. Navigate to the existing row for the record for "Client A".
  5. Validate the 'PATID' field contains the ID for "Client A"
  6. Access the 'Client Merge' form.
  7. Select "Client A" in the 'Source Client' field.
  8. Select "Episode 1" in the 'Source Client Episode' field.
  9. Select "Client B" in the 'Target Client' field.
  10. Click [File].
  11. Validate a confirmation message is displayed stating: "Do you wish to continue with the indicated action?".
  12. Click [Yes].
  13. Validate a confirmation message is displayed stating: "The following new episode has been created for the target client indicated. Episode 2"
  14. Click [OK] and close the form.
  15. Access Crystal Reports or other SQL Reporting tools.
  16. Refresh the report using the 'cw_observations_details_archive' SQL table.
  17. Navigate to the existing row for the record for "Client A".
  18. Validate the 'PATID' field now contains the ID for "Client B".
  19. Validate the 'EPISODE_NUMBER' field contains "2".
  20. Validate the 'from_merge' field contains "1".
  21. Validate the 'merge_date' and 'merge_time' fields contain the date/time of the 'Client Merge'.
  22. Close the report.
Scenario 2: Change MR# - Validate the 'cw_observations_detail_archive' SQL table
Specific Setup:
  • A client must be enrolled in an existing episode and have 'Client Observation' records on file from 30+ days ago that display in the 'cw_observations_detail_archive' table (Client A).
Steps
  1. Access Crystal Reports or other SQL Reporting tools.
  2. Select the CWS namespace.
  3. Create a report using the 'cw_observations_details_archive' SQL table.
  4. Navigate to the existing row for the record for "Client A".
  5. Validate the 'PATID' field contains the ID for "Client A"
  6. Access the 'Change MR# ' form.
  7. Enter the client in the field of 'Client ID'.
  8. Click [Assign MR#].
  9. Validate a confirmation message is displayed stating: "Auto Assign Next ID Number?".
  10. Click [Yes].
  11. Validate the 'New Client ID#' contains the new MR# that will be assigned to "Client A".
  12. Click [Submit].
  13. Access Crystal Reports or other SQL Reporting tools.
  14. Refresh the report using the 'cw_observations_details_archive' SQL table.
  15. Navigate to the existing row for the record for "Client A".
  16. Validate the 'PATID' field contains the updated MR# for "Client A".
  17. Close the report.
Topics
• Change MR# • Client Merge • Client Observation • Query/Reporting
Table Changes
Table Column Change
cw_observation_details_archive data_entry_offset Added
cw_observation_details_archive data_entry_time_j Added
cw_observation_details_archive data_entry_timezone_info_all Added
cw_observation_details_archive data_entry_timezone_short Added
cw_observation_details_archive data_entry_utc Added
cw_observation_details_archive from_merge Added
cw_observation_details_archive merge_date Added
cw_observation_details_archive merge_time Added