Skip to main content

Avatar CWS 2024 Update 44

  1. Last updated
  2. Save as PDF

Product Requirements and Recommendations

Avatar CWS required
RADplus required

Recommended Update Level

Avatar CWS 2024 Monthly Release 2024.01.02
RADplus 2024 Monthly Release 2024.01.02

Product Update Description

An issue is resolved that may prevent the 'SYSTEM.results_detail' SQL table from being queried from the CDR on IRIS systems.

Required Updates

None

Included Updates

20

Details
NEW0 CHANGED0 FIXED1
Fixed (1)
Results - SQL table CWSSYSTEM.results_detail
An issue is resolved that may prevent the 'SYSTEM.results_detail' SQL table from being queried from the CDR on IRIS systems. KB0076876 v0.01
Topics
• Results
 
Acceptance Tests
AV-95965 Summary | Details
Results - SQL table CWSSYSTEM.results_detail
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • Results Entry
Scenario 1: 'Results Entry' - Add/Edit/Delete Results
Specific Setup:
  • A client is enrolled in an existing episode (Client A).
Steps
  1. Select "Client A" and access the 'Results Entry' form.
  2. Select "Add" in the 'Add/Edit/Delete Result' field.
  3. Populate all required and desired fields.
  4. Click [File Header Info].
  5. Validate the message displays: Header information filed.
  6. Click [OK].
  7. Select "Edit" in the 'Add/Edit/Delete Result' field.
  8. Click [Select Result].
  9. Select the result filed in the previous steps from the 'Select Result' dialog and click [OK].
  10. Validate all previously filed data is displayed.
  11. Update any desired fields.
  12. Click [File Header Info].
  13. Validate the message displays: Header information filed.
  14. Click [OK].
  15. Select "Delete" in the 'Add/Edit/Delete Result' field.
  16. Click [Select Result].
  17. Select the result filed in the previous steps from the 'Select Result' dialog and click [OK].
  18. Validate all previously filed data is displayed.
  19. Click [File Header Info].
  20. Validate the message is displays: This will delete the selected result and all of its associated details. Are you sure you want to continue?
  21. Click [Yes]
  22. Validate the message displays: Result deleted.
  23. Click [OK] and [Exit Option].
Scenario 2: Validating CDR SQL table CWSSYSTERM.results_detail
Specific Setup:
  • CDR must be enabled.
Steps
  1. Using the "Results Entry" form
  2. Order a result header and detail.
  3. Using the preferred method to validate SQL tables, validate the CDR table CWSSYSTEM.results_detail for the following fields:
  4. interface_vendor_name
  5. interface_vendor_type
  6. OE_order_Unique_ID
  7. filler_order_number
  8. placer_order_number
  9. universal_service_ID_code
  10. univeral_service_ID_code_type
  11. universal_service_id_val_all
  12. univeral_service_id_value
Topics
• Results
Table Changes
Table Column Change
SYSTEM.results_detail Interface_Vendor_Name Updated to support IRIS
SYSTEM.results_detail Interface_Vendor_Type Updated to support IRIS
SYSTEM.results_detail OE_order_unique_id Updated to support IRIS
SYSTEM.results_detail filler_order_number Updated to support IRIS
SYSTEM.results_detail placer_order_number Updated to support IRIS
SYSTEM.results_detail universal_svc_id_code Updated to support IRIS
SYSTEM.results_detail universal_svc_id_code_typ Updated to support IRIS
SYSTEM.results_detail universal_svc_id_val_alt Updated to support IRIS
SYSTEM.results_detail universal_svc_id_value Updated to support IRIS

 

  1. Back to top
  • Was this article helpful?

Recommended articles

  1. Page type
    Reference
  2. Tags
    1. Avatar CWS 2024 Update 44
    2. content:release
    3. llm-no-index
    4. Results
    5. role:sysadmin