D.3.3 School Data Record Definition Data Records are required and immediately follow the header record in every file submitted to the ESS. Data Records provide the unique identifiers, contact information, and descriptive information for the schools in the state. Each school has a record. Table D.3.3–1: School Data Record Data Element Start Permitted Values Length Type Pop Definition / Comments Name Position Abbreviations File Record 1 10 Number M A sequential number assigned by Number the SEA that is unique to each row entry within the file. DG559 11 2 String M See section 2.4.1.1 For a list of valid State State Code The two-digit American National Codes, refer to the EDFacts Standards Institute (ANSI) code Workbook. for the state, District of Columbia, and the outlying areas and freely associated areas of the United States. DG570 13 2 String M See section 2.4.1.3 01 – State Education Agency State Agency A number used to uniquely Number identify state agencies. This ID cannot be updated through this file. DG4 15 14 String M See section 2.4.1.4 LEA Identifier The identifier assigned to an LEA (State) by the SEA. Also known as State LEA Identification Number (ID). DG1 29 7 String N See section 2.4.1.5 Two–digit state code followed LEA Identifier The seven-digit unique identifier by a five–digit local education (NCES) assigned to the LEA by NCES. agency (LEA) code. Also known as NCES LEA ID. If submitted, all seven digits are required. An incomplete NCES ID will result in a validation error. See Section 2.3 “Errors with Directory Files.” DG5 36 20 String M See section 2.4.1.4. School Identifier The identifier assigned to a school (State) by the SEA. Also known as State School Identification Number (ID). DG529 56 5 String A See section 2.4.1.5. 5 Digits School Identifier The twelve digit unique identifier (NCES) assigned to the school by NCES. Also known as NCES School ID.
D.3.3 School Data Record Definition Data Records are required and immediately follow the header record in every file submitted to the ESS. Data Records provide the unique identifiers, contact information, and descriptive information for the schools in the state. Each school has a record. Table D.3.3–1: School Data Record 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 SEA that is unique to each row entry within the file. DG559 State Code 11 2 String M See section 2.4.1.1 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 See section 2.4.1.3 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 See section 2.4.1.4 The identifier assigned to an LEA by the SEA. Also known as State LEA Identification Number (ID). DG1 LEA Identifier (NCES) 29 7 String N See section 2.4.1.5 The seven-digit unique identifier assigned to the LEA by NCES. Also known as NCES LEA ID. If submitted, all seven digits are required. An incomplete NCES ID will result in a validation error. See Section 2.3 “Errors with Directory Files.” Two–digit state code followed by a five–digit local education agency (LEA) code. DG5 School Identifier (State) 36 20 String M See section 2.4.1.4. The identifier assigned to a school by the SEA. Also known as State School Identification Number (ID). DG529 School Identifier (NCES) 56 5 String A See section 2.4.1.5. The twelve digit unique identifier assigned to the school by NCES. Also known as NCES School ID. 5 Digits