Aggregation Table Name Grade Level (Assessment) Performance Level Assessment Administered Major Racial and Ethnic Groups Sex (Membership) Disability Status (Only) English Learner Status (Only) Revised! Economically Disadvantaged Status Migratory Status Revised! Homeless Enrolled Status Foster Care Status New! Military Connected Student Status New! Total Indicator Comments Category Set A STUDPERFM X X X X N Student Count by Major Racial and Ethnic Groups, Assessment Administered, Grade Level (Assessment), Performance Level Revised! Category Set B STUDPERFM X X X X N Student Count by Sex (Membership), Assessment Administered, Grade Level (Assessment), Performance Level Revised! Category Set C STUDPERFM X X X X N Student Count by Disability Status (Only), Assessment Administered, Grade Level (Assessment), Performance Level Revised! Category Set D STUDPERFM X X X X N Student Count by English Learner Status (Only), Assessment Administered, Grade Level (Assessment), Performance Level Revised! Category Set E STUDPERFM X X X X N Student Count by Economically Disadvantaged Status, Assessment Administered, Grade Level
ss USPS State Abbreviation 2 lev Abbreviation for level: SEA for an State Education Agency level LEA for an Local Education Agency level SCH for a school level 3 filename STUPERFMA 9 vvvvvvv Alphanumeric string designated by the SEA to uniquely identify the individual submission (e.g., ver0001, v010803) 7 .ext Extension identifying the file format: .txt – fixed .csv – comma delimited .tab – tab delimited 4 FIXED OR DELIMITED FILES This section describes the fixed file and delimited file specifications. The fixed file and delimited files contain a header record followed by data records. The file type is specified in the header record. The “Pop” column in the header and data records is coded as follows: M - Mandatory, this field must always be populated A - This field is populated in accordance with table 2.3-1 “Required Categories and Totals” O - Optional, data in this field are optional Header Record Definition The header record is required and is the first record in every file submitted to the ESS. The purpose of the header record is to provide information as to the file type, number of data records in the file, file name, file identifier, and file reporting period. Table 4.1–1: Header Record Data Element Name Start Position Length Type Pop Definition / Comments Permitted Values Abbreviations File Type 1 50 String M Identifies the type of file being submitted. SEA STUDENT PERFORMANCE MATH
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 ID is a required field. 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. 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 section 1.0 STUDPERFM Grade Level (Assessment) 69 15 String A The grade level assigned by the school system in which the students are enrolled. 03 – Grade 3 04 – Grade 4 05 – Grade 5 06 – Grade 6 07 – Grade 7 08 – Grade 8 09 – Grade 9 10 – Grade 10 11 – Grade 11 12 – Grade 12 HS – High School MISSING Major Racial and Ethnic Groups 84 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 Rican)
APPENDIX A: EDFACTS - IDEA (ASSESSMENT) CROSSWALK This appendix contains the crosswalk for the IDEA legacy assessment collection. EDFacts – IDEA (Assessment) Crosswalk Revised! IDEA Data Collection Description Table Section Location (column, row, cell) EDFacts File Spec EDFacts Data Group Category Set Performance of students with disabilities on Mathematics assessment C Regular Assessment based on Grade level academic achievement standards (with & without accommodations) C.11A FS175 583 C Level 1 C.11A FS175 583 C Level 2 C.11A FS175 583 C Level 3 C.11A FS175 583 C Level 4 C.11A FS175 583 C Level 5 C.11A FS175 583 C Level 6 C.11A FS175 583 C Total C.11A 11A Row Total (Column) FS175 583 Alternate Assessment based on Grade level academic achievement standards C.11B (no longer applicable) (no longer applicable) (no longer applicable) Level 1 C.11B (no longer applicable) (no longer applicable) (no longer applicable) Level 2 C.11B (no longer applicable) (no longer applicable) (no longer applicable) Level 3 C.11B (no longer applicable) (no longer applicable) (no longer applicable) Level 4 C.11B (no longer applicable) (no longer applicable) (no longer applicable) Level 5 C.11B (no longer applicable) (no longer applicable) (no longer applicable) Level 6 C.11B (no longer applicable) (no longer applicable) (no longer applicable)
Total C.11B 11B Row Total (Column) (no longer applicable) (no longer applicable) (no longer applicable) Alternate Assessment based on Modified academic achievement standards C.11C (no longer applicable) (no longer applicable) (no longer applicable) Level 1 C.11C (no longer applicable) (no longer applicable) (no longer applicable) Level 2 C.11C (no longer applicable) (no longer applicable) (no longer applicable) Level 3 C.11C (no longer applicable) (no longer applicable) (no longer applicable) Level 4 C.11C (no longer applicable) (no longer applicable) (no longer applicable) Level 5 C.11C (no longer applicable) (no longer applicable) (no longer applicable) Level 6 C.11C (no longer applicable) (no longer applicable) (no longer applicable) Total C.11C 11C Row Total (Column) (no longer applicable) (no longer applicable) (no longer applicable) Alternate Assessment based on Alternate achievement standards C.11D FS175 583 C Level 1 C.11D FS175 583 C Level 2 C.11D FS175 583 C Level 3 C.11D FS175 583 C Level 4 C.11D FS175 583 C Level 5 C.11D FS175 583 C Level 6 C.11D FS175 583 C Total C.11D 11D Row Total (Column) FS175 583