Virginia
- Nora Kinal
The following is the file layout for your district. See the District Direct Certification document for details on performing the DC process.
VDOE School Nutrition Programs
Direct Certification LEA Student Enrollment
Flat File (.txt) Format and Field Definitions
Each student record in the file must contain 239 characters in the field positions detailed below. Records with less than 239 characters or that are not left adjusted will not be validated and uploaded into the system.
FIELD NAME | FIELD TYPE | DESCRIPTION | FIELD POSITION* *All Data is left adjusted | FIELD WIDTH |
|---|---|---|---|---|
SFA ID | Numeric | DIV No. Valid 3 digit for public school divisions and 4 digit for Private SFAs. Public school divisions add leading “0”s to create 4 digit number | 1-4 | 4 |
Local Student Identifier | Numeric | Locally assigned unique 12 digit alpha/numeric identifier for each student in the division. Add “0” following digits if less than 12. | 5-16 | 12 |
School/Site Number | Numeric | School Number or Site Number. Must be valid DOE assigned 4-digit number for the division/SFA. All numbers must be 4 digit. Use the Site Number from the SNPWeb Site Application. | 17-20 | 4 |
Student Last Name | Alpha | Student’s Last Name. Field must be 30 | 21-50 | 30 |
Student First Name | Alpha | Student’s First Name. Field must be 30 | 51-80 | 30 |
MI | Alpha | Student’s Middle Initial. Field is one character only. | 81 | 1 |
Date of Birth MM/DD/YYYY | Numeric | Student’s Date of Birth (MM/DD/YYYY). Must be formatted as two digit month, two digit day, four digit year. | 82-91 | 10 |
SEX | Alpha | Student's Sex Code: F or M. One character only | 92 | 1 |
ADDRESS 1 | Alpha/Numeric | Student’s Street Number, Name of Street, or Address. Field must be 30 characters. | 93-122 | 30 |
ADDRESS 2 | Alpha/Numeric | Student’s Second Address Line (PO Box, Apt. #. Etc.). Field must be 30 characters – use “0” or blanks if none. | 123-152 | 30 |
CITY | Alpha | Student’s City. Field must be 20 characters. | 153-172 | 20 |
STATE | Alpha | Student’s State. Two character state | 173-174 | 2 |
ZIPCODE | Numeric | Student’s 5-Digit Zip code. Five characters only. | 175-179 | 5 |
Parent/Guardian Name Last | Alpha | Student’s Parent/Guardian Last Name. Field must be 30 characters. | 180-209 | 30 |
Parent/Guardian Name First | Alpha | Student’s Parent/Guardian First Name. Field | 210-239 | 30 |