USAS User’s Manual –
Chapter 9 – Financial Inquiry
Overview of Financial Inquiry
About this Chapter
Financial inquiry provides the capability to view financial balances and transactions. It also assists users in transaction entry, error correction, and account monitoring. Inquiry capability is intended to augment, not replace, USAS reporting.
Accessing Financial Inquiry Screens
Inquiry screens can be accessed using the following methods of navigation.- A user may select ‘O’ on the Main Menu to view the financial inquiry submenu and then view the desired inquiry screen by selecting the screen’s number.
- A user may also use the shortcut of linking to ‘MO.’
- A user may also use ‘Link To’ or ‘Interrupt’ to directly go to the desired inquiry screen.
Note: Whether or not a user can view an inquiry screen is determined by the logon user ID, user class, and the associated 96B Security Profile.
Inquiry Screen Standards
Each inquiry screen is merely an inquiry into one of the USAS Financial Tables. For example, the 59 Appropriation Summary and the 62 Appropriation Record Inquiry screens are inquiries on the balances maintained in the Appropriation Financial Table.
To determine which financial table is being accessed, look on the Financial Inquiry Menu (option ‘O’ on the USAS Main Menu); the table is abbreviated in the column next to the screen listing. For example, the 62 Appropriation Record Inquiry screen comes from the Appropriation (AP) Table.
A picture of the USAS Financial Inquiry Menu screen
TEXAS S014 UNIFORM STATEWIDE ACCOUNTING SYSTEM 09/27/95 05:33 PM LINK TO: FINANCIAL INQUIRY MENU PROD ENTER SCREEN ID: 61 AGENCY BUDGET RECORD (AB) 66 GRANT RECORD (GP) 62 APPROPRIATION RECORD (AP) 68 CONTRACT RECORD (CF) 59 APPROPRIATION SUMMARY (AP) 46 CASH EXPENDITURES BY MONTH (GL) 69 AGENCY/FUND RECORD (AF) 47 CASH REVENUES BY MONTH (GL) 58 AGENCY/FUND SUMMARY (AF) 49A REVENUE OR EXPENDITURE (GL) 80 PROJECT RECORD (PJ) 63 CASH CONTROL RECORD (CC) 57 CASH CONTROL SUMMARY (CC) 84 ACCOUNTING EVENT RECORD (AE) 85 VENDOR TRANSACTIONS (AE) 64 DOCUMENT RECORD (DF) 86 DOCUMENT TRANSACTIONS (AE) 56 GENERAL LEDGER SUMMARY (GL) 65 GENERAL LEDGER RECORD (GL) F1-HELP F3-END F4-INTERRUPT
Table IDs include: AB Agency Budget Table CF Contract Table AE Accounting Event Table DF Document Table AF Agency Fund Table GL General Ledger Table AP Appropriation Table GP Grant/Phase Table CC Cash Control Table PJ Project Table
Control Key
The Control Key is a combination of elements creating a unique record in the Financial Table. Each screen has its own unique control key. The control key for the 62 Appropriation Record Inquiry screen is highlighted below.
A picture of the USAS Appropriation Record Inquiry screen
TEXAS S062 UNIFORM STATEWIDE ACCOUNTING SYSTEM 11/14/95 04:26 PM LINK TO: APPROPRIATION RECORD INQUIRY PROD AGY: APPN YEAR: APPN #: APPR FUND: FUND: COMP SRCE/GRP: LBB/COMP OBJ: PRG CD: LVL: ORG CD: LVL: INQ TYPE: CB INQ YEAR: 96 INQ MONTH: 11 NET CASH ACT: REM CASH BASIS BUDG: APPN CASH AVAIL: REM ACCR BASIS BUDG: APPN ACCR CSH AVAIL: REM ENC BASIS BUDG: APPN ENC CASH AVAIL: BT TITLE AMOUNT BT TITLE AMOUNT F1-HELP F3-END F4-INTERRUPT F8-FRWD
Access Paths
Access Paths are the required elements that must be entered to view the information in an inquiry screen. An access path is a subset of the control key that allows efficient inquiry. Each inquiry screen has at least one access path; some have several. If an appropriate access path is entered, the first record meeting the search criteria provided by the access path will be retrieved. The user can then press F8 to scroll through additional records.
In the example below, the access path used is Agency, Appropriation Year, and Appropriation Number. The record retrieved is the first Appropriated Fund associated with that Appropriation. In this example, the first Appropriated Fund is 0001 General Revenue.
A picture of the USAS Appropriation Record Inquiry screen
TEXAS S062 UNIFORM STATEWIDE ACCOUNTING SYSTEM 11/14/95 04:26 PM LINK TO: APPROPRIATION RECORD INQUIRY PROD AGY: 121 APPN YEAR: 96 APPN #: 11002 EDUCATION & TRAINING APPR FUND: 0001 FUND: COMP SRCE/GRP: LBB/COMP OBJ: PRG CD: LVL: ORG CD: LVL: INQ TYPE: CB INQ YEAR: 96 INQ MONTH: 11 NET CASH ACT: 29,356.06- REM CASH BASIS BUDG: 160,643.94 APPN CASH AVAIL: 160,643.94 REM ACCR BASIS BUDG: 160,643.94 APPN ACCR CSH AVAIL: 160,643.94 REM ENC BASIS BUDG: 159,987.94 APPN ENC CASH AVAIL: 159,987.94 BT TITLE AMOUNT BT TITLE AMOUNT 01 APPROP ORIGINAL B 190,000.00 15 CASH EXPENDITURES 28,645.98 16 CASH RSRVD - PAYR 710.08 18 ENCUMBRNCES OUTST 656.00 F1-HELP F3-END F4-INTERRUPT F8-FRWD
Press F8 to scroll to the next Appropriated Fund in that Appropriation.
A picture of the USAS Appropriation Record Inquiry screen
TEXAS S062 UNIFORM STATEWIDE ACCOUNTING SYSTEM 11/14/95 04:27 PM
LINK TO: APPROPRIATION RECORD INQUIRY PROD
AGY: 121 APPN YEAR: 96 APPN #: 11002 EDUCATION & TRAINING
APPR FUND: 0119 FUND: COMP SRCE/GRP: LBB/COMP OBJ:
PRG CD: LVL: ORG CD: LVL:
INQ TYPE: CB INQ YEAR: 96 INQ MONTH: 11 NET CASH ACT: 28,694.84
REM CASH BASIS BUDG: 78,524.84 APPN CASH AVAIL: 28,694.84
REM ACCR BASIS BUDG: 78,524.84 APPN ACCR CSH AVAIL: 28,694.84
REM ENC BASIS BUDG: 78,524.84 APPN ENC CASH AVAIL: 28,694.84
BT TITLE AMOUNT BT TITLE AMOUNT
01 APPROP ORIGINAL B 60,000.00
06 UNEXPENED BALANCE 35,000.00
11 EST COLLECTD REVE 95,000.00
12 CASH REVENUES 45,170.00
14 ACCRUED REVENUES 907.24
15 CASH EXPENDITURES 14,156.66
16 CASH RSRVD - PAYR 2,318.50
F1-HELP F3-END F4-INTERRUPT F8-FRWD
To successfully inquire on inquiry screens, the user must understand the level at which information is posted (or stored). A user can only make an inquiry at the level the information was stored on the financial table which is accessed by a particular inquiry screen. The reason that some screens have many access paths is that information can be posted at many levels.
Note: Not all access paths for a particular inquiry screen will successfully recall inquiry information. Which access paths are valid depends on how the information was stored on the financial table. Chapter 12 – Understanding Financial Tables in the USAS User’s Manual explains posting levels in detail.
For example, statewide policy dictates that on the Appropriation Financial Table (AP), the Appropriated Fund information is retained but Agency Fund detail is not. Since the AP table is the data source for the 62 Appropriation Record Detail inquiry screen, the user cannot successfully retrieve information that is Agency Fund specific using this inquiry screen.
Inquiring at the Appropriated Fund level will retrieve the desired information:
A picture of the USAS Appropriation Record Inquiry screen
TEXAS S062 UNIFORM STATEWIDE ACCOUNTING SYSTEM 11/15/95 11:08 AM
LINK TO: APPROPRIATION RECORD INQUIRY PROD
AGY: 100 APPN YEAR: 96 APPN #: 11001 GENERAL BUDGET
APPR FUND: 5555 FUND: COMP SRCE/GRP: LBB/COMP OBJ:
PRG CD: LVL: ORG CD: LVL:
INQ TYPE: CB INQ YEAR: 96 INQ MONTH: 11 NET CASH ACT: 256,445,703.61
REM CASH BASIS BUDG: 256,445,703.61 APPN CASH AVAIL: 256,445,703.61
REM ACCR BASIS BUDG: 256,445,703.61 APPN ACCR CSH AVAIL: 256,445,703.61
REM ENC BASIS BUDG: 256,445,703.61 APPN ENC CASH AVAIL: 256,445,703.61
BT TITLE AMOUNT BT TITLE AMOUNT
12 CASH REVENUES 437,537,857.04
15 CASH EXPENDITURES 85,255,770.43
17 ACCRUED EXPENDITU .00
21 CASH TRANSFERS OU 95,836,383.00
F1-HELP F3-END F4-INTERRUPT F8-FRWD
In the following example, the user tried to inquire at the Agency Fund detail level. Since that level of detail is not retained on the AP table, the message ‘NO RECORD FOUND’ appears at the bottom of the inquiry screen:
A picture of the USAS Appropriation Record Inquiry screen
TEXAS S062 UNIFORM STATEWIDE ACCOUNTING SYSTEM 11/15/95 11:13 AM LINK TO: APPROPRIATION RECORD INQUIRY PROD AGY: 100 APPN YEAR: 96 APPN #: 11001 GENERAL BUDGET APPR FUND: FUND: 5555 COMP SRCE/GRP: LBB/COMP OBJ: PRG CD: LVL: ORG CD: LVL: INQ TYPE: CB INQ YEAR: 96 INQ MONTH: 11 NET CASH ACT: .00 REM CASH BASIS BUDG: .00 APPN CASH AVAIL: .00 REM ACCR BASIS BUDG: .00 APPN ACCR CSH AVAIL: .00 REM ENC BASIS BUDG: .00 APPN ENC CASH AVAIL: .00 BT TITLE AMOUNT BT TITLE AMOUNT NO RECORD FOUND F1-HELP F3-END F4-INTERRUPT F8-FRWD
Inquiry Type
An inquiry type is a combination of year and activity. It defines the period of time to be selected for inquiry. The following are valid inquiry types and the information displayed on each type.
- MA — Selected month’s activity
- YA — Year-to-date activity
- CB — Inception-to-date balance; default inquiry type
- PA — Prior year activity
- PY — Prior year balances
- PP — Prior prior year balances
Inquiry Year
The Inquiry Year identifies the fiscal year to be selected for inquiry. This will be the current open fiscal year. The prior fiscal year can also be used until the prior year data has been archived.
For example: To recall information for the period September 1, 1995-August 31, 1996, inquiry year ‘96’ would be entered.
Inquiry Month
The Inquiry Month identifies the calendar month to be selected for inquiry.
Note: On USAS inquiry screens, the inquiry month is a calendar month, instead of a fiscal month. This is one of the only instances where calendar month is used in the system. Month ‘13’ is used to display adjustment period balances.
For example: To recall information for the month of September 1995, the inquiry month would be ‘09.’
Balance Type and Title (BT)
Some inquiry screens display Balance Types that have been posted to the Financial Table. The title of the balance type is also displayed. The amount associated with the balance type is the cumulative total of all transactions posted to the balance type for that record in the financial table.
Calculated Balances
Most inquiry screens contain one or more calculated amounts. These are called Calculated Balances. The calculations are based on the amounts shown for each balance type for that record (row) on the financial table. The algorithms for each calculated balance can be found in the discussion for each inquiry screen and in the USAS Reference Guide.