Topics Map > Human Resource System (HRS) > Payroll

Running the Percent Reduction Query in HRS

Overview:

The UW_PY_FUR_PCT_RED query will display, as of the last time the percent reduction process was run, the calculated reduction amount for employees who have the percent reduction action reason set up in Job Data prior to or within the pay period being calculated

PROCESS CONSIDERATIONS:

  • UW_PY_FURPCT is the process that populates this query. This job runs in report mode each night during the payroll processing week and runs in update mode only during the final calc stream. This means that employee percent furlough reductions will not be visible on calculated paychecks prior to the final calc. This PS query will be the only way to validate, prior to the final calc, that the correct reduction amount will be taken from employee paychecks.
  • Each time the UW_PY_FURPCT process runs, the query output will be overwritten with the newest calculation information.




INSTRUCTIONS

  1. Navigation: Reporting Tools > Query > Query Viewer

  2. Search for and select UW_PY_FUR_PCT_RED.

  3. Select to run the query in HTML or Excel.

  4. Enter optional Dept ID.
    NOTE: Enter the wild card (%) for an entire institution or division. For example, enter A% to return results for all UW-Madison employees, or A48% to return results only for that UW-Madison division.

  5. Click View Results.
    NOTEResults will be returned for all employees you have security to view.

  6. The query will return identifying employee information as well as information regarding the calculation of the employee’s furlough reduction amount on the payroll that is being processed.
    • Percent Rate – The percent by which the employee’s earnings will be reduced
    • Total Included Earnings – The total dollar amount on the calculated paycheck that is eligible for the reduction
    • Reduction Amt – The calculated negative dollar amount that will load to the employee’s payline
    • Total Hours – The total number of hours credited to the employee in the pay period
      NOTE: A value will only show in this field for monthly-paid employees. Biweekly employees will not have hours reduced until they record their furlough day on the timesheet.
    • Hours Reduction – The calculated negative hours amount that will load to the employee’s payline
      NOTE: A value will only show in this field for monthly-paid employees. Biweekly employees will not have hours reduced until they record their furlough day on the timesheet.
    • Earnings Code– The earnings code that will be used on the negative furlough payline
      • Monthly = FFR (may swap to FFS for foreign nationals)
      • Biweekly = FHR (may swap to FHT for foreign nationals)
    • Instance – Process instance number of the most recent run of the UW_PY_FURPCT job in HRS


To the top

GET HELP

  • Click HERE to contact UW Shared Services - Service Operations Department or HERE for the UWSS IT HelpDesk if you have any issues with these instructions.




Keywords: PY, Payroll PY, Payroll PY, Payroll PY, Payroll   Doc ID:102882
Owner:kate i.Group:UW–Shared Services
Created:2020-06-08 14:20 CDTUpdated:2020-07-24 10:45 CDT
Sites:Human Resource System (HRS), UW-La Crosse, UW–Shared Services
Feedback:  0   0