Skip to main content

Avatar CWS 2022 Update 64

Product Requirements / Recommendations

Avatar CWS required
RADplus required

Recommended Update Level

Avatar CareFabric 2022 Update 61

Product Update Form Description

The fields 'edit_comments' and 'edit_increment_ID' are added to the table 'SYSTEM.cw_vital_signs'.

Included Updates

18, 38, 41, 58

Required Updates

None

Details

NEW1 CHANGED0 FIXED0
New (1)
Vital Signs - The 'SYSTEM.cw_vital_signs' SQL table
The 'edit_comments' and 'edit_increment_ID' fields are added to the 'SYSTEM.cw_vital_signs' SQL table
Value Added: Additional support for vitals
Topics
• Vital Signs • Vitals
 
Acceptance Tests

AV-80486 Summary | Details
Vital Signs - The 'SYSTEM.cw_vital_signs' SQL table
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • SQL Query/Reporting
Scenario 1: Vitals Entry - Validate the 'SYSTEM.cw_vital_signs' SQL table
Specific Setup:
  • Have a client enrolled in an existing episode (Client A).
  • The user logged into the application must have access to all forms and tables.
Steps
  1. Select "Client A" and access the 'Vitals Entry' form.
  2. Select "Add" in the 'Update Vital Sign' field.
  3. Enter the desired date in the 'Date' field.
  4. Enter the desired time in the 'Time' field.
  5. Select "No" in the 'Refused Vitals' field.
  6. Enter the desired value in the 'Systolic' and 'Diastolic' fields.
  7. Click [Submit] and [No].
  8. Access Crystal Reports or other SQL Reporting Tool.
  9. Create a report using the 'SYSTEM.cw_vital_signs' SQL table.
  10. Validate rows are displayed for the vitals entered in the previous steps.
  11. Validate the 'ID' field contains a unique identifier.
  12. Validate the 'edit_increment_ID' field contains the value as '1' for all the vitals entered in the previous steps.
  13. Validate the 'data_entry_date' field contains the date entered in the previous steps.
  14. Validate the 'data_entry_time' field contains the time entered in the previous steps.
  15. Validate the 'RV reading_value' field contains "No".
  16. Validate the 'BPS reading_value' field contains the value entered in the previous steps.
  17. Validate the 'BPD reading_value' field contains the value entered in the previous steps.
  18. Validate the 'BP vital sign' field contains "Blood Pressure (Label)".
  19. Close the report.
  20. Return to the 'Vitals Entry' form.
  21. Select “Edit” in the ‘Add/Edit/Delete Vital Sign’ field and click [Select Vital Sign].
  22. Select the 1st Vital Entry row and click [OK].
  23. Set the ‘Systolic’ field to"135".
  24. Set the ‘Diastolic’ field to "90".
  25. Set the 'Heart Rate' field to"78".
  26. Set the 'Respiration Rate' field to "108".
  27. Click [Submit] and [No].
  28. Access Crystal Reports or other SQL Reporting Tool.
  29. Create a report using the 'AUDIT.cw_vital_signs' SQL table.
  30. Validate the 'edit_increment_ID' field contains the value as '2' for the vitals edited in the previous steps.
  31. Validate the 'BPS reading_value' field contains the value entered in the previous steps. (ex. 135).
  32. Validate the 'BPD reading_value' field contains the value entered in the previous steps. (ex. 90).
  33. Validate the 'HR reading_value' field contains the value entered in the previous steps. (ex. 78).
  34. Validate the 'RR reading_value' field contains the value entered in the previous steps. (ex. 108).
  35. Close the report.
  36. Return to the 'Vitals Entry' form.
  37. Select “Void” in the ‘Add/Edit/Delete Vital Sign’ field and click [Select Vital Sign].
  38. Select the 1st Vital Entry row and click [OK].
  39. Select any value in the ‘Void Reason’ field.
  40. Click [Submit] and [Yes].
  41. Select “Edit” in the ‘Add/Edit/Delete Vital Sign’ field and click [Select Vital Sign].
  42. Validate “*** VOIDED ***” displays for the 1st Vitals Entry row.
  43. Access Crystal Reports or other SQL Reporting Tool.
  44. Create a report using the 'SYSTEM.cw_vital_signs' SQL table.
  45. Validate rows are displayed for the vitals entered in the previous steps
  46. Validate the 'ID' field contains a unique identifier.
  47. Validate the 'edit_increment_ID' field contains the value as '3' for all the vitals entered in the previous steps.
  48. Create a report using the 'AUDIT.cw_vital_signs' SQL table.
  49. Validate rows are displayed for the vitals added in Step 1.
  50. Validate the 'audit_action_value' field contains "Add" for the vitals added in Step 1.
  51. Validate the 'edit_increment_ID' field contains the value as '1' for the vitals added in Step 1
  52. Validate rows are displayed for the vitals that are edited in Step 3.
  53. Validate the 'audit_action_value' field contains "Edit" for the vitals edited in Step 3.
  54. Validate the 'edit_increment_ID' field contains the value as '2' for the vitals edited in Step 3
  55. Validate rows are displayed for the vitals that are voided in Step 5.
  56. Validate the 'voided_value' field contains "Yes" for the vitals voided in Step 5.
  57. Validate the 'edit_increment_ID' field contains the value as '3' for the vitals voided in Step 5
  58. Close the report.
Scenario 2: 'PutVitalSignSet' SDK action - Validate the 'SYSTEM.cw_vital_signs' SQL table
Steps

Internal Testing only

Topics
• Vital Signs • Vitals

 

  • Was this article helpful?