KIDS Collection SPED
Special Education
The KIDS Collection SPED report will be used to populate specific students, who were previously submitted to the Kansas Individual Data on Students (KIDS) system, in Sped-Pro without claiming the student in KIDS. This report is only for students receiving special education services and no student data will be updated with this report.
Selection Criteria
The report selects records from the [Students] and [ReEnrollments] tables based on the following criteria:
The student must be receiving Special Education services (D35) or must be identified as a Gifted Student (D36).
The student must not be excluded from state reporting.
The student’s school entry date must occur on or before the report end date.
The student’s school exit date must occur after the report start date.
The student’s school exit date must occur after their school entry date.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Note: PowerSchool checks for [S_KS_STU_Demographic_X]Legal_First_Name, [S_KS_STU_Demographic_X]Legal_Last_Name, and [S_KS_STU_Demographic_X]Legal_Middle_Name to include in report output. If ALL three fields are blank then it checks for [STUDENTS]First_Name, [STUDENTS]Last_Name, and STUDENTS.Middle_Name to include in report output.
Field | Description |
Schools to Include | Select the school from the popup menu. This report can only be run for one school at a time. |
Students to Include | Indicate which students to include in the report by selecting one of the following options:
Note: If running the report for a single student, or group of students, select the students prior to running the report. |
Start Date | Enter a date (in mm/dd/yyyy format) for the first day of the report date range. |
End Date | Enter a date (in mm/dd/yyyy format) for the last day of the report date range. |
Include Header Row? | Select Yes or No to indicate whether to include the header row in the report output. Note: Set to No for file submissions. |
Report Output
Each field in the report output is described below. See Understanding the Report Output Table for a definition of each column in the table.
For more information on each data element, see the Report Output Detail in KIDS Collection.
Field Ref | Data Element | [Table]FieldName |
H1 - H6 | Header records | See KIDS Collection for more information. |
D1 | Record Type | "SPED" |
D2 | Accountability School Identifier | [S_KS_STU_X]Accountability_School [S_KS_REN_X]Accountability_School [Students]SchoolID |
D3 | Resident District Identifier | [Students]DistrictOfResidence [ReEnrollments]DistrictOfResidence |
D4 | Legal Last Name | [S_KS_STU_Demographic_X]Legal_Last_Name or [Students]Last_Name |
D5 | Legal First Name | [S_KS_STU_Demographic_X]Legal_First_Name or [Students]First_Name |
D6 | Legal Middle Name | [S_KS_STU_Demographic_X]Legal_MiddleName or [Students]Middle_Name |
D7 | Generation Code | [S_KS_STU_Demographic_X]Generation_Code |
D8 | Gender | [Students]Gender |
D9 | Date of Birth | [Students]DOB |
D10 | Current Grade Level | [S_KS_STU_X]Grade_Level [Students]Grade_Level |
D11 | Local Student Identifier | [Students]Student_Number |
D12 | Hispanic Ethnicity | [Students]FedEthnicity |
D13 | State Student Identifier | [Students]State_StudentNumber |
D14 | Current School Year | [Terms]LastDay |
D15 | Funding School | [S_KS_STU_X]Funding_School [S_KS_REN_X]Funding_School [Schools]School_Number [Schools]Alternate_School_Number |
D16 | Attendance School/Program Identifier | [S_KS_STU_X]Attendance_School [Schools]School_Number [Schools]Alternate_School_Number |
D17 | Virtual Education Student | Not Reported |
D18 | School Entry Date | [S_KS_STU_X]School_Entry_Date [S_KS_REN_X]School_Entry_Date |
D19 | District Entry Date | [S_KS_STU_X]District_Entry_Date [S_KS_REN_X]District_Entry_Date |
D20 | State Entry Date | [S_KS_STU_X]State_Entry_Date |
D21 | Cumulative Number of Days in Membership | Not Reported. |
D22 | Cumulative Number of Days Attended | Not Reported. |
D23 | Truant Student | Not Reported. |
Truant Student Override | Not Reported. | |
D24 | Minutes Enrolled | Not Reported |
D25 | Concurrent High School Enrollment | Not Reported |
D26 | Exit/Withdrawal Date | Not Reported |
D27 | Exit/Withdrawal Type | Not Reported |
D28 | Unweighted Grade Point Average (GPA) | Not Reported |
D29 | High School Credits Earned | Not Reported |
D30 | High School Credits Earned Required to Graduate | Not Reported |
D31 | Dropout Diploma Completion Virtual Student | Not Reported |
D32 | Special Circumstances Transfer Choice | Not Reported |
D33 | Comprehensive Race | [StudentRace]RaceCd |
D34 | Eligibility for National School Lunch Program | Not Reported |
D35 | Primary Disability Indicator | [S_KS_STU_X]Primary_Disability |
D36 | Gifted Student Indicator | [S_KS_STU_X]Gifted_Student |
D37 | Qualified for 504 | Not Reported |
D38 | Residence of Homeless Student while Homeless | Not Reported |
D39 | Kansas At Risk Program Participation | [S_KS_STU_X]K12_Program_Participation. Kansas At-Risk Program Participation field extracts for preschool students (grade level less than 0=KG) |
D40 | ESOL/Bilingual Program Entry Date | Not Reported |
D41 | First Entry Date into a School in the United States | Not Reported |
D42 | First Language | Not Reported |
D43 | ESOL/Bilingual Program Participation Code | [S_KS_STU_ELL_X]ESOL_Program_Code |
D44 | Language Instruction Education Program Type | Not Reported |
D45 | ESOL/Bilingual Student Contact Minutes | Not Reported |
D46 | Career and Technical Education Contact Minutes | Not Reported |
D47 | Title I Participation | Not Reported |
D48 | Miles Transported | Not Reported |
D49 | Transportation FTE | Not Reported |
D50 | Student’s Street Address | Not Reported |
D51 | Student’s City | Not Reported |
D52 | Student’s Zip Code | Not Reported |
D53 | Non-Resident Transportation | Not Reported |
D54 | Military Connected Student Indicator | Not Reported |
D55 | Immigrant Student | Not Reported |
D56 | Country of Birth | Not Reported |
D57 | Neglected Student | Not Reported |
D58 | Preschool Aged At Risk Program Participation | [S_KS_STU_X]PREKG_Program_Participation |
D59 | Kansas Pre-K Pilot Program (KPP) | Not Reported |
D60 | Kansas Parents as Teachers Program (KPAT) | Not Reported |
D51 | Dyslexia Screener | Not Reported |
D62 | Dyslexia Subtest | Not Reported |
D63 | Dyslexia Spring Benchmark Performance Level | Not Reported |
D64 | Math Grouping Indicator 1 | Not Reported |
D65 | Math Grouping Indicator 2 | Not Reported |
D66 | English Language Arts – ELA Grouping Indicator 1 | Not Reported |
D67 | English Language Arts – ELA Grouping Indicator 2 | Not Reported |
D68 | Science Grouping Indicator 1 | Not Reported |
D69 | Science Grouping Indicator 2 | Not Reported |
D70 | Comprehensive Agriculture Grouping Indicator | Not Reported |
D71 | Animal Systems Grouping Indicator | Not Reported |
D72 | Plant Systems Grouping Indicator | Not Reported |
D73 | KELPA Grouping Indicator 1 | Not Reported |
D74 | KELPA Grouping Indicator 2 | Not Reported |
D75 | State Mathematics Assessment | Not Reported |
D76 | State English Language Arts – ELA Assessment | Not Reported |
D77 | State Science Assessment | Not Reported |
D78 | History/Gov Claim/Thesis Score | Not Reported |
D79 | History/Gov Evidence Score | Not Reported |
D80 | History/Gov Reasoning Score | Not Reported |
D81 | Comprehensive Agriculture Assessment | Not Reported |
D82 | Animal Systems Assessment | Not Reported |
D83 | Plant Systems Assessment | Not Reported |
D84 | Kansas English Language Proficiency Assessment (KELPA) | Not Reported |
D85 | KELPA Proctor ID | Not Reported |
D86 | KELPA Proctor First Name | Not Reported |
D87 | KELPA Proctor Last Name | Not Reported |
D88 | Individual Plan of Study (IPS) | Not Reported |
D89 | First Instructional | [S_KS_STU_X]FIRST_INSTR_DATE |
D90 | Community Service | Not Reported |
D91 | Two or More High School Athletics/Activities Postsecondary Asset | Not Reported |
D92 | Junior ROTC Postsecondary Asset | Not Reported |
D93 | Open enrollment student | Not Reported |
D94 | User Field 1 | [S_KS_STU_X]UserField_1 |
D95 | User Field 2 | [S_KS_STU_X]UserField_2 |
D96 | User Field 3 | [S_KS_STU_X]UserField_3 |