Topics Map > Human Resource System (HRS) > Benefits Administration

Running the Deduction Prepay Paycheck Query in HRS


The Deduction Prepay process will automatically add deductions to paychecks for all employees setup on the Deduction Prepay Review Page with a 'OK to Process' checked. During a typical payroll calculation week the Deduction Prepay is loaded on Monday night. The Deduction Prepay Paycheck (UW_BN_PREPAY_PAYCHECK) query was created for Administrators to review paychecks to determine if deductions are taking appropriately.

Process Considerations:

  • The query cannot be run for a payroll until the Deduction Prepay is loaded to paychecks which is three days prior to confirm.  During a typical payroll calculation week, the Deduction Prepay is loaded on Monday night.
You may click on the links below to navigate directly to a section:


1.  Navigate to:  Reporting Tools → Query → Query Viewer

2.  Enter UW_BN_PREPAY_PAYCHECK into the search criteria and click Search button.

3.  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.
4. To view the query, click the link for Excel.
Query Viewer
5.  Once you click on the Excel link, a new page will open.
6.  Enter your Department or first character and % (Example: A%) into the DeptID>field.
7.  Enter the Pay Run ID into the Pay Run ID field to determine which payroll you are reviewing.
  • You can also search for your Pay Run ID by clicking on the magnifying glass.
8.  After you enter your criteria, click View Results.
9.  Open the query using Microsoft Excel by click OK or Open depending on your internet browser.
Run Control
10.  The report will only display employees with deduction prepay on their paycheck.  Review the results and determine a course of actions if needed.  Please contact UW Shared Services if you notice a paycheck is not appearing as expected.
Note:  An employee may appear on the report with multiple rows for each deduction prepay code and insurances.  The data appearing in the Excel spreadsheet is:
A.  Department:  Displays employee's Department appearing on the paycheck.

B.  Company:  UWS is the value for all employees.

C.  Pay Group:  Displays the pay group appearing on the paycheck.  A list of Pay Groups is available in Pay Group Descriptions in HRS.

D.  Pay Period End:  Lists the end date of the pay period end date of the paycheck.

E.  Off Cycle:  Indicates whether or not the paycheck was paid as part of regular on-cycle processing (shows as 'N' in this field) or was created as an off-cycle check or adjustment (shows as 'Y' in this field).

F.  EMPLID:  Displays employees' Employee ID.

G.  Empl Rcd#:  Displays employee's Employee Record of paycheck.

H.  Name:  Displays employee's name.

I.  Plan Type:  A list of Plan Types are available in Plan Types, Benefit Plans, and Payroll Deductions Job Aid in HRS.

J.  Benefit Plan:  A list of Benefit Plans are available in Plan Types, Benefit Plans, and Payroll Deductions Job Aid in HRS.

K.  Deduction Code:  A list of Deduction Codes are available in Plan Types, Benefit Plans, and Payroll Deductions Job Aid in HRS.

L.  Deduction Class
  • Before Taxindicates the deduction reduces the employee's taxable wages on the paycheck.  
  • After Tax indicates the deduction is withheld after tax withholdings are calculated, thus not affecting the employee's taxable gross for the paycheck.  
  • Nontaxable indicates the deduction is an employer-paid deduction.  The dollar amount listed for nontaxable deductions is not actually withheld from the employee's paycheck.
  • Taxable is not actual deductions withheld from the employee's pay.  The dollar amount associated with a taxable "deduction" is the amount added to the employee's taxable gross wages for the pay period.
M.  Current Deduction:  The amount being deducted for the deduction code.

N.  Net Pay:  This is the net amount the employee actually received on the paycheck.

O.  PREATX_AMT(A):  Displays the Cumulative Deduction Prepay After Tax balance as of the last confirmed payroll.

P.  PREBTX_AMT(B):  Displays the Cumulative Deduction Prepay Before Tax balance as of the last confirmed payroll.

Q.  PRETAX_AMT(T):  Displays the Cumulative Deduction Prepay Taxable balance as of the last confirmed payroll.

Additional Resources

Related KBs:

Related Links:

KeywordsMay Multiples LOA SWB Short Work Break Leave of Absence Seasonal UW_BN_PREPAY_PAYCHECK Benefits set aside money setting aside money prepay bucket Deduction Prepay Review Page Deduction Prepay Balance BN, Benefits BN, Benefits   Doc ID18451
OwnerChristina S.GroupUW–Shared Services
Created2011-05-04 19:00:00Updated2024-05-14 10:55:12
SitesUW–Shared Services
Feedback  0   0