Inquiries

This section includes all of the inquiries used in the Financial Administration area, listed alphabetically. For more information on each inquiry, refer to the appropriate link in the Page Code column.

Inquiry Name

Page Code

Description

Accounting Journal and Ledger Query

JLACTGQY

An inquiry that allows you to locate an account at a Fiscal Year level of detail, drill down to see Accounting Period breakdowns of that account, and finally drill down into the individual transactions that make up the account.

Cash Balance Detail

CBALDQ

An inquiry that displays current balances for cash tracking amounts for a Fund and Sub Fund combination. This page optionally provides cash editing at the detail level.

Cash Balance Pool

CBALPQ

An inquiry that displays current balances for cash tracking amounts for a Fund Type. This page optionally provides editing at the pool level.

Tracking is optional at this level and not done unless the Application Parameters (APPCTRL) page option of Pool Cash Balance Tracking is turned on.

Cash Balance Summary

CBALSQ

An inquiry that displays current balances for cash tracking amounts for a Fund. This page optionally provides cash editing at the summary level.

Fund Balance Accounting Period Inquiry

FBALAPD

An inquiry providing a subset of the Trial Balance Inquiry (TBAL) page that shows only nominal account activity and that is summarized information at a level higher than individual department, object, and revenue source codes. Unlike the Fund Balance Detail (FBALDQ) and Fund Balance Summary (FBALSQ) that provide inception-to-date information, this inquiry provides information up to and including a specified accounting period (APD).

Fund Balance Detail

FBALDQ

An inquiry that displays current balances for fund balance tracking amounts for a Fund and Sub Fund combination. This page provides fund balance editing at the detail level.

Fund Balance Summary

FBALSQ

An inquiry that displays current balances for fund balance tracking amounts for a Fund. This page provides fund balance editing at the summary level.

FY Balance Details

BBALFY

An inquiry that displays account balances at the Fiscal Year, Fund, Sub Fund, BSA, and Sub BSA combination.

ITD Balance Sheet Detail

BBALD

An inquiry that displays current balances for balance sheet account balances at a Fund, Sub Fund, BSA, and Sub BSA combination. This page can also provide transaction editing.

ITD Balance Sheet Summary

BBALS

An inquiry that displays current balances for balance sheet account balances at a Fund and BSA combination. This page can also provide transaction editing.

Journal/Ledger Cross-Reference

JLXREF

An inquiry used for auditing purposes that tracks which journal records have been posted to which ledger records.

Journal Log

JLOG

 

Ledgerization Log

JLOGLDGR

An inquiry that provides processing details of the Ledger Engine system process.

Process Log

PLOG

This inquiry tracks the last successful run date and timestamp of several system process.

Trial Balance Inquiry

TBAL

The Trial Balance Inquiry (TBAL) provides real-time information similar to trial balance reports.