n089 – children with disabilities (idea) early childhood ...€¦ · web viewn089-6-0.doc...

U.S. DEPARTMENT OF EDUCATION

Education Data Exchange Network (EDEN)

N089 – Children with Disabilities (IDEA) Early Childhood

File SpecificationsVersion 6.0SY 2009–10

December 2009

U.S. DEPARTMENT OF EDUCATION N089 - Children with Disabilities (IDEA) Early Childhood File Specifications v6.0

This technical guide was produced under U.S. Department of Education Contract No. ED-PEP-09-O-0044 with 2020 Company, LLC. 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 EducationArne DuncanSecretary

Office of Planning, Evaluation and Policy DevelopmentCarmel MartinAssistant Secretary

December 2009

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, N089 – Children with Disabilities (IDEA) Early Childhood File Specifications, Washington, D.C., 2009.

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.

December 2009 i SY 2009-10

http://www.ed.gov/edfacts/


DOCUMENT CONTROLDOCUMENT INFORMATION

Title: N089 – Children with Disabilities (IDEA) Early Childhood File Specifications

Revision: Version 6.0

Issue Date: December 2009

Security Level: Unclassified – For Official Use Only

Filename: document.doc.doc

DOCUMENT HISTORYVersion Number Date Summary of Change

1.0 This file specification was not used 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.



5.0 Version 5.0 or subsequent updates (i.e. 6.0, 5.2, etc) of this file specification is used to build files for SY 2009-10.

6.0 December 2009 1.2 – Added core reporting requirements table 1.2 – Clarified guidance on when zero counts are required. 1.2 – Added subtotals for racial ethnic, LEP status (both) and

educational environment (IDEA) early childhood(EC) 2.0 - Clarified and reformat guidance Appendix – Updated crosswalk

RELEASE AUTHORIZATION Name Signature / Date

Author

QA

Release Authority

December 2009 ii SY 2009-10


PREFACEThis 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 EDFacts Workbook, EDFacts 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.

December 2009 iii SY 2009-10


CONTENTS

DOCUMENT CONTROL iiPREFACE iii1.0 PURPOSE 1

1.1 Changes from the SY 2009-09 File Specifications 11.2 Requirements for Submitting this Data Group 1

2.0 GUIDANCE FOR SUBMITTING THIS FILE43.0 FILE NAMING CONVENTION 9

3.1 Population Status 94.0 SEA CHILDREN WITH DISABILITIES (IDEA) EARLY CHILDHOOD

FILE 104.1 Header Record Definition 104.2 Data Record Definition 114.3 SEA Children with Disabilities (IDEA) Early Childhood File Examples 144.3.1 Partial Record Sample for Fixed Format SEA Children with Disabilities

(IDEA) Early Childhood File 144.3.2 Partial Record Sample for Comma–Delimited File Format SEA Children with

Disabilities (IDEA) Early Childhood File 154.3.3 Partial Record Sample for Tab–Delimited File Format SEA Children with

Disabilities (IDEA) Early Childhood File 165.0 LEA CHILDREN WITH DISABILITIES (IDEA) EARLY CHILDHOOD

FILE 175.1 Header Record Definition 175.2 Data Record Definition 185.3 LEA Children with Disabilities (IDEA) Early Childhood File Example 215.3.1 Partial Record Sample for Fixed Format LEA Children with Disabilities

(IDEA) Early Childhood File 215.3.2 Partial Record Sample for Comma–Delimited File Format LEA Children with

Disabilities (IDEA) Early Childhood File 225.3.3 Partial Record Sample for Tab–Delimited File Format LEA Children with

Disabilities (IDEA) Early Childhood File 23APPENDIX: DANS TO EDFACTS CROSSWALK 24

December 2009 iv SY 2009-10


1.0 PURPOSEThis document contains instructions for building fixed and delimited files to submit EDFacts Data Group: Children with Disabilities (IDEA) Early Childhood Tables, DG613. The definition for this data group is in row “Table Name” in Table 4.2-1.

The data collected using this file specification are required by the Individuals with Disabilities Education Act (IDEA), Section 618.

For states approved for EDFacts only submissions, the data will be used as responses in Table 1, “Report of Children with Disabilities Receiving Special Education under Part B of the Individuals with Disabilities Education Act” and Table 3, “Part B, Individuals With Disabilities Education Act Implementation of FAPE Requirements.”

The data are also used for monitoring the programs and activities under IDEA. The appendix contains a crosswalk between this file and the applicable sections of Tables 1 and 3.

The LEA data collected through this file are also used for the Non-Fiscal Survey of the Common Core of Data (CCD).

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

1.1 Changes from the SY 2009-09 File Specifications

There have been changes to the requirements for submitting this data group:

Added subtotals by racial ethnic, LEP status (both), and environment (IDEA) early childhood (EA).

Added zeros requirement at SEA level.

In addition, the guidance in sections 1.2 and 2.0 has been reformatted and claried.

1.2 Requirements for Submitting this Data Group

This section contains two tables that summarize the reporting requirements. The first table contains the reporting period, the education units included or excluded, the type of count, and zero count reporting. The second table contains the required categories and applicable totals.

December 2009 1 SY 2009-10


Table 1.2-1 Children with Disabilities (IDEA) Early Childhood, Core Reporting Requirements

