![](media/image1.png){width="3.5in" height="3.5in"}

**U.S. DEPARTMENT OF EDUCATION**

**Education Data Exchange Network (EDEN)**

**N102 -- NCLB School Year End Status File Specifications**

**Version 2.0**

**(New for 2005-06)**

**June 2006**

This technical guide was produced under U.S. Department of Education
Contract No. GS00F0049M-ED05P01299 with Perot Systems Government
Services, Inc. Brandon Scott served as the contracting officer's
representative. No official endorsement by the U.S. Department of
Education of any product, commodity, service or enterprise mentioned in
this publication is intended or should be inferred.

**U.S. Department of Education**

Margaret Spellings

*Secretary*

**Office of Planning, Evaluation and Policy Development**

Tom Luce

*Assistant Secretary*

![](media/image2.wmf){width="0.6507874015748032in"
height="9.803149606299212e-2in"}

June 2006

This technical guide is in the public domain. Authorization to reproduce
it in whole or in part is granted. While permission to reprint this
publication is not necessary, the citation should be: U.S. Department of
Education, Office of Planning, Evaluation and Policy Development,
Strategic Accountability Service, *N102 -- NCLB School Year End Status
File Specifications*, Washington, D.C., 2006.

This technical guide is also available on the Department's Web site at:
[http://www.ed.gov/about/inits/ed/pbdmi/index.html
.](http://www.ed.gov/about/inits/ed/pbdmi/index.html)

On request, this publication is available in alternate formats, such as
Braille, large print, or computer diskette. For more information, please
contact the Department's Alternate Format Center at (202) 260-0852 or
(202) 260-0818.

[]{#__RefHeading___Toc140903076 .anchor}DOCUMENT CONTROL

DOCUMENT INFORMATION

  --------------- ---------------------------------------------------------
  **Title:**      N102 -- NCLB School Year End Status File Specifications

  **Revision:**   Version 2.0

  **Issue Date:** June 2006

  **Security      Unclassified -- For Official Use Only
  Level:**        

  **Filename:**   744810.doc
  --------------- ---------------------------------------------------------

DOCUMENT HISTORY

+-------+---------+-------------+-------------------------------------+
| **Ve  | *       | **Resp\     | **Summary of Change**               |
| rsion | *Date** | I           |                                     |
| Num   |         | ndividual** |                                     |
| ber** |         |             |                                     |
+-------+---------+-------------+-------------------------------------+
|       |         |             | -                                   |
+-------+---------+-------------+-------------------------------------+
|       |         |             |                                     |
+-------+---------+-------------+-------------------------------------+

RELEASE AUTHORIZATION

  ----------------------- -----------------------------------------------
  **Name**                **Signature / Date**

  Author                  

  QA                      

  Release Authority       
  ----------------------- -----------------------------------------------

[]{#__RefHeading___Toc140903077 .anchor}PREFACE

This document provides technical instructions for building files that
can be submitted through the Education Data Exchange Network (EDEN).
This document is used in coordination with the EDEN Workbook and the
EDEN Submission System User Guide.

EDEN is a centralized, coordinated repository of state reported, K-12,
educational data residing at the U.S. Department of Education.  The EDEN
Submission System is an electronic system that facilitates the efficient
and timely transmission of data from SEAs to the U.S. Department of
Education. 

**Contents**

[DOCUMENT CONTROL ii](#__RefHeading___Toc140903076)

[PREFACE iii](#__RefHeading___Toc140903077)

[1.0 PURPOSE 1](#purpose)

[1.1 Changes from 03-04 and 04-05 File Specifications
1](#changes-from-03-04-and-04-05-file-specifications)

[1.2 Requirements for Submitting this Data Group
2](#requirements-for-submitting-this-data-group)

[2.0 FILE NAMING CONVENTION 2](#file-naming-convention)

[3.0 GUIDANCE FOR SUBMITTING THIS FILE
3](#guidance-for-submitting-this-file)

[4.0 STATE EDUCATION AGENCY NCLB SCHOOL YEAR END STATUS FILE
4](#state-education-agency-nclb-school-year-end-status-file)

[4.1 Header Record Definition 4](#header-record-definition)

[4.2 Data Record Definition 5](#data-record-definition)

[4.3 SEA NCLB School Year End Status File Examples
7](#sea-nclb-school-year-end-status-file-examples)

[4.3.1 Partial Record Sample for Fixed Format SEA NCLB School Year End
Status File
7](#partial-record-sample-for-fixed-format-sea-nclb-school-year-end-status-file)

[4.3.2 Partial Record Sample for Comma-Delimited File Format SEA NCLB
School Year End Status File
7](#partial-record-sample-for-comma-delimited-file-format-sea-nclb-school-year-end-status-file)

[4.3.3 Partial Record Sample for Tab-Delimited File Format SEA NCLB
School Year End Status File
7](#partial-record-sample-for-tab-delimited-file-format-sea-nclb-school-year-end-status-file)

[5.0 LOCAL EDUCATION AGENCY NCLB SCHOOL YEAR END STATUS FILE
8](#local-education-agency-nclb-school-year-end-status-file)

[5.1 Header Record Definition 8](#header-record-definition-1)

[5.2 Data Record Definition 9](#data-record-definition-1)

[5.3 LEA NCLB School Year End Status File Example
11](#lea-nclb-school-year-end-status-file-example)

[5.3.1 Partial Record Sample for Fixed Format LEA NCLB School Year End
Status File
11](#partial-record-sample-for-fixed-format-lea-nclb-school-year-end-status-file)

[5.3.2 Partial Record Sample for Comma-Delimited File Format LEA NCLB
School Year End Status File
11](#partial-record-sample-for-comma-delimited-file-format-lea-nclb-school-year-end-status-file)

[5.3.3 Partial Record Sample for Tab-Delimited File Format LEA NCLB
School Year End Status File
12](#partial-record-sample-for-tab-delimited-file-format-lea-nclb-school-year-end-status-file)

[6.0 SCHOOL NCLB SCHOOL YEAR END STATUS FILE
13](#school-nclb-school-year-end-status-file)

[6.1 Header Record Definition 13](#header-record-definition-2)

[6.2 Data Record Definition 14](#data-record-definition-2)

[6.3 School NCLB School Year End Status File Example
17](#school-nclb-school-year-end-status-file-example)

[6.3.1 Partial Record Sample for Fixed Format School NCLB School Year
End Status File
17](#partial-record-sample-for-fixed-format-school-nclb-school-year-end-status-file)

[6.3.2 Partial Record Sample for Comma-Delimited File Format School NCLB
School Year End Status File
18](#partial-record-sample-for-comma-delimited-file-format-school-nclb-school-year-end-status-file)

[6.3.3 Partial Record Sample for Tab-Delimited File Format School NCLB
School Year End Status File
19](#partial-record-sample-for-tab-delimited-file-format-school-nclb-school-year-end-status-file)

# PURPOSE

This document contains instructions for building fixed and delimited
files to submit EDEN Data Groups:

-   Truancy Rate, ID# 38

-   Economically Disadvantaged Students, ID #56

-   Combined MEP Funds Indicator Table, ID #514

-   GFSA Reporting Status, ID #603

-   REAP Alternative Funding Indicator, ID #614

-   Supplemental Services Provided Status, ID #545

-   Teachers Receiving High Quality Professional Development, ID #581

-   Average Daily Attendance, ID #595

-   Students applied to receive supplemental services, ID #575

-   Students eligible to receive supplemental services, ID #578

-   Students offered supplemental services, ID #612

-   Students who received supplemental educational services, ID #546

A separate document contains the XML file formats. General guidance for
constructing all EDEN file types may be found in the *Education Data
Exchange Network (EDEN)* *Workbook.*

The data in this file specification is a compilation of single counts
and indicators from a variety of education programs, some of which are
related to the *No Child Left Behind* legislation and some of which are
related to other funded programs.

## Changes from 03-04 and 04-05 File Specifications

This is a new file specification for 2005-06. It replaces parts of the
file specification used in 2003-04/2004-05 named N074 Status Prior Year.
Several elements have been added, including the new supplemental
services data elements that were originally assigned to file
specification N104 Supplemental Services:

-   Average Daily Attendance, ID #595 at the school level

-   GFSA Reporting Status, ID #603 at the LEA level

-   REAP Alternative Funding Indicator, ID #614 at the LEA level

-   Teachers Receiving High Quality Professional Development, ID #581 at
    the SEA level

-   Students applied to receive supplemental services, ID #575

-   Students eligible to receive supplemental services, ID #578

-   Students offered supplemental services, ID #612

-   Students who received supplemental educational services, ID #546

In addition, the definition of Truancy Rate (#38) was changed to remove
the reference to "previous school year." The Truancy Rate that should be
reported in this file specification is the rate for the school year
05-06.

## Requirements for Submitting this Data Group

The data group is submitted at the following levels:

-   SEA

-   LEA

-   School

**Table 1.2-1: NCLB School Year End Status File, Data Groups by Level
Table**

  ------------------------------------------------------------------------
  **SEA**                 **LEA**                  **School**
  ----------------------- ------------------------ -----------------------
  581 - Teachers                                   
  Receiving High Quality                           
  Professional                                     
  Development                                      

                          603 - GFSA Reporting     
                          Status                   

                          614 - REAP Alternative   
                          Funding Indicator        

                          38 - Truancy Rate        38 - Truancy Rate

                                                   56 - Economically
                                                   Disadvantaged Students

                                                   514 - Combined MEP
                                                   Funds Indicator Table

                                                   545 - Supplemental
                                                   Services Provided
                                                   Status

                                                   595 - Average Daily
                                                   Attendance

  575 -- Students applied 575 -- Students applied  575 -- Students applied
  to receive supplemental to receive supplemental  to receive supplemental
  services                services                 services

  578 -- Students         578 -- Students eligible 578 -- Students
  eligible to receive     to receive supplemental  eligible to receive
  supplemental services   services                 supplemental services

  612 -- Students offered 612 -- Students offered  612 -- Students offered
  supplemental services   supplemental services    supplemental services

  546 -- Students who     546 -- Students who      546 -- Students who
  received supplemental   received supplemental    received supplemental
  educational services    educational services     educational services
  ------------------------------------------------------------------------

# FILE NAMING CONVENTION

Being able to readily identify any particular file transmission is an
important consideration for users of the EDEN Data Submission System.
Being able to identify a particular file can greatly facilitate any
technical assistance that may be requested by the State. A maximum of 25
characters (including the file extension) is allowed for the file name.
The following is the naming convention for NCLB School Year End Status
file submissions:

sslevSCHYRENSTvvvvvvv.ext

Where:

> **ss** = Two-character USPS State Abbreviation for the submitting SEA.
>
> **lev** = Three-character abbreviation for the level submitted. Use:
>
> SEA for a State Education Agency NCLB School Year End Status
> submission
>
> LEA for a Local Education Agency NCLB School Year End Status
> submission
>
> SCH for a School NCLB School Year End Status submission
>
> **Filename** = **SCHYRENST** (no more than nine digits)
>
> **vvvvvvv** = Up to seven-character alphanumeric string designated by
> the SEA to uniquely identify the individual submission (e.g., ver0001,
> v010803)
>
> **.ext** = Three-character file extension identifying the file format
> as follows:

.txt = fixed format

.csv = comma-delimited format

.tab = tab-delimited format

**NOTE:** For additional information on file naming conventions, refer
to the *Educational Data Exchange Network (EDEN) Workbook*.

# GUIDANCE FOR SUBMITTING THIS FILE

For Average Daily Attendance, conversion of average daily membership (or
other similar data) to average daily attendance is permitted for local
educational agencies in States that provide State aid to local
educational agencies on the basis of average daily membership (or other
similar data). Also, if the local educational agency in which a child
resides makes a tuition or other payment for the free public education
of the child in a school located in another school district, you should
consider the child to be in attendance at a school of the agency making
the payment rather than the agency receiving the payment. Please note
this is a different methodology than the Student Membership where
children are counted in the agency providing the services.

Fields that are defined as "Number" can contain values with leading
zeros or without leading zeros. Additionally, when submitting fixed
format files, "Number" fields can be either right or left justified.
This applies to the following fields:

-   "Total Records in File" in the Header

-   "File Record Number" in the Data Record

-   "Count" fields in the Data Record, i.e., Teacher Count, Student
    Count

# STATE EDUCATION AGENCY NCLB SCHOOL YEAR END STATUS FILE

This section describes the fixed file and delimited file specifications
used to transmit information pertaining to the SEA NCLB School Year End
Status File. The file type is specified in the header record.

## Header Record Definition

The header record is required and is the first record in every file
submitted to the EDEN Submission System. 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.

Section 4.3 contains examples of the header record.

**Table 4.2-1: NCLB School Year End Status File SEA Data Record**

+--------+----+----+----+-------+---------------------+-------------+
| **Data | ** | ** | ** | *     | **Definition /      | **Permitted |
| E      | St | Le | Ty | *(M)a | Comments**          | Values**    |
| lement | ar | ng | pe | ndato |                     |             |
| Name** | t\ | th | ** | ry/** |                     |             |
|        | Po | ** |    |       |                     |             |
|        | si |    |    | **(O  |                     |             |
|        | ti |    |    | )ptio |                     |             |
|        | on |    |    | nal** |                     |             |
|        | ** |    |    |       |                     |             |
+========+====+====+====+=======+=====================+=============+
| File   | 1  | 50 | St | M     | Identifies the type | **SEA NCLB  |
| Type   |    |    | ri |       | of file being       | SCHOOL YEAR |
|        |    |    | ng |       | submitted.          | END         |
|        |    |    |    |       |                     | STATUS**    |
+--------+----+----+----+-------+---------------------+-------------+
| Total  | 51 | 10 | Nu | M     | The total number of |             |
| R      |    |    | mb |       | Data Records        |             |
| ecords |    |    | er |       | contained in the    |             |
| In     |    |    |    |       | file. The header    |             |
| File   |    |    |    |       | record is NOT       |             |
|        |    |    |    |       | included in this    |             |
|        |    |    |    |       | count               |             |
+--------+----+----+----+-------+---------------------+-------------+
| File   | 61 | 25 | St | M     | File Name and       |             |
| Name   |    |    | ri |       | extension are       |             |
| (Inc   |    |    | ng |       | provided by the     |             |
| luding |    |    |    |       | SEA. The file name  |             |
| file   |    |    |    |       | should be the same  |             |
| exte   |    |    |    |       | as the external     |             |
| nsion) |    |    |    |       | file name. (Please  |             |
|        |    |    |    |       | see *File Naming    |             |
|        |    |    |    |       | Convention* in      |             |
|        |    |    |    |       | Section 2.0 of this |             |
|        |    |    |    |       | document.)          |             |
+--------+----+----+----+-------+---------------------+-------------+
| File   | 86 | 32 | St | M     | Any combination of  |             |
| Iden   |    |    | ri |       | standard characters |             |
| tifier |    |    | ng |       | to further identify |             |
|        |    |    |    |       | the file as         |             |
|        |    |    |    |       | specified by the    |             |
|        |    |    |    |       | SEA, e.g., a date,  |             |
|        |    |    |    |       | person's name, and  |             |
|        |    |    |    |       | version number.     |             |
+--------+----+----+----+-------+---------------------+-------------+
| File   | 1  | 9  | St | M     | Enter the Academic  |             |
| Rep    | 18 |    | ri |       | School Year for     |             |
| orting |    |    | ng |       | which data is being |             |
| Period |    |    |    |       | reported. The       |             |
|        |    |    |    |       | required format for |             |
|        |    |    |    |       | entering the File   |             |
|        |    |    |    |       | Reporting Period is |             |
|        |    |    |    |       | \"CCYY-CCYY\" or    |             |
|        |    |    |    |       | \"CCYY CCYY\",      |             |
|        |    |    |    |       | where either a      |             |
|        |    |    |    |       | hyphen or a space   |             |
|        |    |    |    |       | must separate the   |             |
|        |    |    |    |       | beginning and       |             |
|        |    |    |    |       | ending years, e.g., |             |
|        |    |    |    |       | 2005-2006 or 2005   |             |
|        |    |    |    |       | 2006.               |             |
+--------+----+----+----+-------+---------------------+-------------+
| Filler | 1  | 56 | St | M     | Leave filler field  |             |
|        | 27 |    | ri |       | blank.              |             |
|        |    |    | ng |       |                     |             |
+--------+----+----+----+-------+---------------------+-------------+
| Ca     | 1  | 1  |    | M     |                     |             |
| rriage | 83 |    |    |       |                     |             |
| Retur  |    |    |    |       |                     |             |
| n/Line |    |    |    |       |                     |             |
| Feed   |    |    |    |       |                     |             |
| (CRLF) |    |    |    |       |                     |             |
+--------+----+----+----+-------+---------------------+-------------+

## Data Record Definition

Data Records are required and immediately follow the header record in
every file submitted to the EDEN Submission System. Data Records provide
counts for the specified categories as well as sub-totals and grand
totals.

Section 4.3 contains examples of Data Records.

**Table 4.2-1: NCLB School Year End Status File SEA Data Record**

+-------+----+---+----+-------+------------------------------+-------+
| **D   | *  | * | ** | *     | **Definition / Comments**    | *     |
| ata** | *S | * | Ty | *(M)a |                              | *Perm |
|       | ta | L | pe | ndato |                              | itted |
| *     | rt | e | ** | ry/** |                              | Val   |
| *Elem | Po | n |    |       |                              | ues** |
| ent** | si | g |    | **(O  |                              |       |
|       | ti | t |    | )ptio |                              |       |
| **N   | on | h |    | nal** |                              |       |
| ame** | ** | * |    |       |                              |       |
|       |    | * |    |       |                              |       |
+=======+====+===+====+=======+==============================+=======+
| File  | 1  | 6 | Nu | M     | A sequential number assigned |       |
| R     |    |   | mb |       | by the SEA that is unique to |       |
| ecord |    |   | er |       | each row entry within the    |       |
| N     |    |   |    |       | file.                        |       |
| umber |    |   |    |       |                              |       |
+-------+----+---+----+-------+------------------------------+-------+
| **ID  | 7  | 2 | St | M     | The two-digit Federal        | For a |
| 5     |    |   | ri |       | Information Processing       | list  |
| 59**\ |    |   | ng |       | Standard (FIPS) Code for the | of    |
| FIPS  |    |   |    |       | State, District of Columbia, | valid |
| State |    |   |    |       | and the possessions and      | FIPS  |
| Code  |    |   |    |       | freely associated areas of   | State |
|       |    |   |    |       | the United States (e.g.,     | C     |
|       |    |   |    |       | Puerto Rico).                | odes, |
|       |    |   |    |       |                              | refer |
|       |    |   |    |       |                              | to    |
|       |    |   |    |       |                              | the   |
|       |    |   |    |       |                              | *EDEN |
|       |    |   |    |       |                              | Workb |
|       |    |   |    |       |                              | ook.* |
+-------+----+---+----+-------+------------------------------+-------+
| **ID  | 9  | 2 | St | M     | A number used in EDEN to     | *     |
| 570\  |    |   | ri |       | uniquely identify stage      | *01** |
| **    |    |   | ng |       | agencies. This ID cannot be  | --    |
| State |    |   |    |       | updated through this file.   | State |
| A     |    |   |    |       |                              | Educ  |
| gency |    |   |    |       |                              | ation |
| N     |    |   |    |       |                              | A     |
| umber |    |   |    |       |                              | gency |
+-------+----+---+----+-------+------------------------------+-------+
| F     | 11 | 1 | St | M     | Leave filler field blank.    |       |
| iller |    | 4 | ri |       |                              |       |
|       |    |   | ng |       |                              |       |
+-------+----+---+----+-------+------------------------------+-------+
| F     | 25 | 2 | St | M     | Leave filler field blank.    |       |
| iller |    | 0 | ri |       |                              |       |
|       |    |   | ng |       |                              |       |
+-------+----+---+----+-------+------------------------------+-------+
| F     | 45 | 6 | Nu | M     | Leave filler field blank.    |       |
| iller |    |   | mb |       |                              |       |
|       |    |   | er |       |                              |       |
+-------+----+---+----+-------+------------------------------+-------+
| F     | 51 | 1 | St | M     | Leave filler field blank.    |       |
| iller |    | 5 | ri |       |                              |       |
|       |    |   | ng |       |                              |       |
+-------+----+---+----+-------+------------------------------+-------+
| F     | 66 | 1 | St | M     | Leave filler field blank.    |       |
| iller |    | 5 | ri |       |                              |       |
|       |    |   | ng |       |                              |       |
+-------+----+---+----+-------+------------------------------+-------+
| F     | 81 | 1 | St | M     | Leave filler field blank.    |       |
| iller |    | 5 | ri |       |                              |       |
|       |    |   | ng |       |                              |       |
+-------+----+---+----+-------+------------------------------+-------+
| F     | 96 | 1 | St | M     | Leave filler field blank.    |       |
| iller |    | 5 | ri |       |                              |       |
|       |    |   | ng |       |                              |       |
+-------+----+---+----+-------+------------------------------+-------+
| **ID  | 1  | 6 | Nu | O     | The number of public         |       |
| 5     | 11 |   | mb |       | elementary and secondary     |       |
| 81**\ |    |   | er |       | teachers who received high   |       |
| Tea   |    |   |    |       | quality professional         |       |
| chers |    |   |    |       | development during the       |       |
| Rece  |    |   |    |       | school year. \"High-quality  |       |
| iving |    |   |    |       | professional development\"   |       |
| High  |    |   |    |       | means professional           |       |
| Qu    |    |   |    |       | development that meets the   |       |
| ality |    |   |    |       | criteria outlined in the     |       |
| Pr    |    |   |    |       | definition of professional   |       |
| ofess |    |   |    |       | development in Title IX,     |       |
| ional |    |   |    |       | Section 9101 (34) of ESEA.   |       |
| D     |    |   |    |       |                              |       |
| evelo |    |   |    |       |                              |       |
| pment |    |   |    |       |                              |       |
+-------+----+---+----+-------+------------------------------+-------+
| F     | 1  | 6 | Nu | M     | Leave filler field blank.    |       |
| iller | 17 |   | mb |       |                              |       |
|       |    |   | er |       |                              |       |
+-------+----+---+----+-------+------------------------------+-------+
| **ID  | 1  | 1 | Nu | O     | The number of students who   | N     |
| 5     | 23 | 5 | mb |       | received supplemental        | umber |
| 46**\ |    |   | er |       | educational services during  |       |
| Stu   |    |   |    |       | the school year in           |       |
| dents |    |   |    |       | accordance with Title I,     |       |
| Who   |    |   |    |       | Part A, Section 1116.\       |       |
| Rec   |    |   |    |       | \                            |       |
| eived |    |   |    |       | Not Applicable when no       |       |
| Su    |    |   |    |       | supplemental services        |       |
| pplem |    |   |    |       | required to be provided.     |       |
| ental |    |   |    |       |                              |       |
| E     |    |   |    |       |                              |       |
| ducat |    |   |    |       |                              |       |
| ional |    |   |    |       |                              |       |
| Ser   |    |   |    |       |                              |       |
| vices |    |   |    |       |                              |       |
+-------+----+---+----+-------+------------------------------+-------+
| **ID  | 1  | 1 | Nu | O     | The number of students who   | N     |
| 575\  | 38 | 5 | mb |       | applied to receive           | umber |
| **Stu |    |   | er |       | supplemental educational     |       |
| dents |    |   |    |       | services under Section 1116  |       |
| Ap    |    |   |    |       | of Title 1 during the school |       |
| plied |    |   |    |       | year.                        |       |
| to    |    |   |    |       |                              |       |
| Re    |    |   |    |       |                              |       |
| ceive |    |   |    |       |                              |       |
| Su    |    |   |    |       |                              |       |
| pplem |    |   |    |       |                              |       |
| ental |    |   |    |       |                              |       |
| Ser   |    |   |    |       |                              |       |
| vices |    |   |    |       |                              |       |
+-------+----+---+----+-------+------------------------------+-------+
| **ID  | 1  | 1 | Nu | O     | The number of students who   | N     |
| 5     | 53 | 5 | mb |       | were eligible to receive     | umber |
| 78**\ |    |   | er |       | supplemental educational     |       |
| Stu   |    |   |    |       | services under Section 1116  |       |
| dents |    |   |    |       | of the Title 1 during the    |       |
| Eli   |    |   |    |       | school year.                 |       |
| gible |    |   |    |       |                              |       |
| to    |    |   |    |       |                              |       |
| Re    |    |   |    |       |                              |       |
| ceive |    |   |    |       |                              |       |
| Su    |    |   |    |       |                              |       |
| pplem |    |   |    |       |                              |       |
| ental |    |   |    |       |                              |       |
| Ser   |    |   |    |       |                              |       |
| vices |    |   |    |       |                              |       |
+-------+----+---+----+-------+------------------------------+-------+
| **ID  | 1  | 1 | Nu | O     | The number of students,      | N     |
| 6     | 68 | 5 | mb |       | among those who applied, who | umber |
| 12**\ |    |   | er |       | were actually offered the    |       |
| Stu   |    |   |    |       | opportunity to receive       |       |
| dents |    |   |    |       | supplemental education       |       |
| Of    |    |   |    |       | services.                    |       |
| fered |    |   |    |       |                              |       |
| Su    |    |   |    |       |                              |       |
| pplem |    |   |    |       |                              |       |
| ental |    |   |    |       |                              |       |
| Ser   |    |   |    |       |                              |       |
| vices |    |   |    |       |                              |       |
+-------+----+---+----+-------+------------------------------+-------+
| Car   | 1  | 1 |    | M     |                              |       |
| riage | 83 |   |    |       |                              |       |
| R     |    |   |    |       |                              |       |
| eturn |    |   |    |       |                              |       |
| /Line |    |   |    |       |                              |       |
| Feed  |    |   |    |       |                              |       |
| (     |    |   |    |       |                              |       |
| CRLF) |    |   |    |       |                              |       |
+-------+----+---+----+-------+------------------------------+-------+

## SEA NCLB School Year End Status File Examples

### Partial Record Sample for Fixed Format SEA NCLB School Year End Status File

The following text shows a portion of the header row and data rows.

The highlighted ruler line is provided to help the reader visually
identify the column placement of the data. The ruler line should not be
included in submitted files.

### Partial Record Sample for Comma-Delimited File Format SEA NCLB School Year End Status File

The following text shows a portion of the header row and data rows.[^1]

### Partial Record Sample for Tab-Delimited File Format SEA NCLB School Year End Status File

The following text shows a portion of the header row and data rows.^\*^

# LOCAL EDUCATION AGENCY NCLB SCHOOL YEAR END STATUS FILE 

This section describes the fixed file and delimited file specifications
used to transmit information pertaining to the LEA NCLB School Year End
Status file. The file type is specified in the header record.

## Header Record Definition

The header record is required and is the first record in every file
submitted to the EDEN Submission System. 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.

See Section 5.3 for examples of the header record.

**Table 5.1-1: NCLB School Year End Status File LEA Header Record**

+-------+-----+----+----+-------+-----------------------+-----------+
| *     | **  | ** | ** | *     | **Definition /        | **        |
| *Data | Sta | Le | Ty | *(M)a | Comments**            | Permitted |
| El    | rt\ | ng | pe | ndato |                       | Values**  |
| ement | P   | th | ** | ry/** |                       |           |
| N     | osi | ** |    |       |                       |           |
| ame** | tio |    |    | **(O  |                       |           |
|       | n** |    |    | )ptio |                       |           |
|       |     |    |    | nal** |                       |           |
+=======+=====+====+====+=======+=======================+===========+
| File  | 1   | 50 | St | M     | Identifies the type   | **LEA     |
| Type  |     |    | ri |       | of file being         | NCLB      |
|       |     |    | ng |       | submitted.            | SCHOOL    |
|       |     |    |    |       |                       | YEAR END  |
|       |     |    |    |       |                       | STATUS**  |
+-------+-----+----+----+-------+-----------------------+-----------+
| Total | 51  | 10 | Nu | M     | The total number of   |           |
| Re    |     |    | mb |       | Data Records          |           |
| cords |     |    | er |       | contained in the      |           |
| In    |     |    |    |       | file. The header      |           |
| File  |     |    |    |       | record is NOT         |           |
|       |     |    |    |       | included in this      |           |
|       |     |    |    |       | count                 |           |
+-------+-----+----+----+-------+-----------------------+-----------+
| File  | 61  | 25 | St | M     | File Name and         |           |
| Name  |     |    | ri |       | extension are         |           |
| (Incl |     |    | ng |       | provided by the SEA.  |           |
| uding |     |    |    |       | The file name should  |           |
| file  |     |    |    |       | be the same as the    |           |
| exten |     |    |    |       | external file name.   |           |
| sion) |     |    |    |       | (Please see *File     |           |
|       |     |    |    |       | Naming Convention* in |           |
|       |     |    |    |       | Section 2.0 of this   |           |
|       |     |    |    |       | document.)            |           |
+-------+-----+----+----+-------+-----------------------+-----------+
| File  | 86  | 32 | St | M     | Any combination of    |           |
| Ident |     |    | ri |       | standard characters   |           |
| ifier |     |    | ng |       | to further identify   |           |
|       |     |    |    |       | the file as specified |           |
|       |     |    |    |       | by the SEA, e.g., a   |           |
|       |     |    |    |       | date, person's name,  |           |
|       |     |    |    |       | and version number.   |           |
+-------+-----+----+----+-------+-----------------------+-----------+
| File  | 118 | 9  | St | M     | Enter the Academic    |           |
| Repo  |     |    | ri |       | School Year for which |           |
| rting |     |    | ng |       | data is being         |           |
| P     |     |    |    |       | reported. The         |           |
| eriod |     |    |    |       | required format for   |           |
|       |     |    |    |       | entering the File     |           |
|       |     |    |    |       | Reporting Period is   |           |
|       |     |    |    |       | \"CCYY-CCYY\" or      |           |
|       |     |    |    |       | \"CCYY CCYY\", where  |           |
|       |     |    |    |       | either a hyphen or a  |           |
|       |     |    |    |       | space must separate   |           |
|       |     |    |    |       | the beginning and     |           |
|       |     |    |    |       | ending years, e.g.,   |           |
|       |     |    |    |       | 2005-2006 or 2005     |           |
|       |     |    |    |       | 2006.                 |           |
+-------+-----+----+----+-------+-----------------------+-----------+
| F     | 127 | 56 | St | M     | Leave filler field    |           |
| iller |     |    | ri |       | blank.                |           |
|       |     |    | ng |       |                       |           |
+-------+-----+----+----+-------+-----------------------+-----------+
| Car   | 183 | 1  |    | M     |                       |           |
| riage |     |    |    |       |                       |           |
| R     |     |    |    |       |                       |           |
| eturn |     |    |    |       |                       |           |
| /Line |     |    |    |       |                       |           |
| Feed  |     |    |    |       |                       |           |
| (     |     |    |    |       |                       |           |
| CRLF) |     |    |    |       |                       |           |
+-------+-----+----+----+-------+-----------------------+-----------+

## Data Record Definition

Data Records are required and immediately follow the header record in
every file submitted to the EDEN Submission System. Data Records provide
counts for the specified categories as well as sub-totals and grand
totals.

See Section 5.3 for examples of the Data Record.

**Table 5.2-1: NCLB School Year End Status File LEA Data Record**

+--------+----+---+----+-------+------------------+------------------+
| **Data | *  | * | ** | *     | **Definition /   | **Permitted      |
| E      | *S | * | Ty | *(M)a | Comments**       | Values**         |
| lement | ta | L | pe | ndato |                  |                  |
| Name** | rt | e | ** | ry/** |                  |                  |
|        | Po | n |    |       |                  |                  |
|        | si | g |    | **(O  |                  |                  |
|        | ti | t |    | )ptio |                  |                  |
|        | on | h |    | nal** |                  |                  |
|        | ** | * |    |       |                  |                  |
|        |    | * |    |       |                  |                  |
+========+====+===+====+=======+==================+==================+
| File   | 1  | 6 | Nu | M     | A sequential     |                  |
| Record |    |   | mb |       | number assigned  |                  |
| Number |    |   | er |       | by the SEA that  |                  |
|        |    |   |    |       | is unique to     |                  |
|        |    |   |    |       | each row entry   |                  |
|        |    |   |    |       | within the file. |                  |
+--------+----+---+----+-------+------------------+------------------+
| **ID   | 7  | 2 | St | M     | The two-digit    | For a list of    |
| 559**\ |    |   | ri |       | Federal          | valid FIPS State |
| FIPS   |    |   | ng |       | Information      | Codes, refer to  |
| State  |    |   |    |       | Processing       | the *EDEN        |
| Code   |    |   |    |       | Standard (FIPS)  | Workbook.*       |
|        |    |   |    |       | Code for the     |                  |
|        |    |   |    |       | State, District  |                  |
|        |    |   |    |       | of Columbia, and |                  |
|        |    |   |    |       | the possessions  |                  |
|        |    |   |    |       | and freely       |                  |
|        |    |   |    |       | associated areas |                  |
|        |    |   |    |       | of the United    |                  |
|        |    |   |    |       | States (e.g.,    |                  |
|        |    |   |    |       | Puerto Rico).    |                  |
+--------+----+---+----+-------+------------------+------------------+
| **ID   | 9  | 2 | St | M     | A number used in | **01** -- State  |
| 570\   |    |   | ri |       | EDEN to uniquely | Education Agency |
| *      |    |   | ng |       | identify state   |                  |
| *State |    |   |    |       | agencies. This   |                  |
| Agency |    |   |    |       | ID cannot be     |                  |
| Number |    |   |    |       | updated through  |                  |
|        |    |   |    |       | this file.       |                  |
+--------+----+---+----+-------+------------------+------------------+
| **ID   | 11 | 1 | St | M     | The identifier   |                  |
| 4\     |    | 4 | ri |       | assigned to a    |                  |
| *      |    |   | ng |       | local education  |                  |
| *State |    |   |    |       | agency (LEA) by  |                  |
| LEA    |    |   |    |       | the State        |                  |
| Iden   |    |   |    |       | Education Agency |                  |
| tifier |    |   |    |       | (SEA). Also      |                  |
|        |    |   |    |       | known as State   |                  |
|        |    |   |    |       | LEA ID. This ID  |                  |
|        |    |   |    |       | is a required    |                  |
|        |    |   |    |       | field. This data |                  |
|        |    |   |    |       | element cannot   |                  |
|        |    |   |    |       | be updated       |                  |
|        |    |   |    |       | through this     |                  |
|        |    |   |    |       | file.            |                  |
+--------+----+---+----+-------+------------------+------------------+
| Filler | 25 | 2 | St | M     | Leave filler     |                  |
|        |    | 0 | ri |       | field blank.     |                  |
|        |    |   | ng |       |                  |                  |
+--------+----+---+----+-------+------------------+------------------+
| **ID   | 45 | 6 | Nu | O     | The truancy rate | Percentage --    |
| 38**\  |    |   | mb |       | reported for the | Numeric value of |
| T      |    |   | er |       | school year      | (5,4), with 100  |
| ruancy |    |   |    |       | according to the | percent          |
| Rate   |    |   |    |       | state            | represented as   |
|        |    |   |    |       | definition.      | 1.0000.          |
+--------+----+---+----+-------+------------------+------------------+
| Filler | 51 | 1 | St | M     | Leave filler     |                  |
|        |    | 5 | ri |       | field blank.     |                  |
|        |    |   | ng |       |                  |                  |
+--------+----+---+----+-------+------------------+------------------+
| **ID   | 66 | 1 | St | M     | An indication of | **YESWITHREP     |
| 603\   |    | 5 | ri |       | whether the      | --** Yes, with   |
| **GFSA |    |   | ng |       | local education  | reporting of one |
| Rep    |    |   |    |       | agency (LEA)     | or more students |
| orting |    |   |    |       | submitted a      | for an offense\  |
| Status |    |   |    |       | Gun-Free Schools | **YESWOREP** --  |
|        |    |   |    |       | Act (GFSA)       | Yes, without     |
|        |    |   |    |       | report to the    | reporting of any |
|        |    |   |    |       | State, as        | students\        |
|        |    |   |    |       | defined by Title | **NO**\          |
|        |    |   |    |       | 18, Section 921. | **NA** -- Not    |
|        |    |   |    |       |                  | Applicable\      |
|        |    |   |    |       |                  | **MISSING\       |
|        |    |   |    |       |                  | NOTCOLLECT** --  |
|        |    |   |    |       |                  | Not Collected    |
+--------+----+---+----+-------+------------------+------------------+
| **ID   | 81 | 1 | St | M     | An indication    | **YES**\         |
| 614**\ |    | 5 | ri |       | that the LEA     | **NO\            |
| REAP   |    |   | ng |       | notified the     | NA** -- Not      |
| Alter  |    |   |    |       | State of the     | Applicable\      |
| native |    |   |    |       | LEA\'s intention | **MISSING\       |
| F      |    |   |    |       | to use the       | NOTCOLLECT** --  |
| unding |    |   |    |       | REAP-Flex        | Not Collected    |
| Ind    |    |   |    |       | Alternative Uses |                  |
| icator |    |   |    |       | of Funding       |                  |
|        |    |   |    |       | Authority under  |                  |
|        |    |   |    |       | Section 6211     |                  |
|        |    |   |    |       | during the       |                  |
|        |    |   |    |       | school year.     |                  |
+--------+----+---+----+-------+------------------+------------------+
| Filler | 96 | 1 | St | M     | Leave filler     |                  |
|        |    | 5 | ri |       | field blank.     |                  |
|        |    |   | ng |       |                  |                  |
+--------+----+---+----+-------+------------------+------------------+
| Filler | 1  | 6 | Nu | M     | Leave filler     |                  |
|        | 11 |   | mb |       | field blank.     |                  |
|        |    |   | er |       |                  |                  |
+--------+----+---+----+-------+------------------+------------------+
| Filler | 1  | 6 | Nu | M     | Leave filler     |                  |
|        | 17 |   | mb |       | field blank.     |                  |
|        |    |   | er |       |                  |                  |
+--------+----+---+----+-------+------------------+------------------+
| **ID   | 1  | 1 | Nu | O     | The number of    | Number           |
| 546**\ | 23 | 5 | mb |       | students who     |                  |
| St     |    |   | er |       | received         |                  |
| udents |    |   |    |       | supplemental     |                  |
| Who    |    |   |    |       | educational      |                  |
| Re     |    |   |    |       | services during  |                  |
| ceived |    |   |    |       | the school year  |                  |
| Supple |    |   |    |       | in accordance    |                  |
| mental |    |   |    |       | with Title I,    |                  |
| Educa  |    |   |    |       | Part A, Section  |                  |
| tional |    |   |    |       | 1116.\           |                  |
| Se     |    |   |    |       | \                |                  |
| rvices |    |   |    |       | Not Applicable   |                  |
|        |    |   |    |       | when no          |                  |
|        |    |   |    |       | supplemental     |                  |
|        |    |   |    |       | services         |                  |
|        |    |   |    |       | required to be   |                  |
|        |    |   |    |       | provided.        |                  |
+--------+----+---+----+-------+------------------+------------------+
| **ID   | 1  | 1 | Nu | O     | The number of    | Number           |
| 575\   | 38 | 5 | mb |       | students who     |                  |
| **St   |    |   | er |       | applied to       |                  |
| udents |    |   |    |       | receive          |                  |
| A      |    |   |    |       | supplemental     |                  |
| pplied |    |   |    |       | educational      |                  |
| to     |    |   |    |       | services under   |                  |
| R      |    |   |    |       | Section 1116 of  |                  |
| eceive |    |   |    |       | Title 1 during   |                  |
| Supple |    |   |    |       | the school year. |                  |
| mental |    |   |    |       |                  |                  |
| Se     |    |   |    |       |                  |                  |
| rvices |    |   |    |       |                  |                  |
+--------+----+---+----+-------+------------------+------------------+
| **ID   | 1  | 1 | Nu | O     | The number of    | Number           |
| 578**\ | 53 | 5 | mb |       | students who     |                  |
| St     |    |   | er |       | were eligible to |                  |
| udents |    |   |    |       | receive          |                  |
| El     |    |   |    |       | supplemental     |                  |
| igible |    |   |    |       | educational      |                  |
| to     |    |   |    |       | services under   |                  |
| R      |    |   |    |       | Section 1116 of  |                  |
| eceive |    |   |    |       | the Title 1      |                  |
| Supple |    |   |    |       | during the       |                  |
| mental |    |   |    |       | school year.     |                  |
| Se     |    |   |    |       |                  |                  |
| rvices |    |   |    |       |                  |                  |
+--------+----+---+----+-------+------------------+------------------+
| **ID   | 1  | 1 | Nu | O     | The number of    | Number           |
| 612**\ | 68 | 5 | mb |       | students, among  |                  |
| St     |    |   | er |       | those who        |                  |
| udents |    |   |    |       | applied, who     |                  |
| O      |    |   |    |       | were actually    |                  |
| ffered |    |   |    |       | offered the      |                  |
| Supple |    |   |    |       | opportunity to   |                  |
| mental |    |   |    |       | receive          |                  |
| Se     |    |   |    |       | supplemental     |                  |
| rvices |    |   |    |       | education        |                  |
|        |    |   |    |       | services.        |                  |
+--------+----+---+----+-------+------------------+------------------+
| Ca     | 1  | 1 |    | M     |                  |                  |
| rriage | 83 |   |    |       |                  |                  |
| Retur  |    |   |    |       |                  |                  |
| n/Line |    |   |    |       |                  |                  |
| Feed   |    |   |    |       |                  |                  |
| (CRLF) |    |   |    |       |                  |                  |
+--------+----+---+----+-------+------------------+------------------+

## LEA NCLB School Year End Status File Example 

### Partial Record Sample for Fixed Format LEA NCLB School Year End Status File

The following text shows a portion of the header row and data rows. The
highlighted ruler line is provided to help the reader visually identify
the column placement of the data. The ruler line should not be included
in submitted files.

### Partial Record Sample for Comma-Delimited File Format LEA NCLB School Year End Status File

The following text shows a portion of the header row and data rows.[^2]

### Partial Record Sample for Tab-Delimited File Format LEA NCLB School Year End Status File

The following text shows a portion of the header row and data rows. [^3]

# SCHOOL NCLB SCHOOL YEAR END STATUS FILE 

This section describes the fixed file and delimited file specifications
used to transmit information pertaining to the School NCLB School Year
End Status file type. The file type is specified in the header record.

## Header Record Definition

The header record is required and is the first record in every file
submitted to the EDEN Submission System. 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.

See Section 6.3 for examples of the header record.

**Table 6.1-1: NCLB School Year End Status File School Header Record**

+-------+----+---+----+-------+-------------------------+-----------+
| *     | ** | * | ** | *     | **Definition /          | **        |
| *Data | St | * | Ty | *(M)a | Comments**              | Permitted |
| El    | ar | L | pe | ndato |                         | Values**  |
| ement | t\ | e | ** | ry/** |                         |           |
| N     | Po | n |    |       |                         |           |
| ame** | si | g |    | **(O  |                         |           |
|       | ti | t |    | )ptio |                         |           |
|       | on | h |    | nal** |                         |           |
|       | ** | * |    |       |                         |           |
|       |    | * |    |       |                         |           |
+=======+====+===+====+=======+=========================+===========+
| File  | 1  | 5 | St | M     | Identifies the type of  | **SCHOOL  |
| Type  |    | 0 | ri |       | file being submitted.   | NCLB      |
|       |    |   | ng |       |                         | SCHOOL    |
|       |    |   |    |       |                         | YEAR END  |
|       |    |   |    |       |                         | STATUS**  |
+-------+----+---+----+-------+-------------------------+-----------+
| Total | 51 | 1 | Nu | M     | The total number of     |           |
| Re    |    | 0 | mb |       | Data Records contained  |           |
| cords |    |   | er |       | in the file. The header |           |
| In    |    |   |    |       | record is NOT included  |           |
| File  |    |   |    |       | in this count           |           |
+-------+----+---+----+-------+-------------------------+-----------+
| File  | 61 | 2 | St | M     | File Name and extension |           |
| Name  |    | 5 | ri |       | are provided by the     |           |
| (Incl |    |   | ng |       | SEA. The file name      |           |
| uding |    |   |    |       | should be the same as   |           |
| file  |    |   |    |       | the external file name. |           |
| exten |    |   |    |       | (Please see *File       |           |
| sion) |    |   |    |       | Naming Convention* in   |           |
|       |    |   |    |       | Section 2.0 of this     |           |
|       |    |   |    |       | document.)              |           |
+-------+----+---+----+-------+-------------------------+-----------+
| File  | 86 | 3 | St | M     | Any combination of      |           |
| Ident |    | 2 | ri |       | standard characters to  |           |
| ifier |    |   | ng |       | further identify the    |           |
|       |    |   |    |       | file as specified by    |           |
|       |    |   |    |       | the SEA, e.g., a date,  |           |
|       |    |   |    |       | person's name, and      |           |
|       |    |   |    |       | version number.         |           |
+-------+----+---+----+-------+-------------------------+-----------+
| File  | 1  | 9 | St | M     | Enter the Academic      |           |
| Repo  | 18 |   | ri |       | School Year for which   |           |
| rting |    |   | ng |       | data is being reported. |           |
| P     |    |   |    |       | The required format for |           |
| eriod |    |   |    |       | entering the File       |           |
|       |    |   |    |       | Reporting Period is     |           |
|       |    |   |    |       | \"CCYY-CCYY\" or \"CCYY |           |
|       |    |   |    |       | CCYY\", where either a  |           |
|       |    |   |    |       | hyphen or a space must  |           |
|       |    |   |    |       | separate the beginning  |           |
|       |    |   |    |       | and ending years, e.g., |           |
|       |    |   |    |       | 2005-2006 or 2005 2006. |           |
+-------+----+---+----+-------+-------------------------+-----------+
| F     | 1  | 5 | St | M     | Leave filler field      |           |
| iller | 27 | 6 | ri |       | blank.                  |           |
|       |    |   | ng |       |                         |           |
+-------+----+---+----+-------+-------------------------+-----------+
| Car   | 1  | 1 |    | M     |                         |           |
| riage | 83 |   |    |       |                         |           |
| R     |    |   |    |       |                         |           |
| eturn |    |   |    |       |                         |           |
| /Line |    |   |    |       |                         |           |
| Feed  |    |   |    |       |                         |           |
| (     |    |   |    |       |                         |           |
| CRLF) |    |   |    |       |                         |           |
+-------+----+---+----+-------+-------------------------+-----------+

## Data Record Definition

Data Records are required and immediately follow the header record in
every file submitted to the EDEN Submission System. Data Records provide
counts for the specified categories as well as sub-totals and grand
totals.

See Section 6.3 for examples of the Data Record.

**Table 6.2-1: NCLB School Year End Status File School Data Record**

+--------+----+---+----+-------+-------------------+----------------+
| **Data | *  | * | ** | *     | **Definition /    | **Permitted    |
| E      | *S | * | Ty | *(M)a | Comments**        | Values**       |
| lement | ta | L | pe | ndato |                   |                |
| Name** | rt | e | ** | ry/** |                   |                |
|        | Po | n |    |       |                   |                |
|        | si | g |    | **(O  |                   |                |
|        | ti | t |    | )ptio |                   |                |
|        | on | h |    | nal** |                   |                |
|        | ** | * |    |       |                   |                |
|        |    | * |    |       |                   |                |
+========+====+===+====+=======+===================+================+
| File   | 1  | 6 | Nu | M     | A sequential      |                |
| Record |    |   | mb |       | number assigned   |                |
| Number |    |   | er |       | by the SEA that   |                |
|        |    |   |    |       | is unique to each |                |
|        |    |   |    |       | row entry within  |                |
|        |    |   |    |       | the file.         |                |
+--------+----+---+----+-------+-------------------+----------------+
| **ID   | 7  | 2 | St | M     | The two-digit     | For a list of  |
| 559**\ |    |   | ri |       | Federal           | valid FIPS     |
| FIPS   |    |   | ng |       | Information       | State Codes,   |
| State  |    |   |    |       | Processing        | refer to the   |
| Code   |    |   |    |       | Standard (FIPS)   | *EDEN          |
|        |    |   |    |       | Code for the      | Workbook.*     |
|        |    |   |    |       | State, District   |                |
|        |    |   |    |       | of Columbia, and  |                |
|        |    |   |    |       | the possessions   |                |
|        |    |   |    |       | and freely        |                |
|        |    |   |    |       | associated areas  |                |
|        |    |   |    |       | of the United     |                |
|        |    |   |    |       | States (e.g.,     |                |
|        |    |   |    |       | Puerto Rico).     |                |
+--------+----+---+----+-------+-------------------+----------------+
| **ID   | 9  | 2 | St | M     | A number used in  | **01** --      |
| 570\   |    |   | ri |       | EDEN to uniquely  | State          |
| *      |    |   | ng |       | identify state    | Education      |
| *State |    |   |    |       | agencies. This ID | Agency         |
| Agency |    |   |    |       | cannot be updated |                |
| Number |    |   |    |       | through this      |                |
|        |    |   |    |       | file.             |                |
+--------+----+---+----+-------+-------------------+----------------+
| **ID   | 11 | 1 | St | M     | The identifier    |                |
| 4**\   |    | 4 | ri |       | assigned to a     |                |
| State  |    |   | ng |       | local education   |                |
| LEA    |    |   |    |       | agency (LEA) by   |                |
| Iden   |    |   |    |       | the State         |                |
| tifier |    |   |    |       | Education Agency  |                |
|        |    |   |    |       | (SEA). Also known |                |
|        |    |   |    |       | as State LEA ID.  |                |
|        |    |   |    |       | This ID is a      |                |
|        |    |   |    |       | required field.   |                |
|        |    |   |    |       | This data element |                |
|        |    |   |    |       | cannot be updated |                |
|        |    |   |    |       | through this      |                |
|        |    |   |    |       | file.             |                |
+--------+----+---+----+-------+-------------------+----------------+
| **ID   | 25 | 2 | St | M     | The identifier    |                |
| 5\     |    | 0 | ri |       | assigned to a     |                |
| *      |    |   | ng |       | school by the     |                |
| *State |    |   |    |       | State Education   |                |
| School |    |   |    |       | Agency. Also      |                |
| Iden   |    |   |    |       | known as the      |                |
| tifier |    |   |    |       | State School      |                |
|        |    |   |    |       | Identification    |                |
|        |    |   |    |       | Number. This ID   |                |
|        |    |   |    |       | cannot be updated |                |
|        |    |   |    |       | through this      |                |
|        |    |   |    |       | file.             |                |
+--------+----+---+----+-------+-------------------+----------------+
| **ID   | 45 | 6 | Nu | O     | The truancy rate  | Percentage --  |
| 38**\  |    |   | mb |       | reported for the  | Numeric value  |
| T      |    |   | er |       | school year       | of (5,4), with |
| ruancy |    |   |    |       | according to the  | 100 percent    |
| Rate   |    |   |    |       | state definition. | represented as |
|        |    |   |    |       |                   | 1.0000.        |
+--------+----+---+----+-------+-------------------+----------------+
| **ID   | 51 | 1 | St | M     | An indication of  | **YES\         |
| 514**\ |    | 5 | ri |       | whether the       | NO\            |
| Co     |    |   | ng |       | school has a      | NOPROG** --    |
| mbined |    |   |    |       | Title I           | School does    |
| MEP    |    |   |    |       | school-wide       | not have       |
| Funds  |    |   |    |       | program in which  | either a Title |
| Ind    |    |   |    |       | migrant education | I school-wide  |
| icator |    |   |    |       | program (MEP)     | program or a   |
|        |    |   |    |       | funds are         | migrant        |
|        |    |   |    |       | combined.         | education      |
|        |    |   |    |       |                   | program\       |
|        |    |   |    |       |                   | **MISSING**\   |
|        |    |   |    |       |                   | **NOTCOLLECT** |
|        |    |   |    |       |                   | -- Not         |
|        |    |   |    |       |                   | collected by   |
|        |    |   |    |       |                   | State          |
+--------+----+---+----+-------+-------------------+----------------+
| Filler | 66 | 1 | St | M     | Leave filler      |                |
|        |    | 5 | ri |       | field blank.      |                |
|        |    |   | ng |       |                   |                |
+--------+----+---+----+-------+-------------------+----------------+
| Filler | 81 | 1 | St | M     | Leave filler      |                |
|        |    | 5 | ri |       | field blank.      |                |
|        |    |   | ng |       |                   |                |
+--------+----+---+----+-------+-------------------+----------------+
| **ID   | 96 | 1 | St | M     | An indication of  | **YES\         |
| 545**\ |    | 5 | ri |       | whether the       | NO\            |
| Supple |    |   | ng |       | students within   | NOTREQ** --    |
| mental |    |   |    |       | the school        | Not required\  |
| Se     |    |   |    |       | received          | to provide     |
| rvices |    |   |    |       | supplemental      | supplemental\  |
| Pr     |    |   |    |       | educational       | services\      |
| ovided |    |   |    |       | services under    | **MISSING**\   |
| Status |    |   |    |       | the provisions    | **NOTCOLLECT** |
|        |    |   |    |       | for supplemental  | -- Not         |
|        |    |   |    |       | educational       | collected\     |
|        |    |   |    |       | services in       | by State       |
|        |    |   |    |       | Section 1116 of   |                |
|        |    |   |    |       | Title I during    |                |
|        |    |   |    |       | the school year.  |                |
+--------+----+---+----+-------+-------------------+----------------+
| **ID   | 1  | 6 | Nu | M     | The unduplicated  | Number         |
| 56**\  | 11 |   | mb |       | number of         |                |
| Econom |    |   | er |       | students who met  |                |
| ically |    |   |    |       | the state         |                |
| D      |    |   |    |       | criteria for      |                |
| isadva |    |   |    |       | classification as |                |
| ntaged |    |   |    |       | economically      |                |
| St     |    |   |    |       | disadvantaged     |                |
| udents |    |   |    |       | according to the  |                |
|        |    |   |    |       | state definition. |                |
+--------+----+---+----+-------+-------------------+----------------+
| **ID   | 1  | 6 | Nu | O     | The average       | Number         |
| 595\   | 17 |   | mb |       | number of         |                |
| **A    |    |   | er |       | students in daily |                |
| verage |    |   |    |       | attendance        |                |
| Daily  |    |   |    |       | computed          |                |
| Atte   |    |   |    |       | according to      |                |
| ndance |    |   |    |       | state law or      |                |
|        |    |   |    |       | regulation, or if |                |
|        |    |   |    |       | no state          |                |
|        |    |   |    |       | definition        |                |
|        |    |   |    |       | exists, the       |                |
|        |    |   |    |       | aggregate number  |                |
|        |    |   |    |       | of days of        |                |
|        |    |   |    |       | attendance by     |                |
|        |    |   |    |       | students divided  |                |
|        |    |   |    |       | by the aggregate  |                |
|        |    |   |    |       | number of days of |                |
|        |    |   |    |       | enrollment of     |                |
|        |    |   |    |       | students.         |                |
+--------+----+---+----+-------+-------------------+----------------+
| **ID   | 1  | 1 | Nu | O     | The number of     | Number         |
| 546**\ | 23 | 5 | mb |       | students who      |                |
| St     |    |   | er |       | received          |                |
| udents |    |   |    |       | supplemental      |                |
| Who    |    |   |    |       | educational       |                |
| Re     |    |   |    |       | services during   |                |
| ceived |    |   |    |       | the school year   |                |
| Supple |    |   |    |       | in accordance     |                |
| mental |    |   |    |       | with Title I,     |                |
| Educa  |    |   |    |       | Part A, Section   |                |
| tional |    |   |    |       | 1116.\            |                |
| Se     |    |   |    |       | \                 |                |
| rvices |    |   |    |       | Not Applicable    |                |
|        |    |   |    |       | when no           |                |
|        |    |   |    |       | supplemental      |                |
|        |    |   |    |       | services required |                |
|        |    |   |    |       | to be provided.   |                |
+--------+----+---+----+-------+-------------------+----------------+
| **ID   | 1  | 1 | Nu | O     | The number of     | Number         |
| 575\   | 38 | 5 | mb |       | students who      |                |
| **St   |    |   | er |       | applied to        |                |
| udents |    |   |    |       | receive           |                |
| A      |    |   |    |       | supplemental      |                |
| pplied |    |   |    |       | educational       |                |
| to     |    |   |    |       | services under    |                |
| R      |    |   |    |       | Section 1116 of   |                |
| eceive |    |   |    |       | Title 1 during    |                |
| Supple |    |   |    |       | the school year.  |                |
| mental |    |   |    |       |                   |                |
| Se     |    |   |    |       |                   |                |
| rvices |    |   |    |       |                   |                |
+--------+----+---+----+-------+-------------------+----------------+
| **ID   | 1  | 1 | Nu | O     | The number of     | Number         |
| 578**\ | 53 | 5 | mb |       | students who were |                |
| St     |    |   | er |       | eligible to       |                |
| udents |    |   |    |       | receive           |                |
| El     |    |   |    |       | supplemental      |                |
| igible |    |   |    |       | educational       |                |
| to     |    |   |    |       | services under    |                |
| R      |    |   |    |       | Section 1116 of   |                |
| eceive |    |   |    |       | the Title 1       |                |
| Supple |    |   |    |       | during the school |                |
| mental |    |   |    |       | year.             |                |
| Se     |    |   |    |       |                   |                |
| rvices |    |   |    |       |                   |                |
+--------+----+---+----+-------+-------------------+----------------+
| **ID   | 1  | 1 | Nu | O     | The number of     | Number         |
| 612**\ | 68 | 5 | mb |       | students, among   |                |
| St     |    |   | er |       | those who         |                |
| udents |    |   |    |       | applied, who were |                |
| O      |    |   |    |       | actually offered  |                |
| ffered |    |   |    |       | the opportunity   |                |
| Supple |    |   |    |       | to receive        |                |
| mental |    |   |    |       | supplemental      |                |
| Se     |    |   |    |       | education         |                |
| rvices |    |   |    |       | services.         |                |
+--------+----+---+----+-------+-------------------+----------------+
| Ca     | 1  | 1 |    | M     |                   |                |
| rriage | 83 |   |    |       |                   |                |
| Retur  |    |   |    |       |                   |                |
| n/Line |    |   |    |       |                   |                |
| Feed   |    |   |    |       |                   |                |
| (CRLF) |    |   |    |       |                   |                |
+--------+----+---+----+-------+-------------------+----------------+

## School NCLB School Year End Status File Example 

### Partial Record Sample for Fixed Format School NCLB School Year End Status File

The following text shows a portion of the header row and data rows.

The highlighted ruler line is provided to help the reader visually
identify the column placement of the data. The ruler line should not be
included in submitted files.

### Partial Record Sample for Comma-Delimited File Format School NCLB School Year End Status File

The following text shows a portion of the header row and data rows.[^4]

### Partial Record Sample for Tab-Delimited File Format School NCLB School Year End Status File

The following text shows a portion of the header row and data rows.[^5]

![](media/image1.png){width="1.5in" height="1.5in"}

Our mission is to ensure equal access to education and to promote
educational excellence throughout the nation.

www.ed.gov

[^1]: ^\*^ Using EXCEL will produce extraneous delimiters at the end of
    the header record. They will be disregarded during file processing
    and so will not generate a file format error.

[^2]: ^\*^ Using EXCEL will produce extraneous delimiters at the end of
    the header record. They will be disregarded during file processing
    and so will not generate a file format error.

[^3]: ^\*^ Using EXCEL will produce extraneous delimiters at the end of
    the header record. They will be disregarded during file processing
    and so will not generate a file format error.

[^4]: ^\*^ Using EXCEL will produce extraneous delimiters at the end of
    the header record. They will be disregarded during file processing
    and so will not generate a file format error.

[^5]: ^\*^ Using EXCEL will produce extraneous delimiters at the end of
    the header record. They will be disregarded during file processing
    and so will not generate a file format error.