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.
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.
- Select the QERY: QERY from the Extract Type dropdown list.
- Enter a Data Filter From Date, if desired.
- Enter a Data Filter To Date, if desired.
- Select the Assessment Disaggregation Method 1 option, if desired.
- Select the Assessment Disaggregation Method 2 option, if desired.
- Mark the Students without State IDs checkbox, if desired.
- Mark the Social Security Number Optional, if desired.
- Select an Ad hoc Filter, if desired.
- Select the appropriate Format for the extract.
- If generating the extract in the State Format (tab delimited), enter the Records Limit Per File number.
- Select the Calendars to include in the extract.
- 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. 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 Date | No 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 Average | No 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.
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 | 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 |
American College Testing (ACT) Assessment | No value reports for this field in the QERY Extract. | N/A |
ACT WorkKeys Assessment | No value reports for this field in the QERY Extract. | N/A |
Individual Plan of Study | No 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 |