SEA LEA SchoolReporting Period State-specific child count date1,

Designated between October 1 and December 1Education units reported

Include SEA Include LEAs that had responsibility for the education of children with disabilities (IDEA) at the time of the state’s child count.

File not submitted at the school level

Education units not reported

Closed, inactive, or future LEAs

Type of count Once (unduplicated count)

At only one LEA (unduplicated count across LEAs)

Zero counts If the count is applicable to the state, an integer greater than one, zero, or -1 for missing is required.

If the count is not applicable to the state, the record is not included in the file. Counts not applicable to the state will be reported in the EMAPS State Supplemental Survey.

Not required

The following table indicates the valid combinations of categories and the subtotals and/or totals needed for this file. An “X” in the cell indicates that the cell must be populated when reporting that particular category. The total indicator must be either “Y” (Yes) or “N” (No). If the record is for a detail count (category set), specify an “N” (No). If the record is for a subtotal or total of the education unit, specify a “Y” (Yes).

1 The child count date will be reported in the state’s EMAPS Supplemental Survey. The EMAPS Supplemental Survey collects metadata on files submitted through ESS.

December 2009 2 SY 2009-10


Table 1.2–2: Children with Disabilities (IDEA) Early Childhood, Required Categories, and Applicable TotalsCategory

Set Table NameRacial

/ Ethni

c

Sex (Membership

)

Age (Early

Childhood)

LEP Statu

s(Both)

Disability

Category (IDEA)

Educational Environment

(IDEA) ECTotal

Indicator Comments

Category Set A

CHWDSBERLCHD X X X N

Category Set B

CHWDSBERLCHD X X X N

Category Set C

CHWDSBERLCHD X X N

Category Set D

CHWDSBERLCHD X X N

Subtotal 1

CHWDSBERLCHD X

Y

Subtotal by Sex (Membership)

Subtotal 2

CHWDSBERLCHD XY

Subtotal by Age (Early Childhood)

Subtotal 3

CHWDSBERLCHD X

Y

Subtotal by Disability Category (IDEA)

Subtotal 4

CHWDSBERLCHD X Y Subtotal by Racial Ethnic

Subtotal 5

CHWDSBERLCHD XY

Subtotal by LEP Status (Both)

Subtotal 6

CHWDSBERLCHD X

Y

Subtotal by Education Environment (IDEA) EC

Total of the Education Unit

CHWDSBERLCHDY

Total of the Education Unit

December 2009 3 SY 2009-10


2.0 GUIDANCE FOR SUBMITTING THIS FILEThis file contains an unduplicated count of the children with disabilities ages 3 through 5 receiving special education and related services according to an individualized education program (IEP) or an individualized family service plan (IFSP) in place on the state’s child count date2.

See below for additional guidance concerning this file:

When is the SEA file due?The SEA file is due by February 1 of each year.

Do not submit preliminary or placeholder data just to meet the submission deadline. The submission of the SEA data will be assessed by the Office of Special Education (OSEP) for timeliness, completeness, passing edit checks, and for responding to data note requests about year-to-year changes in Performance Indicator #20 on your state’s Annual Performance Report (APR). Data submissions with missing data elements are rated by OSEP as “incomplete.”

If data will not be submitted by the due date, remember to update your submission plan and contact the Partner Support Center.

Which children should be reported in this file?Include children with disabilities who are ages 3 through 5 receiving special education and related services according to an individual education program or service plan in place on the count date. This includes children enrolled in private school by a parent, but who are still receiving special education services through the LEA under a services plan.

What children should not be reported in this file?Do not include children with disabilities (IDEA) who are ages 6 and over. (Those children are reported in N/X002.)

How should students with disabilities (IDEA) who receive their education in a state-operated school (i.e., state school for the deaf) be reported?Students who receive their education exclusively at a state-operated facility should be reported in the SEA level count. If an LEA retains responsibility for the education of students who receive their education exclusively at a state-operated facility, the LEA may also report those students, depending on state procedures.

How are student counts reported by Age (Early Childhood)?2 Children enrolled in private school by a parent, but who are still receiving special education services through the LEA, may have a services plan rather than an IEP or IFSP. These children should be included in the child count.

December 2009 4 SY 2009-10


Children should be reported according to their discrete age, based on each child’s age as of the child count date.

How are children who reside in one LEA but received services in another reported?Students should be reported by the LEA that has responsibility for the students (i.e., paying for the student’s services.)

How are students reported by developmental delay?States must have defined and established eligibility criteria for developmental delay for children ages 3 through 5 in order to report children under that permitted value in this file. Only children ages 3 through 5 may be reported in the developmental delay disability category, and then only in states with diagnostic instruments and procedures to measure delays in physical, cognitive, communication, social, or emotional, or adaptive development. Although federal law does not require that states and LEAs categorize children according to developmental delay, if this category is required by state law, states are expected to report these children in the developmental delay category.

If the development delay is not authorized for use by the state, the permitted value development delay is not used in the file. The Department will populate the columns for development delay as “not applicable” using the information provided in the State Supplemental Survey in EMAPS (the metadata collection).

How is a child with more than one primary disability reported? If a child has only two primary disabilities and those disabilities are deafness and

blindness and the child is not reported as having a developmental delay, that child must be reported under the permitted value “deaf-blindness.”

