GAAP Data Export - Expenditure (CT (TRAN_IND = 2)) Record - File Layout and Data Mapping

The following table lists the field names, lengths, descriptions, and data sources or valid values for the Expenditure (CT (TRAN_IND = 2)) 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 2.
FUND	3	The first three characters of the fund code.	Retrieved from the Fund field on the Expenditure Ledger.
FUNC	4	The Function code (for expenditures) or Revenue code (for revenues).	Retrieved from the Organization field (Orgn1-Orgn9) on the Expenditure Ledger. The system's Function Level setting determines which organization field is used.
OBJ	3	The Object code (expenditure account number).	Retrieved from the Account field on the Expenditure Ledger.
SCC	4	The Special Cost Center.	Retrieved from the Fund field on the Expenditure Ledger. The last four characters (positions 4-7) represent the Special Cost Center.
BEGIN_BAL	12,2	The beginning balance.	The system automatically assigns "0.00" for Expenditure records.
ORIG_BUDGET	12,2	The original budget amount.	Calculated during the data export process. The calculated value is the sum of transaction amounts from the Transaction file (TRANSACT) with transaction code "11" for the matching Key Organization and Account.
REVISED_BUDGET	12,2	The revised/current budget amount.	Calculated during the data export process. The calculated value represents the sum of budget amounts (Bud1 through Bud12, or Bud13 if Include Period 13 is selected on the GAAP Data Export page) from the Expenditure Ledger.
ACTUAL	12,2	The actual expenditure or revenue amount.	Calculated during the data export process. The calculated value represents the sum of expenditure amounts (Exp1 through Exp12, or Exp13 if Include Period 13 is selected on the GAAP Data Export page) from the Expenditure Ledger.
PRIOR_ENCUMB	12,2	The prior year encumbrance amount (carried forward).	Calculated during the data export process. The calculated value represents the sum of transaction amounts from the Transaction file (TRANSACT) with transaction code 17, where the description matches "ENCCARF" for the matching Key Organization and Account.
CURRENT_ENCUMB	12,2	The current year encumbrance amount.	Calculated during the data export process. The calculated value represents the sum of encumbrance amounts (Enc1 through Enc12, or Enc13 if Include Period 13 is selected on the GAAP Data Export page) from the Expenditure Ledger.
EXP_AGNST_ENCUMB	12,2	The expenditures against prior encumbrances.	Calculated during the data export process. The calculated value represents expenses against prior encumbrances from the Transaction file (TRANSACT) with transaction code 17 for the matching Key Organization and Account.
ACCT_DESC	50	The Account/Fund description.	The system automatically assigns an empty string for Expenditure records.
BUDGETED	1	The budgeted indicator.	The system automatically assigns an empty string for Expenditure records.
FUND_TYPE	2	The GAAP fund type code.	The system automatically assigns an empty string for Expenditure records.