BN - Benefit Arrears Balance Query

The Benefit Arrears Balance Public Query is designed to give Administrators the ability to query arrears balances for their institution employees.

Procedure At-A-Glance
Category: Benefit Deductions
Audience: Campus Benefit Administrators
Overarching Process: Benefits
Navigation: Reporting Tools > Query > Query Viewer
Jump To:

General Description

Arrears balances are created when an employee's net pay within a pay period is insufficient to cover a deduction or a retroactive benefit change has occurred.  The Arrears Benefit Balances query provides the ability for Administrators to view all pending balances for their institution.  Administrators need to review and determine if the arrears balance will take on the next payroll or request the balance to be removed with a payment plan or benefits billing to collect missing deductions.  The "BN Campus Benefit Update" security role will provide access to run the Benefit Arrears Balance query.

Process Inputs

  • Query Name = UW_BN_ARREARS_BAL
  • Business Unit

Process Outputs

  • Excel spreadsheet

Process Considerations

  • Arrears balances will update after:
    • Retroactive Benefit/Deductions (Retro Ben) is loaded to Arrears which is typically two days before the final payroll confirm.  Retro Ben is a result of a change in coverage.
    • Payroll has confirmed resulting in a change to arrears balances due to insufficient net earnings or prior arrears balances deducting.

Procedure Steps

1.  Click Reporting Tools

2.  Click Query

3.  Click Query Viewer

4.  Enter UW_BN_ARREARS_BAL into the search criteria and click Search.


5.  You are shown the Search Results below.  If you had done a partial search, multiple queries may appear in the list.  If you searched for the specific query you are looking for, you should only see that value below.  To view the query, click the link for Excel.


6.  Once you click on the Excel link, a new page will open.  On that page, you will enter your Business Unit into the Business Unit field.  You can also search for your business unit by clicking on the magnifying glass.

UW_BN_ARREARS_BAL Business Unit Lookup

7.  After you choose your business unit, click View Results.


8.  Open the query using Microsoft Excel and click OK or Open depending on your internet browser.

Below is an example of Mozilla Firefox.


Below is an example of Windows Internet Explorer 9.

Arrears Balance Query - IE Pop Up

9.  Review the results and determine a course of actions if needed.  Please contact your Affinity Group if you need arrears balances adjusted.  Note:  An employee may appear on the report with multiple rows if they have balances for more than one Deduction Code.  The data appearing in the Excel spreadsheet is:

A.  ID = Empl ID

B.  Unit = Business Unit

C.  Plan Type = A list of Plan Type are available in BN - Plan Type and Benefit Plan Code Job Aid.

D.  Plan = A list of Benefit Plans are available in BN - Plan Type and Benefit Plan Code Job Aid.

E.  Deductn Cd = A list of Deduction Codes are available in BN - Plan Type and Benefit Plan Code Job Aid.

F.  Ded Class = Deduction Class values are B for Before Tax and A for After Tax.

G.  Arrears = Arrears balance amount


Related Policies, Job Aids and Forms

Related Policies

Related Job Aids

Related Forms

  • Include links to UWSA website for any related forms here.

Keywords:Benefits, Arrear, Arrears, Arrears Balance, Arrear Balance, Query, Queries, Query Viewer, Benefit Retro, Retroactive, insufficient earnings   Doc ID:34240
Owner:Tina H.Group:Human Resource System (HRS)
Created:2013-10-08 10:28 CDTUpdated:2016-08-08 13:36 CDT
Sites:Human Resource System (HRS)
Feedback:  0   0