Viewing Approver Roles Assigned to an Employee

   Overview   

You can run a query to locate the approver roles assigned to an employee using the query name "UGA_USERS_ROLES_ROUTINGS."

In this article, you will learn to run the query UGA_USERS_ROLES_ROUTINGS to see all approval roles for a specific employee.

1. Step 1

step image

First, log into the Financial Management System.

Click the Employee Self Service dropdown button to activate the menu.

2. Step 2

step image

Click the UGA Financials link.

3. Step 3

step image

Click the Query Viewer tile.

4. Step 4

step image

The Query Viewer opens so that you can search for the query you need.

Note : If you have already added it to your My Favorite Queries list, you can run the query from there without searching.

Enter " UGA_USERS_ROLES_ROUTINGS " to search for the query.

5. Step 5

step image

Click the Search button.

6. Step 6

step image

The Query is shown in the list. Select the HTML option to see the report online.

Click the HTML link.

7. Step 7

step image

The User ID number is the employee's ID. If you do not know that ID, you can look up the name.

You can also use the other fields on the page to search.

Click the Look up User ID button.

8. Step 8

step image

The Search dialog opens with the Basic Lookup. To search by name, you will need to use the Advanced Lookup.

Note : Data has been distorted to protect employee information.

Click the Advanced Lookup link.

9. Step 9

step image

The Advanced Lookup has two fields to use as criteria.

Names are listed with the last name first.

Enter all or the first part of the last name of the supervisor into the Name field.

Enter "day" into the Name field.

10. Step 10

step image

Click the Look Up button.

11. Step 11

step image

Click the appropriate link.

Example shown here: day link.

12. Step 12

step image

A list of all approver roles that the employee has access to is displayed.

13. Step 13

step image

You can use the browser print features to print the report, if needed. You can also use hyperlinks on the page to download the data to an Excel Spreadsheet.