The following is the naming convention for file submissions: sslevfilenamevvvvvvv.ext Table 3.0-1: File Naming Convention Where Means Limit in characters ss USPS State Abbreviation 2 lev Abbreviation for level: SCH for a school level 3 filename CHRONABSE 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 may not be required, see guidance in section 2.4 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
the outlying areas and freely associated areas of the United States. 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 table 2.3-1 Required Categories and Totals CHRONABSENT Sex (Membership) 69 15 String A The concept describing the biological traits that distinguish the males and females of a species. F – Female M – Male MISSING Racial Ethnic 84 15 String A The general racial category that most clearly reflects individuals' recognition of their community or with which the individuals most identify. AM7 – American Indian or Alaska Native AS7 – Asian BL7 – Black or African American HI7 – Hispanic/Latino PI7 – Native Hawaiian or Other Pacific Islander MU7 – Two or more races WH7 – White MISSING Disability Status (Only) 99 15 String A An indication that children (students) are children with disabilities (IDEA). WDIS – Children with one or more disabilities (IDEA) MISSING Disability Status (504) 114 15 String A An indication that students have disability status under Section 504 DISAB504STAT – Section 504 Status MISSING English Learner Status (Only) 129 15 String A An indication that students met the definition of an English learner. LEP – English learner MISSING Homeless Enrolled Status 144 15 String A An indication that students were identified as homeless HOMELSENRL – Homeless enrolled MISSING Filler 159 90 String M Leave filler field blank.