EPM Queries

 

Navigation to PS Query = View > Navigator Display > Query.

Choose query and double click.

If you wish to run it to EXCEL, right click and click on Run to Excel.

Budget Queries

Cash Queries

General Queries

Grant Queries

Program Queries

Budget Queries

Query Name Query Purpose
ULGL_BUDGETS_BY_PROG_FY All Budget Journals for a Fiscal Year
ULGL_BUDGETS_BY_GRANT Budget Journals PTD

Cash Queries

Query Name Query Purpose
ULGL_CASH_BY_ACCTG_PERIOD Cash Total by Acconting Period
ULGL_CASH_BAL_BY_PROJ/GRANTS Cash Balances by Project/Grant
ULGL_CASH_BY_DEPT_ACCTG_PERIOD Cash Transactions Department and Accounting Period
ULGL_CASH_BY_DEPT_YTD Cash Totals by Dept
ULGL_CASH_FUND_PERIOD Cash Totals by Fund and Period
ULGL_BY_PROG_ACCTG_PERIOD Cash Totals by Prog Acctg Period

General Queries

Query Name Query Purpose
ULGL_ACCT_LISTING_BY_TYPE List of Valid GL Accounts by Type
ULGL_ACCT_TRANS_DEPT_PERIOD Account Totals by Department and Account and Period
ULGL_DEPARTMENT_LISTING List of Valid GL Departments
ULGL_SPEEDTYPES Speedtypes by Department
ULGL_SPEEDTYPE_INFORMATION Speedtype Information
ULGL_SPEEDTYPES_ALL All Speedtypes and Information
ULGL_STATUS_GRANT Grant Status Information
ULGL_STATUS_PROGRAM Program Status Information
ULGL_DEPT_LIST List Valid PS Departments
ULGL_TRANS_BY_JOURNAL_NUMBER Transactions by Journal Number(Listing)
ULGL_TRANS_BY_SOURCE_DATE Trans By Source and Posted Date
ULGL_TRANS_BY_SOURCE_PERIOD Trans by Source and Period
ULGL_TRANS_BY_DEPT_PERIOD Trans by Department and Period
ULGL_TRANS_BY_DEPT_YTD Trans by Department YTD

Return to Top of Page

Grant Queries

Query Name Query Purpose
ULGL_GRANT_ACCT_TOTALS_PTD Project-to-date Acct Totals for a Specific Grant
ULGL_GRNT_ACCT_TOTALS_YTD Grant Account Totals YTD
ULGL_GRNT_ACCT_TOTALS_PTD_DEPT PTD Grant Totals for a Department
ULGL_GRNT_TRANS_BY_FY Fiscal Year Detail Transactions for a Specific Grant
ULGL_GRNT_TRANS_BY_PERIOD Grant Transactions by Period and Fiscal Year
ULGL_GRNT_TRANS_BY_PER_AND_SOURCE Grant Transactions by Per Source and FY
ULGL_GRNT_TRANS_PTD Grant Transactions Project to Date
ULGL_GRNT_PRMST_COMPARE Grant Parent/Child Compare
ULGL_VENDOR_PAY_BY_GRANT Vendor Payments by Grant(Listing)

Program Queries

Query Name Query Purpose
ULGL_PROG_TRANS_BY_PERIOD Transactions by Period for a Specific Program
ULGL_PROG_TRANS_FY Program Transactions for a Fiscal Year
ULGL_PROG_TRANS_BY_SOURCE_PERIOD Program Transactions by Source and Period
ULGL_PROGRAM_TOTALS YTD Totals for Budgets, Expenses, Encumbrances and Pre-Encumbrances by Programs and Fiscal Year
ULGL_DEPT_PROGRAM_TOTALS YTD Program Totals for Budgets, Expenses,
Encumbrances by Department and Fiscal Year
ULGL_VENDOR_PAY_BY_PROGRAM Vendor Payments by Program

Return to Top of Page

Budget & Financial Planning
Email:

Grawemeyer Hall
Room 20
Louisville, KY 40292

Bursar's Office
Phone: 502-852-6503

Houchens Building
Room 101
Louisville, KY 40292

Controller's Office Administration
Phone: 502-852-6164

Service Complex
2nd Floor
Louisville, KY 40292

Accounts Payable and Travel
Phone: 502-852-8237

Service Complex
2nd Floor
Louisville, KY 40292

Payroll Office
Phone: 502-852-2978

Service Complex
2nd Floor
Louisville, KY 40292

Position Management
Phone: 502-852-2346

Grawemeyer Hall
Room 20
Louisville, KY 40292