FMX Home
Glenn Hegar  ·  Texas Comptroller of Public Accounts

USAS Coding Instructions > previous | next

USAS Coding Instructions

67 Appropriation Agency Detail Inquiry

Inquiry only. The Appropriation Agency Detail Inquiry (67) screen provides inquiry at a summary level (agency, appropriation year (AY) and appropriation) or at a detail level (program code, object, fund, etc.) for an agency’s appropriations.

The 67 screen displays data from the agency fund (AF) table. Posting to the AF table is controlled by the file posting indicators on the Transaction Code Decision Profile (28A) for the appropriation (AP) table.

 TEXAS  S067           UNIFORM STATEWIDE ACCOUNTING SYSTEM    MM/DD/YY HH:MM PM 
 LINK TO:              APPROPRIATION AGENCY DETAIL INQUIRY                      
                                                                                
 AGY:     APPN YEAR:         APPN #:                                            
           D23 FUND:       APPR FUND:                                           
 PRG CD:        LVL:                      ORG CD:      LVL:                     
   COMP SRCE GRP:      LBB/COMP/AGY OBJ:                                        
  INQ TYPE:     INQ YEAR:     INQ MONTH:     NET CASH ACT:                      
  REM CASH BDGT:                          APPN CASH AVAIL:                      
  REM ACCR BDGT:                         APN ACCR CSH AVL:                      
   REM ENC BDGT:                         APPN ENC CSH AVL:                      
 BT       TITLE                  AMOUNT  BT       TITLE                  AMOUNT 
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
 F1-HELP F3-END F4-INTERRUPT F7-BKWD F8-FRWD                                    
 

When the report route agency on the Appropriated Fund Profile (D22) is included in the AGY GROUP or RANGE 1/RANGE 2 or as the SECURITY AGENCY on the user’s Security Profile (96A), this inquiry screen can be used to view shared appropriated fund activity for each agency that operates out of that appropriated fund.

AGY (Required for recall)
Enter the three-digit agency number assigned to the agency.

APPN YR (Required for recall)
Enter the two-digit appropriation year. The appropriation year is the year for which funds are appropriated by the Legislature for setting up budgets, depositing money and paying obligations.

Note: If appropriation year is left blank, the screen will default to the current year.

APPN # (Required for recall)
Enter the five-digit appropriation number. Appropriation numbers are centrally defined on the Appropriation Number Profile (20).

The title of the appropriation will be displayed following the appropriation number (up to 40 characters).

D23 FUND (Optional for recall)
Enter the four-digit fund number. Funds are agency defined on the Fund Profile (D23).

APPR FUND (Optional for recall)
Enter the four-digit appropriated fund number. Appropriation funds are centrally defined on the D22 profile.

PRG CD (Optional for recall)
Enter the four-digit program code. Program codes are agency defined on the Program Code Profile (DØ4).

LVL (System generated)
Displays the level of the strategic (program) structure (see Data Classification Structure on the USAS Reference page) and title, based on program code.

The title of the program code will be displayed following the program code level (up to 18 characters).

ORG CD (Optional for recall)
Enter the four-digit organization code. Organization codes are agency defined on the Organization Code Profile (DØ3).

LVL (System generated)
Displays the level of the organization structure (see Data Classification Structure on the USAS Reference page) and title, based on the organization code.

The title of the organization code will be displayed following the organization code level (up to 15 characters).

COMP SRCE GRP (Optional for recall)
Enter the four-digit comptroller source group. Comptroller source groups are centrally defined on the Comptroller Source/Group Profile (DØ9).

LBB/COMP/AGY OBJ (Optional for recall)

Note: This is a split field. The first field is the Legislative Budget Board (LBB) object (LBB OBJ), second field is the comptroller object (COMP OBJ) and third field is the agency object (AGY OBJ).

Enter the four-digit LBB object. LBB objects are centrally defined on the LBB Object Profile (DØ1).

Enter the four-digit comptroller object. Comptroller objects are centrally defined on the Comptroller Object Profile (D1Ø).

