Running the Smoothing and TRC Code Query in HRS


Walk through running and viewing query to identify those employees that have a salary reduction (smoothing) but have entered a TRC that does not match.

Process Considerations:

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) 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 and/or Dept ID, optional.

  6. Enter From and To Date to identify search dates.

  7. Review results.


  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.