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 NEGL OR DELQ EXITED LEA NEGL OR DELQ EXITED Total Records in 51 10 Number M The total number of data records contained in the File 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 198 String M Leave filler field blank. Carriage Return / 325 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 SEA NEGL OR DELQ EXITED,15,EUSEANDEXITEDPver0007.CSV,characters to identify file, Data Record Definition – SEA (DG785) 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 - SEA 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
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 NEGL OR DELQ EXITED LEA NEGL OR DELQ EXITED 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 198 String M Leave filler field blank. Carriage Return / Line Feed (CRLF) 325 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 SEA NEGL OR DELQ EXITED,15,EUSEANDEXITEDPver0007.CSV,characters to identify file, Data Record Definition – SEA (DG785) 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 - SEA 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 11 2 String M The two-digit American National For a list of valid State
fs181-14-0.docx