Viewing Number of Budget Only Department Approvers

Summary

In this article, you will learn the steps to run a query to view the number of approvers in Budget Only Departments to assist in locating gaps in GL journal and budget amendment workflow.

Body

   Overview   

You can run a query to view the number of approvers assigned to budget-only departments using the query name UGA_USERS_ROLE_BUDG_DEPT.  This query can assist in locating gaps in workflow.  Accounts Payable and Travel and Expense transactions, including payment requests, AP JVs, travel authorizations, and expense reports do not need approvers in budget-only departments; however, GL journals and budget amendments do need approvers in these types of departments. 

There is a separate query to find the number of approvers assigned in transaction departments.  For more on this, please see the tutorial titled Viewing Number of Transaction Department Approvers.

In this article, you will learn the steps to run a query to view the number of approvers in Budget Only Departments to assist in locating gaps in GL journal and budget amendment workflow.  The query name used is 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 home page displayed with the UGA Financials link highlighted

Click the UGA Financials link.

3. Step 3

UGA Financials homepage displayed with the Query Viewer tile highlighted

Click the Query Viewer tile.

4. Step 4

Query Viewer page is displayed with the begins with field highlighted

The Query Viewer page is displayed.

Enter " UGA_USERS_ROLE_DEP T " into the begins with field.

5. Step 5

Query Viewer page is displayed with the Search button highlighted

Click the Search button.

6. Step 6

Search results are displayed with the HTML link highlighted

The search results are displayed.

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

7. Step 7

step image

You can search for specific information using the search fields.

Note: 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: You will search for all departments and roles that have less than 2 approvers, so you will not change the default information.

 

8. Step 8

UGA_USERS_ROLE_BUDG_DEPT-Budgetary Dept Roles (prompt) page displayed with the View Results button highlighted

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

9. Step 9

UGA_USERS_ROLE_BUDG_DEPT-Budgetary Dept Roles (prompt) page search results displayed and highlighted

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

Note: The Max Role Count 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

UGA_USERS_ROLE_BUDG_DEPT-Budgetary Dept Roles (prompt) page search results displayed with the Excel SpreadSheet link highlighted

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

11. Step 11

UGA_USERS_ROLE_BUDG_DEPT-Budgetary Dept Roles (prompt) page search results displayed with the Excel SpreadSheet file highlighted

Click the Excel SpreadSheet file.

12. Step 12

Excel Spreadsheet displayed with the right Scroll bar highlighted

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

 

Additional Information:

While AP and TE transactions do not need approvers in budget-only departments, GL and budget journals do. Another query exists to find gaps in workflow for transaction departments (UGA_USERS_ROLE_TRNS_DEPT).

 

Details

Details

Article ID: 150367
Created
Sat 9/24/22 11:41 PM
Modified
Wed 11/4/26 12:25 PM