![](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 3.2**

**SY 2006-07**

**January 2008**

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**

Williamson "Bill" M. Evers

*Assistant Secretary*

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

January 2008

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, *N102
-- NCLB School Year End Status File Specifications*, Washington, D.C.,
2008.

This technical guide is also available on the Department's Web site at:
<http://www.ed.gov/edfacts>

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___Toc188249847 .anchor}DOCUMENT CONTROL

DOCUMENT INFORMATION

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

  **Revision:**   Version 3.2

  **Issue Date:** January 2008

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

  **Filename:**   756660.doc
  --------------- ---------------------------------------------------------

DOCUMENT HISTORY

+-------+-------------+-----------------------------------------------+
| **Ve  | **Date**    | **Summary of Change**                         |
| rsion |             |                                               |
| Num   |             |                                               |
| ber** |             |                                               |
+=======+=============+===============================================+
| 1.0   |             | This file specification was not used for SYs  |
|       |             | 2003-04 and 2004-05. See N074 -- Status Prior |
|       |             | Year for those school years.                  |
+-------+-------------+-----------------------------------------------+
| 2.0   |             | Version 2.0 or subsequent updates (i.e. 2.1,  |
|       |             | 2.2, etc) of this file specification is used  |
|       |             | to build files for SY 2005-06                 |
+-------+-------------+-----------------------------------------------+
| 3.0   | May 2007    | Updated for SY 2006-07                        |
|       |             |                                               |
|       |             | -   1.0, 4.2: Deleted data group #581 --      |
|       |             |     Teachers Receiving High Quality           |
|       |             |     Professional Development                  |
|       |             |                                               |
|       |             | -   1.0, 5.2, 6.2: Deleted data group #38 --  |
|       |             |     Truancy Rate -- replaced with #664,       |
|       |             |     Truants                                   |
|       |             |                                               |
|       |             | -   1.0, 6.2: Deleted data group #545 --      |
|       |             |     Supplemental Services Provided Status     |
|       |             |                                               |
|       |             | -   1.0, 4.2, 5.2, 6.2: Revised the data      |
|       |             |     group name and definition for data group  |
|       |             |     546 -- Supplemental Services -- Received  |
|       |             |     Services. Also removed from the school    |
|       |             |     data record layout                        |
|       |             |                                               |
|       |             | -   1.0, 4.2, 5.2, 6.2: Revised the data      |
|       |             |     group name and definition for data group  |
|       |             |     575 -- Supplemental Services -- Applied   |
|       |             |     to Receive Services. Also removed from    |
|       |             |     the school data record layout             |
|       |             |                                               |
|       |             | -   1.0, 4.2, 5.2, 6.2: Revised the data      |
|       |             |     group name and definition for data group  |
|       |             |     578 -- Supplemental Services -- Eligible  |
|       |             |     to Receive Services. Also removed from    |
|       |             |     the school data record layout             |
|       |             |                                               |
|       |             | -   1.0, 5.2: Added data group 651 --         |
|       |             |     Supplemental Services -- Funds Spent at   |
|       |             |     the LEA level only                        |
|       |             |                                               |
|       |             | -   1.0, 5.2: Added data group 652 -- School  |
|       |             |     Choice -- Funds Spent at the LEA level    |
|       |             |     only                                      |
|       |             |                                               |
|       |             | -   1.0, 5.2, 6.2: Added data group 603 --    |
|       |             |     GFSA Reporting Status to the school level |
|       |             |     data collection and revised the           |
|       |             |     definition to include schools.            |
|       |             |                                               |
|       |             | -   1.0, 5.2, 6.2: Added data group 664 --    |
|       |             |     Truants at the LEA and the School levels. |
|       |             |                                               |
|       |             | -   1.0, 6.2: Added Data Group 110 -- MEP     |
|       |             |     Students Eligible Regular School Year.    |
|       |             |     This data group was moved from the N/X53  |
|       |             |     file specification.                       |
|       |             |                                               |
|       |             | -   6.2: Revised data group name Combined MEP |
|       |             |     Funds Status, ID #514                     |
|       |             |                                               |
|       |             | -   6.2: Revised data group definition for    |
|       |             |     Average Daily Attendance, ID #595 to make |
|       |             |     it a decimal number                       |
|       |             |                                               |
|       |             | -   4.2, 5.2, 6.2: Added Explanation Fields   |
+-------+-------------+-----------------------------------------------+
| 3.1   | November    | -   3.2: Added Guidance of Average Daily      |
|       | 2007        |     Attendance.                               |
|       |             |                                               |
|       |             | -   6.2: Revised the definition of ID 595     |
|       |             |     Average Daily Attendance.                 |
+-------+-------------+-----------------------------------------------+
| 3.2   | January     | -   3.2: Added to guidance for Data Group     |
|       | 2008        |     Specific Guidance file format.            |
+-------+-------------+-----------------------------------------------+

RELEASE AUTHORIZATION

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

  Author                  

  QA                      

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

[]{#__RefHeading___Toc188249848 .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 ED*Facts* Workbook,
ED*Facts* Business Rules Guide and the EDEN Submission System User
Guide.

EDEN is a centralized, coordinated repository of state reported, K
through 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___Toc188249847)

