BN - Deduction Prepay Load Status Query
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 UW Service Center 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.
- 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 BN - Deduction Prepay Process (Part I: Deduct money for insurance in anticipation of a Leave) .
- 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 UWSC.
- 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.
1. Navigate to: Reporting Tools → Query → Query Viewer
2. Enter UW_BN_PREPAY_LOAD_STATUS
into the search criteria and click Search
3. You are shown the Search Results
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
6. Enter the Pay Run ID into the Pay Run ID
field to determine which payroll you are reviewing.
- Note: you can also search for your Pay Run ID by clicking on the magnifying glass.
7. Select the Load to Payroll Status
value from the drop down menu. The following will provide direction on which Load to Payroll Status to choose:
- 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 UW Service Center 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 your Affinity Group if you identify an issue with an employee loaded and you expected different results.
8. After you enter your criteria, click View Results
9. Open the query using Microsoft Excel by clicking OK
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 your Affinity Group 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.
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 if employee was manually setup for Leave of Absence (LOA), automatically loaded for Academic(C-Basis) Short Work Break (MAY).
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 BN - Benefit Program Assignment Job Aid
i) Plan Type: A list of Plan Type are available in BN - Plan Types, Benefit Plans, and Payroll Deductions Job Aid.
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 BN - Plan Types, Benefit Plans, and Payroll Deductions Job Aid.
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 PY - Pay Group Descriptions.
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).