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:
|