Searching for Employee ID

   Overview   

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.

1. Step 1

The UGA Financials page is displayed with the query viewer tile highlighted.

From the UGA Financials page, click the Query Viewer tile.

2. Step 2

The query viewer page is displayed with the *Search By dropdown menu highlighted.

The Query Viewer page is displayed.

You can search by query name or switch the search method by clicking the Search By list.

3. Step 3

The query viewer page is displayed with the *Search By dropdown menu highlighted.

Enter appropriate information into the begins with field. Enter a valid value e.g. "UGA_USERS_EMPLID".

Example shown here: Query Name list item.

4. Step 4

The begins with field is highlighted.

Enter appropriate information into the  begins with field.

Enter  a valid value e.g.  " UGA_USERS_EMPLID ".

5. Step 5

The Search button is highlighted.

Click the Search button.

6. Step 6

The HTML link is highlighted.

The search results are displayed.

Click the HTML link next to the appropriate query.

7. Step 7

The query prompt page is displayed with the Find Employee ID section highlighted.

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.

8. Step 8

The MyID field is highlighted.

Enter appropriate information into the  MyID  field.

9. Step 9

The View Results button is highlighted.

With the appropriate criteria selected, click the View Results button.

10. Step 10

The query result line is displayed and highlighted.

The query results are displayed, listing the employee and their Employee ID .

Note: Data has been distorted to protect employee information.

11. Step 11

The Last Name (Mixed Case) field is highlighted.

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 ".

12. Step 12

The View Results button is highlighted.

Click the View Results button.

13. Step 13

The query results are displayed and highlighted.

The query results are displayed.

14. Step 14

The Excel Spreadsheet link is highlighted.

To further analyze the query results in Excel, click the  Excel SpreadSheet link.

15. Step 15

The Excel chart is displayed with the title highlighted.

The query results are displayed in Excel for you to organize and save as you see fit.

16. Step 16

The close button is highlighted.

When you are done reviewing the data, click the Close button.

17. Step 17

The First Name (Mixed Case) field is highlighted.

To search by the employee's first name, enter appropriate information into the  First Name (Mixed Case)  field.

Example shown here: " John ".

18. Step 18

The View Results button is highlighted.

Click the View Results button

19. Step 19

The Search Results are displayed. Some personal information is censored in this image.

The search results are displayed.

Note: You can use combinations of search fields to help narrow down the results.
 
Print Article