Skip to main content
Skip table of contents

KIDS Collection TEST

Assessment Information

You can use the KIDS Collection TEST report to submit data elements, based on the TEST collection cycle, to the Kansas Individual Data on Students (KIDS) system. The TEST Collection focuses on gathering data for State assessments.

Selection Criteria

Exclude students from this report by setting the student's Exclude From State Reporting flag located on the State/Province - KS screen.

Required Data Setup

Review the Kansas State Reporting Guide and confirm that all required student and school information has been entered.

Assessment Results

  1. Student assessment information is derived from the test results on the KIDS Collection page.

  2. Only active students within the school year selected will be returned.

Student Selection

The report selects records from the [Students] and [ReEnrollments] tables based on the following criteria:

  • The student must not be excluded from state reporting.

  • The student’s school entry date must be on or before the report end date.

  • The student’s school exit date must be after the report start date.

  • The student’s school exit date must be after their school entry date.

  • The student must be active within the reported school year.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field

Description

Schools to Include

Choose one of the following from the pop-up menu:

  • District office mode – Ability to select Multiple Schools.

  • Current School Only – Includes all student records associated with the current school that meet the selection criteria.
    To change the current school, click School and choose the appropriate school from the list.

Students to Include

Indicate which students to include in the report by selecting one of the following options:

  • The selected [number] students only –. Include all students in the current selection

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

    Remember to select the students prior to running the report.


Include Header Row

Choose Yes or No to indicate whether to include the header row in the report output.

Set to No for file submissions.


Back to Top

Report Output

The following table describes each field in the report output. 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.

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 Ref

Data Element

[Table]FieldName

H1 - H6

Header records

See KIDS Collection for more information.

D1

Record Type

"TEST"

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

(Optional)

[S_KS_STU_Demographic_X]Legal_MiddleName

or

[Students]Middle_Name

D7

Generation Code

(Optional)

[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

Grade Level field is updated to extract KG if the grade level is 0.


Grade Level Override

The KG grade option has been added to the “Grade Level Override” field. Now districts will be able to report pre-K/pre-schooler(less than 0 or greater than 12) students as Kindergarten (KG).

[S_KS_STU_X]Grade_Level

[Students]Grade_Level

Grade Level field is updated to extract KG if the grade level is 0.

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

[S_KS_STU_X]Virtual_Education

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

[S_KS_STU_X]National_School_Lunch

[S_KS_REN_X]National_School_Lunch

[Students]LunchStatus

[ReEnrollments]LunchStatus

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 

[S_KS_STU_Demographic_X]Homeless_Residence

D39

Kansas At Risk Program Participation

[S_KS_STU_X]K12_Program_Participation

At-Risk Program Participation field extracts for grade levels greater than or equal to 0.

Kansas At-Risk Program Participation field extracts for preschool students (grade level less than 0=KG)

D40

ESOL/Bilingual Program Entry Date 

[S_KS_STU_ELL_X] ESOL_Entry_Date 

D41

First Entry Date into a School in the United States 

[S_KS_STU_X] School_Entry Date or [S_KS_STU_X] USA_Entry_Date 

D42

First Language

[S_KS_STU_ELL_X]First_Language

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

[S_KS_STU_Demographic_X]Military_Family

D55

Immigrant Student

Not Reported.

D56

Country of Birth

Not Reported.

D57

Neglected/Delinquent
Student

Note:

If the D57 field is blank then 0 will extracted in the TEST and EOYA report.

Valid values:

  • Blank – None

  • 0 = Not a Neglected/Delinquent Student

  • 5 – Neglected student served under Title 1 Part A any time during
    this school year.

  • 6 – Delinquent student served under Title 1 Part D any time
    during this school year.

[S_KS_STU_X]Neglected_Student

D58

Preschool Aged At Risk Program Participation

[S_KS_STU_X]PREKG_Program_Participation

Preschool-Aged At-Risk Program Participation field extracts for grade levels less than 0.

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

(Optional)

[S_KS_STU_X] Math_Grp_Ind1

D65

Math Grouping Indicator 2

(Optional)

[S_KS_STU_X] Math_Grp_Ind2

D66

English Language Arts – ELA Grouping Indicator 1

(Optional)

[S_KS_STU_X] ELA_Ind1

D67

English Language Arts – ELA Grouping Indicator 2

(Optional)

[S_KS_STU_X] ELA_Ind2

D68

Science Grouping Indicator 1

(Optional)

[S_KS_STU_X] Sci_Grp_Ind1

D69

Science Grouping Indicator 2

(Optional)

[S_KS_STU_X] Sci_Grp_Ind2

D70

Comprehensive Agriculture Grouping Indicator

(Optional)

[S_KS_STU_X] Comp_AG_Grp_Ind

D71

Animal Systems Grouping Indicator

(Optional)

[S_KS_STU_X] Animal_Sys_Grp_Ind

D72

Plant Systems Grouping Indicator

(Optional)

[S_KS_STU_X] Plant_Sys_Grp_Ind

D73

KELPA Grouping Indicator 1

(Optional)

[S_KS_STU_X] ELPA_Grp_Ind1

D74

KELPA Grouping Indicator 2

(Optional)

[S_KS_STU_X] ELPA_Grp_Ind2

D75

State Mathematics Assessment

[S_KS_STU_X] State_Math_Assess

D76

State English Language Arts – ELA Assessment

[S_KS_STU_X] ELA_Assess

D77

State Science Assessment

[S_KS_STU_X] Science_Assess

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

[S_KS_STU_X] Comp_Ag_Assess

D82

Animal Systems Assessment

[S_KS_STU_X] Animal_Sys_Assess

D83

Plant Systems Assessment

[S_KS_STU_X] Plant_Sys_Assess

D84

Kansas English Language Proficiency Assessment (KELPA)

[S_KS_STU_X] State_ELPA_Assess

D85

KELPA Proctor ID

[S_KS_STU_X] State_ELPA_ProctorID

D86

KELPA Proctor First Name

[S_KS_STU_X] State_ELPA_FirstName

D87

KELPA Proctor Last Name

[S_KS_STU_X] State_ELPA_Last_Name

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.

Contact Support Close