A child who has more than one primary disability and is not reported under the permitted value "deaf-blindness" (as explained in the bullet above) or as the permitted value of developmental delay must be reported under the permitted value “multiple disabilities.”

How are student counts reported by the racial ethnic?The document EDFacts Guidance on Submitting Racial and Ethnic Data contains directions on how to report racial and ethnic data.

How are student counts reported by Educational Environment (IDEA) Early Childhood?The chart below explains the permitted values used for educational environment.

Educational Environment Permitted value used

Regular early childhood program - A program that includes at least 50% nondisabled children including but not

At least 80% of the time REC80

December 2009 5 SY 2009-10


Educational Environment Permitted value used

limited to: Head Start Kindergarten Reverse mainstream classrooms Private preschools Preschool classes offered to an

eligible pre-kindergarten population by the public school system

Group child careAttendance does not need to be funded by IDEA, Part B funds.

Between 40% and 79% of the time REC79TO40

Less than 40% of the time REC39

Special education program - A program that includes less than 50% nondisabled children

Special education classrooms - Special education program in a class with less than 50% nondisabled children including: Regular school buildings Trailers or portables outside regular

school buildings Child care facilities Hospital facilities on an outpatient basis Other community-based settings

SC

Separate schools - Education programs in public or private day schools designed specifically for children with disabilities

SS

Residential facilities - Publicly or privately operated residential schools or residential medical facilities on an inpatient basis

RF

Home - Principal residence of the child’s family or caregivers. Include children who receive special education both at home and in a service provider location. The term caregiver includes babysitters

H

Service provider location – Including Private clinicians’ offices Clinicians’ offices located in school buildings Hospital facilities on an outpatient basis Libraries and other public locations

SPL

How is percentage of time in regular early childhood programs calculated? The numerator for this calculation is the amount of time per week the child spends in a regular early childhood program. The denominator for this calculation is the total number of hours the child spends in a regular early childhood program PLUS any time the child spent receiving special education and related services outside of a regular early childhood program. The result is multiplied by 100.

The denominator includes any time spent receiving special education in the special education program. This is is true even if the child receives little or no special education in the early childhood program. For example,

December 2009 6 SY 2009-10


If the child attends a regular early childhood program 6 hours a week and receives special education and related services in a special education program for an additional 4 hours a week, report the child under the permitted value for regular early childhood program 40% to 79% of time. Calculated as follows:

o 6 hours in regular ÷ 10 total hours =.60*100=60%

If the child attends a regular early childhood program 6 hours a week and receives 1 hour of special education and related services at home and an additional half hour of special education and related services a service provider location, report the child under the permitted value for regular early childhood program at least 80% of time. Calculated as follows:

o 6 hours in regular ÷ 7.5 total hours = 0.8*100=80%

If a child is pulled out of the regular early childhood program to receive special education, this is considered time outside the regular early childhood program. Include this time in the in the denominator but not the numerator of the calculation. For example:

If a child attends a regular early childhood program for 6 hours a week, and is pulled out of that environment for 2 hours each week to receive speech instruction, report the child under the permitted value regular early childhood program 40% to 79% of time. Calculated as follows:

o 4 hours in regular ÷ 6 total hours = .67*100 = 67%

What if a child receives special education at home or in a service provider location in addition to attending either a regular early childhood program or a special education program?Report the child under one of the permitted values for regular early childhood program or special education programs, as appropriate, instead of home or service provider.

What if a child receives special education at a service provider location in addition services at home?Report the child under the permitted value for home.

What if some data are not available?If some data are not available, the data can be reported as “missing” by including records with student counts of “-1.” Eventually, all the data will need to be reported.

How does EDFacts data map to DANS?A crosswalk to Table 2 is in the appendix.

What happens to the EDFacts data for a state that has been approved as an EDFacts-only data submitter for this file?Currently, EDFacts data are made available to OSEP’s contractor on the submission due date. The contractor then analyzes the IDEA data for data anomalies and may

December 2009 7 SY 2009-10


contact the state’s IDEA Part B data manager (and EDFacts coordinator) for further clarification.

December 2009 8 SY 2009-10


3.0 FILE NAMING CONVENTIONBeing 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 Children with Disabilities (IDEA) Early Childhood file submissions:

sslevCHDSBERLvvvvvvv.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 Children with Disabilities (IDEA) Early Childhood Tables submissionLEA for a Local Education Agency Children with Disabilities (IDEA) Early Childhood Tables submission

Filename = CHDSBERL (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

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

December 2009 9 SY 2009-10


4.0 SEA CHILDREN WITH DISABILITIES (IDEA) EARLY CHILDHOOD FILE

This section describes the fixed file and delimited file specifications used to transmit information pertaining to the SEA Children with Disabilities (IDEA) Early Childhood File. The file type is specified in the header record.

4.1 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: Children with Disabilities (IDEA) Early Childhood, SEA Header RecordData

ElementName

StartPositio

nLength Type Pop Definition / Comments Permitted Values

File Type 1 50 String M Identifies the type of file being submitted. SEA CHILDREN WITH DISABILITIES (IDEA) EC

Total Records In File

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

File Name (Including file extension)

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

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

File Reporting Period

118 9 String M Enter the Academic School Year for which data is 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..

2009-2010

OR

2009 2010

Filler 127 363 String M Leave filler field blank.

Carriage Return / Line Feed (CRLF)

490 1 M

December 2009 10 SY 2009-10


4.2 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 totals of the education unit.

Section 4.3 contains examples of Data Records.

Table 4.2–1: Children with Disabilities (IDEA) Early Childhood, SEA Data RecordData

ElementName

StartPositio


File Record Number

1 10 Number M A sequential number assigned by the State that is unique to each row entry within the file.

ID 559FIPS State Code

11 2 String M The two–digit Federal Information Processing Standards (FIPS) for the state, District of Columbia, and the possessions and freely associated areas of the United States (e.g., Puerto Rico).

For a list of valid FIPS State Codes, refer to the EDFacts Workbook.

ID 570State Agency Number

13 2 String M A number used to uniquely identify state agencies. This ID cannot be updated through this file.

01 – State Education Agency



Table Name 49 20 String M The unduplicated number of children with disabilities (IDEA) ages 3 through 5.

CHWDSBERLCHD

Racial Ethnic 69 15 String A See “EDFacts Guidance on Submitting Racial Ethnic Data”

See “EDFacts Guidance on Submitting Racial Ethnic Data”MISSING

Sex (Membership)

84 15 String A The concept describing the biological traits that distinguish the males and females of a species.

F – FemaleM – MaleMISSING

Age (Early Childhood)

99 15 String A The age of children who are in early childhood.

3 – age 34 – age 45 – age 5MISSING

LEP Status (Both)

114 15 String A An indication of whether students are limited English proficient.

LEP – Limited English proficient (LEP) StudentNLEP – Non–limited English proficient (Non–LEP) StudentMISSING

December 2009 11 SY 2009-10


DataElement

Name

StartPositio


Disability Category (IDEA)

129 15 String A The primary disability determined by the IEP team. Code set based on the Individuals with Disabilities Education Act (IDEA).

AUT – AutismDB – Deaf–blindnessDD – Developmental delayEMN – Emotional disturbanceHI – Hearing impairmentMR – Mental retardationMD – Multiple disabilitiesOI – Orthopedic impairmentSLD – Specific learning disabilitySLI – Speech or language impairmentTBI – Traumatic brain injuryVI – Visual impairmentOHI – Other health impairmentMISSING






Educational Environment (IDEA) EC

219 60 String A The setting in which children ages 3 through 5 receive special education and related services.

REC80 – In regular EC program at least 80% of the timeREC79TO40 – In regular EC program 40% through 79% of the timeREC39 – In regular EC program less than 40% of the timeSC – Separate ClassSS – Separate School RF – Residential Facility H – HomeSPL – Service Provider LocationMISSING

Total Indicator

279 1 String M An indicator that defines the count level (i.e., detail level, subtotal level or total of the education unit level).

N – specifies detail levelY – specifies a subtotal or total of the education unit level

December 2009 12 SY 2009-10


DataElement

Name

StartPositio


Explanation 280 200 String O Submitted files will be processed through 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 Count

480 10 Number M If the count provided is either a subtotal or total of the education unit, it must be equal to or greater than the sum of its parts.


490 1 M

December 2009 13 SY 2009-10


4.3 SEA Children with Disabilities (IDEA) Early Childhood File Examples

The examples use the codes when a state submits racial ethnic data under the original 5 racial ethnic permitted values.

4.3.1Partial Record Sample for Fixed Format SEA Children with Disabilities (IDEA) Early Childhood 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.

∙∙∙∙5∙∙∙∙0∙∙∙∙5∙∙∙∙0∙∙∙∙5∙∙∙∙0∙∙∙∙5∙∙∙∙0∙∙∙∙5∙∙∙∙0∙∙∙∙5∙∙∙∙0∙∙∙∙5∙∙∙∙0∙∙∙∙5∙∙∙∙0∙∙∙∙5∙∙∙∙0∙∙∙∙5∙∙∙∙0∙∙∙∙5SEA∙CHILDREN∙WITH∙DISABILITIES∙(IDEA)∙EC∙∙∙∙∙∙∙∙∙∙19∙∙∙∙∙∙∙∙euseachdsberlver0006.txt∙SEA∙N089∙CWD∙-∙EC∙∙∙1∙∙∙∙∙∙∙∙∙8001∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙3∙∙∙∙∙∙2∙∙∙∙∙∙∙∙∙8001∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙4∙∙∙∙∙∙3∙∙∙∙∙∙∙∙∙8001∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙5∙∙∙∙∙∙4∙∙∙∙∙∙∙∙∙8001∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙AM∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙5∙∙∙∙∙∙∙∙∙8001∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙AS∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙6∙∙∙∙∙∙∙∙∙8001∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙BL∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙7∙∙∙∙∙∙∙∙∙8001∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙F∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙8∙∙∙∙∙∙∙∙∙8001∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙M∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙9∙∙∙∙∙∙∙∙∙8001∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙10∙∙∙∙∙∙∙∙8001∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙11∙∙∙∙∙∙∙∙8001∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙F∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙12∙∙∙∙∙∙∙∙8001∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙M∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙13∙∙∙∙∙∙∙∙8001∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙3∙∙∙∙∙∙14∙∙∙∙∙∙∙∙8001∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙4∙∙∙∙∙∙15∙∙∙∙∙∙∙∙8001∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙5∙∙∙∙∙∙16∙∙∙∙∙∙∙∙8001∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙17∙∙∙∙∙∙∙∙8001∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙18∙∙∙∙∙∙∙∙8001∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙19∙∙∙∙∙∙∙∙8001∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙

December 2009 14 SY 2009-10


4.3.2Partial Record Sample for Comma–Delimited File Format SEA Children with Disabilities (IDEA) Early Childhood File

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

SEA CHILDREN WITH DISABILITIES (IDEA) EC,19,euseachdsberlver0006.csv,SEA N089 CWD - EC,2009-2010,¶1,80,01,,,CHWDSBERLCHD,,,3,,AUT,,,,,,REC80,N,,50¶2,80,01,,,CHWDSBERLCHD,,,4,,DB,,,,,,REC79TO40,N,,50¶3,80,01,,,CHWDSBERLCHD,,,5,,DD,,,,,,REC39,N,,50¶4,80,01,,,CHWDSBERLCHD,AM,,,,AUT,,,,,,RF,N,,50¶5,80,01,,,CHWDSBERLCHD,AS,,,,DB,,,,,,H,N,,50¶6,80,01,,,CHWDSBERLCHD,BL,,,,DD,,,,,,SPL,N,,50¶7,80,01,,,CHWDSBERLCHD,,F,,,,,,,,,REC39,N,,50¶8,80,01,,,CHWDSBERLCHD,,M,,,,,,,,,SC,N,,50¶9,80,01,,,CHWDSBERLCHD,,,,LEP,,,,,,,SS,N,,50¶10,80,01,,,CHWDSBERLCHD,,,,NLEP,,,,,,,RF,N,,50¶11,80,01,,,CHWDSBERLCHD,,F,,,,,,,,,,Y,,50¶12,80,01,,,CHWDSBERLCHD,,M,,,,,,,,,,Y,,50¶13,80,01,,,CHWDSBERLCHD,,,3,,,,,,,,,Y,,50¶14,80,01,,,CHWDSBERLCHD,,,4,,,,,,,,,Y,,50¶15,80,01,,,CHWDSBERLCHD,,,5,,,,,,,,,Y,,50¶16,80,01,,,CHWDSBERLCHD,,,,,AUT,,,,,,,Y,,100¶17,80,01,,,CHWDSBERLCHD,,,,,DB,,,,,,,Y,,100¶18,80,01,,,CHWDSBERLCHD,,,,,DD,,,,,,,Y,,100¶19,80,01,,,CHWDSBERLCHD,,,,,,,,,,,,Y,,500¶

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.

December 2009 15 SY 2009-10


4.3.3Partial Record Sample for Tab–Delimited File Format SEA Children with Disabilities (IDEA) Early Childhood File

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

SEA CHILDREN WITH DISABILITIES (IDEA) EC>19>euseachdsberlver0006.tab>SEA N089 CWD - EC>2009-2010>¶1>80>01>>>CHWDSBERLCHD>>>3>>AUT>>>>>>REC80>N>>50¶2>80>01>>>CHWDSBERLCHD>>>4>>DB>>>>>>REC79TO40>N>>50¶3>80>01>>>CHWDSBERLCHD>>>5>>DD>>>>>>REC39>N>>50¶4>80>01>>>CHWDSBERLCHD>AM>>>>AUT>>>>>>RF>N>>50¶5>80>01>>>CHWDSBERLCHD>AS>>>>DB>>>>>>H>N>>50¶6>80>01>>>CHWDSBERLCHD>BL>>>>DD>>>>>>SPL>N>>50¶7>80>01>>>CHWDSBERLCHD>>F>>>>>>>>>REC39>N>>50¶8>80>01>>>CHWDSBERLCHD>>M>>>>>>>>>SC>N>>50¶9>80>01>>>CHWDSBERLCHD>>>>LEP>>>>>>>SS>N>>50¶10>80>01>>>CHWDSBERLCHD>>>>NLEP>>>>>>>RF>N>>50¶11>80>01>>>CHWDSBERLCHD>>F>>>>>>>>>>Y>>50¶12>80>01>>>CHWDSBERLCHD>>M>>>>>>>>>>Y>>50¶13>80>01>>>CHWDSBERLCHD>>>3>>>>>>>>>Y>>50¶14>80>01>>>CHWDSBERLCHD>>>4>>>>>>>>>Y>>50¶15>80>01>>>CHWDSBERLCHD>>>5>>>>>>>>>Y>>50¶16>80>01>>>CHWDSBERLCHD>>>>>AUT>>>>>>>Y>>100¶17>80>01>>>CHWDSBERLCHD>>>>>DB>>>>>>>Y>>100¶18>80>01>>>CHWDSBERLCHD>>>>>DD>>>>>>>Y>>100¶19>80>01>>>CHWDSBERLCHD>>>>>>>>>>>>Y>>500¶

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

December 2009 16 SY 2009-10


5.0 LEA CHILDREN WITH DISABILITIES (IDEA) EARLY CHILDHOOD FILE

This section describes the fixed file and delimited file specifications used to transmit information pertaining to the LEA Children with Disabilities (IDEA) Early Childhood File. The file type is specified in the header record.

5.1 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 6.0–1: Children with Disabilities (IDEA) Early Childhood, LEA Header RecordData

ElementName

StartPositio


File Type 1 50 String M Identifies the type of file being submitted. LEA CHILDREN WITH DISABILITIES (IDEA) EC

Total Records In File

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

File Name (Including file extension)

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

File Identifier

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

File Reporting Period

118 9 String M Enter the Academic School Year for which data is 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.

2008-2010

OR

2009 2010



490 1 M

December 2009 17 SY 2009-10


5.2 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 totals of the education unit.

See Section 5.3 for examples of the Data Record.

Table 5.2–1: Children with Disabilities (IDEA) Early Childhood, LEA Data RecordData

ElementName

StartPosition Length Type Pop Definition / Comments Permitted Values

File Record Number

1 10 Number M A sequential number assigned by the State that is unique to each row entry within the file.

ID 559FIPS State Code

11 2 String M The two–digit Federal Information Processing Standards (FIPS) for the state, District of Columbia, and the possessions and freely associated areas of the United States (e.g., Puerto Rico).

For a list of valid FIPS State Codes, refer to the EDFacts Workbook.

ID 570State Agency Number

13 2 String M A number used to uniquely identify state agencies. This ID cannot be updated through this file.

01 – State Education Agency

ID 4State LEA Identifier

15 14 String M The identifier assigned to a local education agency (LEA) by the state education agency (SEA). Also known as State LEA ID. This data element cannot be updated through this file.


Table Name 49 20 String M The unduplicated number of children with disabilities (IDEA) ages 3 through 5.

CHWDSBERLCHD

Racial Ethnic 69 15 String A See “EDFacts Guidance on Submitting Racial Ethnic Data”

See “EDFacts Guidance on Submitting Racial Ethnic Data)MISSING

Sex (Membership)

84 15 String A The concept describing the biological traits that distinguish the males and females of a species.

F – FemaleM – MaleMISSING

Age (Early Childhood)

99 15 String A The age of children who are in early childhood.

3 – age 34 – age 45 – age 5MISSING

LEP Status (Both)

114 15 String A An indication of whether students are limited English proficient.

LEP – Limited English proficient (LEP) StudentNLEP – Non–limited English proficient (Non–LEP) StudentMISSING

December 2009 18 SY 2009-10


Data Element

NameStart

Position Length Type Pop Definition / Comments Permitted Values

Disability Category (IDEA)

129 15 String A The primary disability determined by the IEP team. Code set based on the Individuals with Disabilities Education Act (IDEA).

AUT – AutismDB – Deaf–blindnessDD – Developmental delayEMN – Emotional disturbanceHI – Hearing impairmentMR – Mental retardationMD – Multiple disabilitiesOI – Orthopedic impairmentSLD – Specific learning disabilitySLI – Speech or language impairmentTBI – Traumatic brain injuryVI – Visual impairmentOHI – Other health impairmentMISSING






Educational Environment (IDEA) EC

219 60 String A The setting in which children ages 3 through 5 receive special education and related services.

REC80 – In regular EC program at least 80% of the timeREC79TO40 – In regular EC program 40% through 79% of the timeREC39 – In regular EC program less than 40% of the timeSC – Separate ClassSS – Separate SchoolRF – Residential Facility H – HomeSPL – Service Provider LocationMISSING

Total Indicator

279 1 String M An indicator that defines the count level (i.e., detail level, subtotal level or total of the education unit level).

N – specifies detail levelY – specifies a subtotal or total of the education unit level

December 2009 19 SY 2009-10


Data Element

NameStart

Position Length Type Pop Definition / Comments Permitted Values

Explanation 280 200 String O Submitted files will be processed through 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 Count

480 10 Number M If the count provided is either a subtotal or total of the education unit, it must be equal to or greater than the sum of its parts.


490 1 M

December 2009 20 SY 2009-10


5.3 LEA Children with Disabilities (IDEA) Early Childhood File Example

The examples use the codes when a state submits racial ethnic data under the original 5 racial ethnic permitted values.

5.3.1Partial Record Sample for Fixed Format LEA Children with Disabilities (IDEA) Early Childhood 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.

∙∙∙∙5∙∙∙∙0∙∙∙∙5∙∙∙∙0∙∙∙∙5∙∙∙∙0∙∙∙∙5∙∙∙∙0∙∙∙∙5∙∙∙∙0∙∙∙∙5∙∙∙∙0∙∙∙∙5∙∙∙∙0∙∙∙∙5∙∙∙∙0∙∙∙∙5∙∙∙∙0∙∙∙∙5∙∙∙∙0∙∙∙∙5LEA∙CHILDREN∙WITH∙DISABILITIES∙(IDEA)∙EC∙∙∙∙∙∙∙∙∙∙19∙∙∙∙∙∙∙∙euleachdsberlver0006.txt∙LEA∙N089∙CWD∙-∙EC∙∙∙1∙∙∙∙∙∙∙∙∙800100619AEMDISTRI∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙3∙∙∙∙∙∙2∙∙∙∙∙∙∙∙∙800100619AEMDISTRI∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙4∙∙∙∙∙∙3∙∙∙∙∙∙∙∙∙800100619AEMDISTRI∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙5∙∙∙∙∙∙4∙∙∙∙∙∙∙∙∙800100619AEMDISTRI∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙AM∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙5∙∙∙∙∙∙∙∙∙800100619AEMDISTRI∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙AS∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙6∙∙∙∙∙∙∙∙∙800100619AEMDISTRI∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙BL∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙7∙∙∙∙∙∙∙∙∙800100619AEMDISTRI∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙F∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙8∙∙∙∙∙∙∙∙∙800100619AEMDISTRI∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙M∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙9∙∙∙∙∙∙∙∙∙800100619AEMDISTRI∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙10∙∙∙∙∙∙∙∙800100619AEMDISTRI∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙11∙∙∙∙∙∙∙∙800100619AEMDISTRI∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙F∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙12∙∙∙∙∙∙∙∙800100619AEMDISTRI∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙M∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙13∙∙∙∙∙∙∙∙800100619AEMDISTRI∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙3∙∙∙∙∙∙14∙∙∙∙∙∙∙∙800100619AEMDISTRI∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙4∙∙∙∙∙∙15∙∙∙∙∙∙∙∙800100619AEMDISTRI∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙5∙∙∙∙∙∙16∙∙∙∙∙∙∙∙800100619AEMDISTRI∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙17∙∙∙∙∙∙∙∙800100619AEMDISTRI∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙18∙∙∙∙∙∙∙∙800100619AEMDISTRI∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙19∙∙∙∙∙∙∙∙800100619AEMDISTRI∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙CHWDSBERLCHD∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙∙

