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. 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 Number 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, District of Columbia, and Workbook. the outlying areas and freely associated areas of the United States. DG570 13 2 String M A number used to uniquely identify 01 – State Education State Agency state agencies. This ID cannot be Agency Number updated through this file. DG4 15 14 String M The identifier assigned to a local LEA Identifier education agency (LEA) by the state (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 by School Identifier the state education agency (State) (SEA). Also known as the State School Identification Number (ID). This ID cannot be updated through this file. DG728 49 15 String M The classification of intervention TURN - Turnaround Intervention used used by the school under the School REST - Restart Improvement Grant (SIG) CLOS - Closure TRAN – Transformation STAT – State-determined EVID – Evidence-based ELRN – Early Learning MTRA - Modified Transformation- Rural MTUR - Modified Turnaround - Rural Filler 64 15 String M Leave filler field blank. Revised! Revised! DG729 79 15 Number O The number of minutes that all Integer (most likely School year students were required to be at between 54,000 and minutes school and any additional learning 200,000, but may be a time (e.g., before or after school, different value)
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. 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. 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. DG728 Intervention used 49 15 String M The classification of intervention used by the school under the School Improvement Grant (SIG) TURN - Turnaround REST - Restart CLOS - Closure TRAN – Transformation STAT – State-determined EVID – Evidence-based ELRN – Early Learning MTRA - Modified Transformation- Rural MTUR - Modified Turnaround - Rural Filler Revised! 64 15 String M Leave filler field blank. Revised! DG729 School year minutes 79 15 Number O The number of minutes that all students were required to be at school and any additional learning time (e.g., before or after school, Integer (most likely between 54,000 and 200,000, but may be a different value)
fs167-14-0.docx