GAAP Data Export - Fund Balance (CT (TRAN_IND = 1)) Record - File Layout and Data Mapping
The following table lists the field names, lengths, descriptions, and data sources or valid values for the Fund Balance (CT (TRAN_IND = 1)) Record of the GAAP Data Export report.
Field Name | Length | Description | Data Source or Valid Values |
|---|---|---|---|
FISCAL_YEAR | 4 | The fiscal year to report. | Retrieved from the Year field on the GAAP Data Export page. |
REC_ID | 2 | Identifies the record type. | The valid value is CT. |
TRAN_IND | 1 | Identifies the transaction type. | The valid value is 1. |
FUND | 3 | The first three characters of the fund code. | Retrieved from the Fund field on the General Ledger. |
FUNC | 4 | The Function code (for expenditures) or Revenue code (for revenues). | The system automatically assigns an empty string for Fund Balance records. |
OBJ | 3 | The Object code (expenditure account number). | The system automatically assigns an empty string for Fund Balance records. |
SCC | 4 | The Special Cost Center. | Retrieved from the Fund field on the General Ledger. The last four characters (positions 4-7) represent the Special Cost Center. |
BEGIN_BAL | 12,2 | The beginning balance. | Calculated during the data export process. The calculated value represents the sum of transaction amounts from the Transaction file (TRANSACT) for the Fund, filtered by the Cash Account(s) on the GAAP Data Export page. |
ORIG_BUDGET | 12,2 | The original budget amount. | The system automatically assigns 0 for Fund Balance records. |
REVISED_BUDGET | 12,2 | The revised/current budget amount. | The system automatically assigns 0 for Fund Balance records. |
ACTUAL | 12,2 | The actual expenditure or revenue amount. | The system automatically assigns 0 for Fund Balance records. |
PRIOR_ENCUMB | 12,2 | The prior year encumbrance amount (carried forward). | The system automatically assigns 0 for Fund Balance records. |
CURRENT_ENCUMB | 12,2 | The current year encumbrance amount. | The system automatically assigns 0 for Fund Balance records. |
EXP_AGNST_ENCUMB | 12,2 | The expenditures against prior encumbrances. | The system automatically assigns 0 for Fund Balance records. |
ACCT_DESC | 50 | The Account/Fund description. | The system automatically assigns an empty string for Fund Balance records. |
BUDGETED | 1 | The budgeted indicator. | The system automatically assigns an empty string for Fund Balance records. |
FUND_TYPE | 2 | The GAAP fund type code. | The system automatically assigns an empty string for Fund Balance records. |