Skip to main content

Avatar CWS 2023 Update 89

  1. Last updated
  2. Save as PDF

Product Requirements and Recommendations

Avatar CWS required
RADplus required

Recommended Update Level

Avatar CWS 2023 Monthly Release 2023.04.00
RADplus 2023 Monthly Release 2023.04.00

Product Update Description

The following enhancements are made: 1) Audit tables are created for the tables 'InfoScrb.rxstorage', 'InfoScrb.noniscrxstorage', 'InfoScrb.rxofficemedadminstorage', 'InfoScrb.rxnotesstorage', 'InfoScrb.noniscrxnotesstorage', and 'InfoScrb.rxdosagestorage'. 2) The tables 'SYSTEM.cw_problem_list', 'SYSTEM.cw_implantable_device', and 'SYSTEM.cw_hist_client_allergies' are added to the form 'Data Trail Configuration' for selection.

Required Updates

None

Included Updates

3, 5, 8, 9, 11, 14, 15, 15.1, 21, 23, 28, 33, 35, 36, 37, 39, 43, 44, 45, 48, 50, 51, 52, 53, 54, 54.1, 56, 59, 61, 62, 64, 65, 70, 73, 76, 78, 80, 81, 82, 84, 87

Details
NEW6 CHANGED0 FIXED0
New (6)
Data Trail - AUDIT.cw_problem_list
AUDIT.cw_problem_list is added to Data Trail.
Value Added: Adding table to data trail.
Topics
• NX • Problem List • Treatment Plan
 
Data Trail - AUDIT.noniscrxstorage
AUDIT.noniscrxstorage is added to Data Trail
Value Added: Tables added to Data Trail
Topics
• NX • Order Entry Console • Widgets
 
Data Trail - AUDIT.cw_hist_client_allergies
AUDIT.cw_hist_client_allergies is added to Data Trail.
Value Added: Adding tables to Data Trail
Topics
• Allergies and Hypersensitivities • NX
 
Data Trail - AUDIT_cw_implantable_device
AUDIT.cw_implantable_device is added to Data Trail
Value Added: Table added to Data Trail
Topics
• Implantable Device List • NX
 
Data Trail - AUDIT.rxdosagestorage and AUDIT.rxstorage
AUDIT.rxdosagestorage and AUDIT.rxstorage tables added to Data Trail
Value Added: Add tables to Data Trail
Topics
• NX
 
Data Trail Configuration - Added tables
The following tables have been added to Data Trail:
AUDIT.cw_problem_list
AUDIT.cw_hist_client_allergies
AUDIT.cw_implantable_device_list
Value Added: Tables added to Data Trail
Topics
• Allergies and Hypersensitivities • Implantable Device List • NX • Problem List • Treatment Plan
 
Acceptance Tests
AV-93498 Summary | Details
Data Trail - AUDIT.cw_problem_list
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • Data Trail Configuration
  • Problem List
  • Treatment Plan
  • Treatment Plan Number 1
Scenario 1: Data Trail - Problem List
Specific Setup:
  • Using the "Data Trail Configuration" form, select the SYSTEM_cw_problem_list under "Problem List"
Steps
  1. Open the "Problem List" form.
  2. Add a new problem.
  3. Click "Submit" to file data.
  4. Using the preferred method to view SQL tables, validate a row was added to the "AUDIT.cw_problem_list table and that it has an "audit_action_code" of "A" for Add.
  5. Open the "Problem List" form.
  6. Edit an existing problem.
  7. Click "Submit" to file data.
  8. Using the preferred method to view SQL tables, validate a row was added to the "AUDIT.cw_problem_list table and that it has an "audit_action_code" of "E" for Edit.
  9. Open the "Problem List" form.
  10. Mark a problem as Inactive.
  11. Click "Submit" to file data.
  12. Using the preferred method to view SQL tables, validate a row was added to the "AUDIT.cw_problem_list table and that it has an "audit_action_code" of "I" for Inactive.
