Finding Your Control Departments

Summary

In this article, you will learn how to run a query to find the Departments that accept transactions.

Body

   Overview   

You can use the UGA_KK_TRANS_DEPTS query to find your departments with control information.

In this article, you will learn how to run a query to find the Departments that accept transactions.

1. Step 1

step image

First, log into the UGA Financial 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_KK" to search for the query.

5. Step 5

step image

Click the Search button.

6. Step 6

step image

The UGA_KK_TRANS_DEPT query is shown in the list.

Select the HTML option to see the report online.

7. Step 7

step image

If you haven't turned on your pop-up preferences, click the Options for this site button.

8. Step 8

step image

Select Always allow from the drop-down menu items.

9. Step 9

step image

Enter the appropriate information into the  Department  field. This allows you to search for all Departments that begin with a set of numbers. Enter the numbers and then the % sign to search for all departments that begin with those digits.

Example shown here: "32" into the Department (can use %) field.

10. Step 10

step image

Click the View Results button.

11. Step 11

step image

The results are returned. The report lists the Departments and descriptions.

12. Step 12

step image

The second column gives the transaction type for each of the selected department.

A 2 indicates that the department can have transactions and also controls budget at that level.

A 3 indicates a department that can only receive transactions.

13. Step 13

step image

The Status column indicates whether the department is currently Active (A) or Inactive (I).

14. Step 14

step image

The last column shows which department controls the budget for the department.

If the result is 00000000, it means N/A since this department is a control department.

15. Step 15

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.

Details

Details

Article ID: 151494
Created
Sun 9/25/22 10:09 AM
Modified
Wed 5/22/24 12:48 PM