Searching for Employee ID

Summary

This article will walk you through the steps to run the UGA_USERS_EMPLID query to search for a person's USG Employee ID.

Body

   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

step image

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

2. Step 2

step image

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

step image

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

step image

Enter appropriate information into the  begins with field.

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

5. Step 5

step image

Click the Search button.

6. Step 6

step image

The search results are displayed.

Click the HTML link next to the appropriate query.

7. Step 7

step image

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

step image

Enter appropriate information into the  MyID  field.

9. Step 9

step image

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

10. Step 10

step image

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

Note: Data has been distorted to protect employee information.

11. Step 11

step image

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

step image

Click the View Results button.

13. Step 13

step image

The query results are displayed.

14. Step 14

step image

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

15. Step 15

step image

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

16. Step 16

step image

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

17. Step 17

step image

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

step image

Click the View Results button

19. Step 19

step image

The search results are displayed.

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

Details

Details

Article ID: 149707
Created
Sat 9/24/22 11:22 PM
Modified
Fri 3/8/24 2:39 PM