Skip to main content
Skip table of contents

KIDS Collection QERY

Introduction

The KIDS Collection QERY is an optional report to query existing KIDS data.

Selection Criteria

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

Current Selection Students

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.

Note: The default value is the start date for the selected term.

End Date

Enter a date (in mm/dd/yyyy format) for the last day of the report date range.

Note: The default value is the end date for the selected term.

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

"QERY"

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

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


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

[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

[S_KS_STU_X]Minutes_Enrolled

D25

Concurrent High School Enrollment

[S_KS_STU_X]Concurrent_School

D26

Exit/Withdrawal Date

Not Reported.

D27

Exit/Withdrawal Type

Not Reported.

D28

Unweighted Grade Point Average (GPA) 

[S_KS_STU_X]Unweighted_GPA

D29

High School Credits Earned

[S_KS_STU_X]HS_Credits_Earned

D30

High School Credits Earned Required to Graduate

[S_KS_STU_X]HS_Credits_Graduate

D31

Dropout Diploma Completion Virtual Student

[S_KS_STU_X]Dropout_Diploma_Virtual

D32

Special Circumstances Transfer Choice 

[S_KS_STU_X]Special_Circumstances _Transfer_Choice 

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

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

[S_KS_STU_X]LANG_INST_EDU_PRGM_TYPE

D45

ESOL/Bilingual Student Contact Minutes

[S_KS_STU_ELL_X]ESOL_Minutes

D46

Career and Technical Education Contact Minutes

[S_KS_STU_X]Tech_Ed_Minutes

D47

Title I Participation

Not Reported

D48

Miles Transported

[S_KS_STU_X]Miles_Transported

D49

Transportation FTE

[S_KS_STU_X]Transport_FTE

D50

Student’s Street Address

[S_KS_STU_X]Transport_Address

D51

Student’s City

[S_KS_STU_X]Transport_City

D52

Student’s Zip Code

[S_KS_STU_X]Transport_Zip

D53

Non-Resident Transportation

[S_KS_STU_X]Ten_Mile_Law

D54

Military Connected Student Indicator

[S_KS_STU_Demographic_X]Military_Family

D55

Immigrant Student

[S_KS_STU_Demographic_X]Immigrant_Status

D56

Country of Birth

[S_KS_STU_Demographic_X]Country_Of_Birth

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)

[S_KS_STU_X]EL_Participant

D60

Kansas Parents as Teachers Program (KPAT) 

[S_KS_STU_X]PAT_Participant

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.