Running the Compensation History Query

   Overview   

In the UGA Financial Management System, you can view the compensation history for an Employee ID and/or Department ID through a query (180_HR_COMP_HIST) on the System Manager Reporting Page, under Workforce Administration. The query displays Annual, Monthly, Daily, and Hourly Compensation Rates.

In this article, you will learn the steps to run a query to view compensation history for an employee or group of employees.

1. Step 1

The Manager Self Service page is displayed with the System Manager Reporting tile highlighted.

First, log into OneUSG Connect

From the Manager Self Service page, click the System Manager Reporting tile.

2. Step 2

The System Manager Reporting page is displayed with the Workforce Administration menu item highlighted.

The System Manager Reporting page is displayed.

From the Queries menu on the left, click the Workforce Administration menu item to view available queries.

3. Step 3

The System Manager Reporting page is displayed with the Compensation Query Group link highlighted.

The available queries under the Workforce Administration category are displayed.

Click the Compensation Query Group link.

4. Step 4

The Compensation History link is highlighted.

The available categories under the Compensation Query Group query are displayed.

Click the Compensation History link.

5. Step 5

The 180_HR_COMP_HIST (Compensation History) query is displayed with the HR Status field highlighted.

The search criteria for the query 180_HR_COMP_HIST (Compensation History) is displayed.

You can enter available information into the search fields to limit your results. The % wildcard will display all possible results for the query.

Example shonwn here: Open search, with no Employee ID or Department ID information entered.  This will return all of the employees you can access to view.

Click the HR Status drop-down list.

6. Step 6

The 180_HR_COMP_HIST (Compensation History) query is displayed with the Active list item highlighted.

Click the Active list item to only display active UGA employees.

7. Step 7

The View Results button is highlighted.

To view the query results, click the View Results button.

8. Step 8

The Excel SpreadSheet link is highlighted.

The query results are displayed.

Click the Excel SpreadSheet link to open the results as an Excel file.

9. Step 9

The Excel SpreadSheet link is highlighted.

Depending on the web browser, you will be prompted to open the Excel file.

Click the Open button.

10. Step 10

The Excel file is displayed with all the column headers highlighted.

The Excel file is displayed. You can filter and sort through the columns to view the information you need. Scroll to the right to view additional columns.

11. Step 11

The Excel file is displayed with the Annual Rate through Monthly Rate columns highlighted.

Column K displays Annual Rate of compensation, Column M shows Compensation Frequency. You can also see the Hourly Rate and Monthly Rate. Scroll to the right to view additional information.

12. Step 12

The Hourly Rate through Annual Benefits Base columns are highlighted.

Additional information is displayed, including Hourly, Monthly, and Daily Rate for the employees. Column R shows the Annual Benefits Base.