The following is the file layout for your district. See the State Direct Certification document for details on performing the DC process. Plug-In Name: Maryland Match Style: State Match File Type: CSV Number of Heading Lines: 0 Export Available: No Advanced Setup Available: No File Format: Fixed Length Note: Not Not all fields are defined; only ones we are importing. Field |
|
|
|
| Start Position | Length |
|
|---|
Import.Birthdate | MCDateMask | Trim | Mid | (sLineOfText | 14 | 21 | "MMDDYYYY" | Import.FirstName |
| Trim | Mid | (sLineOfText | 24 | 20 |
| Import.LastName |
| Trim | Mid | (sLineOfText | 44 | 20 |
| Import.Middle |
| Trim | Mid | (sLineOfText | 64 | 1 |
| Import.Address1 | Trim | Trim | Mid | (sLineOfText | 65 | 5 | & " " & Trim(Trim (Mid (sLineOfText, 70, 20) | Import.Address2 |
| Trim | Mid | (sLineOfText | 90 | 20 |
| Import.City |
| Trim | Mid | (sLineOfText | 110 | 15 |
| Import.State |
| Trim | Mid | (sLineOfText | 125 | 2 |
| Import.Zip |
| Trim | Mid | (sLineOfText | 127 | 5 |
| Import.StudentSSN |
| Trim | Mid | (sLineOfText | 132 | 9 |
|
|