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

Classic View: KS State Reporting > Collection Extract > QERY: QERY

Search Terms: Collection Extract

The KIDS Collection QERY Extract is used to retrieve data about a school's students. This record may be useful in retrieving demographic and program participation data about new students.

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

Report Logic

See the KIDS Collection Extracts article for general reporting logic.

QERY records must be submitted in a batch file by themselves - not included with other KIDS files.

Data returned for students is the most recent data submitted for a student. If the student was previously claimed by another school, the data returned is the most recent information from the previous school.

Generate the Report

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

  1. Select the QERY: QERY from the Extract Type dropdown list.
  2. Enter a Data Filter From Date, if desired.
  3. Enter a Data Filter To Date, if desired.
  4. Select the Assessment Disaggregation Method 1 option, if desired.
  5. Select the Assessment Disaggregation Method 2 option, if desired.
  6. Mark the Students without State IDs checkbox, if desired.
  7. Mark the Social Security Number Optional, if desired.
  8. Select an Ad hoc Filter, if desired.
  9. Select the appropriate Format for the extract.
  10. If generating the extract in the State Format (tab delimited), enter the Records Limit Per File number.
  11. Select the Calendars to include in the extract.
  12. Click the Generate Report button. The report will display in the selected format.

Report Layout

Data Element

Description

Location

Record Type

Type of extract being generated, chosen on the Report Editor.


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, this will be reported. 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

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.


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 2010-11 school year, this will report as 2011.


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

N/A

School Entry Date 

No value reports for this field in the QERY Extract.

N/A

District Entry Date 

No value reports for this field in the QERY Extract.

N/A

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 DateNo value reports for this field in the QERY Extract.N/A

Membership Days 

No value reports for this field in the QERY Extract.

N/A

Attended Days 

No value reports for this field in the QERY Extract.

N/A

Truant Student 

No value reports for this field in the QERY Extract.

N/A

Minutes Enrolled 

No value reports for this field in the QERY Extract.

N/A

Concurrent HS Enrollment 

No value reports for this field in the QERY Extract.

N/A

Exit Withdrawal Date 

No value reports for this field in the QERY Extract.

N/A

Exit Withdrawal Type 

No value reports for this field in the QERY Extract.

N/A

Unweighted Grade Point AverageNo value reports for this field in the QERY Extract.N/A

Special Circumstance Transfer Choice 

No value reports for this field in the QERY Extract.

N/A

Post Graduation Plans 

No value reports for this field in the QERY Extract.

N/A

Comprehensive Race

Indicates the student's race/ethnicity.

All five positions must be filled with a 0 or a 1. For a student designed as being White, this field will report as 00005.

  • 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 QERY Extract.

N/A

Primary Disability Indicator

No value reports for this field in the QERY Extract.

N/A

Gifted Student Indicator

No value reports for this field in the QERY Extract.

N/A

Section 504 

No value reports for this field in the QERY Extract.

N/A

Residence of Homeless 

No value reports for this field in the QERY Extract.

N/A

ESOL/Bilingual Program Entry Date 

No value reports for this field in the QERY Extract.

N/A

First Entry Date into a school in the US

No value reports for this field in the QERY Extract.

N/A

First Language 

No value reports for this field in the QERY Extract.

N/A

ESOL/Bilingual Participation Code 

No value reports for this field in the QERY Extract.

N/A

Language Instruction Education Program Type

No value reports for this field in the QERY Extract.


N/A


ESOL/Bilingual Program Ending Date

No value reports for this field in the QERY Extract.

N/A

ESOL/Bilingual Student Contact Minutes 

No value reports for this field in the QERY Extract.

N/A

Career Tech Ed Contact Minutes 

No value reports for this field in the QERY Extract.

N/A

Title 1 Participation 

No value reports for this field in the QERY Extract.

N/A

Miles Transported 

No value reports for this field in the QERY Extract.

N/A

Transportation FTE 

No value reports for this field in the QERY Extract.

N/A

Student's Street Address 

No value reports for this field in the QERY Extract.

N/A

Student's City 

No value reports for this field in the QERY Extract.

N/A

Student's Zip 

No value reports for this field in the QERY Extract.

N/A

Non-Resident Transportation 10 Mile Law 

No value reports for this field in the QERY Extract.

N/A

Military Connected Student Indicator
 

No value reports for this field in the QERY Extract.

N/A

Immigrant Student 

No value reports for this field in the QERY Extract.

N/A

Country of Birth 

No value reports for this field in the QERY Extract.

N/A

Neglected Student 

No value reports for this field in the QERY Extract.

N/A

Kansas Preschool Program (KPP)
No value reports for this field in the QERY Extract.N/A
Kansas Parents as Teachers Participant (KPAT)
No value reports for this field in the QERY Extract.N/A
Dyslexia Screener

No value reports for this field in the QERY Extract.


N/A
Dyslexia Subtest

No value reports for this field in the QERY Extract.


N/A
Dyslexia Spring Benchmark Performance

No value reports for this field in the QERY Extract.


N/A

Math Grouping Indicator 1

No value reports for this field in the QERY Extract.

N/A

Math Grouping Indicator 2

No value reports for this field in the QERY Extract.

N/A

English Language Arts - ELA Grouping Indicator 1 

No value reports for this field in the QERY Extract.

N/A

English Language Arts - ELA Grouping Indicator 2

No value reports for this field in the QERY Extract.

N/A

Science Grouping Indicator 1

No value reports for this field in the QERY Extract.

N/A

Science Grouping
Indicator 2

No value reports for this field in the QERY Extract.

N/A

Comprehensive Agriculture Grouping Indicator

No value reports for this field in the QERY Extract.

N/A

Animal Systems Grouping Indicator

No value reports for this field in the QERY Extract.

N/A

Plant Systems Grouping Indicator

No value reports for this field in the QERY Extract.

N/A

KELPA2 Grouping Indicator 1

No value reports for this field in the QERY Extract.

N/A

KELPA2 Grouping Indicator 2

No value reports for this field in the QERY Extract.

N/A

State Math Assessment Type

No value reports for this field in the QERY Extract.

N/A

State ELA Assessment Type

No value reports for this field in the QERY Extract.

N/A

State Science Assessment Type

No value reports for this field in the QERY Extract.

N/A

State History/Government Assessment Type

No value reports for this field in the QERY Extract.

N/A

History/Gov Claim/Thesis Score

No value reports for this field in the QERY Extract.

N/A

History/Gov Evidence Score

No value reports for this field in the QERY Extract.

N/A

History/Gov Reasoning Score

No value reports for this field in the QERY Extract.

N/A

Comprehensive Agriculture Assessment

No value reports for this field in the QERY Extract.

N/A

Animal Systems Assessment

No value reports for this field in the QERY Extract.

N/A

Plant Systems Assessment

No value reports for this field in the QERY Extract.

N/A

Kansas English Language Proficiency Assessment (KELPA)

No value reports for this field in the QERY Extract.

N/A

KELPA Proctor ID

No value reports for this field in the QERY Extract.

N/A

KELPA Proctor First Name

No value reports for this field in the QERY Extract.

N/A

KELPA Proctor Last Name

No value reports for this field in the QERY Extract.

N/A

Individual Plan of StudyNo value reports for this field in the QERY Extract.N/A

User Field 1

N/A

N/A

User Field 2

N/A 

N/A

User Field 3

N/A 

N/A