unit logo
  1. Home
  2. Knowledge Base
  3. Internal Controls and Quality Assurance
  4. Tier 2 Resources
  5. Tier 2 – Useful Queries

Tier 2 – Useful Queries

Overview

This provides a list of useful queries for Tier 2 employees.

Please e-mail controller-office@ad.ufl.edu with suggestions of queries to add.

Trial Balance Queries

Please note – a wildcard symbol ( %) may be used in place of input field (excluding dates) if the field is unknown or the user wants all results.

GA_GL_TB_FUND_DEPT_ACT_PROJ_SOF

Fiscal Year to Date balance by Fund, Account, Dept, Project

GA_GL_TB_BY_FND_DPT_ACT_QRY

Fiscal Year to Date balance by Fund, Account, Dept

GA_GL_TB_BY_ACCT_QUERY

Fiscal Year to Date balance by Account

GA_GL_TB_BY_DEPT_QUERY

Fiscal Year to Date balance by Department

GA_GL_TB_BY_FUND_QUERY_DSO

Fiscal Year to Date balance by Fund for specific DSO

GA_TB_LTD_QUERY

Life to Date balances on Projects, Funds, Accounts, Department, Source

Additional Queries

Please note – a wildcard symbol ( %) may be used in place of input field (excluding dates) if the field is unknown or the user wants all results.

EX_REPORTS_FOR_JOUNRALS

Used to show all expense reports associated with a specific journal.  Enter journal ID#

GA_ER_ACCTG_LINE_INFO

Used if expense report you are viewing is very large and you would like to see all lines in one Excel tab.

GA_EX_JOURNALS_FOR_EX_REPT

Used to show all journal entries associated with a specific expense report number (enter ER ID #).

JR_AP_VCHR_ACCTG_LINE

Used to show all journal entries associated with a specific voucher.  Enter voucher ID number.

MJ_JOURNALS_POSTED_BY_UFID

To search for journals posted by a specific user ID.

UF_AP_VOUCHER_BY_VCHR_ID

Used if voucher you are viewing is very large and you would like to see all lines on one Excel tab.

UF_AR_JRNLID_BYDIRJRNL_DEP

To view all lines of specific deposit.

UF_DEPOSIT_FROM_JRNL_ID

Find the deposit number from the journal entry number (crosswalk).

UF_GL_KK_ACTIVITY_DRILL_TRANS

Used to review budget activity in a specific cost center and for GL/KK variance review.

UF_GL_KK_EXCP_JOURNALS_AMT

To show which lines of a journal have budget errors.

UF_GL_JOURNAL_DETAIL_QUERY2

GL detail by Fund with Flex – Query to help locate a journal number if you know account, dept, fund or other ChartField information.  Also good to review activity in an account.

UF_GL_JOURNAL_DETAIL_QUERY2_F

GL detail by Fund with Flex – Query to help locate a journal number if you know account, dept, fund or flex.  Also good to review activity in an account.

UF_GL_JRNL_LN_ERR_SUMMARY

Used to view all journal lines with errors.

UF_JRNL_DRILL

Provides a detail of a journal – Used to download and view all lines of a journal in Excel format.  This is used if the journal under review is very large and would otherwise cause timing out issues in myUFL.

UF_PCARD_TXN_XWALK

Find voucher and PCard holder by PCard transaction ID.  Enter TXN number (include “TXN”)

UF_VOUCHER_FROM_JOURNAL_ID

Used to show all vouchers associated with a specific journal.  Enter journal ID number.

Last Reviewed

2/10/2020: reviewed content

Toolkits

UF HR Toolkit – Enterprise Analytics

Contacts

University Controller’s Office: (352) 392-1321

General Accounting & Financial Reporting: (352) 392-1326