Topics Map > Human Resource System (HRS) > Benefits Administration
Running the Deduction Prepay Load Status Query in HRS
Overview
The Deduction Prepay Load Status (UW_BN_PREPAY_LOAD_STATUS) query was created to provide Administrators the ability to review all employees setup on the Deduction Prepay Review Page prior to and after deduction prepay is loaded to payroll. The UWSS Service Operations will run a process to automatically setup Academic (C-Basis) employees on the Deduction Prepay Review Page for the March, April and May payrolls in anticipation of Short Work Break during the summer. All other employees can be manually setup prior to an anticipated Leave of Absence or Short Work Break directly on the Deduction Prepay Review Page.Process Considerations:
- Academic (C-Basis) employees are automatically setup on the Deduction Prepay Review Page based on the Benefit Primary Empl Record at the end of February for March, April, and May in preparation for the summer short work break.
- Employees must be enrolled in Benefit Plans at that time.
- Employees can be manually setup for leave of absences anytime prior to the Deduction Prepay being added to the paycheck which is two days prior to each payroll confirm.
- For assistance on manually setting up Deduction Prepay please refer to Deduction Prepay Process (Part I: Deduct Money for Insurance in Anticipation of a Leave) in HRS .
- The 'OK to Process' check on the Deduction Prepay Review Page can be removed prior to the Deduction Prepay Load to Payroll to prevent deductions if needed.
- NOTE: Unchecking the 'OK to Process' checkbox will remove the check mark for all Plan Types for that particular payroll.
- The query can be run after the Deduction Prepay Load to Payroll to verify which employees have been successfully loaded to payroll.
- Status ‘Not Processed’ will identify employees setup with “OK to Process” checked. These will be manually reviewed and fixed by the UWSS.
- Status ‘Loaded to Payroll’ will identify employees whose deduction prepay was setup on the paycheck.
- Determine who will be returning in the fall and need summer prepay deductions.
- When in doubt, start with the employee.
- Follow up with the division/department/institution for the fall semester appointment to confirm.
You may click on the links below to navigate directly to a section:
2. Enter UW_BN_PREPAY_LOAD_STATUS into the search criteria and click Search button.
4. To view the query, click the link to Run to Excel.
10. The report will only display employees checked 'OK to Process' for the payroll. Review the results and determine a course of actions if needed.
Instructions
1. Navigate to: Reporting Tools → Query → Query Viewer2. Enter UW_BN_PREPAY_LOAD_STATUS into the search criteria and click Search button.
3. You are shown the Search Results below.
4. To view the query, click the link to Run to Excel.
5. Once you click on the Run to Excel link, a new page will open. On that page, enter your Department or first character and %.
- Example: Enter A% into the Department field
- Note: you can also search for your Pay Run ID by clicking on the magnifying glass.
- Two Days Before Payroll Confirm:
- Not Processed: The value should be selected to review and determine if Academic (C-Basis) employees automatically setup for the summer should have deduction prepay based on expectation of fall return. In addition, you can review employees manually setup for leave of absence throughout the year.
- Day Before Payroll Confirm or later:
- Not Processed: The value should be selected after the deduction prepay has been added to the paycheck. The query will identify employees that did not successfully load to paychecks. No action is required since the UWSS Service Operations will be reviewing and fixing as appropriate. One common reason for Plan Types to not process is the benefit is zero cost to the employee.
- Processed: The value should be selected after the deduction prepay has been added to the paycheck. The query will identify employees who successfully loaded to paychecks. Please contact UW Shared Services if you identify an issue with an employee loaded and you expected different results.
9. Open the query using Microsoft Excel by clicking OK or Open depending on your internet browser.
10. The report will only display employees checked 'OK to Process' for the payroll. Review the results and determine a course of actions if needed.
- Please contact UWSS Service Operations if you notice a processed deduction prepay that is not appearing on a paycheck as expected.
- Note: An employee may appear on the report with multiple rows if they were setup in deduction prepay for more than one insurance plan.
Sample Report:
The data appearing in the report includes:
a) Business Unit: Displays employee's Business Unit the deduction prepay was setup under.
b) Department: Displays employee's Department the deduction prepay was setup under.
c) Prepay Source: Displays the value of Leave of Absence (LOA) (please note MAY is no longer used).
d) EMPLID: Displays employees' Employee ID.
e) Empl Rcd#: Displays employee's Employee Record number the deduction prepay was setup under.
f) Name: Displays employee's name.
g) Empl Status: Displays' the employee status. For example: Active (A), Leave of Absence (L), Leave with Pay (P), Short Work Break (W) and Terminated (T).
h) Ben Program: A benefit program indicates the collection of benefits available to the employee. For an explanation of benefit program values refer to Benefit Program Assignment Job Aid for HRS
i) Plan Type: A list of Plan Type are available in Plan Types, Benefit Plans, and Payroll Deductions Job Aid in HRS.
j) Coverage Elect: The values represents if the employee is currently enrolled. For example, E for 'Elect', W for 'Waived', and 'T' for 'Termed' coverage.
k) Benefit Plan: A list of Benefit Plans are available in Plan Types, Benefit Plans, and Payroll Deductions Job Aid in HRS.
l). Company: UWS is the value for all employees.
m) Pay Group: Displays the pay group the prepay was loaded under. A list of Pay Groups is available in Pay Group Descriptions in HRS.
n) Pay Period End: Lists the end date of the pay period end date of pay run id.
o) 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).
p) Pay Run ID: The pay period the deduction prepay was setup to take.
q) Prepay Factor: Indicates how many additional deductions should be taken for this employee on the specified Pay Run ID (i.e., pay period).
r) PREATX_AMT(A): The calculated Deduction Prepay After Tax amount for each Plan Type.
s) PREBTX_AMT(B): The calculated Deduction Prepay Before Tax amount for each Plan Type.
t) PRETAX_AMT(T): The calculated Deduction Prepay Taxable Tax amount for each Plan Type.
u) Loaded to Payroll: The value represents if the Deduction Prepay has loaded to payroll (L) or not processed (N).
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 Paycheck 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