3. You are shown the Search Results below.
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 %.
9. Open the query using Microsoft Excel by clicking OK or Open depending on your internet browser.
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 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).