The following is the file layout for your district. See the State Direct Certification - State 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 |