GAAP Data Export - Revenue (CT (TRAN_IND = 3)) Record - File Layout and Data Mapping

The following table lists the field names, lengths, descriptions, and data sources or valid values for the Revenue (CT (TRAN_IND = 3)) 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 3.
FUND	3	The first three characters of the fund code.	Retrieved from the Fund field on the Revenue Ledger.
FUNC	4	The Function code (for expenditures) or Revenue code (for revenues).	Calculated during the data export process. If the first character of the Account field on the Revenue Ledger is a letter (A-Z), the system extracts characters 2-5 from the Account field. Otherwise, an empty string is assigned.
OBJ	3	The Object code (expenditure account number).	The system automatically assigns an empty string for Revenue records.
SCC	4	The Special Cost Center.	Retrieved from the Fund field on the Revenue 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 Revenue 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 where transaction code = 12 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 Bud1 through Bud12 (plus Bud13 if Include Period 13 is selected on the GAAP Data Export page) from the Revenue Ledger.
ACTUAL	12,2	The actual expenditure or revenue amount.	Calculated during the data export process. The calculated value represents the sum of Exp1 through Exp12 (plus Exp13 if Include Period 13 is selected on the GAAP Data Export page) from the Revenue Ledger.
PRIOR_ENCUMB	12,2	The prior year encumbrance amount (carried forward).	The system automatically assigns 0 for Revenue records.
CURRENT_ENCUMB	12,2	The current year encumbrance amount.	The system automatically assigns 0 for Revenue records.
EXP_AGNST_ENCUMB	12,2	The expenditures against prior encumbrances.	The system automatically assigns 0 for Revenue records.
ACCT_DESC	50	The Account/Fund description.	The system automatically assigns an empty string for Revenue records.
BUDGETED	1	The budgeted indicator.	The system automatically assigns an empty string for Revenue records.
FUND_TYPE	2	The GAAP fund type code.	The system automatically assigns an empty string for Revenue records.