Avatar CWS 2023 Update 72

Product Requirements and Recommendations

Avatar CWS required
RADplus required

Recommended Update Level

Avatar CWS 2023 Monthly Release 2023.02.01
RADplus 2023 Monthly Release 2023.02.01

Product Update Description

The table 'SYSTEM.client_curr_demographics' is updated to include the fields "other_race_code" and "other_race_value".

Required Updates

None

Included Updates

None

Details

NEW1 CHANGED0 FIXED0

New (1)

AV-89566 Details \| User Acceptance Tests The 'SYSTEM.client_curr_demographics' SQL table The 'other_race_code' and 'other_race_value' fields are added to the 'SYSTEM.client_curr_demographics' SQL table. Value Added: The ability to capture additional information in the 'SYSTEM.client_curr_demographics' SQL table	Topics • Query/Reporting

Acceptance Tests

AV-89566 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:

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

Table Changes

Table	Column	Change
SYSTEM.client_curr_demographics	other_race_code	Added
SYSTEM.client_curr_demographics	other_race_value	Added