Scenario 2: DataTrail -Treatment Plan Problems
Specific Setup:
  • Open the "Data Trail Configuration" form.
  • Select "SYSTEM.cw_problem_list" under Treatment Plan.
Steps
  1. Open the "Treatment Plan" form.
  2. Add a problem to the "Problem List".
  3. Complete and t finalize treatment plan.
  4. Using the preferred method to validate SQL tables, validate that a row was added to the AUDIT.cw_problem_list with a value of "A" in the audit_action_code.
  5. Open the "Treatment Plan" form.
  6. Modify an existing problem in the "Problem List".
  7. Complete and t finalize treatment plan.
  8. Using the preferred method to validate SQL tables, validate that a row was added to the AUDIT.cw_problem_list with a value of "E" in the audit_action_code.
Scenario 3: Data Trail - Treatment Plan Copies - Problems
Specific Setup:
  • Open the "Data Trail Configuration" form.
  • Select "SYSTEM.cw_problem_list" under Treatment Plan.
  • Using the "Create New Treatment Plan"
  • Create a copy of the treatment plan form.
  • Using "User Definition"
  • Add the new treatment plan form to the user's "Forms and Tables to Access".
Steps
  1. Open the Treatment Plan copy form.
  2. Add a problem to the "Problem List".
  3. Complete and finalize treatment plan.
  4. Using the preferred method to validate SQL tables, validate that a row was added to the AUDIT.cw_problem_list with a value of "A" in the audit_action_code.
  5. Open the Treatment Plan copy form.
  6. Modify an existing problem in the "Problem List".
  7. Complete and finalize treatment plan.
  8. Using the preferred method to validate SQL tables, validate that a row was added to the AUDIT.cw_problem_list with a value of "E" in the audit_action_code.
Topics
• NX • Problem List • Treatment Plan
AV-93499 Summary | Details
Data Trail - AUDIT.noniscrxstorage
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • Crystal Report Viewer
  • Home Medications
  • Order Entry Console
  • CareFabric Monitor
Scenario 1: Validate Data Trail tables AUDIT.rxstorage, AUDIT_rxdosagestorage
Specific Setup:
  • Add the "Order Console Widget" to the user's home view.
Steps
  1. Navigate to the "Order Console Widget".
  2. Add a medication to the Home Medications tab.
  3. Using the preferred method to validate SQL tables, validate a row is added to the AUDIT.rxdosagestorage with an "A" in the audit_action_code.
  4. Return to the "Orders Console Widget".
  5. Modify the medication entered on the Home Medications tab.
  6. Using the preferred method to validate SQL tables, validate a row is added to the AUDIT.rxdosagestorage with an "E" in the audit_action_code.
  7. Return to the "Orders Console Widget".
  8. Discontinue the medication entered on the Home Medications tab.
  9. Using the preferred method to validate SQL tables, validate a row is added to the AUDIT.rxdosagestorage with an "E" in the audit_action_code.
  10. Using the preferred method to validate SQL tables, validate a row is added to the AUDIT.rxdosagestorage with an "R" in the audit_action_code.
Scenario 2: Validate DataTrail audit tables AUDIT.noniscrxstorage
Specific Setup:
  • Add the "Order Console Widget" to the user's home view.
Steps
  1. Navigate to the "Order Console Widget".
  2. Add a reported medication to the Home Medications tab.
  3. Using the preferred method to validate SQL tables, validate a row is added to the AUDIT.rxdosagestorage with an "A" in the audit_action_code.
  4. Return to the "Orders Console Widget".
  5. Modify the reported medication entered on the Home Medications tab.
  6. Using the preferred method to validate SQL tables, validate a row is added to the AUDIT.rxdosagestorage with an "E" in the audit_action_code.
Topics
• NX • Order Entry Console • Widgets
AV-93500 Summary | Details
Data Trail - AUDIT.cw_hist_client_allergies
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • Allergies and Hypersensitivities
  • Data Trail Configuration
