Topics Map > Human Resource System (HRS) > Time and Labor

Running the Smoothing and TRC Code Query in HRS

Overview

Walk through the running and viewing of the queries to identify employees that have used a Furlough TRC not associated to the employee's Furlough configuration (Intermittent, Consecutive or Smoothing).

Process Considerations:

  • The UW_TL_WRONG_TRC_SAL_RED query is designed to identify employees who have an action reason for salary reduction (smoothing) but have entered a TRC code on the Timesheet that is used for intermittent or consecutive furlough.
  • The UW_TL_WRONG_TRC_INTF_CONF query is designed to identify employees who have an action reason for consecutive or intermittent but have entered a TRC code on the Timesheet that is used for salary reduction (smoothing).
  • Query Reports can be run to HTML or Excel.
You may click on the links below to navigate directly to a section:

Instructions When the Wrong TRC Code is Used

  1. Navigate to Reporting Tools > Query > Query Viewer.
  2. Enter the Query Name (UW_TL_WRONG_TRC_SAL_RED or UW_TL_WRONG_TRC_INTF_CONF) 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 Business Unit - Required Field.
  6. Enter Dept ID - Optional Field.
  7. Review results.

    SelectionCriteriaUPD.jpg
  8. Direct employee to update Timesheet as needed.
To the top

Get Help

  • Click HERE to contact UW Shared Services or HERE for the Office of Technology Services (OTS) Helpdesk if you have any issues with these instructions.




Keywords:UW_HR_TER_EMPL Terminated Employee report EJED Expected Job End Date public TL, AM, Time, Labor, Absence Management   Doc ID:102598
Owner:Neal W.Group:UW–Shared Services
Created:2020-05-28 14:07 CDTUpdated:2021-07-23 13:21 CDT
Sites:UW–Shared Services
Feedback:  0   0