December 2009 21 SY 2009-10


5.3.2Partial Record Sample for Comma–Delimited File Format LEA Children with Disabilities (IDEA) Early Childhood File

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

LEA CHILDREN WITH DISABILITIES (IDEA) EC,19,euleachdsberlver0006.csv,LEA N089 CWD - EC,2009-2010,¶1,80,01,00619AEMDISTRI,,CHWDSBERLCHD,,,3,,AUT,,,,,,REC80,N,,50¶2,80,01,00619AEMDISTRI,,CHWDSBERLCHD,,,4,,DB,,,,,,REC79TO40,N,,50¶3,80,01,00619AEMDISTRI,,CHWDSBERLCHD,,,5,,DD,,,,,,REC39,N,,50¶4,80,01,00619AEMDISTRI,,CHWDSBERLCHD,AM,,,,AUT,,,,,,RF,N,,50¶5,80,01,00619AEMDISTRI,,CHWDSBERLCHD,AS,,,,DB,,,,,,H,N,,50¶6,80,01,00619AEMDISTRI,,CHWDSBERLCHD,BL,,,,DD,,,,,,SPL,N,,50¶7,80,01,00619AEMDISTRI,,CHWDSBERLCHD,,F,,,,,,,,,REC39,N,,50¶8,80,01,00619AEMDISTRI,,CHWDSBERLCHD,,M,,,,,,,,,SC,N,,50¶9,80,01,00619AEMDISTRI,,CHWDSBERLCHD,,,,LEP,,,,,,,SS,N,,50¶10,80,01,00619AEMDISTRI,,CHWDSBERLCHD,,,,NLEP,,,,,,,RF,N,,50¶11,80,01,00619AEMDISTRI,,CHWDSBERLCHD,,F,,,,,,,,,,Y,,50¶12,80,01,00619AEMDISTRI,,CHWDSBERLCHD,,M,,,,,,,,,,Y,,50¶13,80,01,00619AEMDISTRI,,CHWDSBERLCHD,,,3,,,,,,,,,Y,,50¶14,80,01,00619AEMDISTRI,,CHWDSBERLCHD,,,4,,,,,,,,,Y,,50¶15,80,01,00619AEMDISTRI,,CHWDSBERLCHD,,,5,,,,,,,,,Y,,50¶16,80,01,00619AEMDISTRI,,CHWDSBERLCHD,,,,,AUT,,,,,,,Y,,100¶17,80,01,00619AEMDISTRI,,CHWDSBERLCHD,,,,,DB,,,,,,,Y,,100¶18,80,01,00619AEMDISTRI,,CHWDSBERLCHD,,,,,DD,,,,,,,Y,,100¶19,80,01,00619AEMDISTRI,,CHWDSBERLCHD,,,,,,,,,,,,Y,,500¶

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.

December 2009 22 SY 2009-10


5.3.3Partial Record Sample for Tab–Delimited File Format LEA Children with Disabilities (IDEA) Early Childhood File

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

