Skip to main content
Skip table of contents

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:

  • The selected [number] students only – Run the report for students in the current selection.

  • All students – Run the report for all students in the current school or district that meet the selection criteria.

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
Date

[S_KS_STU_X]FIRST_INSTR_DATE
[S_KS_REN_X]FIRST_INSTR_DATE

D90

Community Service
Postsecondary Asset

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.