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 LEA TITLE III ENGLISH LEARNERS,15,EUSEATITLE3Sver0007.CSV,characters to identify Revised! file,2017-2018,¶ Data Record Definition Data records are required and immediately follow the header record in every file submitted to the ESS. Data records provide counts for the specified category sets, subtotals and education unit totals. 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 the State that is unique to each row entry within the file. DG559 11 2 String M The two-digit American National For a list of valid State State Code Standards Institute (ANSI) code Codes, refer to the EDFacts for the state, , and the outlying Workbook. areas and freely associated areas of the United States. DG570 13 2 String M A number used to uniquely identify 01 – State Education Agency State Agency state agencies. This ID cannot be Number updated through this file. DG4 15 14 String M The identifier assigned to a local SEA level – Blank LEA Identifier (State) education agency (LEA) 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 Revised! LEA TITLE III ENGLISH LEARNERS,15,EUSEATITLE3Sver0007.CSV,characters to identify file,2017-2018,¶ Data Record Definition Data records are required and immediately follow the header record in every file submitted to the ESS. Data records provide counts for the specified category sets, subtotals and education unit totals. 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 the State that is unique to each row entry within the file. DG559 State Code 11 2 String M The two-digit American National Standards Institute (ANSI) code for the state, , and the outlying areas and freely associated areas of the United States. For a list of valid State Codes, refer to the EDFacts Workbook. DG570 State Agency Number 13 2 String M A number used to uniquely identify state agencies. This ID cannot be updated through this file. 01 – State Education Agency DG4 LEA Identifier (State) 15 14 String M The identifier assigned to a local education agency (LEA) by the SEA level – Blank
fs204-14-1.docx