Classic View: KS State Reporting > Collection Extract > SPED: Special Education

Search Terms: Collection Extract

The KIDS Collection SPED Extract allows staff to report Special Education data services without owning the student record. Only those students who are assigned a Primary Disability report (Field 32 on extract reports as WD).

Screenshot of the KIDS SPED extract editor highlighting the extract type field. KIDS SPED Editor

See the KIDS Collection Extracts article for general reporting logic.

Generate the Report

See the KIDS Collection Extracts editor for description of the Report Editor fields and Sample Report Formats.

Select SPED: Special Education from the Extract Type dropdown list.
Enter a Data Filter From Date, if desired.
Enter a Data Filter To Date, if desired.
Select the Assessment Disaggregation Method 1 option, if desired.
Select the Assessment Disaggregation Method 2 option, if desired.
Mark the Students without State IDs checkbox, if desired.
Select an Ad hoc Filter, if desired.
Select the appropriate Format for the extract.
If generating the extract in the State Format (tab delimited), enter the Records Limit Per File number.
Select the Calendars to include in the extract.
Click the Generate Report button. The report displays in the selected format.

Report Layout

Data Element	Description	Location
Record Type	Type of extract being generated, chosen on the Report Editor. This always reports SPED. Alphanumeric, 4 characters	Not dynamically stored
Accountability School Identifier	Indicates the school number of the student's enrollment. Alphanumeric, 4 characters	System Administration > Resources > School > School Detail > State School Number School.number
Resident District	District number where student resides (but not necessarily attends). If Home District field is blank, data reports from the State District Number field. Alphanumeric, 5 characters	Student Information > General > Enrollments > State Reporting Fields > Home District Enrollment.residentDistrict System Administration > Resources > District Information > District Info > State District Number District.number
Legal Last Name	Reports the last name of the student. If the Legal Last Name field is populated, information reports from that field. Alphanumeric, 60 characters	Census > People > Identities > Identity Information > Protected Identity Information > Legal Last Name Identity.legalLastName Census > People > Demographics > Person Information > Last Name Identity.lastName
Legal First Name	Reports the legal first name of the student. If the Legal First Name field is populated, information reports from that field. Alphanumeric, 60 characters	Census > People > Identities > Identity Information > Protected Identity Information > Legal First Name Identity.legalFirstName Census > People > Demographics > Person Information > First Name Identity.firstName
Legal Middle Name	Middle name or middle initial of the student. If only the middle initial is available, that value reports. If no middle name or initial is available for the student, this field reports blank. If the Legal Middle Name field is populated, information reports from that field. Alphanumeric, 60 characters	Census > People > Identities > Identity Information > Protected Identity Information > Legal Middle Name Identity.legalMiddleName Census > People > Demographics > Person Information > Middle Name Identity.middleName
Suffix	Indicates student's name is generational (Jr., III, etc.) If the Legal Suffix field is populated, information reports from that field. Alphanumeric, 10 characters	Census > People > Identities > Identity Information > Protected Identity Information > Legal Suffix Identity.legalSuffix Census > People > Demographics > Person Information > Suffix Identity.suffix
Gender	Indication of student being either male or female. If the Legal Gender field is populated, information reports from that field. Numeric, 1 digit (0 = Female, 1 = Male)	Census > People > Identities > Identity Information > Protected Identity Information > Legal Gender Identity.legalGender Census > People > Demographics > Person Information > Gender Identity.gender
Date of Birth	Date on which student was born. Date field, 10 characters (MM/DD/YYYY)	Census > People > Demographics > Person Information > Birth Date Identity.birthDate
Grade Level	Grade level or primary instructional level at which the student enters and receives services in a school or an educational institution during a given academic session. See the Report Logic section for more information on grade levels. When the enrollment State Grade Level is 04 and the Primary Disability reports a value of WD, a value of 02 reports. Otherwise, this field reports the mapped state grade level of the local grade level. Alphanumeric, 2 characters	Student Information > General > Enrollments > General Enrollment Information > Grade Enrollment.grade
Student Identifier	Unique identifier assigned to the student by the school and/or district. Alphanumeric, 20 characters	Census > People > Demographics > Person Identifiers > Student Number Person.studentNumber
Hispanic Ethnicity	Indication of student being of Hispanic/Latino ethnicity. If yes, reports as Y; if No, reports as N. Alphanumeric, 1 character	Census > People > Demographics > Person Information > Race/Ethnicity > Is the individual Hispanic/Latino? Identity.hispanicLatino
State Student Identifier	Student's state identification number. If there is no value entered, field reports blank. Numeric, 10 digits	Census > People > Demographics > Person Identifiers > State ID Person.stateID
School Year	The ending year of the current school year. If reporting for the 2012-13 school year, this reports as 2012. Numeric, 4 digits	System Administration > Calendar > Calendar > Calendar Information > End Date Calendar.year
Funding School	Override field for the school that receives funding for the student. Alphanumeric, 4 characters	System Administration > Resources > School > School Editor > State School Number Student Information > General > Enrollments > State Reporting Fields > Funding School EnrollmentKS.fundingSchool
Attendance School	Unique number of the school or program in which the student is physically located and where he/she takes the state assessments. Numeric, 4 digits	Student Information > General > Enrollments > State Reporting Fields > Attendance School EnrollmentKS.attendanceSchool
Virtual Education Student	No value reports for this field in the SPED Extract.	N/A
School Entry Date	Reports the student's start date of enrollment at the school. If this Entry into School field is blank on the enrollment record, the pre-determined Override logic (see here) is used. Date field, 10 characters (MM/DD/YYYY)	Student Information > General > Enrollments > State Reporting Fields > Entry into School EnrollmentKS.schoolDate
District Entry Date	Reports the student's first date of entry at the district. If the Entry into District field is blank on the enrollment record, the pre-determined Override logic (see here) is used. Date field, 10 characters (MM/DD/YYYY)	Student Information > General > Enrollments > State Reporting Fields > Entry into District EnrollmentKS.districtDate
State Entry Date	Reports the student's first date of entry at a school in the state. If this Entry into State field is blank, the pre-determined Override logic (see here) is used. Date field, 10 characters (MM/DD/YYYY)	Student Information > General > Enrollments > State Reporting Fields > Entry into State EnrollmentKS.stateDate
First Instructional Date	Reports the first day the student receives instructional services during the school year. A value reports when the student meets the following criteria (at least one of these is true): Primary Disability Code reports as WD. Gifted Student Code reports as GI. Qualified for 504 reports a value that is not 0. Residence of Homeless Student while Homeless reports a value that is not 0. Title I Participation reports a value that is not 0. Military Connected Student Indicator reports a value that is not 0. Immigrant Student reports a value that is not 0. Neglected Student reports a value that is not 0. This reports the first day marked for instruction and attendance from the Calendar in which the student is enrolled. If the student's most recent primary enrollment start date is after this date, the enrollment start date reports. If the student has multiple primary enrollments, the most recent enrollment start date that is on or after the first day of instruction and attendance on the calendar reports. If the student has no primary enrollments, the most recent enrollment start date that is on or after the first day of instruction and attendance on the calendar reports. If the school is marked as School Wide in the Title 1 field on the School Editor, all students within the school report their First Instruction Date. Otherwise, a blank value reports. Date field, 10 characters (MM/DD/YYYY)	Student Information > General > Enrollment > General Enrollment Information > Start Date Enrollment.startDate Student Information > Program Participation > Gifted > Start Date Gifted.startDate Student Information > Special Education > General > State Reporting > Start Date SpecialEDState.startDate System Administration > Calendar > Calendar > Calendar > Days > Instruction, Attendance
Membership Days	No value reports for this field in the SPED Extract.	N/A
Attended Days	No value reports for this field in the SPED Extract.	N/A
Truant Student	No value reports for this field in the SPED Extract.	N/A
Minutes Enrolled	No value reports for this field in the SPED Extract.	N/A
Concurrent HS Enrollment	No value reports for this field in the SPED Extract.	N/A
Exit Withdrawal Date	No value reports for this field in the SPED Extract.	N/A
Exit Withdrawal Type	No value reports for this field in the SPED Extract.	N/A
Unweighted Grade Point Average	No value reports for this field in the ENRL Extract.	N/A
Special Circumstance Transfer Choice	No value reports for this field in the SPED Extract.	N/A
Post Graduation Plans	No value reports for this field in the SPED Extract.	N/A
Comprehensive Race	Indicates the student's race/ethnicity. All five positions must be filled with either a 0 or a 1. A student designated as White, this field reports as 00001. A student designated as American Indian reports as 10000. Position 5 - White Position 4 - Native Hawaiian or Other Pacific Islander Position 3 - Black or African American Position 2 - Asian Position 1 - American Indian or Alaska Native Bit field, 6 characters	Census > People > Demographics > Person Information > Federal Race Identity.raceEthnicity
Lunch Program	No value reports for this field in the SPED Extract.	N/A
Primary Disability Indicator	Indicates student's primary disability. When a student has an active Special Education State Reporting record OR an active IEP, a value of WD reports. Otherwise, a value of ND reports. SPED State Reporting records that were ended prior to the selected calendar year do not report when the Date From field on the extract editor is not populated. An active Special Education State Reporting record is calculated as follows: The Start Date on the Special Education State Reporting record is on or before the Date To field on the Extract Editor. The End Date on the Special Education State Reporting record is blank or on or after the Date From field on the Extract editor. An active IEP record is calculated as follows: The Start Date of the IEP is on or before the Date To field on the Extract Editor. The End Date of the IEP is blank or on or after the Date From field on the Extract editor. When there is more than one SPED records in a given year for a student, the most recent record that overlaps the dates entered on the extract editor reports. Alphanumeric, 2 characters	Student Information > Special Education > General > State Reporting > Disability SpecialEDState.primaryDisability Student Information > Special Education > General > State Reporting > Start Date, End Date SpecialEDState.startDate SpecialEDState.endDate Student Information > Special Education > Documents > IEP > Start Date, End Date Plan.startDate Plan.endDate
Gifted Student Indicator	Indicates whether student is considered gifted/talented. When the student has an active Gifted record, a value of GI reports. Gifted records that were ended prior to the selected calendar year do not report when the Date From field is not populated on the extract editor. Otherwise, a blank value reports. An active Gifted record is calculated as follows: The Start Date on the Gifted record is on or before the Date To field on the Extract editor. The End Date on the Gifted record is blank or on or after the Date From field on the Extract editor. Alphanumeric, 2 characters	Student Information > Program Participation > Gifted > Start Date, End Date Gifted.startDate Gifted.endDate
Section 504	No value reports for this field in the SPED Extract.	N/A
Residence of Homeless	No value reports for this field in the SPED Extract.	N/A
ESOL/Bilingual Program Entry Date	No value reports for this field in the SPED Extract.	N/A
First Entry Date into a school in the US	No value reports for this field in the SPED Extract.	N/A
First Language	No value reports for this field in the SPED Extract.	N/A
ESOL/Bilingual Participation Code	Reports the Service Type of the student's EL Service Record(s) and reports that value. If the First Language field is populated, this field must report a value of 1-6. See the Report Logic section for more information. If there is no selection made for this field, a default value of zero (0) reports. Alphanumeric, 1 character	Student Information > Program Participation > English Learners > EL Services > ESOL Participation LepServices.serviceType
Language Instruction Education Program Type	No value reports for this field in the SPED Extract.	N/A
ESOL/Bilingual Program Ending Date	No value reports for this field in the SPED Extract.	N/A
ESOL/Bilingual Student Contact Minutes	No value reports for this field in the SPED Extract.	N/A
Career Tech Ed Contact Minutes	No value reports for this field in the SPED Extract.	N/A
Title 1 Participation	No value reports for this field in the SPED Extract.	N/A
Miles Transported	No value reports for this field in the SPED Extract.	N/A
Transportation FTE	No value reports for this field in the SPED Extract.	N/A
Student's Street Address	No value reports for this field in the SPED Extract.	N/A
Student's City	No value reports for this field in the SPED Extract.	N/A
Student's Zip	No value reports for this field in the SPED Extract.	N/A
Non-Resident Transportation 10 Mile Law	No value reports for this field in the SPED Extract.	N/A
Military Connected Student	No value reports for this field in the SPED Extract.	N/A
Immigrant Student	No value reports for this field in the SPED Extract.	N/A
Country of Birth	No value reports for this field in the SPED Extract.	N/A
Neglected Student	No value reports for this field in the SPED Extract.	N/A
Kansas Preschool Program (KPP)	No value reports for this field in the SPED Extract.	N/A
Kansas Parents as Teachers (KPAT)	No value reports for this field in the SPED Extract.	N/A
Dyslexia Screener	No value reports for this field in the SPED Extract.	N/A
Dyslexia Subtest	No value reports for this field in the SPED Extract.	N/A
Dyslexia Spring Benchmark Performance Level	No value reports for this field in the SPED Extract.	N/A
Math Grouping Indicator 1	No value reports for this field in the SPED Extract.	N/A
Math Grouping Indicator 2	No value reports for this field in the SPED Extract.	N/A
English Language Arts - ELA Grouping Indicator 1	No value reports for this field in the SPED Extract.	N/A
English Language Arts - ELA Reading Grouping Indicator 2	No value reports for this field in the SPED Extract.	N/A
Science Grouping Indicator 1	No value reports for this field in the SPED Extract.	N/A
Science Grouping Indicator 2	No value reports for this field in the SPED Extract.	N/A
Comprehensive Agriculture Grouping Indicator	No value reports for this field in the SPED Extract.	N/A
Animal Systems Grouping Indicator	No value reports for this field in the SPED Extract.	N/A
Plant Systems Grouping Indicator	No value reports for this field in the SPED Extract.	N/A
KELPA2 Grouping Indicator 1	No value reports for this field in the SPED Extract.	N/A
KELPA2 Grouping Indicator 2	No value reports for this field in the SPED Extract.	N/A
State Mathematics Assessment Type	No value reports for this field in the SPED Extract.	N/A
State English Language Arts - ELA Assessment Type	No value reports for this field in the SPED Extract.	N/A
State Science Assessment Type	No value reports for this field in the SPED Extract.	N/A
State History/Government Assessment Type	No value reports for this field in the SPED Extract.	N/A
History/Gov Claim/These Score	No value reports for this field in the SPED Extract.	N/A
History/Gov Analyze Evidence Score	No value reports for this field in the SPED Extract.	N/A
History/Gov Reasoning Score	No value reports for this field in the SPED Extract.	N/A
Comprehensive Agriculture Assessment	No value reports for this field in the SPED Extract.	N/A
Animal Systems Assessment	No value reports for this field in the SPED Extract.	N/A
Plant System Assessment	No value reports for this field in the SPED Extract.	N/A
Kansas English Language Proficiency Assessment (KELPA)	No value reports for this field in the SPED Extract.	N/A
KELPA Proctor ID	No value reports for this field in the SPED Extract.	N/A
KELPA Proctor Name	No value reports for this field in the SPED Extract.	N/A
KELPA Proctor Last Name	No value reports for this field in the SPED Extract.	N/A
Individual Plan of Study	No value reports for this field in the SPED Extract.	N/A
User Field 1	N/A	N/A
User Field 2	N/A	N/A
User Field 3	N/A	N/A

KIDS SPED Extract (Kansas) [.2335 and previous]

Generate the Report

Report Layout

Related Articles