Return to File Formats & Field Values
For fixed width format, the total trailer record length is 1250 bytes. For Excel/text tab delimited format, the total trailer record length is 12 columns.
All fields in the trailer record are required.
| Excel Column | Field Name | Characters | Bytes | Format | Description |
|---|---|---|---|---|---|
| A | Record Type | 2 | 01-02 | Alphanumeric | T1 |
| B | Number of “F” | 6 | 03-08 | Number | Number of records where campus level enrollment status = F |
| C | Number of “Q” | 6 | 09-14 | Number | Number of records where campus level enrollment status = Q |
| D | Number of “H” | 6 | 15-20 | Number | Number of records where campus level enrollment status = H |
| E | Number of “L” | 6 | 21-26 | Number | Number of records where campus level enrollment status = L |
| F | Number of “W” | 6 | 27-32 | Number | Number of records where campus level enrollment status = W |
| G | Number of “G” | 6 | 33-38 | Number | Number of records where campus level enrollment status = G |
| H | Number of “A” | 6 | 39-44 | Number | Number of records where campus level enrollment status = A |
| I | Number of “X” | 6 | 45-50 | Number | Filled with zeros (not currently used at campus level) |
| J | Number of “D” | 6 | 51-56 | Number | Number of records where campus level enrollment status = D |
| K | Total Record Count | 8 | 57-64 | Number | Number of student detail records plus two (including the header and trailer records) |
| L | Filler | 1186 | 65-1250 | Alphanumeric | Filler |