ACR 60527 – USAS System Change
Effective Aug. 4, 2022

Introduction

Application Change Request (ACR) 60527 for the Uniform Statewide Accounting System (USAS) repurposed certain fields on the Comptroller Object (D10) profile and Appropriated Fund (D22) profile for use in preparing the State of Texas Annual Cash Report. This change is effective Aug. 4, 2022.

Issue

Portions of the State of Texas Annual Cash Report are compiled from data on the USAS financial tables using specific fields on the D10 profile to identify cash report activity. However, there is not a field that identifies revenue objects related to federal activity, which is presented in the cash report, Table 5: Federal Revenue by Function and Program Category and Table 6: Federal Revenue by Agency. Therefore, manual analysis is required to determine the federal activity.

Additionally, the cash report is presented at the appropriated fund level by type of fund, such as general revenue, special revenue, trust or non-trust. Because there is not a field on the D22 profile to readily identify the appropriated fund type, classifying the funds for cash report presentation also requires manual analysis.

Solution

Using profile field values to identify federal revenue activity and appropriated fund type eliminates the need for manual analysis, creating time-savings and greater data-gathering efficiency for compiling the cash report.
To implement this solution, the following changes were made to the D10 and D22 profiles:

The unused CONVERTED OBJECT field on the D10 profile was renamed to FEDERAL MATCH IND and repurposed to identify revenue objects related to federal activity. See the Comptroller Object Profile (D10) in the USAS Coding Instructions (FPP Q.010) for more information.
The unused CASH BALANCE DISPOSITION DESCRIPTION field on the D22 profile was renamed to CASH REPORT FUND TYPE and repurposed to identify the appropriated fund type for the cash report. See the Appropriated Fund Profile (D22) in the USAS Coding Instructions (FPP Q.010) for more information.

Note: The new field titles were not updated on the corresponding profile tables. To obtain the new indicator values, query the profile tables as follows:

For the federal match indicator values on the comptroller object table, query on the CONVERTED OBJECT field.
For the appropriated fund type indicator values on the appropriated fund table, query on the CASH BALANCE DISPOSITION DESCRIPTION field.

Screens Affected

For More Information

Contact your agency’s financial reporting analyst for information.

ACR 60527 – USAS System Change Effective Aug. 4, 2022