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:

  • This query is designed to identify those who have an action reason for salary reduction (smoothing) but have entered a TRC code on the timesheet that does not match the TRC's used for 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) 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.

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 13:07 CSTUpdated:2020-11-30 09:54 CST
Sites:Human Resource System (HRS), UW-La Crosse, UW–Shared Services
Feedback:  0   0