Scenario 1: Data Trail - Allergies and Hypersensitivities
Specific Setup:
  • Open the "Data Trail Configuration" form.
  • Select the SYSTEM.cw_hist_client_allergies table.
Steps
  1. Open the "Allergies and Hypersensitivities" form.
  2. Add an allergy to the client.
  3. Save the data and file the form.
  4. Using the preferred method of validating SQL table, validate a row has been added to the AUDIT.cw_hist_client_allergies table and the row has an "A" in the audit_action_code.
  5. Open the "Allergies and Hypersensitivities" form.
  6. Edit an allergy for the client.
  7. Save the data and file the form.
  8. Using the preferred method of validating SQL table, validate a row has been added to the AUDIT.cw_hist_client_allergies table and the row has an "E" in the audit_action_code.
Topics
• Allergies and Hypersensitivities • NX
AV-93502 Summary | Details
Data Trail - AUDIT_cw_implantable_device
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • Data Trail Configuration
  • Implantable Device List
Scenario 1: Data Trail- Implantable Devices
Specific Setup:
  • Open the "Data Trail Configuration" form.
  • Select the System.cw_implantable_device table.
Steps
  1. Open the "Implantable Device List" form.
  2. Assign an implantable device to a client.
  3. Using the preferred method to view SQL tables, validate a row is added to the AUDIT.cw_implantable_device table with an "A" in the audit_action_code.
  4. Open the "Implantable Device List" form.
  5. Change the "Status" to "Completed".
  6. Using the preferred method to view SQL tables, validate a row is added to the AUDIT.cw_implantable_device table with an "E" in the audit_action_code.
  7. Open the "Implantable Device List" form.
  8. Change the "Status" to "Aborted".
  9. Using the preferred method to view SQL tables, validate a row is added to the AUDIT.cw_implantable_device table with an "D" in the audit_action_code.
Topics
• Implantable Device List • NX
AV-93503 Summary | Details
Data Trail - AUDIT.rxdosagestorage and AUDIT.rxstorage
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • Crystal Report Viewer
  • Home Medications
  • Order Entry Console
Scenario 1: Validate Data Trail tables AUDIT.rxstorage, AUDIT_rxdosagestorage
Specific Setup:
  • Add the "Order Console Widget" to the user's home view.
Steps
  1. Navigate to the "Order Console Widget".
  2. Add a medication to the Home Medications tab.
  3. Using the preferred method to validate SQL tables, validate a row is added to the AUDIT.rxdosagestorage with an "A" in the audit_action_code.
  4. Return to the "Orders Console Widget".
  5. Modify the medication entered on the Home Medications tab.
  6. Using the preferred method to validate SQL tables, validate a row is added to the AUDIT.rxdosagestorage with an "E" in the audit_action_code.
  7. Return to the "Orders Console Widget".
  8. Discontinue the medication entered on the Home Medications tab.
  9. Using the preferred method to validate SQL tables, validate a row is added to the AUDIT.rxdosagestorage with an "E" in the audit_action_code.
  10. Using the preferred method to validate SQL tables, validate a row is added to the AUDIT.rxdosagestorage with an "R" in the audit_action_code.
Topics
• NX
AV-93504 Summary | Details
Data Trail Configuration - Added tables
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • Data Trail Configuration
  • Problem List
  • Treatment Plan
  • Allergies and Hypersensitivities
  • Implantable Device List
  • Treatment Plan Number 1
Scenario 1: Data Trail - Problem List
Specific Setup:
  • Using the "Data Trail Configuration" form, select the SYSTEM_cw_problem_list under "Problem List"
