PY - Running Payline Details and PSHUP Load Report

GENERAL DESCRIPTION:

The Payline Details Report gives a Payroll Coordinator a listing of paylines that have been created for a specific Pay Run ID (pay cycle) to ensure accuracy of the amounts being either deducted or refunded to the employee. The PSHUP Load Report gives users a preview of possible errors which may cause the entered payline to not load to the employee's paycheck.

PROCESS CONSIDERATIONS:
  • The Payline Details Report can be run multiple times prior to the evening of the load of the payline adjustments.  It must be run after the Tuesday night load to identify paylines that did not successfully load to paychecks.
  • The PSHUP Load Report must be run prior to the Payline load to paychecks (on Tuesday night of a regular payroll processing week) to identify possible error paylines.



PROCEDURE STEPS:

Payline Details Report

This report is a reflection of all data entered in the Custom Payline Page. This report can be run prior to the Tuesday night load to quickly review all entries made for a given pay run ID.  This is an easy way to give a final review to data before it is loaded to the employee's paycheck.
This report MUST be run on the Wednesday after the payline load to review the statuses of all entered paylines for anything in error status.
NOTE: Contact the Service Center for Paylines that did not load so they can be added manually to the payroll.
  1. Navigation: Payroll for North America> Payroll Processing USA > Create and Load Paysheets > UW Payline > UW Payline Reports > Payline Details Report

  2. Enter a Run Control, or create a new one, see KB PD - Setting Up Run Control IDs for assistance.

  3. Enter information in some or all of the following fields to limit results:
    NOTE: results will be restricted by users' security access
    • Entered By - enter the empl ID of the individual that created the payline
    • Business Unit - Enter the business unit that you are running this report for.
    • Department - Enter the department ID that the report is being run for. To view all departments within your security leave this field blank.
    • Pay Run ID - Enter the Pay Run ID value that you want to run this for.
    • Payline Type - This report can be run against specific types of payline adjustments. (E = earnings, PD = General Deductions)
      NOTE: If wanted to run for both earnings and general deductions, the report must be run twice, once with each separate Payline type. 
    • Empl ID - If wanted, this report can be run to find paylines created for specific employees
    • Select Statuses for Report - All statuses should stay marked, results can be filter to find errors in the excel document


    https://kb.wisc.edu/images/group61/26861/9.2Paylinedetails.jpg

  4. Once this information has been entered, click the Run button.

  5. Click OK.

  6. Use the Process Scheduler and View Trace/Log to monitor and view the report, see KB PD - Viewing the Process Monitor for more information.

  7. On the View Log/Trace page, find the File List section, and in there find the document titled PAYLINE_DETAILS.xls Click that link.
    NOTE: You may receive messages regarding opening this file into Microsoft Excel. Click Yes to confirm opening the file.

    https://kb.wisc.edu/images/group61/26861/9.2viewtracelog1.jpg

  8. This spreadsheet delivers details of Payline Adjustments requested for this specific pay run. As this is an Excel spreadsheet, the information can be sorted and filtered to refine the information you are looking for.

    • Empl ID - the employee's Empl ID value.
    • Empl Rcd - the employee's Empl Record that these paylines are being applied to.
    • Employee Name
    • Run ID - identifies the pay period for which the adjustment is being processed
    • Payline Type - value options: Earnings, General Deductions or Benefits. Based upon criteria from the run control.
    • PayGroup - Value will default from employee's job data record for the empl record specified
    • BusUnit - Value will default from employee's job data record for the empl record specified
    • DeptID - - Value will default from employee's job data record for the empl record specified
    • EarnCd/DedCd -the Earning Code or Deduction Code as entered on the payline adjustment page.
    • Earnings/Payment Beg Dt - the begin date as entered on the payline adjustment page.
    • Earnings/Payment End Dt - the end date as entered on the payline adjustment page.
    • One Time Cd - the payline code attributed to this adjustment. A stands for Addtion (or added deduction); R stands for Refund; O stands for Override.
    • Plan Type - Two character code accessible through looking glass on payline page.
    • Ded Class - Value options: B - Before Tax; A - After Tax; N - Non-taxed; T - taxable.
    • Amount - the dollar amount that is being applied to this pay run
    • Root Cause - as entered on the payline adjustment page
    • PSHUP Status - displays the current status of the payline adjustment. If the payline adjustment is in error status contact the Service Center to manually add the adjustment to the employee's check.
    • Create Oprid - reflects user responsible for UW Payline Page Entry.
    • Creation Dt - reflects original date of UW Payline Page entry
    • Comments - reflects manually entered comments on the Requestor Detail's tab of the UW Payline Page
    • Last Update Dttm - reflect date last updated in the UW Payline Page
    • Last Update Oprid - reflects EEID of last change made to entry in the UW Payline Page.
     
    https://kb.wisc.edu/images/group61/26861/9.2Paylinedetailsreport.jpg




PSHUP Load Report

This proactive report should be run prior to the Tuesday night load. When this report runs background edits validate whether or not a payline will load successfully or have an error. All paylines in error status on the report should be reviewed and fixed prior to the Tuesday night load.

  1. Navigation: Payroll for North America> Payroll Processing USA > Create and Load Paysheets > UW Payline > UW PSHUP Load Process

  2. Enter a Run Control, or create a new one, see KB PD - Setting Up Run Control IDs for assistance.

  3. Enter information in the following fields:
    NOTE: results will be restricted by users' security access
    • Pay Run ID - Enter the Pay Run ID value that you want to run this for.
    • Report Mode - Report Only should remain as default

    9.2 PSHUP load report

  4. Once this information has been entered, click the Run button.

  5. Click OK.

  6. Use the Process Scheduler and View Trace/Log to monitor and view the report, see KB PD - Viewing the Process Monitor for more information.

  7. On the View Log/Trace page, find the File List section, and in there find the document titled UW_PSHUP_LD_##.xls Click that link.
    NOTE: You may receive messages regarding opening this file into Microsoft Excel. Click Yes to confirm opening the file.

    9.2 PSHUP view/trace log

  8. The report output will pull all the entered information from the custom payline page by employee.
    • The most important field on this report is column W "PSHUP_Status". This field will tell you what status the payline will be put into when the Tuesday night load runs.  Running the PSHUP report does not actually update the status of the payline on the custom payline page - it just previews whether a payline will have an error loading.  As long as the payline is still in "Pending" status, updates can be made to it.
      • If the status is Ready for Payline, the payline should load without issue, and no manual intervention should be necessary
      • If the status is anything other than Ready for Payline, the error will need to be resolved or else the payline will not load to the employee's paycheck (See KB 26830 for common errors).

    https://kb.wisc.edu/images/group61/26861/9.2PSHUPreport.jpg



To the top

ADDITIONAL RESOURCES:

Related KBs:

Related Links:



    Keywords:Payline One-Time Adjustment deduction refund processing payroll training   Doc ID:26861
    Owner:Kate I.Group:Human Resource System (HRS)
    Created:2012-10-16 13:45 CDTUpdated:2017-03-07 10:30 CDT
    Sites:Human Resource System (HRS)
    Feedback:  0   0