BN - Deduction Prepay Load Status Query

GENERAL DESCRIPTION:

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.

PROCESS CONSIDERATIONS:
You may click on the links below to navigate directly to a section:

PROCEDURE STEPS:

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

2.  Enter UW_BN_PREPAY_LOAD_STATUS into the search criteria and click Search button.
  Query Search
3.  You are shown the Search Results below. 

4. To view the query, click the link to Run to Excel.
9.2 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 %.
6.  Enter the Pay Run ID into the Pay Run ID field to determine which payroll you are reviewing.  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: 8.  After you enter your criteria, click View Results.
9.2 Run Control Parameters
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.

Sample Report:
9.2 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 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).


ADDITIONAL RESOURCES

Related KBs: Related Links: