MSDE Annual Financial Report - File Layouts and Data Mapping
The following table lists the state field numbers, field names, description, type, location, and length.
All fields after the Local Grant Number are zero-filled except for the Fiscal Year.
Field # | Field Name | Description | Type | Location | Length |
---|---|---|---|---|---|
1 | LEA | The two-character state-assigned Local Education Agency (LEA) number. | Numeric | 1-2 | 2 |
2 | Fund | MSDE Fund. The fund codes identify the fund types for which revenue, expenditures, assets, liabilities, and balances are reported. The fund codes are: 1 Current Expense 2 [Not Used] 3 School Construction 4 Debt Service 5 Food Service 6 Student Activities 7 Trust/Agency 8 General Fixed Assets 9 Fixed Charges Supplemental Report Group (This account is used to redistribute expenditures reported in the Fixed Charges category to the category for which the charge was incurred. It should not be confused with the true fund types and is used for convenience only.) | Numeric | 3 | 1 |
3 | Class | MSDE Class. The class code describes the type of nominal and real accounts. These account totals describe the operations and status of each major fund identified in the Fund code. 1 Revenue 2 Expenditures 3 Assets 4 Liabilities 5 [Not Used] 6 [Not Used] 7 Fund Balance | Numeric | 4 | 1 |
4 | Category | MSDE Category. | Numeric | 5-6 | 2 |
5 | Program | MSDE Program. | Numeric | 7-8 | 2 |
6 | Activity | MSDE Activity. | Numeric | 9-10 | 2 |
7 | Object | MSDE Object. | Numeric | 11 | 1 |
8 | Sub-object | MSDE Sub-Object. | Numeric | 12-13 | 2 |
9 | Dollar Amount | Not Applicable | Numeric | 14-25 | 12 |
10 | Fund (Revenue) Source | Fund source codes identify the funding source of restricted program expenditures. | Numeric | 26-29 | 4 |
11 | Grant Document Number | MSDE Grant. | Numeric | 30-37 | 8 |
12 | Local Grant Number | Local Grant. | Alphanumeric | 38-47 | 10 |
13 | Original Grant Amount | Not Applicable | Numeric | 48-59 | 12 |
14 | Cash Received | Not Applicable | Numeric | 60-71 | 12 |
15 | Cash Expenditures | Not Applicable | Numeric | 72-83 | 12 |
16 | Payables | Not Applicable | Numeric | 84-91 | 8 |
17 | Encumbrances | Not Applicable | Numeric | 92-99 | 8 |
18 | Administration-Federal | Not Applicable | Numeric | 100-109 | 10 |
19 | Administration-Nonfederal | Not Applicable | Numeric | 110-119 | 10 |
20 | Career & Tech Maintenance of Effort | Not Applicable | Numeric | 120-129 | 10 |
21 | Fiscal Year | Year. | Numeric | 130-133 | 4 |
22 | Local Contributions | Not Applicable | Numeric | 134-143 | 10 |