FIXED OR DELIMITED FILES This section describes the fixed file and delimited file specifications. The fixed file and delimited files contain a header record followed by data records. The file type is specified in the header record. The column in the header and data records is coded as follows: “Pop” M - Mandatory, this field must always be populated A - This field is populated in accordance with table 2.3-1 Categories “Required and Totals” O - Optional, data in this field are optional Header Record Definition The header record is required and is the first record in every file submitted to the ESS. The purpose of the header record is to provide information as to the file type, number of data records in the file, file name, file identifier, and file reporting period. Table 4.1–1: Header Record Data Element Start Permitted Values Length Type Pop Definition / Comments Name Position Abbreviations File Type 1 50 String M Identifies the type of file being submitted. SEA CHILDREN WITH DISABILITIES (IDEA) DISCIP ACT LEA CHILDREN WITH DISABILITIES (IDEA) DISCIP ACT Total Records In 51 10 Number M The total number of data records contained in File the file. The header record is NOT included in this count. File Name 61 25 String M The file name including extension, the same as See section 3.0 the external file name. File Identifier 86 32 String M Any combination of standard characters to further identify the file as specified by the SEA (e.g., a date, person’s name, and version number). File Reporting 118 9 String M The school year for which data are being 2017-2018 Period reported. The required format is "CCYY–CCYY" or "CCYY CCYY", where either a hyphen or a OR space separates the beginning and ending years. 2017 2018 Filler 127 333 String M Leave filler field blank. Carriage Return / 460 1 M Line Feed (CRLF)
FIXED OR DELIMITED FILES This section describes the fixed file and delimited file specifications. The fixed file and delimited files contain a header record followed by data records. The file type is specified in the header record. The “Pop” column in the header and data records is coded as follows: M - Mandatory, this field must always be populated A - This field is populated in accordance with table 2.3-1 “Required Categories and Totals” O - Optional, data in this field are optional Header Record Definition The header record is required and is the first record in every file submitted to the ESS. The purpose of the header record is to provide information as to the file type, number of data records in the file, file name, file identifier, and file reporting period. Table 4.1–1: Header Record Data Element Name Start Position Length Type Pop Definition / Comments Permitted Values Abbreviations File Type 1 50 String M Identifies the type of file being submitted. SEA CHILDREN WITH DISABILITIES (IDEA) DISCIP ACT LEA CHILDREN WITH DISABILITIES (IDEA) DISCIP ACT Total Records In File 51 10 Number M The total number of data records contained in the file. The header record is NOT included in this count. File Name 61 25 String M The file name including extension, the same as the external file name. See section 3.0 File Identifier 86 32 String M Any combination of standard characters to further identify the file as specified by the SEA (e.g., a date, person’s name, and version number). File Reporting Period 118 9 String M The school year for which data are being reported. The required format is "CCYY–CCYY" or "CCYY CCYY", where either a hyphen or a space separates the beginning and ending years. 2017-2018 OR 2017 2018 Filler 127 333 String M Leave filler field blank. Carriage Return / Line Feed (CRLF) 460 1 M
fs088-14-0.docx