Steps
  1. Open the "Problem List" form.
  2. Add a new problem.
  3. Click "Submit" to file data.
  4. Using the preferred method to view SQL tables, validate a row was added to the "AUDIT.cw_problem_list table and that it has an "audit_action_code" of "A" for Add.
  5. Open the "Problem List" form.
  6. Edit an existing problem.
  7. Click "Submit" to file data.
  8. Using the preferred method to view SQL tables, validate a row was added to the "AUDIT.cw_problem_list table and that it has an "audit_action_code" of "E" for Edit.
  9. Open the "Problem List" form.
  10. Mark a problem as Inactive.
  11. Click "Submit" to file data.
  12. Using the preferred method to view SQL tables, validate a row was added to the "AUDIT.cw_problem_list table and that it has an "audit_action_code" of "I" for Inactive.
Scenario 2: DataTrail -Treatment Plan Problems
Specific Setup:
  • Open the "Data Trail Configuration" form.
  • Select "SYSTEM.cw_problem_list" under Treatment Plan.
Steps
  1. Open the "Treatment Plan" form.
  2. Add a problem to the "Problem List".
  3. Complete and t finalize treatment plan.
  4. Using the preferred method to validate SQL tables, validate that a row was added to the AUDIT.cw_problem_list with a value of "A" in the audit_action_code.
  5. Open the "Treatment Plan" form.
  6. Modify an existing problem in the "Problem List".
  7. Complete and t finalize treatment plan.
  8. Using the preferred method to validate SQL tables, validate that a row was added to the AUDIT.cw_problem_list with a value of "E" in the audit_action_code.
Scenario 3: Data Trail - Allergies and Hypersensitivities
Specific Setup:
  • Open the "Data Trail Configuration" form.
  • Select the SYSTEM.cw_hist_client_allergies table.
Steps
  1. Open the "Allergies and Hypersensitivities" form.
  2. Add an allergy to the client.
  3. Save the data and file the form.
  4. Using the preferred method of validating SQL table, validate a row has been added to the AUDIT.cw_hist_client_allergies table and the row has an "A" in the audit_action_code.
  5. Open the "Allergies and Hypersensitivities" form.
  6. Edit an allergy for the client.
  7. Save the data and file the form.
  8. Using the preferred method of validating SQL table, validate a row has been added to the AUDIT.cw_hist_client_allergies table and the row has an "E" in the audit_action_code.
Scenario 4: Data Trail- Implantable Devices
Specific Setup:
  • Open the "Data Trail Configuration" form.
  • Select the System.cw_implantable_device table.
Steps
  1. Open the "Implantable Device List" form.
  2. Assign an implantable device to a client.
  3. Using the preferred method to view SQL tables, validate a row is added to the AUDIT.cw_implantable_device table with an "A" in the audit_action_code.
  4. Open the "Implantable Device List" form.
  5. Change the "Status" to "Completed".
  6. Using the preferred method to view SQL tables, validate a row is added to the AUDIT.cw_implantable_device table with an "E" in the audit_action_code.
  7. Open the "Implantable Device List" form.
  8. Change the "Status" to "Aborted".
  9. Using the preferred method to view SQL tables, validate a row is added to the AUDIT.cw_implantable_device table with an "D" in the audit_action_code.
Scenario 5: Data Trail - Treatment Plan Copies - Problems
Specific Setup:
  • Open the "Data Trail Configuration" form.
  • Select "SYSTEM.cw_problem_list" under Treatment Plan.
  • Using the "Create New Treatment Plan"
  • Create a copy of the treatment plan form.
  • Using "User Definition"
  • Add the new treatment plan form to the user's "Forms and Tables to Access".
Steps
  1. Open the Treatment Plan copy form.
  2. Add a problem to the "Problem List".
  3. Complete and finalize treatment plan.
  4. Using the preferred method to validate SQL tables, validate that a row was added to the AUDIT.cw_problem_list with a value of "A" in the audit_action_code.
  5. Open the Treatment Plan copy form.
  6. Modify an existing problem in the "Problem List".
  7. Complete and finalize treatment plan.
  8. Using the preferred method to validate SQL tables, validate that a row was added to the AUDIT.cw_problem_list with a value of "E" in the audit_action_code.
Topics
• Allergies and Hypersensitivities • Implantable Device List • NX • Problem List • Treatment Plan