Avatar CWS 2023 Monthly Release 2023.02.02 Acceptance Tests
- Last updated
-
-
Save as PDF
|
Topics
• NX
• Group Progress Notes
|
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:
Scenario 1: Admission - Validate the 'SYSTEM.client_curr_demographics' SQL table
Specific Setup:
- The 'Client Demographics - Additional Fields' registry setting must include "Multi-Select Race".
Steps
- Access the 'Admission' form.
- Enter any new values in the 'Last Name' and 'First Name' fields.
- Select the desired value in the 'Sex' field.
- Click [Search], [New Client] and [Yes].
- Enter the desired date in the 'Preadmit/Admission Date' field.
- Enter the desired time in the 'Preadmit/Admission Time' field.
- Select the desired value in the 'Program' field.
- Select the desired value in the 'Type of Admission' field.
- Select the desired staff in the 'Admitting Practitioner' field.
- Select the "Demographics" section.
- Select the desired value(s) in the 'Other Race(s)' field.
- Populate any other desired fields.
- Click [Submit].
- Access Crystal Reports or other SQL Reporting tool.
- Select the CWS namespace.
- Create a report using the 'SYSTEM.client_curr_demographics' SQL table.
- Validate a row is displayed for the client admitted in the previous steps.
- Validate the 'other_race_code' field contains the code(s) associated to the value(s) filed in the previous steps.
- Validate the 'other_race_value' field contains the value(s) filed in the previous steps.
- Close the report.
Scenario 2: Update Client Data - Validate the 'SYSTEM.client_curr_demographics' SQL table
Specific Setup:
- A client is enrolled in an existing episode (Client A).
- The 'Client Demographics - Additional Fields' registry setting must include "Multi-Select Race".
Steps
- Select "Client A" and access the 'Update Client Data' form.
- Select the desired value(s) in the 'Other Race(s)' field.
- Click [Submit].
- Access Crystal Reports or other SQL Reporting tool.
- Select the CWS namespace.
- Create a report using the 'SYSTEM.client_curr_demographics' SQL table.
- Navigate to the row for "Client A".
- Validate the 'other_race_code' field contains the code(s) associated to the value(s) filed in the previous steps.
- Validate the 'other_race_value' field contains the value(s) filed in the previous steps.
- Select "Client A" and access the 'Update Client Data' form.
- Select any new value(s) in the 'Other Race(s)' field.
- Click [Submit].
- Access Crystal Reports or other SQL Reporting tool.
- Refresh the report using the 'SYSTEM.client_curr_demographics' SQL table.
- Navigate to the row for "Client A".
- Validate the 'other_race_code' field contains the code(s) associated to the updated value(s) filed in the previous steps.
- Validate the 'other_race_value' field contains the updated value(s) filed in the previous steps.
- Close the report.
|
Topics
• Query/Reporting
|
| |
Avatar_CWS_2023_Monthly_Release_2023.02.02_Details.csv