Skip to main content

Avatar PM 2024 Update 19

  1. Last updated
  2. Save as PDF

Product Requirements and Recommendations

Avatar PM required
RADplus required

Recommended Update Level

Avatar PM 2024 Monthly Release 2024.01.01
RADplus 2024 Monthly Release 2024.01.01

Product Update Description

An issue is resolved where the 'table_payor_auths' table may error on a record with an unspecified Expiration Date.

Required Updates

None

Included Updates

None

Details
NEW0 CHANGED0 FIXED1
Fixed (1)
Payor based Authorization
Resolves an issue to ensure that the 'SYSTEM.table_payor_auths' table displays correct value when 'Payor Based Authorizations' is submitted with a specified 'Effective Date' field and unspecified (blank) 'Expiration Date' field.
Topics
• Database Tables • Payor Based Authorizations
 
Acceptance Tests
AV-93759 Summary | Details
Payor based Authorization
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • Payor Based Authorizations
Scenario 1: Payor Based Authorizations - Add/Edit/Delete payor based authorization
Specific Setup:
  • Registry Settings:
  • Payor Based Authorizations >> Enable Payor Based Authorizations = Y.
  • Payor Based Authorizations >> Enable CPT Based Payor Authorizations Registry Setting Value = N.
  • Authorization Group >> Require Authorizations at Guarantors/Payors Level Registry Setting Value = Y.
  • Authorization Group Definition:
  • New Authorization group(s) created. Note the authorization group number/names.
Steps
  1. Open 'Payor Based Authorizations’ form.
  2. Select 'Add' in the 'Add/Edit/Delete' field.
  3. Select desired guarantor from the 'Guarantor' field.
  4. Select desired program(s) from the 'Program' field.
  5. Enter desired date in the 'Effective Date' field. Note the date.
  6. Leave the 'Expiration Date' field empty.
  7. Select desired group number from the 'Authorization Group' field.
  8. Validate 'Service Codes' selected based on the selected 'Authorization Group'.
  9. Enter desired authorization number in the 'Authorization Number' field.
  10. Click [Submit].
  11. Open the 'Crystal Report' or any other SQL data viewer.
  12. Locate the PM namespace of the system.
  13. Query - select * from SYSTEM.table_payor_auths where GUARANTOR_ID=[desired guarantor id].
  14. Verify the 'effective_date' displays the correct date that is entered during creating a payor based authorization record.
  15. Verify the 'expiration_date' displays "NONE" because the field was blank during creating a payor based authorization record.
  16. Verify the 'authorization_number' field displays the correct authorization number.
  17. Open the 'Payor Based Authorizations’ form.
  18. Select 'Edit' from the 'Add/Edit/Delete' field.
  19. Click [Select Authorization To Edit/Delete].
  20. Select desired authorization record from the 'Edit Entry' list box.
  21. Click [OK].
  22. Update the 'Effective Date' field to different date. Note the date.
  23. Enter desired date in the 'Expiration Date' field. Note the date.
  24. Click [Submit].
  25. Open the 'Crystal Report' or any other SQL data viewer.
  26. Locate the PM namespace of the system.
  27. Query - select * from SYSTEM.table_payor_auths where GUARANTOR_ID=[desired guarantor id].
  28. Verify the 'effective_date' displays correct date that is changed during updating a payor based authorization record.
  29. Verify the 'expiration_date' displays correct date that is changed during updating a payor based authorization record.
  30. Verify the 'authorization_number' field displays the correct authorization number.
  31. Open the 'Payor Based Authorizations’ form.
  32. Select 'Edit' from the 'Add/Edit/Delete' field.
  33. Click [Select Authorization To Edit/Delete].
  34. Select desired authorization record from the 'Edit Entry' list box.
  35. Click [OK].
  36. Update the 'Effective Date' field to different date. Note the date.
  37. Enter same date in the 'Expiration Date' field. Note the date.
  38. Click [Submit].
  39. Open the 'Crystal Report' or any other SQL data viewer.
  40. Locate to the PM namespace of the system.
  41. Query - 'select * from SYSTEM.table_payor_auths where GUARANTOR_ID=[desired guarantor id]'.
  42. Verify the 'effective_date' displays correct date that is changed during updating a payor based authorization record.
  43. Verify the 'expiration_date' displays correct date that is changed during updating a payor based authorization record.
  44. Verify the 'authorization_number' field displays the correct authorization number.
  45. Open the 'Payor Based Authorizations’ form.
  46. Select 'Delete' from the 'Add/Edit/Delete' field.
  47. Click [Select Authorization To Edit/Delete].
  48. Select desired authorization record from the 'Edit Entry' list box.
  49. Click [OK].
  50. Click [Submit].
  51. Open the 'Crystal Report' or any other SQL data viewer.
  52. Locate to the PM namespace of the system.
  53. Query - 'select * from SYSTEM.table_payor_auths where GUARANTOR_ID=[desired guarantor id]'.
  54. Verify the 'effective_date' displays correct date that is changed during updating a payor based authorization record.
  55. Verify the 'expiration_date' displays correct date that is changed during updating a payor based authorization record.
  56. Verify the 'authorization_number' field displays the correct authorization number.
  57. Close the report.
Topics
• Database Tables • Payor Based Authorizations
Table Changes
Table Column Change
SYSTEM.tablepayorauths expiration_date type changed from %Date to %String, as "NONE" is a valid input for this field