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: Louisiana
Match Style: State Match
File Type: CSV
Column Header Expected: Yes
Export Available: No
Advanced Setup Available: No
File Format: FileSpec.AddField
Field | Start Position | ||||
---|---|---|---|---|---|
"SystemIndicator" | 1 | 255 | adVarChar | False | sQuoteFormat |
"SchopolSession" | 2 | 255 | adVarChar | True | sQuoteFormat |
"SponsorCd" | 3 | 255 | adVarChar | True | sQuoteFormat |
"StudentID" | 4 | 255 | adVarChar | False | sQuoteFormat |
"ProfileLocalId" | 5 | 255 | adVarChar | False | sQuoteFormat |
"ProfileLastName" | 6 | 255 | adVarChar | False | sQuoteFormat |
"ProfileSuffixName" | 7 | 255 | adVarChar | False | sQuoteFormat |
"ProfileFirstName" | 8 | 255 | adVarChar | False | sQuoteFormat |
"ProfileMiddleName" | 9 | 255 | adVarChar | False | sQuoteFormat |
"ProfileBirthDt" | 10 | 10 | adVarChar | False | sQuoteFormat |
"ProfileSexCd" | 11 | 255 | adVarChar | False | sQuoteFormat |
"ProfileEthnicCd" | 12 | 255 | adVarChar | False | sQuoteFormat |
"EnrollmentSiteCd" | 13 | 255 | adVarChar | False | sQuoteFormat |
"MatchedSSN" | 14 | 255 | adVarChar | False | sQuoteFormat |
"MatchedBirthDt" | 15 | 255 | adVarChar | False | sQuoteFormat |
"MatchedFirstName" | 16 | 255 | adVarChar | False | sQuoteFormat |
"FNSBirthDate" | 17 | 255 | adVarChar | True | sQuoteFormat |
"FNSLastName" | 18 | 255 | adVarChar | True | sQuoteFormat |
"FNSFirstName" | 19 | 255 | adVarChar | True | sQuoteFormat |
"FNSMiddleName" | 20 | 255 | adVarChar | True | sQuoteFormat |
"FNSHouseholdSSN" | 21 | 255 | adVarChar | False | sQuoteFormat |
"FNSHouseholdName" | 22 | 255 | adVarChar | False | sQuoteFormat |
"EnrollmentGradePlacementCd" | 23 | 255 | adVarChar | True | sQuoteFormat |
"AuditSponsorCd" | 24 | 255 | adVarChar | True | sQuoteFormat |
"AuditDateReceived" | 25 | 255 | adVarChar | True | sQuoteFormat |
"AuditDownloadType" | 26 | 255 | adVarChar | True | sQuoteFormat |
"AuditDateProcessed" | 27 | 255 | adVarChar | True | sQuoteFormat |