Running a Query to View Employee Job Data

   Overview   

You can access the 180_HR_JOB_DATA query on the System Manager Reporting Page in OneUSG Connect. This query provides HR job data results for employees, including Pay Group, Job Code, compensation rates, hire date, and Reports To information.

In this article, you will learn the steps to run a query to view employee job data.

1. Step 1

step image

First, log into OneUSG Connect.                         

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

2. Step 2

step image

In the Queries section on the left side of the screen, click the Workforce Administration menu item.

3. Step 3

step image

Click the Employee Job Data query link.

 

4. Step 4

step image

The requested results are displayed.

Click the appropriate link for the Job Data you want to review.

Example Shown: Basic Job Data

5. Step 5

step image

The Job Data report is displayed.

Click the Excel SpreadSheet link to download the report to an Excel file.

5. Step 5

step image

Click the Open file button.

6. Step 6

step image

The Excel file is displayed. You can filter and sort the data to view the information that you need.

Displayed columns include: Short Hr Dept. Description, HR Dept. ID, HR dept. ID description, Empl ID, Badge number, Name, Organization Relation and Effective date.

7. Step 7

step image

Scroll to the right to view additional fields, including: Position Number, Job Title, Reports to, Pay Group / Description.

8. Step 8

step image

Scroll right to view: Reason Description, HR Status, (Terminated A= Active, I= Inactive),  Payroll Status, Regular/Temporary status, Full/Part Time status, Employee Type (H = hourly, S = salaried), and Standard Hours/Week.

9. Step 9

step image

Additional information includes: Compensation Frequency, and Hire Date, First Start date, Rehire and Termination Date. 

10. Step 10

step image

Continue scrolling to see MyID, and Job Indicator / Summary Information

Note: Clicking on the hyperlinked fields, Job Summary, Job Data, Position Funding, and Position Comp History, will navigate you back to OneUSG Connect, where you can drill deeper into the selected topic for an employee.