Topics Map > Human Resource System (HRS) > Benefits Administration
Running the Deduction Prepay Paycheck Query in HRS
Overview
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:
2. Enter UW_BN_PREPAY_PAYCHECK into the search criteria and click Search button.
3. You are shown the Search Results below.
Instructions
1. Navigate to: Reporting Tools → Query → Query Viewer2. 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.
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.
9. Open the query using Microsoft Excel by click OK or Open depending on your internet browser.
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:M. Current Deduction: The amount being deducted for the deduction code.
- 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.
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:
- Deduction Prepay Process (Part I: Deduct Money for Insurance in Anticipation of a Leave) in HRS
- Deduction Prepay Process (Part II: Disburse Money for Insurance During Leave) in HRS
- Frequently Asked Questions Regarding Deduction Prepay in HRS
- Security Role BN Deduction Prepay Review for HRS
- Running the Deduction Prepay Load Status Query in HRS
- Benefit Program Assignment Job Aid for HRS
- Plan Types, Benefit Plans, and Payroll Deductions Job Aid in HRS
- Pay Group Descriptions in HRS