Skip to main content

Avatar PM 2024 Update 54

  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.00
RADplus 2024 Monthly Release 2024.01.00

Product Update Description

The 'SYSTEM.billing_837_p_report', 'SYSTEM.billing_837_i_report' and 'SYSTEM.billing_837_d_report' are changed from SQL views to tables.

Required Updates

None

Included Updates

24

Details
NEW1 CHANGED0 FIXED0
New (1)
Various SQL views changed to SQL tables
'SYSTEM.billing_837_p_report', 'SYSTEM.billing_837_i_report' and 'SYSTEM.billing_837_d_report' are changed from SQL views to tables.
Value Added: Processing Improvements
Topics
• 837 Dental • 837 Institutional • 837 Professional
 
Acceptance Tests
AV-97358 Summary | Details
Various SQL views changed to SQL tables
Scenario 1: Validating SYSTEM.billing_837_d_report switched from a SQL view to an SQL table
Specific Setup:
  • An 837 Dental report file has been created by the "Electronic Billing" process for 837 Dental files.
Steps
  1. Using the preferred method of viewing SQL tables, validate SYSTEM.billing_837_d_report is no longer an SQL view, and is now a table.
Scenario 2: Validating SYSTEM.billing_837_i_report switched from a SQL view to an SQL table
Specific Setup:
  • An 837 Institutional report file has been created by the "Electronic Billing" process for 837 Institutional files.
Steps
  1. Using the preferred method of viewing SQL tables, validate SYSTEM.billing_837_i_report is no longer an SQL view, and is now a table.
Scenario 3: Validating SYSTEM.billing_837_p_report switched from a SQL view to an SQL table
Specific Setup:
  • An 837 Professional report file has been created by the "Electronic Billing" process for 837 Professional files.
Steps
  1. Using the preferred method of viewing SQL tables, validate SYSTEM.billing_837_p_report is no longer an SQL view, and is now a table.
Topics
• 837 Dental • 837 Institutional • 837 Professional
Table Changes
Table Column Change
SYSTEM.billing_837_d_report Table Type Changed from view to table
SYSTEM.billing_837_i_report Table Type Changed from view to table
SYSTEM.billing_837_p_report Table Type Changed from view to table