Enter the four-digit agency object. Agency objects are agency defined on the Agency Object Profile (D11).

INQ TYPE (Required for recall)
Enter the two-character inquiry type. The inquiry type is a combination of year and activity. It defines the period of time in which the inquiry will be made.

CB Current balance (Default). Displays the cumulative activity through the requested INQ YEAR and INQ MONTH.
MA Monthly activity. Displays the month’s activity for the requested INQ YEAR and INQ MONTH.
PA Prior activity. Displays the prior year’s activity for the requested INQ YEAR (including month 13 activity*) without regard to INQ MONTH.
PP Prior prior. Displays the prior prior year’s cumulative activity for the requested INQ YEAR (including month 13 activity*) without regard to INQ MONTH.
PY Prior year. Displays the prior year’s cumulative activity for the requested INQ YEAR (including month 13 activity*) without regard to INQ MONTH.
YA Year activity. Displays the year-to-date activity for the requested INQ YEAR and INQ MONTH.

*Note: Month 13 reflects activity occurring in the financial reporting adjustment period of 08/32/YYYY.

INQ YEAR (Required for recall)
Enter the two-digit fiscal year of the inquiry. The fiscal year is the year used in the generally accepted accounting principles (GAAP)-based financial reports and spans September through August. The INQ YEAR defaults to current fiscal year based on the current year indicator on the System Management Profile (97).

INQ MONTH (Required for recall)
Enter the two-digit calendar month of the inquiry. An INQ MONTH of 13 is a valid value and reflects activity occurring in the financial reporting adjustment period of 08/32/YYYY. The INQ MONTH defaults to current calendar month based on the current month indicator on the 97 profile.

NET CASH ACT (Calculated balance – System generated)
Displays the net cash activity. For Inquiry Screen Algorithms, please see USAS Reference.

REM CASH BDGT (Calculated balance – System generated)
Displays the remaining cash basis budget. For Inquiry Screen Algorithms, please see USAS Reference.

APPN CASH AVAIL (Calculated balance – System generated)
Displays the appropriation cash available. For Inquiry Screen Algorithms, please see USAS Reference.

REM ACCR BDGT (Calculated balance – System generated)
Displays the remaining accrued basis budget. For Inquiry Screen Algorithms, please see USAS Reference.

APN ACCR CSH AVL (Calculated balance – System generated)
Displays the appropriation accrued cash available. For Inquiry Screen Algorithms, please see USAS Reference.

REM ENC BDGT (Calculated balance – System generated)
Displays the remaining encumbered basis budget. For Inquiry Screen Algorithms, please see USAS Reference.

APPN ENC CSH AVL (Calculated balance — System generated)
Displays the appropriation encumbered cash available. For Inquiry Screen Algorithms, please see USAS Reference.

BT (System generated)
Displays the balance type information. For Balance Types, please see Balance Type Profile (DØ5).

TITLE (System generated)
Displays the title of the balance type from the Balance Type Profile (DØ5).

AMOUNT (System generated)
Displays the cumulative total of all applicable transactions for the specified balance type.

Function Key Definitions

F1 (Help) Automatically links to the News/Help Table (90) screen. Will transfer to the appropriate type of help depending upon the screen and activity the user is on at the time F1 is pressed.
F3 (End) Returns the screen to the menu associated with that screen.
F4 (Interrupt) Initiates or ends an active interrupt. When ending an active interrupt, F4 returns the user to the original screen showing the same information as was on the screen when the active interrupt was initiated. This does not undo the last action.
F7 (Bkwd) Retrieves the previous page of recalled information.
F8 (Frwd) Retrieves the following page of recalled information within the selection criteria entered.
Glenn Hegar
Texas Comptroller of Public Accounts
Questions? Contact statewide.accounting@cpa.texas.gov
Comptroller.Texas.Gov | FMX
FMX Sitemap | Contact FM
Accessibility Policy | Privacy and Security Policy