Skip to main content

Avatar PM 2022 Update 104

  1. Last updated
  2. Save as PDF

Product Requirements / Recommendations

Avatar PM required
RADplus required

Product Update Form Description

The 'single_file_isa_code' field is added to 'billing_guar_table_270' in order to store the value of 'Create Single File Per Interchange Control Header (ISA)' in the 'Guarantors/Payors' form.

Included Updates

None

Required Updates

None

Details
NEW0 CHANGED1 FIXED0
Changed (1)
SYSTEM.billing_guar_table_270 - fields added
The 'single_file_isa_code' and 'single_file_isa_value' fields are added to the 'billing_guar_table_270' SQL table. KB0070775 v0.01
Value Added: The value of 'Create Single File Per Interchange Control Header (ISA)' from the 'Guarantors/Payors' form is stored to the 'SYSTEM.billing_guar_table_270' for auditing purposes.
Topics
• Database Tables • NX
 
Acceptance Tests
AV-81622 Summary | Details
SYSTEM.billing_guar_table_270 - fields added
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • Form and Table Documentation (PM)
  • Guarantors/Payors
  • Registry Settings (PM)
Scenario 1: SYSTEM.billing_guar_table_270 - Validating 'Create Single File Per Interchange Control Header (ISA)' in the 'Guarantors/Payors' form - Editing an existing guarantor
Specific Setup:
  • Registry Setting:
  • The 'Enable 270/271 Transaction Sets' registry setting is set to 'Y'.
  • The 'Create Single File Per Interchange Control Header (ISA)' registry setting is set to 'Y'.
  • Guarantors/Payors:
  • An existing guarantor is identified. Note the Guarantor code/ value.
Steps
  1. Open the 'Guarantors/Payors' form.
  2. Select a guarantor to edit. Note the guarantor code.
  3. Navigate to the 270/271/834 tab.
  4. Select 'Yes' for the 'Create Single File Per Interchange Control Header (ISA)' field. Note the value.
  5. File the form.
  6. Open the 'Crystal Report' or any other SQL Data Viewer tool.
  7. Query the 'billing_guar_table_270' table for the guarantor identified above.
  8. Verify the 'single_file_isa_code' and 'single_file_isa_value' fields exist.
  9. Verify the 'single_file_isa_code' contains 'Y' and the 'single_file_isa_value' field contains 'Yes' when 'Yes' is selected in the 'Create Single File Per Interchange Control Header (ISA)' field.
  10. Open the 'Guarantors/Payors' form.
  11. Select a guarantor to edit. Note the guarantor code.
  12. Navigate to the 270/271/834 tab.
  13. Select 'No' for the 'Create Single File Per Interchange Control Header (ISA)' field. Note the value.
  14. File the form.
  15. Open the 'Crystal Report' or any other SQL Data Viewer tool.
  16. Query the 'billing_guar_table_270' table for the guarantor identified above.
  17. Verify the 'single_file_isa_code' contains 'N' and the 'single_file_isa_value' field contains 'No' when 'No' is selected in the 'Create Single File Per Interchange Control Header (ISA)' field.
Scenario 2: SYSTEM.billing_guar_table_270 - Validating 'Create Single File Per Interchange Control Header (ISA)' in the 'Guarantors/Payors' form - Adding a new guarantor
Specific Setup:
  • Registry Setting:
  • The 'Enable 270/271 Transaction Sets' registry setting is set to 'Y'.
  • The 'Create Single File Per Interchange Control Header (ISA)' registry setting is set to 'Y'.
Steps
  1. Open the 'Guarantors/Payors' form.
  2. Select 'Add' in the 'Add New or Edit Existing Guarantor' field to add a guarantor.
  3. Enter a numeric value as the guarantor code in the 'New Guarantor Code' field. Note the guarantor code/value to be used for further testing.
  4. Enter desired value in the 'Guarantor Name' field.
  5. Enter desired value in the 'Guarantor Name For Alpha Lookup' field.
  6. Enter desired value in the 'Guarantor's Address - Zip Code' field.
  7. Select desired class from the 'Financial Class' field.
  8. Select desired value from the 'Guarantor Nature' field.
  9. Navigate to the 270/271/834 tab.
  10. Select 'Yes' in the 'Support 270/271 Transaction Sets' field.
  11. Select 'No' to 'Skip Liability Update Process If No Valid Response (271) Received For An Inquiry (270)' field.
  12. Set the 'Real Time 270/271 Access Point' to desired value.
  13. Select 'Yes' in the 'Create Single File Per Interchange Control Header (ISA)' field.
  14. File the form.
  15. Open the 'Crystal Report' or any other SQL Data Viewer tool.
  16. Query the 'billing_guar_table_270' table for the guarantor identified above.
  17. Verify the 'single_file_isa_code' and 'single_file_isa_value' fields exist.
  18. Verify the 'single_file_isa_code' contains 'Y' and the 'single_file_isa_value' field contains 'Yes' because 'Yes' is selected in the 'Create Single File Per Interchange Control Header (ISA)' field.
  19. Open the 'Guarantors/Payors' form.
  20. Select the same guarantor to edit. Note the guarantor code.
  21. Navigate to the 270/271/834 tab.
  22. Select 'No' in the 'Create Single File Per Interchange Control Header (ISA)' field.
  23. File the form.
  24. Open the 'Crystal Report' or any other SQL Data Viewer tool.
  25. Query the 'billing_guar_table_270' table for the guarantor identified above.
  26. Open the 'Crystal Report' or any other SQL Data Viewer tool.
  27. Query the 'billing_guar_table_270' table for the guarantor identified above.
  28. Verify the 'single_file_isa_code' contains 'N' and the 'single_file_isa_value' field contains 'No' because 'No' is selected in the 'Create Single File Per Interchange Control Header (ISA)' field.
Topics
• Database Tables • NX
Table Changes
Table Column Change
billing_guar_table_270 single_file_isa_code Added
billing_guar_table_270 single_file_isa_value Added

 

  1. Back to top
  • Was this article helpful?

Recommended articles

  1. Page type
    Reference
  2. Tags
    1. content:release
    2. Database Tables
    3. llm-no-index
    4. NX
    5. nx:nx
    6. role:sysadmin
    7. search:ready