Viewing Number of Transaction Department Approvers

   Overview   

You can run a query to view the number of approvers assigned to any transaction department using the query name UGA_USERS_ROLE_TRNS_DEPT.  This query can assist in locating gaps in workflow. 

There is a separate query to view the number of approvers assigned to budget-only departments.  For more information, please see the tutorial titled Viewing Number of Budget Only Department Approvers.

In this article, you will learn the steps to run a query to view the number of approvers assigned to each pool in any transaction department to locate gaps in workflow.  The query name is UGA_USERS_ROLE_TRNS_DEPT.

Note : This information can be viewed for Budget Only Departments using a different query (UGA_USERS_ROLE_BUDG_DEPT).

1. Step 1

Employee Self service homepage displayed with the dropdown arrow highlighted

First, log into the Financial Management System.

Click the drop-down button next to the Employee Self Service menu.

2. Step 2

UGA Financials page displayed with the UGA Financials link highlighted

Click the UGA Financials link.

3. Step 3

UGA Financials page displayed with the Query Viewer tile highlighted

Click the Query Viewer tile.

4. Step 4

Query Viewer page displayed with the begins with field highlighted

The Query Viewer page is displayed.

Enter " UGA_USERS_ROLE_DEPT " into the begins with field.

5. Step 5

Query Viewer page displayed with the Search button highlighted

Click the Search button.

6. Step 6

Query Viewer page displayed with the HTML link highlighted

The search result is displayed.

Click the HTML link to open the query as a webpage.

7. Step 7

Query Viewer page displayed with the Department field highlighted

You can search for specific information using the search fields.

You can limit the search results by entering the appropriate information into the Department(s) and/or Role Name fields. To find departments with gaps in workflow, you can enter a 2 or 1 into the Approvers Less Than field. 

Example shown here:  Search for all departments and roles that have less than 2 approvers, so you will not change the default information.

8. Step 8

Query Viewer page displayed with the View Results button highlighted

Click the View Results  button to display results based on your search criteria.

9. Step 9

Query Viewer page displayed with the searched list of approvers highlighted

The search results are displayed. You can view information by role name and department ID.

The # of Approvers column indicates the number of employees assigned to a role and depends upon the information search in the Approvers Less Than field.

10. Step 10

Query Viewer page displayed with the Excel SpreadSheet link highlighted

Click the Excel SpreadSheet  link to download the results into an Excel file.

11. Step 11

Query Viewer page displayed with the Open button highlighted

Click the Open button.

12. Step 12

Excel Spreadsheet displayed with the lower Scroll bar highlighted

The Excel file is displayed. You can add filters to sort the information as needed.