[PREFACE iv](#__RefHeading___Toc188249848)

[1.0 PURPOSE 1](#purpose)

[1.1 Changes from the SY 2005-06 File Specifications
1](#changes-from-the-sy-2005-06-file-specifications)

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

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

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

[3.1 General Guidance 4](#general-guidance)

[3.2 Data Group Specific Guidance 4](#data-group-specific-guidance)

[3.3 Population Status 5](#population-status)

[4.0 SEA NCLB SCHOOL YEAR END STATUS FILE
6](#sea-nclb-school-year-end-status-file)

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

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

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

[4.3.1 Partial Record Sample for Fixed Format SEA NCLB School Year End
Status File
9](#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
9](#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
9](#partial-record-sample-for-tab-delimited-file-format-sea-nclb-school-year-end-status-file)

[5.0 LEA NCLB SCHOOL YEAR END STATUS FILE
10](#lea-nclb-school-year-end-status-file)

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

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

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

[5.3.1 Partial Record Sample for Fixed Format LEA NCLB School Year End
Status File
14](#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
15](#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
15](#partial-record-sample-for-tab-delimited-file-format-lea-nclb-school-year-end-status-file)

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

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

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

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

[6.3.1 Partial Record Sample for Fixed Format School NCLB School Year
End Status File
19](#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
20](#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
21](#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 ED*Facts* Data Groups:

-   Average Daily Attendance, ID #595

-   Combined MEP Funds Status, ID #514

-   Economically Disadvantaged Students, ID #56

-   GFSA Reporting Status, ID #603

-   MEP Students Eligible Regular School Year, ID#110

-   REAP Alternative Funding Indicator, ID #614

-   School Choice -- Funds Spent, ID #652

-   Supplemental Services -- Applied to Receive Services, ID #575

-   Supplemental Services -- Eligible to Receive Services, ID #578

-   Supplemental Services -- Funds Spent, ID #651

-   Supplemental Services -- Offered, ID #612

-   Supplemental Services -- Received Services, ID #546

-   Truants, ID #664

A separate document contains the XML file formats. General guidance for
constructing all EDEN file types may be found in the ED*Facts*
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 the SY 2005-06 File Specifications

There have been significant changes to this file specification:

-   Deleted data groups 38 -- Truancy Rate (replaced with 664 --
    Truants)

-   Deleted data groups 545 -- Supplemental Services Provided Status

-   Deleted data groups 581 -- Teachers Receiving High Quality
    Professional Development

-   Added data group 651 -- Supplemental Services -- Funds Spent, at the
    LEA level only

-   Added data group 652 -- School Choice -- Funds Spent, at the LEA
    level only

-   Added data group 664 -- Truants, at the LEA and School levels. This
    replaces data group 38, Truancy Rate.

-   Removed data group 546 -- Supplemental Services -- Received
    Services, from the school level only. Also revised the data group
    name and definition for clarity.

-   Removed data group 575 -- Supplemental Services -- Applied to
    Receive Services, from the school level only. Also revised the data
    group name and definition for clarity.

-   Removed data group 578 -- Supplemental Services -- Eligible to
    Receive Services, from the school level only. Also revised the data
    group name and definition for clarity.

-   Added data group 603 -- GFSA Reporting Status, to the school level
    data collection and revised the data group definition to include
    schools.

-   Added data group 110 -- MEP Students Eligible Regular School Year to
    the school level only. This data group was deleted from the N/X53
    file specification, is now collected as a single count rather than a
    count with multiple categories.

-   Revised data group 595 -- Average Daily Attendance to provide one
    decimal place in the number, rather than a whole number.

-   Revised data group name Combined MEP Funds Status, ID #514 from
    Combined MEP Funds Indicator.

-   Added Explanation Fields to all levels.

## Requirements for Submitting this Data Group

The data groups listed in Table 1.2-1 below are 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**
  ----------------------- ------------------------ -----------------------
  546 -- Supplemental     546 -- Supplemental      
  Services -- Received    Services -- Received     
  Services                Services                 

  575 -- Supplemental     575 -- Supplemental      
  Services -- Applied to  Services -- Applied to   
  Receive Services        Receive Services         

  578 -- Supplemental     578 -- Supplemental      
  Services -- Eligible to Services -- Eligible to  
  Receive Services        Receive Services         

  612 -- Supplemental     612 -- Supplemental      
  Services - Offered      Services - Offered       

                          614 - REAP Alternative   
                          Funding Indicator        

                          651 -- Supplemental      
                          Services -- Funds Spent  

                          652 -- School Choice --  
                          Funds Spent              

                          603 -- GFSA Reporting    603 -- GFSA Reporting
                          Status                   Status

                          664 -- Truants           664 - Truants

                                                   56 - Economically
                                                   Disadvantaged Students

                                                   110 -- MEP Students
                                                   Eligible Regular School
                                                   Year

                                                   514 - Combined MEP
                                                   Funds Status Table

                                                   595 - Average Daily
                                                   Attendance
  ------------------------------------------------------------------------

# 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:

sslev**SCHYRENST**vvvvvvv.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 characters)
>
> **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

# GUIDANCE FOR SUBMITTING THIS FILE

## General Guidance

This file specification collects a number of data elements including
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.

Most of the data elements in this file are cumulative counts or data for
the school year. The two exceptions to this are data group #56,
Economically Disadvantaged Students and data group #514, Combined MEP
Funds Status, which are both to be reported as of October 1^st^ of the
school year.

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

## Data Group Specific Guidance

Supplemental Services counts of students are not reported when no
supplemental services are required to be provided for the given level
(SEA or LEA). If these counts are not applicable, leave the fields blank
(fixed format) or null (delimited formats).

In the definition of Truants, the phrase \"threshold definition\" refers
to the number of unexcused absences before a student is deemed truant.
For example, some states allow 5 and others allow 10 unexcused absences
after which the student is deemed truant.

Please note that the Combined MEP Funds Status (#514) values are very
specific. A "No" value means that funds are not combined OR the school
does not have a Title I schoolwide program. A value of "No Program" is
used when the school does not have a migrant education program.

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 used for Student Membership where
children are counted in the agency providing the services.

If no state definition, average daily attendance can be computed by
dividing the aggregate number of days of attendance by the number of
days in the school year.

Data Group ID# 652 - School Choice - Funds Spent: Fixed-length file
format limits the cell size to 6 digits. Comma-delimited and
Tab-delimited formats do not have the same constraint, therefore, are
recommended for submissions with Funds Spent values greater than 6
digits.

## Population Status

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 1.2-1
>
> O - Optional, data in this field is optional

# SEA 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 Header Record**

  -----------------------------------------------------------------------------------------------------
  **Data       **Start\     **Length**   **Type**   **Pop**   **Definition / Comments**   **Permitted
  Element      Position**                                                                 Values**
  Name**                                                                                  
  ------------ ------------ ------------ ---------- --------- --------------------------- -------------
  File Type    1            50           String     M         Identifies the type of file **SEA NCLB
                                                              being submitted.            SCHOOL YEAR
                                                                                          END STATUS**

  Total        51           10           Number     M         The total number of Data     
  Records In                                                  Records contained in the    
  File                                                        file. The header record is  
                                                              NOT included in this count  

  File Name    61           25           String     M         File Name and extension are  
  (Including                                                  provided by the SEA. The    
  file                                                        file name should be the     
  extension)                                                  same as the external file   
                                                              name. (Please see *File     
                                                              Naming Convention* in       
                                                              Section 2.0 of this         
                                                              document.)                  

  File         86           32           String     M         Any combination of standard  
  Identifier                                                  characters to further       
                                                              identify the file as        
                                                              specified by the SEA, e.g., 
                                                              a date, person's name, and  
                                                              version number.             

  File         118          9            String     M         Enter the Academic School    
  Reporting                                                   Year for which data is      
  Period                                                      being 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.,         
                                                              2006-2007 or 2006 2007.     

  Filler       127          256          String     M         Leave filler field blank.    

  Carriage     383          1                       M                                     
  Return /                                                                                
  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**

+-------+----+---+----+---+-----------------------------------+-------+
| *     | *  | * | ** | * | **Definition / Comments**         | *     |
| *Data | *S | * | Ty | * |                                   | *Perm |
| El    | ta | L | pe | P |                                   | itted |
| ement | rt | e | ** | o |                                   | Val   |
| N     | Po | n |    | p |                                   | ues** |
| ame** | si | g |    | * |                                   |       |
|       | ti | t |    | * |                                   |       |
|       | on | h |    |   |                                   |       |
|       | ** | * |    |   |                                   |       |
|       |    | * |    |   |                                   |       |
+=======+====+===+====+===+===================================+=======+
| File  | 1  | 6 | Nu | M | A sequential number assigned by   |       |
| R     |    |   | mb |   | the SEA that is unique to each    |       |
| ecord |    |   | er |   | row entry within the file.        |       |
| N     |    |   |    |   |                                   |       |
| umber |    |   |    |   |                                   |       |
+-------+----+---+----+---+-----------------------------------+-------+
| **ID  | 7  | 2 | St | M | The two-digit Federal Information | For a |
| 5     |    |   | ri |   | Processing Standard (FIPS) Code   | list  |
| 59**\ |    |   | ng |   | for the State, District of        | of    |
| FIPS  |    |   |    |   | Columbia, and the possessions and | valid |
| State |    |   |    |   | freely associated areas of the    | FIPS  |
| Code  |    |   |    |   | United States (e.g., Puerto       | State |
|       |    |   |    |   | Rico).                            | C     |
|       |    |   |    |   |                                   | odes, |
|       |    |   |    |   |                                   | refer |
|       |    |   |    |   |                                   | to    |
|       |    |   |    |   |                                   | the   |
|       |    |   |    |   |                                   | ED*F  |
|       |    |   |    |   |                                   | acts* |
|       |    |   |    |   |                                   | Work  |
|       |    |   |    |   |                                   | book. |
+-------+----+---+----+---+-----------------------------------+-------+
| **ID  | 9  | 2 | St | M | A number used in EDEN to uniquely | *     |
| 570\  |    |   | ri |   | identify stage agencies. This ID  | *01** |
| **    |    |   | ng |   | cannot be updated through this    | =     |
| State |    |   |    |   | 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 |   |                                   |       |
+-------+----+---+----+---+-----------------------------------+-------+
| F     | 1  | 6 | St | M | Leave filler field blank.         |       |
| iller | 11 |   | ri |   |                                   |       |
|       |    |   | ng |   |                                   |       |
+-------+----+---+----+---+-----------------------------------+-------+
| F     | 1  | 6 | Nu | M | Leave filler field blank.         |       |
| iller | 17 |   | mb |   |                                   |       |
|       |    |   | er |   |                                   |       |
+-------+----+---+----+---+-----------------------------------+-------+
| **ID  | 1  | 1 | Nu | O | The unduplicated number of        |       |
| 5     | 23 | 5 | mb |   | eligible students who received    |       |
| 46**\ |    |   | er |   | supplemental educational services |       |
| Su    |    |   |    |   | during the school year in         |       |
| pplem |    |   |    |   | accordance with Title I, Part A,  |       |
| ental |    |   |    |   | Section 1116.\                    |       |
| Ser   |    |   |    |   | \                                 |       |
| vices |    |   |    |   | Not Applicable (leave blank) when |       |
| --    |    |   |    |   | no supplemental services are      |       |
| Rec   |    |   |    |   | required to be provided for the   |       |
| eived |    |   |    |   | entire State.                     |       |
| Ser   |    |   |    |   |                                   |       |
| vices |    |   |    |   |                                   |       |
+-------+----+---+----+---+-----------------------------------+-------+
| **ID  | 1  | 1 | Nu | O | The unduplicated number of        |       |
| 575\  | 38 | 5 | mb |   | eligible students who applied to  |       |
| **Su  |    |   | er |   | receive supplemental educational  |       |
| pplem |    |   |    |   | services under Section 1116 of    |       |
| ental |    |   |    |   | Title 1, Part A during the school |       |
| Ser   |    |   |    |   | year.                             |       |
| vices |    |   |    |   |                                   |       |
| --    |    |   |    |   | Not Applicable (leave blank) when |       |
| Ap    |    |   |    |   | no supplemental services are      |       |
| plied |    |   |    |   | required to be provided for the   |       |
| to    |    |   |    |   | entire State.                     |       |
| Re    |    |   |    |   |                                   |       |
| ceive |    |   |    |   |                                   |       |
| Ser   |    |   |    |   |                                   |       |
| vices |    |   |    |   |                                   |       |
+-------+----+---+----+---+-----------------------------------+-------+
| **ID  | 1  | 1 | Nu | O | The unduplicated number of        |       |
| 5     | 53 | 5 | mb |   | students who were eligible to     |       |
| 78**\ |    |   | er |   | receive supplemental educational  |       |
| Su    |    |   |    |   | services under Section 1116 of    |       |
| pplem |    |   |    |   | the Title 1, Part A during the    |       |
| ental |    |   |    |   | school year.                      |       |
| Ser   |    |   |    |   |                                   |       |
| vices |    |   |    |   | Not Applicable (leave blank) when |       |
| --    |    |   |    |   | no supplemental services are      |       |
| Eli   |    |   |    |   | required to be provided for the   |       |
| gible |    |   |    |   | entire State.                     |       |
| to    |    |   |    |   |                                   |       |
| Re    |    |   |    |   |                                   |       |
| ceive |    |   |    |   |                                   |       |
| Ser   |    |   |    |   |                                   |       |
| vices |    |   |    |   |                                   |       |
+-------+----+---+----+---+-----------------------------------+-------+
| **ID  | 1  | 1 | Nu | O | The unduplicated number of        |       |
| 6     | 68 | 5 | mb |   | eligible students who were        |       |
| 12**\ |    |   | er |   | offered the opportunity to apply  |       |
| Su    |    |   |    |   | to receive supplemental education |       |
| pplem |    |   |    |   | services under section 1116 of    |       |
| ental |    |   |    |   | Title I, Part A during the school |       |
| Servi |    |   |    |   | year.                             |       |
| ces - |    |   |    |   |                                   |       |
| Of    |    |   |    |   | Not Applicable (leave blank) when |       |
| fered |    |   |    |   | no supplemental services are      |       |
|       |    |   |    |   | required to be provided for the   |       |
|       |    |   |    |   | entire State.                     |       |
+-------+----+---+----+---+-----------------------------------+-------+
| E     | 1  | 2 | St | O | Submitted files will be processed |       |
| xplan | 83 | 0 | ri |   | through various edit checks. When |       |
| ation |    | 0 | ng |   | unusual conditions are detected,  |       |
|       |    |   |    |   | warning errors may be issued,     |       |
|       |    |   |    |   | even though the data may be       |       |
|       |    |   |    |   | valid. When this occurs, an       |       |
|       |    |   |    |   | explanation responding to the     |       |
|       |    |   |    |   | warning may be submitted with the |       |
|       |    |   |    |   | data, or after files have been    |       |
|       |    |   |    |   | processed. The U.S. Department of |       |
|       |    |   |    |   | Education will verify             |       |
|       |    |   |    |   | explanations, and after           |       |
|       |    |   |    |   | verification, accept the data.    |       |
+-------+----+---+----+---+-----------------------------------+-------+
| Car   | 3  | 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 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 the header row and data rows.^\*^

# LEA 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**

  -------------------------------------------------------------------------------------------------------
  **Data       **Start\     **Length**   **Type**   **Pop**   **Definition / Comments**     **Permitted
  Element      Position**                                                                   Values**
  Name**                                                                                    
  ------------ ------------ ------------ ---------- --------- ----------------------------- -------------
  File Type    1            50           String     M         Identifies the type of file   **LEA NCLB
                                                              being submitted.              SCHOOL YEAR
                                                                                            END STATUS**

  Total        51           10           Number     M         The total number of Data       
  Records In                                                  Records contained in the      
  File                                                        file. The header record is    
                                                              NOT included in this count    

  File Name    61           25           String     M         File Name and extension are    
  (Including                                                  provided by the SEA. The file 
  file                                                        name should be the same as    
  extension)                                                  the external file name.       
                                                              (Please see *File Naming      
                                                              Convention* in Section 2.0 of 
                                                              this document.)               

  File         86           32           String     M         Any combination of standard    
  Identifier                                                  characters to further         
                                                              identify the file as          
                                                              specified by the SEA, e.g., a 
                                                              date, person's name, and      
                                                              version number.               

  File         118          9            String     M         Enter the Academic School      
  Reporting                                                   Year for 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., 2006-2007 or 2006 2007. 

  Filler       127          256          String     M         Leave filler field blank.      

  Carriage     383          1                       M                                       
  Return /                                                                                  
  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 | * | Comments**           | Values**         |
| lement | ta | L | pe | P |                      |                  |
| Name** | rt | e | ** | o |                      |                  |
|        | Po | n |    | p |                      |                  |
|        | si | g |    | * |                      |                  |
|        | ti | t |    | * |                      |                  |
|        | on | h |    |   |                      |                  |
|        | ** | * |    |   |                      |                  |
|        |    | * |    |   |                      |                  |
+========+====+===+====+===+======================+==================+
| File   | 1  | 6 | Nu | M | A sequential number  |                  |
| Record |    |   | mb |   | assigned by the SEA  |                  |
| Number |    |   | er |   | 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 Information  | valid FIPS State |
| FIPS   |    |   | ng |   | Processing Standard  | Codes, refer to  |
| State  |    |   |    |   | (FIPS) Code for the  | the ED*Facts*    |
| Code   |    |   |    |   | State, District of   | Workbook.        |
|        |    |   |    |   | 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 ID    |                  |
| Agency |    |   |    |   | cannot be updated    |                  |
| Number |    |   |    |   | through this file.   |                  |
+--------+----+---+----+---+----------------------+------------------+
| **ID   | 11 | 1 | St | M | The identifier       |                  |
| 4\     |    | 4 | ri |   | assigned to a local  |                  |
| *      |    |   | ng |   | education agency     |                  |
| *State |    |   |    |   | (LEA) by the state   |                  |
| LEA    |    |   |    |   | education agency     |                  |
| Iden   |    |   |    |   | (SEA). Also known as |                  |
| tifier |    |   |    |   | 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 field   |                  |
|        |    | 0 | ri |   | blank.               |                  |
|        |    |   | ng |   |                      |                  |
+--------+----+---+----+---+----------------------+------------------+
| **ID   | 45 | 6 | Nu | M | The unduplicated     |                  |
| 664**\ |    |   | mb |   | number of truants as |                  |
| T      |    |   | er |   | defined by state,    |                  |
| ruants |    |   |    |   | using threshold      |                  |
|        |    |   |    |   | definition.          |                  |
+--------+----+---+----+---+----------------------+------------------+
| Filler | 51 | 1 | St | M | Leave filler field   |                  |
|        |    | 5 | ri |   | blank.               |                  |
|        |    |   | ng |   |                      |                  |
+--------+----+---+----+---+----------------------+------------------+
| **ID   | 66 | 1 | St | M | An indication of     | **YESWITHREP** = |
| 603\   |    | 5 | ri |   | whether the local    | Yes, with        |
| **GFSA |    |   | ng |   | education agency     | reporting of one |
| Rep    |    |   |    |   | (LEA) submitted a    | or more students |
| orting |    |   |    |   | Gun-Free Schools Act | for an offense\  |
| Status |    |   |    |   | (GFSA) report to the | **YESWOREP** =   |
|        |    |   |    |   | State, as defined by | Yes, without     |
|        |    |   |    |   | Title 18, Section    | reporting of any |
|        |    |   |    |   | 921.                 | students\        |
|        |    |   |    |   |                      | **NO**\          |
|        |    |   |    |   |                      | **NA** = Not     |
|        |    |   |    |   |                      | Applicable\      |
|        |    |   |    |   |                      | **MISSING\       |
|        |    |   |    |   |                      | NOTCOLLECT** =   |
|        |    |   |    |   |                      | Not Collected    |
+--------+----+---+----+---+----------------------+------------------+
| **ID   | 81 | 1 | St | M | An indication that   | **YES**\         |
| 614**\ |    | 5 | ri |   | the LEA notified the | **NO\            |
| REAP   |    |   | ng |   | State of the LEA\'s  | NA** = Not       |
| Alter  |    |   |    |   | intention to use the | Applicable\      |
| native |    |   |    |   | REAP-Flex            | **MISSING\       |
| F      |    |   |    |   | Alternative Uses of  | NOTCOLLECT** =   |
| unding |    |   |    |   | Funding Authority    | Not Collected    |
| Ind    |    |   |    |   | under Section 6211   |                  |
| icator |    |   |    |   | during the school    |                  |
|        |    |   |    |   | year.                |                  |
+--------+----+---+----+---+----------------------+------------------+
| **ID   | 96 | 1 | Nu | O | The dollar amount    |                  |
| 651**\ |    | 5 | mb |   | the LEA spent on     |                  |
| Supple |    |   | er |   | supplemental         |                  |
| mental |    |   |    |   | educational services |                  |
| Se     |    |   |    |   | under section 1116   |                  |
| rvices |    |   |    |   | of Title I, Part A   |                  |
| --     |    |   |    |   | during the school    |                  |
| Funds  |    |   |    |   | year.                |                  |
| Spent  |    |   |    |   |                      |                  |
|        |    |   |    |   | The dollar amount is |                  |
|        |    |   |    |   | expressed as a       |                  |
|        |    |   |    |   | numeric value in     |                  |
|        |    |   |    |   | whole dollars, no    |                  |
|        |    |   |    |   | decimal places or    |                  |
|        |    |   |    |   | \"\$\".              |                  |
+--------+----+---+----+---+----------------------+------------------+
| **ID   | 1  | 6 | Nu | O | The dollar amount    |                  |
| 652**\ | 11 |   | mb |   | the LEA spent on     |                  |
| School |    |   | er |   | transportation for   |                  |
| Choice |    |   |    |   | public school choice |                  |
| --     |    |   |    |   | under section 1116   |                  |
| Funds  |    |   |    |   | of Title I, Part A   |                  |
| Spent  |    |   |    |   | during the school    |                  |
|        |    |   |    |   | year.\               |                  |
|        |    |   |    |   | \                    |                  |
|        |    |   |    |   | The dollar amount is |                  |
|        |    |   |    |   | expressed as a       |                  |
|        |    |   |    |   | numeric value in     |                  |
|        |    |   |    |   | whole dollars, no    |                  |
|        |    |   |    |   | decimal places or    |                  |
|        |    |   |    |   | \"\$\".              |                  |
+--------+----+---+----+---+----------------------+------------------+
| Filler | 1  | 6 | St | M | Leave filler field   |                  |
|        | 17 |   | ri |   | blank.               |                  |
|        |    |   | ng |   |                      |                  |
+--------+----+---+----+---+----------------------+------------------+
| **ID   | 1  | 1 | Nu | O | The unduplicated     |                  |
| 546**\ | 23 | 5 | mb |   | number of eligible   |                  |
| Supple |    |   | er |   | students who         |                  |
| mental |    |   |    |   | received             |                  |
| Se     |    |   |    |   | supplemental         |                  |
| rvices |    |   |    |   | educational services |                  |
| --     |    |   |    |   | during the school    |                  |
| Re     |    |   |    |   | year in accordance   |                  |
| ceived |    |   |    |   | with Title I, Part   |                  |
| Se     |    |   |    |   | A, Section 1116.\    |                  |
| rvices |    |   |    |   | \                    |                  |
|        |    |   |    |   | Not Applicable       |                  |
|        |    |   |    |   | (leave blank) when   |                  |
|        |    |   |    |   | no supplemental      |                  |
|        |    |   |    |   | services are         |                  |
|        |    |   |    |   | required to be       |                  |
|        |    |   |    |   | provided for the     |                  |
|        |    |   |    |   | entire LEA.          |                  |
+--------+----+---+----+---+----------------------+------------------+
| **ID   | 1  | 1 | Nu | O | The unduplicated     |                  |
| 575\   | 38 | 5 | mb |   | number of eligible   |                  |
| **     |    |   | er |   | students who applied |                  |
| Supple |    |   |    |   | to receive           |                  |
| mental |    |   |    |   | supplemental         |                  |
| Se     |    |   |    |   | educational services |                  |
| rvices |    |   |    |   | under Section 1116   |                  |
| --     |    |   |    |   | of Title 1, Part A   |                  |
| A      |    |   |    |   | during the school    |                  |
| pplied |    |   |    |   | year.                |                  |
| to     |    |   |    |   |                      |                  |
| R      |    |   |    |   | Not Applicable       |                  |
| eceive |    |   |    |   | (leave blank) when   |                  |
| Se     |    |   |    |   | no supplemental      |                  |
| rvices |    |   |    |   | services are         |                  |
|        |    |   |    |   | required to be       |                  |
|        |    |   |    |   | provided for the     |                  |
|        |    |   |    |   | entire LEA.          |                  |
+--------+----+---+----+---+----------------------+------------------+
| **ID   | 1  | 1 | Nu | O | The unduplicated     |                  |
| 578**\ | 53 | 5 | mb |   | number of students   |                  |
| Supple |    |   | er |   | who were eligible to |                  |
| mental |    |   |    |   | receive supplemental |                  |
| Se     |    |   |    |   | educational services |                  |
| rvices |    |   |    |   | under Section 1116   |                  |
| --     |    |   |    |   | of the Title 1, Part |                  |
| El     |    |   |    |   | A during the school  |                  |
| igible |    |   |    |   | year.                |                  |
| to     |    |   |    |   |                      |                  |
| R      |    |   |    |   | Not Applicable       |                  |
| eceive |    |   |    |   | (leave blank) when   |                  |
| Se     |    |   |    |   | no supplemental      |                  |
| rvices |    |   |    |   | services are         |                  |
|        |    |   |    |   | required to be       |                  |
|        |    |   |    |   | provided for the     |                  |
|        |    |   |    |   | entire LEA.          |                  |
+--------+----+---+----+---+----------------------+------------------+
| **ID   | 1  | 1 | Nu | O | The unduplicated     |                  |
| 612**\ | 68 | 5 | mb |   | number of eligible   |                  |
| Supple |    |   | er |   | students who were    |                  |
| mental |    |   |    |   | offered the          |                  |
| Serv   |    |   |    |   | opportunity to apply |                  |
| ices - |    |   |    |   | to receive           |                  |
| O      |    |   |    |   | supplemental         |                  |
| ffered |    |   |    |   | education services   |                  |
|        |    |   |    |   | under section 1116   |                  |
|        |    |   |    |   | of Title I, Part A   |                  |
|        |    |   |    |   | during the school    |                  |
|        |    |   |    |   | year.                |                  |
|        |    |   |    |   |                      |                  |
|        |    |   |    |   | Not Applicable       |                  |
|        |    |   |    |   | (leave blank) when   |                  |
|        |    |   |    |   | no supplemental      |                  |
|        |    |   |    |   | services are         |                  |
|        |    |   |    |   | required to be       |                  |
|        |    |   |    |   | provided for the     |                  |
|        |    |   |    |   | entire LEA.          |                  |
+--------+----+---+----+---+----------------------+------------------+
| Expla  | 1  | 2 | St | O | Submitted files will |                  |
| nation | 83 | 0 | ri |   | be processed through |                  |
|        |    | 0 | ng |   | various edit checks. |                  |
|        |    |   |    |   | When unusual         |                  |
|        |    |   |    |   | conditions are       |                  |
|        |    |   |    |   | detected, warning    |                  |
|        |    |   |    |   | errors may be        |                  |
|        |    |   |    |   | issued, even though  |                  |
|        |    |   |    |   | the data may be      |                  |
|        |    |   |    |   | valid. When this     |                  |
|        |    |   |    |   | occurs, an           |                  |
|        |    |   |    |   | explanation          |                  |
|        |    |   |    |   | responding to the    |                  |
|        |    |   |    |   | warning may be       |                  |
|        |    |   |    |   | submitted with the   |                  |
|        |    |   |    |   | data, or after files |                  |
|        |    |   |    |   | have been processed. |                  |
|        |    |   |    |   | The U.S. Department  |                  |
|        |    |   |    |   | of Education will    |                  |
|        |    |   |    |   | verify explanations, |                  |
|        |    |   |    |   | and after            |                  |
|        |    |   |    |   | verification, accept |                  |
|        |    |   |    |   | the data.            |                  |
+--------+----+---+----+---+----------------------+------------------+
| Ca     | 3  | 1 |    | M |                      |                  |
| rriage | 83 |   |    |   |                      |                  |
| Return |    |   |    |   |                      |                  |
| / 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 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 the header row and data rows. ^\*^

# 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**

  ---------------------------------------------------------------------------------------------------------
  **Data       **Start\     **Length**   **Type**   **Pop**   **Definition / Comments**       **Permitted
  Element      Position**                                                                     Values**
  Name**                                                                                      
  ------------ ------------ ------------ ---------- --------- ------------------------------- -------------
  File Type    1            50           String     M         Identifies the type of file     **SCHOOL NCLB
                                                              being submitted.                SCHOOL YEAR
                                                                                              END STATUS**

  Total        51           10           Number     M         The total number of Data         
  Records In                                                  Records contained in the file.  
  File                                                        The header record is NOT        
                                                              included in this count          

  File Name    61           25           String     M         File Name and extension are      
  (Including                                                  provided by the SEA. The file   
  file                                                        name should be the same as the  
  extension)                                                  external file name. (Please see 
                                                              *File Naming Convention* in     
                                                              Section 2.0 of this document.)  

  File         86           32           String     M         Any combination of standard      
  Identifier                                                  characters to further identify  
                                                              the file as specified by the    
                                                              SEA, e.g., a date, person's     
                                                              name, and version number.       

  File         118          9            String     M         Enter the Academic School Year   
  Reporting                                                   for 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., 2006-2007 or 2006 2007.   

  Filler       127          241          String     M         Leave filler field blank.        

  Carriage     368          1                       M                                         
  Return /                                                                                    
  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 | * | Comments**            | Values**       |
| lement | ta | L | pe | P |                       |                |
| Name** | rt | e | ** | o |                       |                |
|        | Po | n |    | p |                       |                |
|        | si | g |    | * |                       |                |
|        | ti | t |    | * |                       |                |
|        | on | h |    |   |                       |                |
|        | ** | * |    |   |                       |                |
|        |    | * |    |   |                       |                |
+========+====+===+====+===+=======================+================+
| File   | 1  | 6 | Nu | M | A sequential number   |                |
| Record |    |   | mb |   | assigned by the SEA   |                |
| Number |    |   | er |   | that is unique to     |                |
|        |    |   |    |   | each row entry within |                |
|        |    |   |    |   | the file.             |                |
+--------+----+---+----+---+-----------------------+----------------+
| **ID   | 7  | 2 | St | M | The two-digit Federal | For a list of  |
| 559**\ |    |   | ri |   | Information           | valid FIPS     |
| FIPS   |    |   | ng |   | Processing Standard   | State Codes,   |
| State  |    |   |    |   | (FIPS) Code for the   | refer to the   |
| Code   |    |   |    |   | State, District of    | ED*Facts*      |
|        |    |   |    |   | Columbia, and the     | Workbook*.*    |
|        |    |   |    |   | possessions and       |                |
|        |    |   |    |   | freely associated     |                |
|        |    |   |    |   | areas of the United   |                |
|        |    |   |    |   | States (e.g., Puerto  |                |
|        |    |   |    |   | Rico).                |                |
+--------+----+---+----+---+-----------------------+----------------+
| **ID   | 9  | 2 | St | M | A number used in EDEN | **01** = State |
| 570\   |    |   | ri |   | to uniquely identify  | Education      |
| *      |    |   | ng |   | state agencies. This  | Agency         |
| *State |    |   |    |   | ID cannot be updated  |                |
| Agency |    |   |    |   | through this file.    |                |
| Number |    |   |    |   |                       |                |
+--------+----+---+----+---+-----------------------+----------------+
| **ID   | 11 | 1 | St | M | The identifier        |                |
| 4**\   |    | 4 | ri |   | assigned to a local   |                |
| State  |    |   | ng |   | education agency      |                |
| LEA    |    |   |    |   | (LEA) by 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.    |                |
+--------+----+---+----+---+-----------------------+----------------+
| **ID   | 25 | 2 | St | M | The identifier        |                |
| 5\     |    | 0 | ri |   | assigned to a school  |                |
| *      |    |   | ng |   | by the State          |                |
| *State |    |   |    |   | Education Agency.     |                |
| School |    |   |    |   | Also known as the     |                |
| Iden   |    |   |    |   | State School          |                |
| tifier |    |   |    |   | Identification        |                |
|        |    |   |    |   | Number. This ID       |                |
|        |    |   |    |   | cannot be updated     |                |
|        |    |   |    |   | through this file.    |                |
+--------+----+---+----+---+-----------------------+----------------+
| **ID   | 45 | 6 | Nu | M | The unduplicated      |                |
| 664**\ |    |   | mb |   | number of truants as  |                |
| T      |    |   | er |   | defined by state,     |                |
| ruants |    |   |    |   | using threshold       |                |
|        |    |   |    |   | definition.           |                |
+--------+----+---+----+---+-----------------------+----------------+
| **ID   | 51 | 1 | St | M | An indication of      | **YES\         |
| 514**\ |    | 5 | ri |   | whether the school    | NO** = funds   |
| Co     |    |   | ng |   | has a Title I         | are not        |
| mbined |    |   |    |   | school-wide program   | combined or    |
| MEP    |    |   |    |   | in which migrant      | the school     |
| Funds  |    |   |    |   | education program     | does not have  |
| Status |    |   |    |   | (MEP) funds are       | a Title I      |
|        |    |   |    |   | combined.             | schoolwide     |
|        |    |   |    |   |                       | program**\     |
|        |    |   |    |   |                       | NOPROG** =     |
|        |    |   |    |   |                       | School does    |
|        |    |   |    |   |                       | not have a     |
|        |    |   |    |   |                       | [migrant       |
|        |    |   |    |   |                       | educatio       |
|        |    |   |    |   |                       | n]{.underline} |
|        |    |   |    |   |                       | program\       |
|        |    |   |    |   |                       | **MISSING**\   |
|        |    |   |    |   |                       | **NOTCOLLECT** |
|        |    |   |    |   |                       | = Not          |
|        |    |   |    |   |                       | collected      |
+--------+----+---+----+---+-----------------------+----------------+
| **ID   | 66 | 1 | St | M | An indication of      | **YESWITHREP** |
| 603\   |    | 5 | ri |   | whether the school    | = Yes, with    |
| **GFSA |    |   | ng |   | submitted a Gun-Free  | reporting of   |
| Rep    |    |   |    |   | Schools Act (GFSA)    | one or more    |
| orting |    |   |    |   | report to the LEA, as | students for   |
| Status |    |   |    |   | defined by Title 18,  | an offense\    |
|        |    |   |    |   | Section 921.          | **YESWOREP** = |
|        |    |   |    |   |                       | Yes, without   |
|        |    |   |    |   |                       | reporting of   |
|        |    |   |    |   |                       | any students\  |
|        |    |   |    |   |                       | **NO**\        |
|        |    |   |    |   |                       | **NA** = Not   |
|        |    |   |    |   |                       | Applicable\    |
|        |    |   |    |   |                       | **MISSING\     |
|        |    |   |    |   |                       | NOTCOLLECT** = |
|        |    |   |    |   |                       | Not Collected  |
+--------+----+---+----+---+-----------------------+----------------+
| Filler | 81 | 1 | St | M | Leave filler field    |                |
|        |    | 5 | ri |   | blank.                |                |
|        |    |   | ng |   |                       |                |
+--------+----+---+----+---+-----------------------+----------------+
| Filler | 96 | 1 | St | M | Leave filler field    |                |
|        |    | 5 | ri |   | blank.                |                |
|        |    |   | ng |   |                       |                |
+--------+----+---+----+---+-----------------------+----------------+
| **ID   | 1  | 6 | Nu | M | The unduplicated      |                |
| 56**\  | 11 |   | mb |   | number of students    |                |
| Econom |    |   | er |   | who met the state     |                |
| ically |    |   |    |   | criteria for          |                |
| D      |    |   |    |   | classification as     |                |
| isadva |    |   |    |   | economically          |                |
| ntaged |    |   |    |   | disadvantaged         |                |
| St     |    |   |    |   | according to the      |                |
| udents |    |   |    |   | state definition.     |                |
+--------+----+---+----+---+-----------------------+----------------+
| **ID   | 1  | 6 | D  | O | The average number of |                |
| 595\   | 17 |   | ec |   | students in daily     |                |
| **A    |    |   | im |   | attendance computed   |                |
| verage |    |   | al |   | according to state    |                |
| Daily  |    |   | Nu |   | law or regulation.    |                |
| Atte   |    |   | mb |   |                       |                |
| ndance |    |   | er |   | Note: Decimal numbers |                |
|        |    |   |    |   | to one decimal place  |                |
|        |    |   |    |   | (one tenth) are       |                |
|        |    |   |    |   | permitted.            |                |
+--------+----+---+----+---+-----------------------+----------------+
| **ID   | 1  | 1 | Nu | M | The cumulative        |                |
| 110**\ | 23 | 5 | mb |   | unduplicated (within  |                |
| MEP    |    |   | er |   | school) number of     |                |
| St     |    |   |    |   | migrant students, as  |                |
| udents |    |   |    |   | defined by 34 CFR     |                |
| El     |    |   |    |   | 200.81, who were      |                |
| igible |    |   |    |   | enrolled and eligible |                |
| R      |    |   |    |   | for the Migrant       |                |
| egular |    |   |    |   | Education Program     |                |
| School |    |   |    |   | (MEP) at any time     |                |
| Year   |    |   |    |   | during the regular    |                |
|        |    |   |    |   | school year. This     |                |
|        |    |   |    |   | figure includes all   |                |
|        |    |   |    |   | eligible migrant      |                |
|        |    |   |    |   | students who may or   |                |
|        |    |   |    |   | may not have          |                |
|        |    |   |    |   | participated in MEP   |                |
|        |    |   |    |   | services.             |                |
+--------+----+---+----+---+-----------------------+----------------+
| Filler | 1  | 1 | St | M | Leave filler field    |                |
|        | 38 | 5 | ri |   | blank.                |                |
|        |    |   | ng |   |                       |                |
+--------+----+---+----+---+-----------------------+----------------+
| Filler | 1  | 1 | St | M | Leave filler field    |                |
|        | 53 | 5 | ri |   | blank.                |                |
|        |    |   | ng |   |                       |                |
+--------+----+---+----+---+-----------------------+----------------+
| Expla  | 1  | 2 | St | O | Submitted files will  |                |
| nation | 68 | 0 | ri |   | be processed through  |                |
|        |    | 0 | ng |   | various edit checks.  |                |
|        |    |   |    |   | When unusual          |                |
|        |    |   |    |   | conditions are        |                |
|        |    |   |    |   | detected, warning     |                |
|        |    |   |    |   | errors may be issued, |                |
|        |    |   |    |   | even though the data  |                |
|        |    |   |    |   | may be valid. When    |                |
|        |    |   |    |   | this occurs, an       |                |
|        |    |   |    |   | explanation           |                |
|        |    |   |    |   | responding to the     |                |
|        |    |   |    |   | warning may be        |                |
|        |    |   |    |   | submitted with the    |                |
|        |    |   |    |   | data, or after files  |                |
|        |    |   |    |   | have been processed.  |                |
|        |    |   |    |   | The U.S. Department   |                |
|        |    |   |    |   | of Education will     |                |
|        |    |   |    |   | verify explanations,  |                |
|        |    |   |    |   | and after             |                |
|        |    |   |    |   | verification, accept  |                |
|        |    |   |    |   | the data.             |                |
+--------+----+---+----+---+-----------------------+----------------+
| Ca     | 3  | 1 |    | M |                       |                |
| rriage | 68 |   |    |   |                       |                |
| Return |    |   |    |   |                       |                |
| / 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 the header row and data rows.[^3]

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

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

![](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.