PREFACE This document provides technical instructions for building files that are submitted through the EDFacts Submission System (ESS). The ESS is an electronic system that facilitates the efficient and timely transmission of data from SEAs to the U.S. Department of Education. This document is to be used in coordination with other documentation posted on the under EDFacts System Documentation, including: EDFacts Workbook – a reference guide to using the EDFacts Submission System (ESS); particularly useful to new users; contains multiple appendices, including one that explains how to use the file specifications ESS User Guide – provides assistance to new users of the EDFacts Submission System (ESS); it addresses the basic mechanics of system access and data submission EDFacts Business Rules Guide – describes each business rule including the error number, type, message, definition, edit logic, and the file specifications where the business rules are applied Please contact the Partner Support Center (PSC) with questions about the documents. You will find contact information for PSC and each State EDFacts Coordinator on the . Data submitted through the ESS are authorized by an Annual Mandatory Collection of Elementary and Secondary Education Data Through EDFacts (OMB 1850-0925, expires 6/30/2020). EDFacts is a U.S. Department of Education (ED) initiative to govern, acquire, validate, and use high-quality, kindergarten through grade 12 (K–12) performance data for education planning, policymaking, and management and budget decision-making to improve outcomes for students. EDFacts centralizes data provided by SEAs, LEAs and schools, and provides users with the ability to easily analyze and report data. This initiative has significantly reduced the reporting burden for state and local data producers, and has streamlined data collection, analysis and reporting functions at the federal, state and local levels.
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 TITLE III RESULTS,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 state education agency (SEA). Also known as State LEA SEA level – Blank