Running the Job Compensation Queries in OneUSG Connect

First, log into OneUSG Connect

On the Manager Self Service homepage, click theSystem Manager Reporting tile.

The System Manager Reporting page is displayed.

In the Queries menu on the left side of your screen, follow the navigation:

Workforce Administration > Compensation Query Group

Click the Compensation Query Group link.

The Job Compensation Queries page is displayed. On this page, there are links to four Queries: Simple Job Compensation, Compensation Component Summary, Compensation Component Detail, and Compensation History. There is also a link to access the available Query UPKs in the Training Library.

Click the Simple Job Compensation Query link.

Enter the appropriate information in the search criteria fields then choose the appropriate employee HR status, Active / Inactive from the HR Status Drop-down menu.  

Click the Active option.

Click the View Results button.

On the System Manager Reporting page, click the  Compensation Component Query - Summary link.

Click the View Results button.

The Compensation Component Query - Summary results are displayed. This query returns the components of pay associated with the Job Record.  This query will return a SINGLE ROW per job record/position will all the components detailed in the columns on the right.  If there is no Multiple Components of Pay (MCOP), these columns will be empty. 

To view job details for an employee, choose the appropriate row for the employee then, in the View Job Summary column, click the View Job Summary link.

Example shown here: View Job Summary link.

The General tab provides, Organizational Relationship, Employee Record, Effective Date, Sequence, Actions / Reasons information, and a Key Person checkbox.

Click the Job Information tab.

The Job Information tab provides Effective, Job Code, Employee Status, Full /Part Time, Reg Temp, Standard Hours and Work Period information.

Click the Work Location tab.

The Work Location tab provides Position, Company, Department, Location and Reports To information.

Click the Salary Plan tab.

The Salary Plan tab provides Salary Plan, Grade Step, Pay Group and Frequency of pay information.

Click the Compensation tab.

Returning to the System Manager Reporting page, click the Compensation Component Query - Detail  link.

Enter the appropriate information in the search criteria fields then choose the appropriate employee HR status, Active / Inactive from the HR Status Drop-down menu.   

Click the Active option.

Click the View Results button.

Click the Compensation History link.

Enter the appropriate information in the search criteria fields then choose the appropriate employee HR status, Active / Inactive from the HR Status Drop-down menu.

Click the  Active option.

Click the View Results button.

To access the Reporting and Queries resources in the OneUSG Connect section of the OneSource Training Library, click the  Query UPKs  link.