Skip to main content

Avatar CWS 2022 Update 123

  1. Last updated
  2. Save as PDF

Product Requirements / Recommendations

Avatar CWS required
RADplus required

Recommended Update Level

Avatar CareFabric 2022 Update 95

Product Update Form Description

"distinct_identifier" field is added to the "SYSTEM.cw_implantable_device" SQL table.

Included Updates

3, 4, 6, 10, 13, 13.1, 14, 17, 18, 20, 24, 26, 27, 28, 30, 31, 32, 35, 37, 38, 39, 40, 41, 45, 46, 49, 50, 55, 57, 58, 59, 61, 64, 66, 68, 69, 70, 71, 73, 76, 80, 82, 83, 84, 86, 87, 90, 94, 98, 100, 103, 105, 107, 108, 109, 110, 113, 117, 118, 120

Required Updates

None

Details
NEW1 CHANGED0 FIXED0
New (1)
Implantable Device List - 'SYSTEM.cw_implantable_device' SQL table
The 'distinct_identifier' field is added to the 'SYSTEM.cw_implantable_device_list' SQL table.
Value Added: The ability to capture additional information in the 'SYSTEM.cw_implantable_device_list' SQL table
Topics
• Implantable Device List • Query/Reporting
 
Acceptance Tests
AV-84111 Summary | Details
Implantable Device List - 'SYSTEM.cw_implantable_device' SQL table
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • Implantable Device List
Scenario 1: Implantable Device List - Form Validation
Specific Setup:
  • A client is enrolled in an existing episode (Client A).
Steps
  1. Access the 'Implantable Device List' form.
  2. Select "Client A" in the 'Client Search' field.
  3. Select a device in the 'Unique Device Identifier Search' field.
  4. Verify the following fields in the "Device Information" section display data:
  5. Brand Name
  6. Version or Model
  7. Device Type
  8. Company Name
  9. Device Description
  10. What MRI safety information does the labeling contain
  11. Device required to be labeled as containing natural rubber latex or dry natural rubber?
  12. Verify the following fields in the "Production Identifiers" section display data. Note that not all fields will be populated, depending on the selected device:
  13. Batch/Lot Number
  14. Serial Number
  15. Expiration Date
  16. Manufacturing Date
  17. Donation Identification Number
  18. Click [File Implantable Device To Client].
  19. Click [OK] on the "Information: Filed Successfully" dialog.
  20. Click [Submit].
  21. Access the 'Implantable Device List' form.
  22. Select "Client A" in the 'Client Search' field.
  23. Validate all fields display the data as filed previously.
  24. Click [Submit].
Scenario 2: Implantable Device List - SQL Table Validation
Steps
  1. Access the 'Implantable Device List' form.
  2. Select "Client A" in the 'Client Search' field.
  3. Select a device in the 'Unique Device Identifier Search' field.
  4. Verify the following fields in the "Device Information" section display data:
  5. Brand Name
  6. Version or Model
  7. Device Type
  8. Company Name
  9. Device Description
  10. What MRI safety information does the labeling contain
  11. Device required to be labeled as containing natural rubber latex or dry natural rubber?
  12. Verify the following fields in the "Production Identifiers" section display data. Note that not all fields will be populated, depending on the selected device:
  13. Batch/Lot Number
  14. Serial Number
  15. Expiration Date
  16. Manufacturing Date
  17. Donation Identification Number
  18. Click [File Implantable Device To Client].
  19. Click [OK] on the "Information: Filed Successfully" dialog.
  20. Click [Submit].
  21. Access Crystal Reports or other SQL reporting tool.
  22. Select the CWS namespace.
  23. Create a report using the 'SYSTEM.cw_implantable_device' SQL table.
  24. Include, at a minimum, the following fields:
  25. PATID
  26. distinct_identifier
  27. device_type_code
  28. device_type_value
  29. data_entry_date
  30. device_identifier
  31. Validate a row is displayed for the device filed for "Client A" with the all of the device data.
  32. Close the report.
Topics
• Implantable Device List • Query/Reporting
Table Changes
Table Column Change
SYTEM.cw_implantable_device distinct_identifier New