Monthly Report - File Layout And Data Mapping
The default file name for the Monthly report is mi_rep_monthly.txt.
The following table shows the Monthly report's field numbers, names, format, length, and position.
Field # | Field Name | Format | Length | Position |
---|---|---|---|---|
1 | Date of Count | Date of Count/slashes | 10 | 001-010 |
2 | Operating ISD/ESA Number | Character | 2 | 011-012 |
3 | Operating District Number | Character | 5 | 013-017 |
4 | Last Name | Alpha | 40 | 018-057 |
5 | First Name | Alpha | 40 | 058-097 |
6 | Middle Name | Alpha | 40 | 098-137 |
7 | Social Security Number | Integer | 9 | 138-146 |
8 | Credential License Number | Alphanumeric | 15 | 147-161 |
9 | Date of Hire | Date, with slashes | 10 | 162-171 |
10 | School Assignment Data Includes the following data elements:
| Character | 450 | 172-621 |
11 | Title I and Title II, Part A Teachers | Numeric | 3 | 622-624 |
12 | Funded Position Status | Integer | 1 | 625 |
13 | Date of Birth | Date, with slashes | 10 | 626-635 |
14 | Gender Code | Alpha | 1 | 636 |
15 | Racial/Ethnic Code | Character | 6 | 637-642 |
16 | Highest Educational Level | Character | 2 | 643-644 |
17 | Type of Credential | Character | 2 | 645-646 |
18 | Date Credential Issued | Date, with slashes | 10 | 647-656 |
19 | Date of Expiration of Credential | Date, with slashes | 10 | 657-666 |
20 | Educator Effectiveness | Numeric | 2 | 667-668 |
21 | Reserved | Numeric | 8 | 669-676 |
22 | Reserved | Numeric | 6 | 677-682 |
23 | Reserved | Numeric | 6 | 683-688 |
24 | Professional Development Days | Character NN.NNNN.NNNN.NNXXXXXXXXXXXX X = blank space | 27 | 689-715 |
25 | Employment Status | Character | 2 | 716-717 |
26 | Date of Termination of Employment | Date, with slashes | 10 | 718-727 |
27 | Personnel Identification Code (PIC) | Integer | 10 | 728-737 |
28 | Full-Time Base Annual Salary | Integer | 6 | 738-743 |
29 | Michigan Sponsoring Institution | Character | 6 | 744-749 |
30 | Non-Michigan Sponsoring Institution | Character | 2 | 750-751 |