Skip to main content

Avatar CWS 2022 Update 5

  1. Last updated
  2. Save as PDF

Product Requirements / Recommendations

Avatar CWS required
RADplus required

Recommended Update Level

RADplus 2022 Update 1977

Product Update Form Description

The error '[VALUE OUT OF RANGE]' that may occur when executing a query in the SYSTEM.cw_patient_notes SQL table when including the 'date_of_service' and/or 'date_of_group_service' fields is resolved.

Included Updates

None

Required Updates

None

Details
NEW0 CHANGED0 FIXED1
Fixed (1)
Progress Notes - 'SYSTEM.cw_patient_notes' SQL table
Ensure the ability to query the 'SYSTEM.cw_patient_notes' SQL table when including the 'date_of_service' and 'date_of_group_service' fields in the query.
Topics
• Progress Notes • Registry Settings
 
Acceptance Tests
AV-77816 Summary | Details
Progress Notes - 'SYSTEM.cw_patient_notes' SQL table
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • Progress Notes (Group and Individual)
  • Registry Settings (CWS)
Scenario 1: Progress Notes - File an individual service and validate the 'SYSTEM.cw_patient_notes' SQL table
Specific Setup:
  • Access to Crystal Reports or other SQL Reporting Tool.
  • A client is enrolled in an existing episode (Client A).
  • The 'Populate the 'date_of_group_service' with group service dates only' registry setting is set to "Y".
Steps
  1. Access the 'Progress Notes (Group and Individual)' form.
  2. Create a "New Service" note for "Client A".
  3. File the note.
  4. Access Crystal Reports or other SQL Reporting Tool.
  5. Create a report using the 'SYSTEM.cw_patient_notes' SQL table.
  6. Validate a row is displayed for the note for "Client A".
  7. Validate the 'date_of_service' field contains the date of the service for "Client A".
  8. Validate the 'date_of_group_service' field is blank for "Client A".
  9. Leave the report open.
  10. Access the 'Registry Settings' form.
  11. Search for and select the 'Populate the 'date_of_group_service' field with group service dates only' registry setting.
  12. Enter "N" in the 'Registry Setting Value' field.
  13. Click [Submit] and close the form.
  14. Repeat step #1.
  15. Access Crystal Reports or other SQL Reporting Tool.
  16. Refresh the report using the 'SYSTEM.cw_patient_notes' SQL table.
  17. Validate a row is displayed for the note for "Client A".
  18. Validate the 'date_of_service' field contains the date of the service for "Client A".
  19. Validate the 'date_of_group_service' field contains the date of service for "Client A".
  20. Close the report.
Scenario 2: Progress Notes - File a group service and validate the 'SYSTEM.cw_patient_notes' SQL table
Specific Setup:
  • Access to Crystal Reports or other SQL Reporting Tool.
  • A practitioner is defined (Practitioner A).
  • The 'Populate the 'date_of_group_service' with group service dates only' registry setting is set to "Y".
  • A client enrolled in an existing episode (Client A).
  • A client enrolled in an existing episode (Client B).
  • (Group A) defined with two group members (Client A & Client B).
Steps
  1. Access the 'Progress Notes (Group and Individual)' form.
  2. Select the "Group Default Notes" section.
  3. Enter the date of the note in the 'Date of Group' field.
  4. Select "Practitioner A" in the 'Practitioner' field.
  5. Select "New Service" in the 'Progress Note For' field.
  6. Select any value in the 'Note Type' field.
  7. Enter "Group A" in the 'Group Name or Number' field.
  8. Enter the desired value in the 'Note' field.
  9. Enter the desired group code in the 'Service Charge Code' field.
  10. Select any service program in the 'Service Program' field.
  11. File the note.
  12. Select the "Individual Progress Notes" section.
  13. Enter "Group A" in the 'Group Name or Number' field.
  14. Enter the note date in the 'Note Date' field.
  15. Select the note for "Client A" in the 'Select Note To Edit' field.
  16. Customize the progress note for "Client A".
  17. Select "Final" in the 'Draft/Final' field.
  18. File the note.
  19. Repeat steps 1n-1q for "Client B".
  20. Close the form.
  21. Access Crystal Reports or other SQL Reporting Tool.
  22. Create a report using the 'SYSTEM.cw_patient_notes' SQL table.
  23. Validate a row is displayed for the note for "Client A".
  24. Validate 'PATID' field contains PATID for "Client A".
  25. Validate the 'date_of_service' field contains the date of the service for "Client A".
  26. Validate the 'date_of_group_service' field contains the date of the service for "Client A".
  27. Validate the 'GroupID' field contains "Group A".
  28. Validate a row is displayed for the note for "Client B".
  29. Validate the 'PATID' field contains the PATID for "Client B".
  30. Validate the 'date_of_service' field contains the date of the service for "Client B".
  31. Validate the 'date_of_group_service' field contains the date of the service for "Client B".
  32. Validate the 'GroupID' field contains "Group A".
  33. Leave the report open.
  34. Access the 'Registry Settings' form.
  35. Search for and select the 'Populate the 'date_of_group_service' field with group service dates only' registry setting.
  36. Enter "N" in the 'Registry Setting Value' field.
  37. Click [Submit] and close the form.
  38. Repeat steps '1-3'.
Topics
• Progress Notes • Registry Settings