The "Student Position Info" query is actually a set of three queries for student worker positions: Student Employee Lookup, Show Students w/Multiple Positions, and Show Combined Reported/Standard Hours.
In this article, you will learn the steps to run a query on the OneUSG Connect System Manager Reporting Page in order to view student worker information, including students with multiple positions and total reported hours in a current pay period.
Note: Data has been redacted to protect employee information.
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.
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.
The student worker's position information is displayed for each position. Data shown includes the Department ID, hours for each position, and their Reports To and T&A Approver information.
If you have access to Job Data, you can click the Empl ID link to access their job data in OneUSG Connect.
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.
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.
The student's reported time is displayed, including Pay Run ID, number of hours ( Quantity ), and when the hours were reported ( Rpt Dt ).