The following table lists the field names, descriptions, positions, lengths, and data sources or valid values for the UFARS report's Expenditure (E) and Revenue (R) record.
|
Field Name |
Description |
Position |
Length |
Data Source or Valid Values |
|---|---|---|---|---|
|
Account ID |
Indicates whether this is an Expenditure or Revenue record. |
1 |
1 |
Valid values:
System-generated based on record type. |
|
District ID |
The unique identifier assigned to your school district by the Minnesota Department of Education. |
2-5 |
4 |
Retrieved from the District ID field on the MN UFARS Report - Setup - District Settings page. |
|
District Type |
The classification code that identifies the type of educational organization. |
6 |
1 |
Retrieved from the District Type field on the MN UFARS Report - Setup - District Settings page. |
|
Summary Account |
The summary account code. |
7-9 |
3 |
Retrieved from the Exp Control or Rev Control field on the Funds/Accounts tab of the Fund Accounting Profile page. |
|
Fund |
The UFARS Fund code. |
10-11 |
2 |
Retrieved from the Organization/Account Level field on the Fund row of the MN UFARS Report - Reporting Structure page, then translated using the MN UFARS Report - Setup - Data Crosswalk - Fund page. |
|
Organization |
The UFARS Organization code. |
12-15 |
4 |
Retrieved from the Organization/Account Level field on the Org row of the MN UFARS Report - Reporting Structure page, then translated using the MN UFARS Report - Setup - Data Crosswalk - Org page. |
|
Program |
The UFARS Program code. |
16-18 |
3 |
Retrieved from the Organization/Account Level field on the Program row of the MN UFARS Report - Reporting Structure page, then translated using the MN UFARS Report - Setup - Data Crosswalk - Program page. |
|
Finance |
The UFARS Finance code. |
19-21 |
3 |
Retrieved from the Organization/Account Level field on the Finance row of the MN UFARS Report - Reporting Structure page, then translated using the MN UFARS Report - Setup - Data Crosswalk - Finance page. |
|
Object/Source |
The UFARS Object (expenditure) or Source (revenue) code. |
22-24 |
3 |
Retrieved from the Organization/Account Level field on the Object row of the MN UFARS Report - Reporting Structure page, then translated using the MN UFARS Report - Setup - Data Crosswalk - Object page. |
|
Course |
The UFARS Course code. |
25-28 |
4 |
Retrieved from the Organization/Account Level field on the Course row of the MN UFARS Report - Reporting Structure page, then translated using the MN UFARS Report - Setup - Data Crosswalk - Course page. |
|
Adopted Budget |
Sign (+/-) + 11-digit amount (cents, zero-padded). |
29-40 |
12 |
Calculated from transaction records with transaction codes 11 or 12 in the General Ledger. |
|
Revised Budget |
Sign (+/-) + 11-digit amount (cents, zero-padded). |
41-52 |
12 |
Calculated from transaction records with transaction codes 11 or 12, 13 or 14, and 25 or 26 in the General Ledger. |
|
Next Year Budget |
Sign (+/-) + 11-digit amount (cents, zero-padded). |
53-64 |
12 |
Retrieved from the Year 2 Budget field in the Expenditure or Revenue Ledger. |
|
Ending Balance |
Sign (+/-) + 11-digit amount (cents, zero-padded). |
65-76 |
12 |
Calculated from the sum of periodic expenditure/revenue amounts (Periods 1-13) in the Expenditure or Revenue Ledger. |