Data Record Definition Data records are required and immediately follow the header record in every file submitted to the ESS. Data records provide the statuses and other data for the education units. For the data records, there is an additional code in the column: “Pop” SDS This field is required when the permitted value in the Status field is – for state defined status. “STTDEF” 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 for Codes, refer to the EDFacts the state, , and the outlying areas Workbook. and freely associated areas of the United States. DG570 13 2 String M A number used to uniquely identify 01 – State Education State Agency Number state agencies. This ID cannot be Agency updated through this file. DG4 15 14 String M The identifier assigned to a local LEA Identifier (State) 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. DG5 29 20 String M The identifier assigned to a school School Identifier by the state education agency (State) (SEA). Also known as the State School Identification Number (ID). This ID cannot be updated through this file. Table Name 49 20 String M See section 1.0 ACADACHSTATUS Major Racial and 69 15 String A The major racial and ethnic groups MA - Asian Ethnic Groups states use for accountability and MAN - American Indian \ assessment data. Alaska Native \ Native American MAP - Asian \ Pacific Islander MB - Black (not Hispanic) African American MF - Filipino MHL - Hispanic \ Latino MHN - Hispanic (not Puerto
Data Record Definition Data records are required and immediately follow the header record in every file submitted to the ESS. Data records provide the statuses and other data for the education units. For the data records, there is an additional code in the “Pop” column: SDS – This field is required when the permitted value in the Status field is “STTDEF” for state defined status. 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 Identification Number (ID). This data element cannot be updated through this file. 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. Table Name 49 20 String M See section 1.0 ACADACHSTATUS Major Racial and Ethnic Groups 69 15 String A The major racial and ethnic groups states use for accountability and assessment data. MA - Asian MAN - American Indian \ Alaska Native \ Native American MAP - Asian \ Pacific Islander MB - Black (not Hispanic) African American MF - Filipino MHL - Hispanic \ Latino MHN - Hispanic (not Puerto
fs200-14-0.docx