reported LEAs LEAs that do not have any English learners enrolled schools Schools that do not have any English learners enrolled Type of count Once At only one LEA At only one school Zero counts Required for all valid combinations Not required; valid combinations for the state not included will be assumed to be zeros Not required; valid combinations for the state not included will be assumed to be zeros Zero exceptions or Not applicable If the state does not allow medical emergencies, leave the permitted value “MEDICAL” out of the file. If the state does not allow medical emergencies, leave the permitted value “MEDICAL” out of the file. If the state does not allow medical emergencies, leave the permitted value “MEDICAL” out of the file. Missing Use “-1” to report missing counts. Use “MISSING” when a category is not available Use “-1” to report missing counts. Use “MISSING” when a category is not available Use “-1” to report missing counts. Use “MISSING” when a category is not available Related metadata survey Required Categories and Totals The table below lists the combinations of the categories that are expected to be submitted for the state and each LEA or school that should be included in the file. An “X” in the column indicates that the column must be populated when reporting that particular category. The total indicator must be “N” (No). The abbreviations in the “Table Name” column represent the technical name of the data used in the file. Table 2.3–1: Required Categories and Totals Aggregation Table Name Participation Status Assessed First Time Total Indicator Comments Category Set A LEPENGLANGTST X N Student Count by Participation Status Category Set B LEPENGLANGTST X N Student Count by Assessed First Time
Carriage Return / Line Feed (CRLF) 310 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 SCHOOL LEP ENG LANG TESTING,15,euschLEPENGTSTv000001.csv,characters to identify file,2018-2019,¶ 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, District of Columbia, 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 state education agency (SEA). Also known as State LEA Identification Number (ID). This data element cannot be updated through this file. SEA level – Blank DG5 School Identifier (State) 29 20 String M The identifier assigned to a school by the state education agency (SEA). Also known as the State School Identification Number (ID). This ID cannot be updated through this file. SEA level - Blank LEA level - Blank Table Name 49 20 String M See table 2.3-1 Required Categories and Totals LEPENGLANGTST