As University System of Georgia (USG) employees, all UGA employees have a USG Employee ID, often labeled in the PeopleSoft systems as Empl_ID. This number is in addition to the UGA 81X number. Most often it begins with 180 but if employees have worked for other USG institutions, or was assigned after July 1, 2018, their number may begin with a different prefix. Employees and/or their home departments may need to know or recognize this Empl_ID for use on various forms or in query results. In the UGA Financial Management System, this number can be found in various places, including Expense Reports.
You may find yourself in the situation where you need to find your USG Employee ID or the USG Employee for another employee. You can access the UGA_USERS_EMPLID query via the Query Viewer to complete this task.
This article will walk you through the steps to run the UGA_USERS_EMPLID query to search for a person's USG Employee ID.
From the UGA Financials page, click the Query Viewer tile.
The Query Viewer page is displayed.
You can search by query name or switch the search method by clicking the Search By list.
Enter appropriate information into the begins with field. Enter a valid value e.g. "UGA_USERS_EMPLID".
Example shown here: Query Name list item.
Enter appropriate information into the begins with field.
Enter a valid value e.g. " UGA_USERS_EMPLID ".
Click the Search button.
The search results are displayed.
Click the HTML link next to the appropriate query.
The query prompt page is displayed. From this page, you can search for an employee by MyID, last name, and/or first name. The query will return that employee's USG Employee ID.
Enter appropriate information into the MyID field.
With the appropriate criteria selected, click the View Results button.
The query results are displayed, listing the employee and their Employee ID .
Note: Data has been distorted to protect employee information.
Alternatively, you can search for the employee by their last name. Enter appropriate information into the Last Name (Mixed Case) field.
Example shown here: " Smith ".
Click the View Results button.
The query results are displayed.
To further analyze the query results in Excel, click the Excel SpreadSheet link.
The query results are displayed in Excel for you to organize and save as you see fit.
When you are done reviewing the data, click the Close button.
To search by the employee's first name, enter appropriate information into the First Name (Mixed Case) field.
Example shown here: " John ".
Click the View Results button
Note: You can use combinations of search fields to help narrow down the results.