Return to File Formats & Field Values

Excel/text enrollment reporting files can be in fixed width or in flat file, tab delimited format.

• Fixed Width Format: Records are 1250 bytes. Fields with no value (aka “fillers”) are filled with spaces.
• Tab Delimited Format: Records are 109 columns. Fillers are left blank. Each field is separated by a tab, including blank fields and fillers. A carriage return or line feed signals the end of a record.

Records & Data Fields

Each file contains one header record, one detail record for each student, and one trailer record. We recommend listing the student detail records in order of Social Security number.

• Name suffixes (e.g., Jr, Sr, III) have an assigned field. If your system includes them as part of the last name, parse the suffix from the last name and move it into the suffix field.
• We store data fields with alphanumeric characters in our database in all uppercase except for email addresses, which are stored in mixed case.

Filename

Files should be named according to the following format:

School Code + Branch Code + three-letter file extension

Example: 12345600.CLR

Excel Format

1. In Microsoft Excel, create a new spreadsheet.
2. Highlight columns A through DF.
3. In the Cells menu on the Ribbon, click Format.
4. Select Format Cells from the drop-down.
5. Select the Number tab.
6. Under Category, select Text.
7. Click OK.

Return to File Formats & Field Values