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

**U.S. DEPARTMENT OF EDUCATION**

**Education Data Exchange Network (EDEN)**

**N010 - School Choice - Transferred File Specifications**

**Version 3.2**

**SY 2006 -- 07**

**March 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 M. \"Bill\" Evers

*Assistant Secretary*

![](media/image2.wmf){width="1.3854330708661418in"
height="0.20826771653543308in"}

March 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, *N010
-- School Choice - Transferred 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___Toc191890674 .anchor}DOCUMENT CONTROL

DOCUMENT INFORMATION

  --------------- ---------------------------------------------------------
  **Title:**      N010 --School Choice - Transferred File Specifications

  **Revision:**   Version 3.2

  **Issue Date:** March 2008

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

  **Filename:**   740086.doc
  --------------- ---------------------------------------------------------

DOCUMENT HISTORY

+-------+-------------+-----------------------------------------------+
| **Ve  | **Date**    | **Summary of Change**                         |
| rsion |             |                                               |
| Num   |             |                                               |
| ber** |             |                                               |
+-------+-------------+-----------------------------------------------+
| 1.0   |             | Version 1.0 or subsequent updates (i.e. 1.1,  |
|       |             | 1.2, etc) of this file specification is used  |
|       |             | to build files for SYs 2003-04 and 2004-05    |
+-------+-------------+-----------------------------------------------+
| 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: Updated Data Groups' Names           |
|       |             |                                               |
|       |             | -   1.0, 4.2, 5.2: Removed Data Group 577 --  |
|       |             |     Students Eligible for School Choice       |
|       |             |     Transfer                                  |
|       |             |                                               |
|       |             | -   1.2, 6.0: Removed School Level collection |
|       |             |     for Data Groups 544, 574, and 579         |
|       |             |                                               |
|       |             | -   1.3: Changed the Definition for Data      |
|       |             |     Group 544 -- School Choice -- Transferred |
|       |             |                                               |
|       |             | -   1.3: Changed the Definition for Data      |
|       |             |     Group 574 -- School Choice -- Applied for |
|       |             |     Transfer                                  |
|       |             |                                               |
|       |             | -   1.3: Changed the Definition for Data      |
|       |             |     Group 579 -- School Choice -- Offered     |
+-------+-------------+-----------------------------------------------+
| 3.1   | November    | -   1.3-1: Updated the "Data Group            |
|       | 2007        |     Definition" table.                        |
+-------+-------------+-----------------------------------------------+
| 3.2   | March 2008  | -   4.3 and 5.3: Updated file samples.        |
+-------+-------------+-----------------------------------------------+

RELEASE AUTHORIZATION

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

  Author                  

  QA                      

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

