Skip to main content

Avatar CWS 2022 Update 104

  1. Last updated
  2. Save as PDF

Product Requirements / Recommendations

Avatar CWS required
RADplus required

Product Update Form Description

Additional demographic fields are added to the 'SYSTEM.client_curr_demographics' table.

Included Updates

None

Required Updates

None

Details
NEW1 CHANGED0 FIXED0
New (1)
The 'SYSTEM.client_curr_demographics' SQL table
The following demographics fields are added to the 'SYSTEM.client_curr_demographics' SQL table:
-'patient_name_middle'
-'gender_identity_code'
-'gender_identity_value'
-'client_alias' fields 1-10
Value Added: The ability to capture additional information in the 'SYSTEM.client_curr_demographics' SQL table
Topics
• Query/Reporting
 
Acceptance Tests
AV-81697 Summary | Details
The 'SYSTEM.client_curr_demographics' SQL table
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • Admission
  • Update Client Data
Scenario 1: Admit a new client and validate the 'SYSTEM.client_curr_demographics' SQL table
Steps
  1. Access the 'Admission' form.
  2. Enter any new values in the 'Last Name' and 'First Name' fields.
  3. Select the desired value in the 'Sex' field.
  4. Click [Search], [New Client] and [Yes].
  5. Enter the desired date in the 'Preadmit/Admission Date' field.
  6. Enter the desired time in the 'Preadmit/Admission Time' field.
  7. Select the desired value in the 'Program' field.
  8. Select the desired value in the 'Type of Admission' field.
  9. Select the desired staff in the 'Admitting Practitioner' field.
  10. Select the "Demographics" section.
  11. Enter the desired value in the 'Client Middle Name' field.
  12. Enter the desired value in the 'Alias' field.
  13. Enter the desired value in the 'Alias 2' field.
  14. Enter the desired value in the 'Alias 3' field.
  15. Enter the desired value in the 'Alias 4' field.
  16. Enter the desired value in the 'Alias 5' field.
  17. Enter the desired value in the 'Alias 6' field.
  18. Enter the desired value in the 'Alias 7' field.
  19. Enter the desired value in the 'Alias 8' field.
  20. Enter the desired value in the 'Alias 9' field.
  21. Enter the desired value in the 'Alias 10' field.
  22. Select the desired value in the 'Gender Identity' field.
  23. Populate any other desired fields.
  24. Click [Submit].
  25. Access Crystal Reports or other SQL Reporting tool.
  26. Select the CWS namespace.
  27. Create a report using the 'SYSTEM.client_curr_demographics' SQL table.
  28. Validate a row is displayed for the client admitted in the previous steps.
  29. Validate the 'client_alias' fields 1-10, 'patient_middle_name', 'gender_identity_code', and 'gender_identity_value' fields are displayed.
  30. Validate the 'client_alias' fields 1-10 contains the value filed in the previous steps.
  31. Validate the 'gender_identity_code' field contains the code associated to the value filed in the previous steps.
  32. Validate the 'gender_identity_value' field contains the value filed in the previous steps.
  33. Validate the 'patient_middle_name' field contains the value filed in the previous steps.
  34. Close the report.
Scenario 2: 'Update Client Data' Form - Validate the 'SYSTEM.client_curr_demographics' SQL table
Specific Setup:
  • A client must be enrolled in an existing episode (Client A).
Steps
  1. Select "Client A" and access the 'Update Client Data' form.
  2. Enter the desired value in the 'Client Middle Name' field.
  3. Enter the desired value in the 'Alias' field.
  4. Enter the desired value in the 'Alias 2' field.
  5. Enter the desired value in the 'Alias 3' field.
  6. Enter the desired value in the 'Alias 4' field.
  7. Enter the desired value in the 'Alias 5' field.
  8. Enter the desired value in the 'Alias 6' field.
  9. Enter the desired value in the 'Alias 7' field.
  10. Enter the desired value in the 'Alias 8' field.
  11. Enter the desired value in the 'Alias 9' field.
  12. Enter the desired value in the 'Alias 10' field.
  13. Select the desired value in the 'Gender Identity' field.
  14. Populate any other desired fields.
  15. Click [Submit].
  16. Access Crystal Reports or other SQL Reporting tool.
  17. Select the CWS namespace.
  18. Create a report using the 'SYSTEM.client_curr_demographics' SQL table.
  19. Navigate to the row for "Client A".
  20. Validate the 'client_alias' fields 1-10, 'patient_middle_name', 'gender_identity_code', and 'gender_identity_value' fields are displayed.
  21. Validate the 'client_alias' fields 1-10 contains the value filed in the previous steps.
  22. Validate the 'gender_identity_code' field contains the code associated to the value filed in the previous steps.
  23. Validate the 'gender_identity_value' field contains the value filed in the previous steps.
  24. Validate the 'patient_middle_name' field contains the value filed in the previous steps.
  25. Select "Client A" and access the 'Update Client Data' form.
  26. Enter any new value in the 'Client Middle Name' field.
  27. Enter any new value in the 'Alias' field.
  28. Enter any new value in the 'Alias 2' field.
  29. Enter any new value in the 'Alias 3' field.
  30. Enter any new value in the 'Alias 4' field.
  31. Enter any new value in the 'Alias 5' field.
  32. Enter any new value in the 'Alias 6' field.
  33. Enter any new value in the 'Alias 7' field.
  34. Enter any new value in the 'Alias 8' field.
  35. Enter any new value in the 'Alias 9' field.
  36. Enter any new value in the 'Alias 10' field.
  37. Select any new value in the 'Gender Identity' field.
  38. Click [Submit].
  39. Access Crystal Reports or other SQL Reporting tool.
  40. Refresh the report using the 'SYSTEM.client_curr_demographics' SQL table.
  41. Navigate to the row for "Client A".
  42. Validate the 'client_alias' fields 1-10, 'patient_middle_name', 'gender_identity_code', and 'gender_identity_value' fields are displayed.
  43. Validate the 'client_alias' fields 1-10 contains the updated value filed in the previous steps.
  44. Validate the 'gender_identity_code' field contains the code associated to the updated value filed in the previous steps.
  45. Validate the 'gender_identity_value' field contains the updated value filed in the previous steps.
  46. Validate the 'patient_middle_name' field contains the updated value filed in the previous steps.
  47. Close the report.
Topics
• Query/Reporting
Table Changes
Table Column Change
SYSTEM.client_curr_demographics patient_name_middle Add
SYSTEM.client_curr_demographics client_alias Add
SYSTEM.client_curr_demographics client_alias_2 Add
SYSTEM.client_curr_demographics client_alias_3 Add
SYSTEM.client_curr_demographics client_alias_4 Add
SYSTEM.client_curr_demographics client_alias_5 Add
SYSTEM.client_curr_demographics client_alias_6 Add
SYSTEM.client_curr_demographics client_alias_7 Add
SYSTEM.client_curr_demographics client_alias_8 Add
SYSTEM.client_curr_demographics client_alias_9 Add
SYSTEM.client_curr_demographics client_alias_10 Add
SYSTEM.client_curr_demographics gender_identity_code Add
SYSTEM.client_curr_demographics gender_identity_value Add

 

  1. Back to top
  • Was this article helpful?

Recommended articles

  1. Page type
    Reference
  2. Tags
    1. content:release
    2. llm-no-index
    3. Query/Reporting
    4. role:sysadmin
    5. search:ready