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 or "CCYY CCYY", where either a OR hyphen or a 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) Below is an example of a header record. Table 4.1–2: Header Record Example Format File Type,Total Records in File,File Name,File Identifier,File Reporting Period,Filler,Carriage Return / Line Feed (CRLF) Example SCH OTHER ACAD STATUS,15,EUSCHPROGSTATver0007.CSV,characters to identify Data Record Definition Data records are required and immediately follow the header record in every file submitted to the ESS. Data records provide the statuses and other data for the education units. For the data records, there is an additional code in the column: “Pop” SDS This field is required when the permitted value in the Status field is – for state defined status. “STTDEF” Table 4.2–1: Data Records Start Permitted Values Data Element Name Length Type Pop Definition / Comments Position Abbreviations File Record Number 1 10 Number M A sequential number assigned by
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 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 Below is an example of a header record. Table 4.1–2: Header Record Example Format File Type,Total Records in File,File Name,File Identifier,File Reporting Period,Filler,Carriage Return / Line Feed (CRLF) Example SCH OTHER ACAD STATUS,15,EUSCHPROGSTATver0007.CSV,characters to identify Data Record Definition Data records are required and immediately follow the header record in every file submitted to the ESS. Data records provide the statuses and other data for the education units. For the data records, there is an additional code in the “Pop” column: SDS – This field is required when the permitted value in the Status field is “STTDEF” for state defined status. Table 4.2–1: Data Records Data Element Name Start Position Length Type Pop Definition / Comments Permitted Values Abbreviations File Record Number 1 10 Number M A sequential number assigned by
fs201-14-0.docx