Use this record layout to import cafeteria data into ASCENDER. The import file is a comma-delimited text file.
NOTE: Each field has a fixed length, except the name fields. The name fields are truncated, so no additional spaces are needed.
| Field | Characters | Required | Notes |
|---|---|---|---|
| Record ID | 6 | Y | Literal “CAFIMP” |
| County/District/Campus | 9 | Y | |
| Student ID | 6 | Y | |
| Date of Birth | 8 | Y | YYYYMMDD |
| Student Last Name | 25 | Y | |
| Student First Name | 17 | Y | |
| Student Middle Initial | 1 | Y | Space if no middle name. |
| Economic Disadvantage Status | 2 | Y | |
| Effective Date | 8 | Y | Date used for Begin/End Date on inserted/updated records. |
Example: CAFIMP,030902041,003018,20041010,LOPEZ,MICHAEL,L,00