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 Start Permitted Values Length Type Pop Definition / Comments Name Position Abbreviations File Record 1 10 Number M A sequential number assigned by the State Number that is unique to each row entry within the file. DG559 11 2 String M The two-digit American National Standards For a list of valid State State Code Institute (ANSI) code for the state, District Codes, refer to the of Columbia, and the outlying areas and EDFacts Workbook. freely associated areas of the United States. DG570 13 2 String M A number used to uniquely identify state 01 – State Education State Agency agencies. This ID cannot be updated Agency Number through this file. DG4 15 14 String M The identifier assigned to a local education SEA level – Blank LEA Identifier agency (LEA) by the state education (State) 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 by the SEA level - Blank School Identifier state education agency (SEA). Also known LEA level - Blank (State) as the State School Identification Number Revised! Revised! (ID). This ID cannot be updated through this file. Revised! Table Name 49 20 String M See section 1.0. TITLEIIILEPTST Participation 69 15 String A An indication of whether students PART – Participated Status participated in assessments. NPART – Did not participate MEDICAL – Medical Exemption MISSING Assessed First 84 15 String A An indication that students are taking the FIRSTASSESS – Time English language proficiency assessment Students took (Also known as for the first time. assessment for the first “one data point”) time MISSING Disability Status 99 15 String A An indication that children (students) are WDIS – Children with one (Only) children with disabilities (IDEA). or more disabilities New! (IDEA) MISSING
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) Revised! 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. Revised! SEA level - Blank LEA level - Blank Revised! Table Name 49 20 String M See section 1.0. TITLEIIILEPTST Participation Status 69 15 String A An indication of whether students participated in assessments. PART – Participated NPART – Did not participate MEDICAL – Medical Exemption MISSING Assessed First Time (Also known as “one data point”) 84 15 String A An indication that students are taking the English language proficiency assessment for the first time. FIRSTASSESS – Students took assessment for the first time MISSING Disability Status (Only) New! 99 15 String A An indication that children (students) are children with disabilities (IDEA). WDIS – Children with one or more disabilities (IDEA) MISSING