The following table lists the field names, descriptions, positions, lengths, and data sources or valid values for the UFARS report's General Ledger (G) record.
|
Field Name |
Description |
Position |
Length |
Data Source or Valid Values |
|---|---|---|---|---|
|
Account ID |
Indicates that this is a General Ledger record. |
1 |
1 |
The valid value is G. |
|
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. |
|
Fund |
The UFARS Fund code. |
7-8 |
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. |
|
Summary Account |
The summary account code. |
9-11 |
3 |
Retrieved from the Organization/Account Level field on the GL row of the MN UFARS Report - Reporting Structure page, then translated using the MN UFARS Report - Setup - Data Crosswalk - GL page. |
|
Beginning Balance |
Sign (+/-) + 11-digit amount (cents, zero-padded) |
12-23 |
12 |
Calculated from transaction records in the General Ledger. |
|
Debit YTD |
Sign (+/-) + 11-digit amount (cents, zero-padded) |
24-35 |
12 |
Calculated from transaction details in the General Ledger based on transaction codes 19, 20, 21, 22, and 24. |
|
Credit YTD |
Sign (+/-) + 11-digit amount (cents, zero-padded) |
36-47 |
12 |
Calculated from transaction details in the General Ledger based on transaction codes 19, 20, 21, 22, and 24. |