[]{#__RefHeading___Toc191890675 .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___Toc191890674)

[PREFACE iii](#__RefHeading___Toc191890675)

[1.0 PURPOSE 1](#purpose)

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

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

[1.3 Key Definitions 2](#key-definitions)

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

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

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

[4.0 SEA SCHOOL CHOICE - TRANSFERRED FILE
6](#sea-school-choice---transferred-file)

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

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

[4.3 SEA School Choice - Transferred File Examples
8](#sea-school-choice---transferred-file-examples)

[4.3.1 Partial Record Sample for Fixed Format SEA School Choice -
Transferred File
8](#partial-record-sample-for-fixed-format-sea-school-choice---transferred-file)

[4.3.2 Partial Record Sample for Comma-Delimited File Format SEA School
Choice - Transferred File
9](#partial-record-sample-for-comma-delimited-file-format-sea-school-choice---transferred-file)

[4.3.3 Partial Record Sample for Tab-Delimited File Format SEA School
Choice - Transferred File
9](#partial-record-sample-for-tab-delimited-file-format-sea-school-choice---transferred-file)

[5.0 LEA SCHOOL CHOICE - TRANSFERRED FILE
10](#lea-school-choice---transferred-file)

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

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

[5.3 LEA School Choice - Transferred File Example
12](#lea-school-choice---transferred-file-example)

[5.3.1 Partial Record Sample for Fixed Format LEA School Choice -
Transferred File
12](#partial-record-sample-for-fixed-format-lea-school-choice---transferred-file)

[5.3.2 Partial Record Sample for Comma-Delimited File Format LEA School
Choice - Transferred File
13](#partial-record-sample-for-comma-delimited-file-format-lea-school-choice---transferred-file)

[5.3.3 Partial Record Sample for Tab-Delimited File Format LEA School
Choice - Transferred File
13](#partial-record-sample-for-tab-delimited-file-format-lea-school-choice---transferred-file)

# PURPOSE

This document contains instructions for building fixed and delimited
files to submit ED*Facts* Data Groups:

-   School Choice - Transferred, ID \# 544

-   School Choice - Applied for Transfer, ID \# 574

-   School Choice - Offered, ID \# 579.

The definition for these data groups are in the column "Data Group
Definition" in Table 1.3-1.

The Consolidated State Performance Report, which is legislatively
supported by Sections 9302 and 9303 of the Elementary and Secondary
Education Act as amended by the No Child Left Behind Act of 2001, uses
these EDEN data groups.

A separate document contains the XML file formats. General guidance for
constructing all EDEN file types may be found in the ED*Facts* Workbook.

## Changes from the SY 2005-2006 File Specifications

There have been significant changes to this file specification:

-   Removed Data Group 577 -- Students Eligible for School Choice
    Transfer.

-   Removed the School Level collection for Data Groups 544, 574, and
    579

-   Changed the Definition for Data Group 574 -- School Choice --
    Applied for Transfer to clarify that these are eligible students who
    applied for transfer.

-   Changed the Definition for Data Group 579 -- School Choice --
    Offered to clarify that this is an unduplicated count of eligible
    students who were offered the opportunity to apply for transfer.

-   Changed the Definition for Data Group 544 -- School Choice --
    Transferred to clarify that these are eligible students who
    transferred.

-   Updated Data Group Names.

## Requirements for Submitting this Data Group

This data group is submitted at the following levels:

-   SEA

-   LEA

## Key Definitions

Table 1.3-1: School Choice - Transferred, Key Definitions Table

  -------------------------------------------------------------------------------
  **Data Group**   **Abbreviation**   **Data Group Definition**
  ---------------- ------------------ -------------------------------------------
  School Choice -  TRANFSTUDCH        The unduplicated number of eligible
  Transferred                         students who transferred to another school
                                      under the provisions for public school
                                      choice in accordance with Title I, Part A,
                                      Section 1116.

  School Choice -  TRANFSTUDAPP       The unduplicated number of eligible
  Applied for                         students who applied to transfer to another
  Transfer                            public school under the provisions for
                                      public school choice in accordance with
                                      Title I, Part A, Section 1116.

  School Choice -  TRANFSTUDOFF       The number of students, among those who
  Offered                             applied to transfer to another public
                                      school under Title I, Part A, Section 1116,
                                      the public school choice provisions, who
                                      were actually offered the opportunity to
                                      transfer by their LEAs.
  -------------------------------------------------------------------------------

# 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 School Choice - Transferred
File submissions:

sslev**STUCHOICE**vvvvvv.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 School Choice - Transferred
> submission
>
> LEA for a Local Education Agency School Choice - Transferred
> submission
>
> **Filename** = **STUCHOICE** (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

This file specification collects counts of students who were eligible
for transfer to another public school under the provisions of public
school choice in the No Child Left Behind legislation.[^1] Each count in
this file is a discreet count of students at the SEA or LEA level. The
count should reflect the cumulative total of students for the school
year who fall in each category (eligible to transfer, applied to
transfer, and transferred), not the number of times a student was
eligible, applied, or transferred.

If a student transferred, that student should have been offered an
opportunity to transfer and applied to transfer, and should be counted
in those categories, too. Therefore, the count of students who applied
to transfer should be equal to or greater than the number of students
who transferred. Similarly, the count of students who were offered an
opportunity to apply for transfer should be equal to or greater than the
number of students who applied to transfer.

For those LEAs that have open enrollment and other choice programs, the
LEA may consider a student as eligible for and participating in Title I
public school choice if the student meets the following conditions:

-   Has a \"home\" or \"neighborhood\" school (to which the student
    would have been assigned, in the absence of a choice program) that
    receives Title I funds and has been identified, under the statute,
    as in need of improvement, corrective action, or restructuring; and

-   Has elected to enroll, at some point since July 1, 2002 (the
    effective date of the Title I choice provisions) and after the home
    school has been identified as in need of improvement, in a school
    that has not been so identified and is attending that school.[^2]

For those LEAs that are not able to offer public school choice (i.e.,
LEAs in which all schools in a grade level are schools in need of
improvement, LEAs which have only a single school at that grade level,
or LEAs whose schools are so remote from one another that choice is
impracticable), count as eligible all students who attend Title I
schools identified for improvement. States should report that no
eligible schools or students were provided the option to transfer, and
should provide an explanation why choice is not possible within the LEA
in the Explanations field. For example, "All schools in the LEA are in
need of improvement therefore school choice was not offered", "There is
only one school with grades 6-8 in this LEA, so offering choice is not
possible", or "Offering school choice is not possible due to the
distance between schools" would suffice as explanations for the three
situations given above.

## 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 SCHOOL CHOICE - TRANSFERRED FILE

This section describes the fixed file and delimited file specifications
used to transmit information pertaining to the SEA School Choice -
Transferred 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.1-1: School Choice - Transferred 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 CHOICE
                                                              being submitted.               PROVISIONS**

  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          149          String     M         Leave filler fields blank.      

  Carriage     276          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 subtotals and grand
totals.

Section 4.3 contains examples of Data Records.

Table 4.2-1: School Choice - Transferred File, SEA Data Record

+---------+----+----+----+----+-------------------------+------------+
| **Data  | ** | ** | ** | *  | **Definition /          | *          |
| Element | St | Le | Ty | *P | Comments**              | *Permitted |
| Name**  | ar | ng | pe | op |                         | Values**   |
|         | t\ | th | ** | ** |                         |            |
|         | Po | ** |    |    |                         |            |
|         | si |    |    |    |                         |            |
|         | ti |    |    |    |                         |            |
|         | on |    |    |    |                         |            |
|         | ** |    |    |    |                         |            |
+=========+====+====+====+====+=========================+============+
| File    | 1  | 6  | Nu | M  | A sequential number     |            |
| Record  |    |    | mb |    | assigned by the State   |            |
| Number  |    |    | er |    | that is unique to each  |            |
|         |    |    |    |    | round entry within the  |            |
|         |    |    |    |    | file.                   |            |
+---------+----+----+----+----+-------------------------+------------+
| **ID    | 7  | 2  | St | M  | The two-digit Federal   | For a list |
| 559\    |    |    | ri |    | Information Processing  | of valid   |
| **FIPS  |    |    | ng |    | Standards (FIPS) for    | FIPS State |
| State   |    |    |    |    | the state, District of  | Codes,     |
| Code    |    |    |    |    | Columbia, and the       | refer to   |
|         |    |    |    |    | possessions and freely  | the        |
|         |    |    |    |    | associated areas of the | ED*Facts*  |
|         |    |    |    |    | United States (e.g.,    | Workbook.  |
|         |    |    |    |    | Puerto Rico).           |            |
+---------+----+----+----+----+-------------------------+------------+
| **ID    | 9  | 2  | St | M  | A number used in EDEN   | **01** =   |
| 570\    |    |    | ri |    | to uniquely identify    | State      |
| **State |    |    | ng |    | state agencies.  This   | Education  |
| Agency  |    |    |    |    | ID cannot be updated    | Agency     |
| Number  |    |    |    |    | through this file       |            |
+---------+----+----+----+----+-------------------------+------------+
| Filler  | 11 | 14 | St | M  | Leave filler field      |            |
|         |    |    | ri |    | blank.                  |            |
|         |    |    | ng |    |                         |            |
+---------+----+----+----+----+-------------------------+------------+
| Filler  | 25 | 20 | St | M  | Leave filler field      |            |
|         |    |    | ri |    | blank.                  |            |
|         |    |    | ng |    |                         |            |
+---------+----+----+----+----+-------------------------+------------+
| Table   | 45 | 20 | St | M  | The identifier of the   | **TRA      |
| Name    |    |    | ri |    | data group:             | NFSTUDCH** |
|         |    |    | ng |    |                         |            |
|         |    |    |    |    | -   TRANFSTUDCH (ID     | **TRAN     |
|         |    |    |    |    |     544)                | FSTUDAPP** |
|         |    |    |    |    |                         |            |
|         |    |    |    |    | -   TRANFSTUDAPP (ID    | **TRAN     |
|         |    |    |    |    |     574)                | FSTUDOFF** |
|         |    |    |    |    |                         |            |
|         |    |    |    |    | -   TRANFSTUDOFF (ID    | ([see Key  |
|         |    |    |    |    |     579)                | D          |
|         |    |    |    |    |                         | efinitions |
|         |    |    |    |    |                         | in Section |
|         |    |    |    |    |                         | 1.3        |
|         |    |    |    |    |                         | ](#key-def |
|         |    |    |    |    |                         | initions)) |
+---------+----+----+----+----+-------------------------+------------+
| Total   | 65 | 1  | St | M  | An indicator that       | **N** =    |
| In      |    |    | ri |    | defines the count level | specifies  |
| dicator |    |    | ng |    | (i.e., detail level,    | detail     |
|         |    |    |    |    | subtotal level or grand | level      |
|         |    |    |    |    | total level).           |            |
+---------+----+----+----+----+-------------------------+------------+
| Expl    | 66 | 2  | St | O  | Submitted files will be |            |
| anation |    | 00 | ri |    | processed through       |            |
|         |    |    | 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.               |            |
+---------+----+----+----+----+-------------------------+------------+
| Student | 2  | 10 | Nu | M  | If there are no schools |            |
| Count   | 66 |    | mb |    | in improvement status,  |            |
|         |    |    | er |    | the number must be      |            |
|         |    |    |    |    | zero.                   |            |
+---------+----+----+----+----+-------------------------+------------+
| C       | 2  | 1  |    | M  |                         |            |
| arriage | 76 |    |    |    |                         |            |
| Return  |    |    |    |    |                         |            |
| / Line  |    |    |    |    |                         |            |
| Feed    |    |    |    |    |                         |            |
| (CRLF)  |    |    |    |    |                         |            |
+---------+----+----+----+----+-------------------------+------------+

## SEA School Choice - Transferred File Examples

### Partial Record Sample for Fixed Format SEA School Choice - Transferred 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 School Choice - Transferred File

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

### Partial Record Sample for Tab-Delimited File Format SEA School Choice - Transferred File

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

# LEA SCHOOL CHOICE - TRANSFERRED FILE

This section describes the fixed file and delimited file specifications
used to transmit information pertaining to the LEA School Choice -
Transferred 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: School Choice - Transferred 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 CHOICE
                                                              being submitted.                PROVISIONS**

  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          149          String     M         Leave filler fields blank.      

  Carriage     276          1                       M                                         0
  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 subtotals and grand
totals.

See Section 5.3 for examples of the Data Record.

Table 5.2-1: School Choice - Transferred File, LEA Data Record

+--------+----+----+----+---+---------------------------+-----------+
| **Data | ** | ** | ** | * | **Definition / Comments** | **        |
| E      | St | Le | Ty | * |                           | Permitted |
| lement | ar | ng | pe | P |                           | Values**  |
| Name** | t\ | th | ** | o |                           |           |
|        | Po | ** |    | p |                           |           |
|        | si |    |    | * |                           |           |
|        | ti |    |    | * |                           |           |
|        | on |    |    |   |                           |           |
|        | ** |    |    |   |                           |           |
+========+====+====+====+===+===========================+===========+
| File   | 1  | 6  | Nu | M | A sequential number       |           |
| Record |    |    | mb |   | assigned by the State     |           |
| Number |    |    | er |   | that is unique to each    |           |
|        |    |    |    |   | round entry within the    |           |
|        |    |    |    |   | file.                     |           |
+--------+----+----+----+---+---------------------------+-----------+
| **ID   | 7  | 2  | St | M | The two-digit Federal     | For a     |
| 559\   |    |    | ri |   | Information Processing    | list of   |
| **FIPS |    |    | ng |   | Standards (FIPS) for the  | valid     |
| State  |    |    |    |   | state, District of        | FIPS      |
| Code   |    |    |    |   | Columbia, and the         | State     |
|        |    |    |    |   | possessions and freely    | Codes,    |
|        |    |    |    |   | associated areas of the   | refer to  |
|        |    |    |    |   | United States (e.g.,      | the       |
|        |    |    |    |   | Puerto Rico).             | ED*Facts* |
|        |    |    |    |   |                           | Workbook. |
+--------+----+----+----+---+---------------------------+-----------+
| **ID   | 9  | 2  | St | M | A number used in EDEN to  | **01** =  |
| 570\   |    |    | ri |   | uniquely identify state   | State     |
| *      |    |    | ng |   | agencies.  This ID cannot | Education |
| *State |    |    |    |   | be updated through this   | Agency    |
| Agency |    |    |    |   | file.                     |           |
| Number |    |    |    |   |                           |           |
+--------+----+----+----+---+---------------------------+-----------+
| **ID   | 11 | 14 | St | M | The identifier assigned   |           |
| 4\     |    |    | ri |   | to a local education      |           |
| *      |    |    | ng |   | agency (LEA) by the state |           |
| *State |    |    |    |   | education agency (SEA).   |           |
| LEA    |    |    |    |   | Also known as State LEA   |           |
| Iden   |    |    |    |   | ID. This ID is a required |           |
| tifier |    |    |    |   | field. This data element  |           |
|        |    |    |    |   | cannot be updated through |           |
|        |    |    |    |   | this file.                |           |
+--------+----+----+----+---+---------------------------+-----------+
| Filler | 25 | 20 | St | M | Leave filler field blank. |           |
|        |    |    | ri |   |                           |           |
|        |    |    | ng |   |                           |           |
+--------+----+----+----+---+---------------------------+-----------+
| Table  | 45 | 20 | St | M | The identifier of the     | **TRAN    |
| Name   |    |    | ri |   | data group:               | FSTUDCH** |
|        |    |    | ng |   |                           |           |
|        |    |    |    |   | -   TRANFSTUDCH (ID 544)  | **TRANF   |
|        |    |    |    |   |                           | STUDAPP** |
|        |    |    |    |   | -   TRANFSTUDAPP (ID 574) |           |
|        |    |    |    |   |                           | **TRANF   |
|        |    |    |    |   | -   TRANFSTUDOFF (ID 579) | STUDOFF** |
|        |    |    |    |   |                           |           |
|        |    |    |    |   |                           | ([see Key |
|        |    |    |    |   |                           | De        |
|        |    |    |    |   |                           | finitions |
|        |    |    |    |   |                           | in        |
|        |    |    |    |   |                           | Section   |
|        |    |    |    |   |                           | 1.3](     |
|        |    |    |    |   |                           | #key-defi |
|        |    |    |    |   |                           | nitions)) |
+--------+----+----+----+---+---------------------------+-----------+
| Total  | 65 | 1  | St | M | An indicator that defines | **N** =   |
| Ind    |    |    | ri |   | the count level (i.e.,    | specifies |
| icator |    |    | ng |   | detail level, subtotal    | detail    |
|        |    |    |    |   | level or grand total      | level     |
|        |    |    |    |   | level).                   |           |
+--------+----+----+----+---+---------------------------+-----------+
| Expla  | 66 | 2  | St | O | Submitted files will be   |           |
| nation |    | 00 | ri |   | processed through various |           |
|        |    |    | ng |   | 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.          |           |
+--------+----+----+----+---+---------------------------+-----------+
| S      | 2  | 10 | Nu | M | If there are no schools   |           |
| tudent | 66 |    | mb |   | in improvement status,    |           |
| Count  |    |    | er |   | the number must be zero.  |           |
+--------+----+----+----+---+---------------------------+-----------+
| Ca     | 2  | 1  |    | M |                           |           |
| rriage | 76 |    |    |   |                           |           |
| Return |    |    |    |   |                           |           |
| / Line |    |    |    |   |                           |           |
| Feed   |    |    |    |   |                           |           |
| (CRLF) |    |    |    |   |                           |           |
+--------+----+----+----+---+---------------------------+-----------+

## LEA School Choice - Transferred File Example 

### Partial Record Sample for Fixed Format LEA School Choice - Transferred 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 School Choice - Transferred File

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

### Partial Record Sample for Tab-Delimited File Format LEA School Choice - Transferred File

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

![](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]: School choice data groups are all supported by Title I, Part A,
    Section 1116.

[^2]: Adapted from OESE policy letter of August 2004. The policy letter
    may be found on the Department's web page at
    <http://www.ed.gov/policy/elsec/guid/stateletters/choice/choice081804.html>.

[^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.