LEA CHILDREN WITH DISABILITIES (IDEA) EC>19>euleachdsberlver0006.tab>LEA N089 CWD - EC>2009-2010>¶1>80>01>00619AEMDISTRI>>CHWDSBERLCHD>>>3>>AUT>>>>>>REC80>N>>50¶2>80>01>00619AEMDISTRI>>CHWDSBERLCHD>>>4>>DB>>>>>>REC79TO40>N>>50¶3>80>01>00619AEMDISTRI>>CHWDSBERLCHD>>>5>>DD>>>>>>REC39>N>>50¶4>80>01>00619AEMDISTRI>>CHWDSBERLCHD>AM>>>>AUT>>>>>>RF>N>>50¶5>80>01>00619AEMDISTRI>>CHWDSBERLCHD>AS>>>>DB>>>>>>H>N>>50¶6>80>01>00619AEMDISTRI>>CHWDSBERLCHD>BL>>>>DD>>>>>>SPL>N>>50¶7>80>01>00619AEMDISTRI>>CHWDSBERLCHD>>F>>>>>>>>>REC39>N>>50¶8>80>01>00619AEMDISTRI>>CHWDSBERLCHD>>M>>>>>>>>>SC>N>>50¶9>80>01>00619AEMDISTRI>>CHWDSBERLCHD>>>>LEP>>>>>>>SS>N>>50¶10>80>01>00619AEMDISTRI>>CHWDSBERLCHD>>>>NLEP>>>>>>>RF>N>>50¶11>80>01>00619AEMDISTRI>>CHWDSBERLCHD>>F>>>>>>>>>>Y>>50¶12>80>01>00619AEMDISTRI>>CHWDSBERLCHD>>M>>>>>>>>>>Y>>50¶13>80>01>00619AEMDISTRI>>CHWDSBERLCHD>>>3>>>>>>>>>Y>>50¶14>80>01>00619AEMDISTRI>>CHWDSBERLCHD>>>4>>>>>>>>>Y>>50¶15>80>01>00619AEMDISTRI>>CHWDSBERLCHD>>>5>>>>>>>>>Y>>50¶16>80>01>00619AEMDISTRI>>CHWDSBERLCHD>>>>>AUT>>>>>>>Y>>100¶17>80>01>00619AEMDISTRI>>CHWDSBERLCHD>>>>>DB>>>>>>>Y>>100¶18>80>01>00619AEMDISTRI>>CHWDSBERLCHD>>>>>DD>>>>>>>Y>>100¶19>80>01>00619AEMDISTRI>>CHWDSBERLCHD>>>>>>>>>>>>Y>>500¶

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

December 2009 23 SY 2009-10


APPENDIX: DANS TO EDFACTS CROSSWALK Appendix A - SY 2009-10 IDEA (Child Count – Table 1) – EDFacts Crosswalk

IDEA Data Collection Description Table Section

EDFacts File Spec

EDFacts Data Group Category Set Comment

Data Collection Date A EMAPSDiscrete Age by Disability for children ages 3 through 5 receiving special education

B N/X089 613 A

Race/Ethnicity by Disability of children ages 3 through 5 receiving special education

C N/X089 613 B

Appendix B - SY 2009-10 IDEA (Educational Environments – Table 3) – EDFacts Crosswalk

IDEA Data Collection Description Table Section EDFacts

File Spec EDFacts Data Group Category Set

Discrete age of children ages 3 through 5 by educational environment

A

Children attending a regular early childhood program

AA

In the regular early childhood program at least 80% of time

AA1 N/X089 613 A

In the regular early childhood program 40% to 79% of time

AA2

In the regular early childhood program less than 40% of time

AA3

Children not attending a regular early childhood program or kindergarten

AB

Attending a special education program in a separate class

AB1 N/X089 613 A

Attending a special education program in a separate school

AB2

Attending a special education program in a residential facility

AB3

Not attending a special education program: at home

AB4

Not attending a special education program: service

AB5

December 2009 24 SY 2009-10




provider location

Subtotal by age N/X089 613 Subtotal 1

Educational environment of children with disabilities ages 3 through 5 by disability

B

Children attending a regular early childhood program or kindergarten

BA

In a regular early childhood program at least 80% of time

BA1 N/X089 613 A


BA2


BA3


BB

Only attending a special education program: separate class

BB1 N/X089 613 A

Only attending a special education program: separate school

BB2

Only attending a special education program: residential facility

BB3


BB4

Not attending a special education program: at service provider location

BB5

Subtotal by disability N/X089 613 Subtotal 3

Subtotal by educational environment

Subtotal 6

Race/ethnicity of children with disabilities ages 3 through 5 by

C

December 2009 25 SY 2009-10




educational environmentChildren attending a regular early childhood program or kindergarten

CA


CA1 N/X089 613 B


CA2


CA3


CB

Attending a special education program: separate class

CB1 N/X089 613 B

Attending a special education program: separate school

CB2

Attending a special education program: residential facility

CB3


CB4


CB5

Subtotal by racial ethnic N/X089 613 Subtotal 4

Gender (sex) of children with disabilities ages 3-5 by educational environment

D


DA


DA1 N/X089 613 C


DA2

December 2009 26 SY 2009-10





DA3


DB


DB1 N/X089 613 C


DB2


DB3


DB4


DB5

Subtotal by sex N/X089 613 Subtotal 1

Limited English proficiency status of children with disabilities ages 3 through 5 by educational environment

E


EA


EA1 N/X089 613 D


EA2


EA3


EB


EB1 N/X089 613 D

December 2009 27 SY 2009-10





EB2


EB3


EB4


EB5

Subtotal by LEP status (both)

N/X089 613 Subtotal 5

December 2009 28 SY 2009-10


The Department of Education’s mission is to promote student achievement and preparation for global competitiveness by fostering educational excellence and ensuring

equal access.www.ed.gov

December 2009 29 SY 2009-10

n089 – children with disabilities (idea) early childhood ...€¦ · web viewn089-6-0.doc...

Documents