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

System Manager reporting tile selected

First, log into OneUSG Connect.                         

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

2. Step 2

workforce administration menu item selected

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

3. Step 3

Employee job data query group selected

Click the Employee Job Data query link.

 

4. Step 4

basic job data selected

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

excel spreadsheet link selected

The Job Data report is displayed.

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

5. Step 5

open file button selected

Click the Open file button.

6. Step 6

excel file displayed

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

title tab displays additional fields

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

8. Step 8

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.

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

Addtional information cell selected

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

10. Step 10

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

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.