GAAP Data Export - Fund Definition (AF) Record - File Layout and Data Mapping
The following table lists the field names, lengths, descriptions, and data sources or valid values for the Fund Definition (AF) 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 AF. |
TRAN_IND | 1 | Identifies the transaction type. | The system automatically assigns a space (" ") for Fund Definition records. |
FUND | 3 | The first three characters of the fund code. | Retrieved from the Key Organization field on the Organization Chart page. |
FUNC | 4 | The Function code (for expenditures) or Revenue code (for revenues). | The system automatically assigns an empty string for Fund Definition records. |
OBJ | 3 | The Object code (expenditure account number). | The system automatically assigns an empty string for Fund Definition records. |
SCC | 4 | The Special Cost Center. | Retrieved from the Key Organization field on the Organization Chart page. 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 Fund Definition records. |
ORIG_BUDGET | 12,2 | The original budget amount. | The system automatically assigns 0 for Fund Definition records. |
REVISED_BUDGET | 12,2 | The revised/current budget amount. | The system automatically assigns 0 for Fund Definition records. |
ACTUAL | 12,2 | The actual expenditure or revenue amount. | The system automatically assigns 0 for Fund Definition records. |
PRIOR_ENCUMB | 12,2 | The prior year encumbrance amount (carried forward). | The system automatically assigns 0 for Fund Definition records. |
CURRENT_ENCUMB | 12,2 | The current year encumbrance amount. | The system automatically assigns 0 for Fund Definition records. |
EXP_AGNST_ENCUMB | 12,2 | The expenditures against prior encumbrances. | The system automatically assigns 0 for Fund Definition records. |
ACCT_DESC | 50 | The Account/Fund description. | Retrieved from the Title field on the Organization Chart page. |
BUDGETED | 1 | The budgeted indicator. | Valid values:
Calculated during the data export process. The system checks the Transaction file for budget transactions (codes 11 or 12) for the fund. Returns Y if budget transactions exist, otherwise N. |
FUND_TYPE | 2 | The GAAP fund type code. | Retrieved from the EMIS Fund Class Code field on the OH Fund Class Codes page. The one-character EMIS code is translated to a two-character FUND_TYPE as follows:
|