Running the Student Position Info Queries

First, log into OneUSG Connect.                         

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

The System Manager Reporting page is displayed.

Under the Queries menu, click the Workforce Administration drop-down menu to view the available queries.

A list of available Workforce Administration queries is displayed.

Click the Student Posn Query Group link.

The 180_HR_STUDENT_POSITIONS_QRY (Student Positions Info) query is displayed on the right side of the screen.

Unlike the other queries on the System Manager Reporting Page, this one has three different query links that you can access to view different data relating to student worker employment.

Click the Student Employee Look-up link.

The Ee Info w/RptsTo and TA Appr query is displayed. This query will show you the student's Report To information, among other things.

You can only search this data by Empl ID.

Enter the Empl ID for the student worker you want to query, or click the lookup magnifying glass to search for the needed value.

Example shown here: " 1888888 " in the EmplID field.

Click the View Results button.

The requested information is displayed. The columns list the student's position number, Hours/Wk, and their Reports To and T&A Approver information. The results will also list all of the student worker's positions across UGA.

To return to the previous page, click to close the current tab.

Next, click the Show Students w/ Multiple Positions link.

The Multi Stu Pos > 1 query is displayed. This query will produce a list of students that have multiple positions.

The prompts give you the option to search by Top HR Dept, which replicates the HR Department Tree. You can use this field to search by a higher level department to see all of the information for departments that roll up to that top level.

You can also search by specific HR department.

Example shown here: " H1000436 " in the Specific HR Dept field.

Click the View Results button.

The search results show each student worker's Empl ID and the number of positions they hold.

To view each position a student worker has, click the appropriate View Positions link.

On the main query page, click the Show Combined Reported/Standard Hours link.

The Stu Mult Pos w/ Total Hrs query is displayed. This query adds up the total combined reported hours a student has worked within the current week across multiple positions.

You can again search by Top HR Dept or Specific HR Dept.

Example shown here: " H1000436 " in the Specific HR Dept field.

Click the View Results button.

The combined hours are displayed by employee. The data in All Hrs (Rptd plus Std Hrs) shows the total reported hours across all positions

Click the Reported Hours this Pay Week link.