USAS Coding Instructions
62 Appropriation Record Inquiry
Inquiry only. The Appropriation Record Inquiry (62) screen provides financial activity summed by agency, appropriation year (AY), appropriation number and appropriated fund or fund.
The 62 screen displays data from the appropriation (AP) financial table. The ability to recall data on this screen by appropriated fund or fund, or any of the other optional elements is determined by how the data is posted to the AP table. The posting levels for the AP table are controlled centrally on the Appropriated Fund Profile (D22) and the Appropriation Number Profile (20). Refer to individual fields for information on the related posting level indicator.
Statewide posting levels for the AP are set as follows:
| Post | Do Not Post |
|---|---|
| Agency | Comptroller source/group |
| AY | Object (LBB or comptroller object) |
| Appropriated fund | Fund Program code Organization code |
Note: For detail-level inquiries using fund, object, program code, organization code, etc., use the Appropriation Agency Detail Inquiry (67) screen.
TEXAS S062 UNIFORM STATEWIDE ACCOUNTING SYSTEM MM/DD/YY HH:MM 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: INQ MONTH: 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
When the report route agency on the D22 profile 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.
AGENCY (Required for recall)
Enter the three-digit agency number assigned to the agency.
APPN YEAR (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 APPN 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 20 screen.
The title of the appropriation will be displayed following the appropriation number (up to 40 characters).
APPR FUND (Optional for recall – Determined by centrally defined posting levels)
Enter the four-digit appropriated fund. Appropriated funds are centrally defined on the D22 screen. If left blank, the system will display the first appropriated fund/appropriation combination and F8 can be used to scroll to subsequent appropriated funds.
The ability to recall data on this screen by appropriated fund or fund is dependent on the centrally defined posting level indicators on the D22 screen in the APPROPRIATION – LEVEL field.
FUND (Optional for recall – Determined by centrally defined posting levels)
Enter the four-digit fund. Funds are agency defined on the Fund Profile (D23).
The ability to recall data on this screen by appropriated fund or fund is dependent on the centrally defined posting level indicators on the D22 screen in the APPROPRIATION – LEVEL field.
COMP SRC/GRP (Not available on this inquiry screen)
LBB/COMP OBJ (Not available on this inquiry screen)
PRG CD (Optional for recall – Determined by centrally defined posting levels)
Enter the four-digit program code. Program codes are agency defined on the Program Code Profile (D04).
The ability to recall data on this screen by program code is dependent on centrally defined posting level indicators on the 20 screen in the APPN LEVEL – PROG field.
LVL (System generated)
Displays the program code level.
The title of the program code will be displayed following the program code level (up to 18 characters).
ORG CD (System generated)
Enter the four-digit organization code. Organization codes are agency defined on the Organization Code Profile (D03).
The ability to recall data on this screen by organization code is dependent on centrally defined posting level indicators on the 20 screen in the APPN LEVEL – ORGANIZATION field.
LVL (System generated)
Displays the organization code level.
The title of the organization code will be displayed following the organization code level (up to 15 characters).
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 balances – System generated)
Displays the net cash activity. For Inquiry Screen Algorithms, please see USAS Reference.
REM CASH BASIS BUDG (Calculated balances – System generated)
Displays the remaining cash basis budget. For Inquiry Screen Algorithms, please see USAS Reference.
APPN CASH AVAIL (Calculated balances – System generated)
Displays the appropriation cash available. For Inquiry Screen Algorithms, please see USAS Reference.
CREM ACCR BASIS BUDG (alculated balances – System generated)
Displays the remaining accrued basis budget. For Inquiry Screen Algorithms, please see USAS Reference.
APPN ACCR CSH AVAIL (Calculated balances – System generated)
Displays the appropriation accrued cash available. For Inquiry Screen Algorithms, please see USAS Reference.
REM ENC BASIS BUDG (Calculated balances – System generated)
Displays the remaining encumbered basis budget. For Inquiry Screen Algorithms, please see USAS Reference.
APPN ENC CASH AVAIL (Calculated balances – 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 (D05).
TITLE (System generated)
Displays the title of the balance type from the Balance Type Profile (D05).
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. |
| F8 | (Frwd) Retrieves the following page of information. If the appropriated fund is blank for the initial financial data recall, F8 will retrieve the next record for the agency, AY and appropriation number. |