1.1.0.12239
Mississippi has two files - a district matched and a State matched. All use the State matched. They go to the State Website and they download it as a spreadsheet. It will auto open and they save it as a CSV File. They import the CSV File.
Note: Rename existing MS file to 'Mississippi District Match File'.
Pull in MSIS_ID as the ID #
Attempt to Parse Name 1 for School #
The following is the file layout for your district. See the District Direct Certification document for details on performing the DC process.
Plug-In Name: Mississippi
Match Style: District Match
File Type:
Number of Heading Lines: 0
Export Available: No
Advanced Setup Available: No
File Format: Fixed Length
Field | Start Position | Length |
'Student last name | 1 | 17 |
'Student First Name | 18 | 12 |
'Student Middle In. | 30 | 1 |
'Student DOB | 31 | 8 |
'Filler | 39 | 3 |
'Student SSN | 42 | 9 |
'Filler | 51 | 2 |
'Gender | 53 | 1 |
'Race | 54 | 2 |
'DC Case # | 56 | 11 |
'Parent Last Name | 67 | 17 |
'Parent First Name | 84 | 12 |
'Parent Middle In. | 96 | 1 |
'County Code | 97 | 11 |
'Address 1 | 108 | 25 |
'Address 2 | 133 | 25 |
'City | 158 | 15 |
'State | 173 | 2 |
'Zip | 175 | 5 |