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:


Click on the links below to skip directly to a section:



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.