Skip to content

USAS User’s Manual
Chapter 9 – Financial Inquiry (continued)

Summary Inquiries vs. Record Inquiries

Summary Inquiries

Summary Inquiries summarize data from the Cash Control, Appropriation, and Agency/Fund tables. All records matching the key elements input are summarized without regard to key elements not entered.

For example, the 59 Appropriation Summary Inquiry will show the Appropriation activity across Appropriated Funds if the Appropriated Fund field is left blank. This screen will also reflect activity for a specific Appropriated Fund if one is designated in the Appropriated Fund field.

The amounts shown on the 59 Appropriation Summary Inquiry screen below represent the total of all appropriated funds for Agency 999’s Survey and Certification Appropriation.

A picture of the USAS Appropriation Summary Inquiry screen


TEXAS  S059           UNIFORM STATEWIDE ACCOUNTING SYSTEM    09/27/95 03:01 PM
LINK TO:                  APPROPRIATION SUMMARY INQUIRY                   PROD


AGY: 999 AY: 96 APPN #: 11111   SURVEY/CERTIFICATION
APPR FUND:         FUND:          PROG:         LEVEL:    ORG:       LEVEL:
 INQ TYPE: CB  INQ YEAR: 96  INQ MONTH: 09      NET CASH ACT:      1,990,806.26-


REM CASH BASIS BUDG:     28,214,665.78      APPN CASH AVAIL:      7,560,241.74
REM ACCR BASIS BUDG:     28,214,665.78  APPN ACCR CSH AVAIL:      7,560,241.74
 REM ENC BASIS BUDG:     28,214,665.78  APPN ENC CASH AVAIL:      7,560,241.74
BT       TITLE                  AMOUNT  BT       TITLE                  AMOUNT
01 APPROP ORIGINAL B     30,568,881.00
03 APPROP TRSFRS OUT        363,180.00
11 EST COLLECTD REVE     20,654,653.00
15 CASH EXPENDITURES         17,390.41
16 CASH RSRVD - PAYR      1,973,644.81
20 CASH TRANSFERS IN            228.96





F1-HELP F3-END F4-INTERRUPT

Note: This 59 Appropriation Summary Inquiry screen does not have scrolling capability.

Record Inquiries

Record Inquiries display financial data from tables, using the control key and access path. Once a record is retrieved, a user can scroll to the next record.

For example, the 62 Appropriation Record Inquiry will allow scrolling through the Appropriated Funds associated with a particular Appropriation. If a user leaves Appropriated Fund blank, the system will default to the first Appropriated Fund for the Appropriation. Pressing F8 will scroll to the next Appropriated Fund for the Appropriation. Refer to the discussion on access paths earlier in this chapter for an example of scrolling through subsequent records.

Return to Chapter 9 Table of Contents