This document contains the layouts for the header, detail, and trailer records for the Fixed Width and Comma Separated Values (CSV) extract versions of the output. Each report requested online will generate one header record, one or more detail records, and one trailer record. The record layout table contains the position, the data element name, description, field format, and length as they will appear on the Fixed Width extract and the data element name, description, and field format as they will appear on the CSV extract file. The user may choose to receive all data associated with their school by leaving the asterisk (*) in the School Location Code field, or only data for a single location by entering the eight-digit OPEID for that location. The report output may be sorted by SSN or Last/First Name, and is available in Fixed-Width or Comma Separated Values (CSV) format. The report will be delivered to the SAIG mailbox associated with the FSA User ID requesting the report using the following message classes: ERSBFWOP Fixed Width extract • – ERSBCDOP Comma Separated Values (CSV) extract • – Enrollment Reporting Statistics Backup Detail Report Extract File Layout for Schools Fixed Width The following represents the file layout for a Fixed Width extract: ER Statistics Backup Detail Report Header Record Layout Length = 150 Pos Pos Data Element Description Field Lth FR TO Format 1 1 Record Type Indicator used to identify the header Char. 1 record. Value: ‘0’. 2 36 Report Description Value: STATISTICS BACKUP Char. 35 ‘ER DETAIL’. 37 42 Report ID Identifier of report. Value: Char. 6 ‘SCHCB1’. 43 50 Requesting User FSA User ID of the user making the Char. 8 request. 51 58 Request Date The request date of the report. Format: Date 8 CCYYMMDD. 59 64 Requested School Code The six-digit OPEID, as assigned by the Char. 6 Office of Postsecondary Education, for the school requesting the report.
This document contains the layouts for the header, detail, and trailer records for the Fixed Width and Comma Separated Values (CSV) extract versions of the output. Each report requested online will generate one header record, one or more detail records, and one trailer record. The record layout table contains the position, the data element name, description, field format, and length as they will appear on the Fixed Width extract and the data element name, description, and field format as they will appear on the CSV extract file. The user may choose to receive all data associated with their school by leaving the asterisk (*) in the School Location Code field, or only data for a single location by entering the eight-digit OPEID for that location. The report output may be sorted by SSN or Last/First Name, and is available in Fixed-Width or Comma Separated Values (CSV) format. The report will be delivered to the SAIG mailbox associated with the FSA User ID requesting the report using the following message classes: • ERSBFWOP – Fixed Width extract • ERSBCDOP – Comma Separated Values (CSV) extract Enrollment Reporting Statistics Backup Detail Report Extract File Layout for Schools Fixed Width The following represents the file layout for a Fixed Width extract: ER Statistics Backup Detail Report Header Record Layout Length = 150 Pos FR Pos TO Data Element Description Field Format Lth 1 1 Record Type Indicator used to identify the header record. Value: ‘0’. Char. 1 2 36 Report Description Value: ‘ER STATISTICS BACKUP DETAIL’. Char. 35 37 42 Report ID Identifier of report. Value: ‘SCHCB1’. Char. 6 43 50 Requesting User FSA User ID of the user making the request. Char. 8 51 58 Request Date The request date of the report. Format: CCYYMMDD. Date 8 59 64 Requested School Code The six-digit OPEID, as assigned by the Office of Postsecondary Education, for the school requesting the report. Char. 6
NSLDSEnrollRprtStatBckupDetRprtExtrctFileLayoutSchlsSCHCB1.docx