Running the Furlough/Temporary Workforce Reduction (TWR) Queries in HRS

Overview

Walk through running and viewing queries related to Furlough and Temp. Workforce Reduction.

Process Considerations:

  • Query Reports can be run to HTML or Excel.


Instructions

Furlough Incorrect FTE Query

This query is used to verify that the correct Job Data Action reason was used to change an employee's FTE.
  1. Navigate to Reporting Tools > Query > Query Viewer.

  2. Enter the Query Name (UW_HR_INCORRECT_FTE_CD) in the begins with field

  3. Click on the Search button.

  4. Click on the Run to HTML link or the Run To Excel link.

  5. Results will automatically appear.

  6. Review results.

    HR_FTEreport.png

  7. Correct the Job Data action/action reason if the incorrect action/action reason code was used.

To the top

Restored Leave for Temp Workforce Reduction Employees

This query can be used to identify employees who are on temp workforce reduction (TWR) and if and when their leave balances were restored and what they were restored to.
  1. Navigate to Reporting Tools > Query > Query Viewer.

  2. Enter the Query Name (UW_HR_TWR_FTE) in the begins with field

  3. Click on the Search button.

  4. Click on the Run to HTML link or the Run To Excel link.

  5. Enter the Business Unit and/or Department prompt values, optional

  6. Click View Results.

  7. Review results.

    HR_TWR_FTEquery.png


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:UW_HR_TER_EMPL Terminated Employee report EJED Expected Job End Date public HR, Human Resources HR, Human Resources   Doc ID:102119
Owner:tami e.Group:UW–Shared Services
Created:2020-05-15 16:00 CDTUpdated:2020-07-24 11:54 CDT
Sites:Human Resource System (HRS), UW-La Crosse, UW–Shared Services
Feedback:  0   0