Classic View: KS State Reporting > Collection Extract > TEST: Assessment Information Type
Search Terms: Collection Extract
The KIDS Collection TEST Extract report gathers student data for distributing paper-based state assessments and generating testing rosters for state assessments. The submission window is between the first day of school for the current school in August and the last day of school for the current school year in June.
See the KIDS Collection Extracts (Kansas) article for additional information on Reporting Logic and Report Editor elements.
Report Logic
TEST records are submitted for all students in grade levels mapped to state grade levels of 05-17 (grades KN-12) who are eligible to take state assessments. Students entering a school after February 8 do not have to be tested. One record reports per enrolled student for each selected calendar in the reporting range.
This extract only reports enrollment records that are active within the Reporting Range entered on the Extract Editor (Data Filter From Date, Data Filter To Date). If th Enrollment Start Date or Enrollment End Date fall on the day of the reporting range (Data Filter From Date and Data Filter To Date is the same), the enrollment is included.
Students report regardless of whether they are actively scheduled into course sections.
Students report regardless of whether or not they have any TEST data to report.
One record per enrolled student reports from the selected calendar for the entered Reporting Range.
Students do not report when:
- The Enrollment record is marked as State Exclude or No Show.
- The Calendar of Enrollment is marked as State Exclude.
- The Grade Level of Enrollment is marked as State Exclude.
Test Type Selection
For the TEST extract, select a specific test type or select the option for All Assessment Types to be included. Multiple assessment types can be selected by using the CTRL and SHIFT keys. Assessment Types are assigned on the student's Enrollment record.
When reporting the assessment indicators and assessment, The KIDS Subject reports the disaggregation method based on the reporting end date selected on the Extract Editor or on the Course Schedule Placement end date, whichever comes first. Note the following examples.
- If a student drops section 1, and restarts in section 2 during the reporting range or before course schedule end, disaggregation method reports from section 2.
- If a student remains in the same section, however the reportable teacher changes prior to reporting range or course schedule end, the new teacher reports.
- If a student was not enrolled and/or not scheduled into a course section during the reporting range, a null value reports.
Generate the Report
See the KIDS Collection Extracts editor for description of the Report Editor fields and Sample Report Formats.
- Select the TEST: Assessment Information Type 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 Grades by State Code option if generating the TEST Extract.
- 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.
- Select the Test Types to include in the extract.
- Click the Generate Report button. The report displays in the selected format.
Report Layout
The KIDS TEST Collection Extract also includes a Report Header and a Report Footer. See the KIDS Collection Extracts (Kansas) article for descriptions of that area of the print details.
Data Element | Description | Location |
---|---|---|
Record Type | Type of extract being generated, chosen on the Report Editor. Alphanumeric, 4 characters | Data not stored |
Accountability School Identifier | Indicates the school number of the student's enrollment. Alphanumeric, 4 characters | Student Information > General > Enrollments > State Reporting Fields > AYP Override 1 Enrollment.school AYP1 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, that initial reports. 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 > Demographics > Person Information > Gender Identity.gender Census > People > Identities > Identity Information > Protected Identity Information > Legal Gender Identity.legalGender |
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 Y; if No, reports 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 2019-20 school year, this reports as 2020. 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 TEST Extract. | N/A |
School Entry Date | Reports the student's start date of enrollment at the school. If this Entry into School field is blank on the enrollment record, 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 School EnrollmentKS.schoolDate |
District Entry Date | Reports the student's first date of entry at the district. If the Entry into District field is blank on the enrollment record, 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 District EnrollmentKS.districtDate |
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 | Reports the first day the student receives instructional services during the school year. A value reports when the student meets the following criteria (at least one of these is true):
This reports the first day marked for instruction and attendance from the Calendar in which the student is enrolled.
If the school is marked as School Wide in the Title 1 field on the School Editor, all students within the school report their First Instruction Date. Otherwise, a blank value reports. Date field, 10 characters (MM/DD/YYYY) | Student Information > General > Enrollment > General Enrollment Information > Start Date Enrollment.startDate Student Information > Program Participation > Gifted > Start Date Gifted.startDate Student Information > Special Education > General > State Reporting > Start Date SpecialEDState.startDate System Administration > Calendar > Calendar > Calendar > Days > Instruction, Attendance |
Membership Days | No value reports for this field in the TEST Extract. | N/A |
Attended Days | No value reports for this field in the TEST Extract. | N/A |
Truant Student | No value reports for this field in the TEST Extract. | N/A |
Minutes Enrolled | No value reports for this field in the TEST Extract. | N/A |
Concurrent HS Enrollment | No value reports for this field in the TEST Extract. | N/A |
Exit Withdrawal Date | No value reports for this field in the TEST Extract. | N/A |
Exit Withdrawal Type | No value reports for this field in the TEST Extract. | N/A |
Unweighted Grade Point Average | No value reports for this field in the TEST Extract. | N/A |
Special Circumstance Transfer Choice | No value reports for this field in the TEST Extract. | N/A |
Post Graduation Plans | No value reports for this field in the TEST Extract. | N/A |
Comprehensive Race | Indicates the student's race/ethnicity. All five positions must be filled with either a 0 or a 1. A student designated as White, this field reports as 00001. A student designated as American Indian reports as 10000.
Numeric, 6 digits | Census > People > Demographics > Person Information > Federal Race Identity.raceEthnicity |
Lunch Program | Indicates student meets requirements for free and reduced meals. A numeric value of 1-4 reports, based on the student's FRAM record dates being within the reporting period and the State Eligibility Code selection.
If no value is selected or there is no FRAM record, a value of zero (0: Not Eligible) reports. Numeric, 1 digit | FRAM > Eligibility Fram.eligibility |
Primary Disability Indicator | Indicates student's primary disability. When a student has an active Special Education State Reporting record OR an active IEP, a value of WD reports. Otherwise, a value of ND reports. An active Special Education State Reporting record is calculated as follows:
SPED State Reporting records that were ended prior to the selected calendar year do not report when the Date From field on the extract editor is not populated. An active IEP record is calculated as follows:
Alphanumeric, 2 characters | Student Information > Special Education > General > State Reporting > Disability SpecialEDState.primaryDisability Student Information > Special Education > General > State Reporting > Start Date, End Date SpecialEDState.startDate SpecialEDState.endDate Student Information > Special Education > Documents > IEP > Start Date, End Date Plan.startDate Plan.endDate |
Gifted Student Indicator | Indicates whether student is considered gifted/talented. When the student has an active Gifted record, a value of GI reports. Otherwise, a blank value reports. Gifted records that were ended prior to the selected calendar year do not report when the Date From field on the extract editor is not populated. An active Gifted record is calculated as follows:
Alphanumeric, 2 characters | Student Information > Program Participation > Gifted > Start Date, End Date Gifted.startDate Gifted.endDate |
Section 504 | No value reports for this field in the TEST Extract. | N/A |
Residence of Homeless | Indicates the student meets the federal guidelines of being homeless. See the Kansas Enrollment Editor page for more information. Alphanumeric, 1 character | Student Information > General > Enrollment > State Reporting Fields > Homeless EnrollmentKS.homeless |
ESOL/Bilingual Program Entry Date | Start date of student's participation in ESOL programming. When the ESOL Participation field reports a value of 0, this field does not report. Date field, 10 characters (MM/DD/YYYY) | Student Information > Program Participation > English Learners (EL) > Identified Date lep.IdentifiedDate |
First Entry Date into a school in the US | Date of first enrollment into a school in the United States. This date ONLY reports when the ESOL Participation value for the student is 1-8 (not 0 or blank). If a Participation code is selected and no date is in the Date Entered US School field, the report auto-generates a date of 01/01/1900 to make it easier to find these students. Date field, 10 characters (MM/DD/YYYY) | Census > People > Demographics > Person Information > Date Entered US Identity.DateEnteredUSSchool |
First Language | Notes the first language the student speaks (primary language).
If no values are selected, a value of ENG reports. Alphanumeric, 3 characters | Census > People > Demographics > Person Information > Home Primary Language Identity.HomePrimaryLanguage |
ESOL/Bilingual Participation Code | Indicates the status of the student's ESOL Participation. See the ESOL Participation section for reporting logic. If no values are selected, the default value of zero (0) reports. Alphanumeric, 1 character | Student Information > Program Participation > English Learners (EL) > EL Services > Service Types LepService.Type |
Language Instruction Education Program Type | No value reports for this field in the TEST Extract. | N/A |
ESOL/Bilingual Program Ending Date | No value reports for this field in the TEST Extract. | N/A |
ESOL/Bilingual Student Contact Minutes | No value reports for this field in the TEST Extract. | N/A |
Career and Technical Education Contact Minutes | No value reports for this field in the TEST Extract. | N/A |
Title 1 Participation | No value reports for this field in the TEST Extract. | N/A |
Miles Transported | No value reports for this field in the TEST Extract. | N/A |
Transportation FTE | No value reports for this field in the TEST Extract. | N/A |
Student's Street Address | No value reports for this field in the TEST Extract. | N/A |
Student's City | No value reports for this field in the TEST Extract. | N/A |
Student's Zip Code | No value reports for this field in the TEST Extract. | N/A |
Non-Resident Transportation 10 Mile Law | No value reports for this field in the TEST Extract. | N/A |
Military Connected Student Indicator | Indicates whether the student is the son or daughter of a parent who is in the military. If no value is selected, a default value zero (0) reports. Alphanumeric, 1 character | Student Information > General > Enrollments > State Reporting Fields > Child of Military Family EnrollmentKS.militaryFamily |
Immigrant Student | No value reports for this field in the TEST Extract. | N/A |
Country of Birth | No value reports for this field in the TEST Extract. | N/A |
Neglected Student | No value reports for this field in the TEST Extract. | N/A |
Kansas Preschool Program | No value reports for this field in the TEST Extract. | N/A |
Kansas Parents as Teachers Participant | No value reports for this field in the TEST Extract. | N/A |
Dyslexia Screener | No value reports for this field in the TEST Extract. | N/A |
Dyslexia Subtest | No value reports for this field in the TEST Extract. | N/A |
Dyslexia Spring Benchmark Performance Level | No value reports for this field in the TEST Extract. | N/A |
Math Grouping Indicator 1 | This option is chosen on the Collection Extract editor. See the Report Editor section for more information. Reports one of the following based on the selection made in the Report Editor:
When the Legal Name and Gender fields are populated for the Homeroom teacher or the Subject Teacher, those values report. These values are based on the student's course enrollment, and reports when any of these courses have the KIDS Subject dropdown list populated for Math. Alphanumeric, 50 characters | Scheduling > Courses > Course > KIDS Subject > Math Course.kidsSubject |
Math Grouping Indicator 2 | This option is chosen on the Collection Extract editor. See the Report Editor section for more information. Reports one of the following based on the selection made in the Report Editor. :
When the Legal Name and Gender fields are populated for the Homeroom teacher or the Subject Teacher, those values report. These values are based on the student's course enrollment, and reports when any of these courses have the KIDS Subject dropdown list populated for Math. Alphanumeric, 50 characters | Scheduling > Courses > Course > KIDS Subject > Math Course.kidsSubject |
English Language Arts - ELA Grouping Indicator 1 | This option is chosen on the Collection Extract editor. See the Report Editor section for more information. Reports one of the following based on the selection made in the Report Editor.
When the Legal Name and Gender fields are populated for the Homeroom teacher or the Subject Teacher, those values report. These values are based on the student's course enrollment, and reports when any of these courses have the KIDS Subject dropdown list populated for ELA. Alphanumeric, 50 characters | Scheduling > Courses > Course > KIDS Subject > ELA Course.kidsSubject |
English Language Arts - ELA Grouping Indicator 2 | This option is chosen on the Collection Extract editor. See the Report Editor section for more information. Reports one of the following based on the selection made in the Report Editor.
When the Legal Name and Gender fields are populated for the Homeroom teacher or the Subject Teacher, those values report. These values are based on the student's course enrollment, and reports when any of these courses have the KIDS Subject dropdown list populated for ELA. Alphanumeric, 50 characters | Scheduling > Courses > Course > KIDS Subject > ELA Course.kidsSubject |
Science Grouping Indicator 1 | This option is chosen on the Collection Extract editor. See the Report Editor section for more information. Reports one of the following based on the selection made in the Report Editor. :
When the Legal Name and Gender fields are populated for the Homeroom teacher or the Subject Teacher, those values report. These values are based on the student's course enrollment, and reports when any of these courses have the KIDS Subject dropdown list populated for Science. Alphanumeric, 50 characters | Scheduling > Courses > Course > KIDS Subject > Science Course.kidsSubject |
Science Grouping Indicator 2 | This option is chosen on the Collection Extract editor. See the Report Editor section for more information. Reports one of the following based on the selection made in the Report Editor. :
When the Legal Name and Gender fields are populated for the Homeroom teacher or the Subject Teacher, those values report. These values are based on the student's course enrollment, and reports when any of these courses have the KIDS Subject dropdown list populated for Science. Alphanumeric, 50 characters | Scheduling > Courses > Course > KIDS Subject > Science Course.kidsSubject |
Comprehensive Agriculture Grouping Indicator | This option is chosen on the Collection Extract editor. See the Report Editor section for more information. Reports one of the following based on the selection made in the Report Editor:
When the Legal Name and Gender fields are populated for the Homeroom teacher or the Subject Teacher, those values report. These values are based on the student's course enrollment, and reports when any of these courses have the KIDS Subject dropdown list populated for Agriculture. Alphanumeric, 50 characters | Scheduling > Courses > Course > KIDS Subject > General > Agriculture Course.kidsSubject |
Animal Systems Grouping Indicator | This option is chosen on the Collection Extract editor. See the Report Editor section for more information. Reports one of the following based on the selection made in the Report Editor:
When the Legal Name and Gender fields are populated for the Homeroom teacher or the Subject Teacher, those values report. These values are based on the student's course enrollment, and reports when any of these courses have the KIDS Subject dropdown list populated for Animal Systems. Alphanumeric, 50 characters | Scheduling > Courses > Course > KIDS Subject > General > Animal Systems Course.kidsSubject |
Plant Systems Grouping Indicator | This option is chosen on the Collection Extract editor. See the Report Editor section for more information. Reports one of the following based on the selection made in the Report Editor:
When the Legal Name and Gender fields are populated for the Homeroom teacher or the Subject Teacher, those values report. These values are based on the student's course enrollment, and reports when any of these courses have the KIDS Subject dropdown list populated for Plant Systems. Alphanumeric, 50 characters | Scheduling > Courses > Course > KIDS Subject > General > Plant Systems Course.kidsSubject |
KELPA2 Grouping Indicator 1 | This option is chosen on the Collection Extract editor. See the Report Editor section for more information. Reports one of the following based on the selection made in the Report Editor. :
When the Legal Name and Gender fields are populated for the Homeroom teacher or the Subject Teacher, those values report. These values are based on the student's course enrollment, and reports when any of these courses have the KIDS Subject dropdown list populated for Pathways. Alphanumeric, 50 characters | Scheduling > Courses > Course > KIDS Subject > Pathways Course.kidsSubject |
KELPA2 Grouping Indicator 2 | This option is chosen on the Collection Extract editor. See the Report Editor section for more information. Reports one of the following based on the selection made in the Report Editor:
When the Legal Name and Gender fields are populated for the Homeroom teacher or the Subject Teacher, those values report. These values are based on the student's course enrollment, and reports when any of these courses have the KIDS Subject dropdown list populated for Pathways. Alphanumeric, 50 characters | Scheduling > Courses > Course > KIDS Subject > Pathways Course.kidsSubject |
State Mathematics Assessment Type | Reports the assigned Math Assessment Type value from the student's enrollment record. Values reports for students in grades 08-12, 13 and 15 only. If no values are selected, the default value of zero (0) reports. Alphanumeric, 50 characters | Student Information > General > Enrollments > State Reporting Fields > Math Assessment Type EnrollmentKS.mathAssessmentType |
State English Language Arts - ELA Assessment | Reports the assigned ELA Assessment Type value from the student's enrollment record. Values reports for students in grades 08-12, 13 and 15 only. If no values are selected, the default value of zero (0) reports. Alphanumeric, 50 characters | Student Information > General > Enrollments > State Reporting Fields > ELA Assessment Type EnrollmentKS.readingAssessmentType |
State Science Assessment Type | Reports the assigned Science Assessment Type value from the student's enrollment record. Values reports for students in grades 10, 13 and 16 only. Alphanumeric, 50 characters | Student Information > General > Enrollments > State Reporting Fields > Science Assessment Type EnrollmentKS.scienceAssessmentType |
State History/Gov Assessment | Reports the assigned History/Government Assessment Type value from the student's enrollment record. Values reports for students in grades 11, 13 and 16 only. Alphanumeric, 50 characters | Student Information > General > Enrollments > State Reporting Fields > History/Government Assessment Type EnrollmentKS.histgovAssessmentType |
History/Gov Claim/Thesis Score | No value reports for this field in the TEST Extract. | N/A |
History/Gov Evidence Score | No value reports for this field in the TEST Extract. | N/A |
History/Gov Reasoning Score | No value reports for this field in the TEST Extract. | N/A |
Comprehensive Agriculture Assessment | Reports the assigned Comprehensive Agriculture Assessment Type value from the student's enrollment record. Values reports for students in grades 15-17 only. Alphanumeric, 50 characters | Student Information > General > Enrollments > State Reporting Fields > General Comprehensive Agriculture Assessment EnrollmentKS.agricultureAssessmentType |
Animal Systems Assessment | Reports the assigned Animal Systems Assessment Type value from the student's enrollment record. Values reports for students in grades 15-17 only. Alphanumeric, 50 characters | Student Information > General > Enrollments > State Reporting Fields > General Animal Systems Assessment EnrollmentKS.animalSystemsAssessmentType |
Plant Systems Assessment | Reports the assigned Plant Systems Assessment Type value from the student's enrollment record. Values reports for students in grades 15-17 only. Alphanumeric, 50 characters | Student Information > General > Enrollments > State Reporting Fields > General Plant Systems Assessment EnrollmentKS. plantSystemsAssessmentType |
Kansas English Language Proficiency Assessment (KELPA) | Reports the assigned KELPA Exam value from the student's enrollment record. Values reports for students in grades 05-17 only. If no values are selected, the default value of zero (0) reports. Alphanumeric, 50 characters | Student Information > General > Enrollments > State Reporting Fields > KELPA Exam EnrollmentKS.KelpaExam |
KELPA Proctor ID | Reports the state staff ID of the staff person administering the ELPA exam. Numeric, 10 digits | Census > Demographics > Person Identifiers > State StaffID Person.stateStaffID |
KELPA Proctor First Name | Reports the first name of the staff person administering the ELPA exam. Alphanumeric, 100 characters | Census > People > Demographics > Person Information > First Name Identity.firstName Census > People > Identities > Identity Information > Protected Identity Information > Legal First Name Identity.legalFirstName |
KELPA Proctor Last Name | Reports the last name of the staff person administration the ELPA exam. Alphanumeric, 100 characters | Census > People > Demographics > Person Information > Last Name Identity.lastName Census > People > Identities > Identity Information > Protected Identity Information > Legal Last Name Identity.legalLastName |
American College Testing (ACT) Assessment | Indicates the student takes the ACT Assessment during the school year. Reports the selected value from the enrollment record. The student's grade level must be equal to state grade level 16 or 17. This is only for students who have not previously taken the ACT. Alphanumeric, 1 character | Student Information > General > Enrollments > State Reporting Fields > Assessments > ACT Assessment Enrollment.actAssessment |
ACT WorkKeys Assessment | Indicates the student takes the ACT WorkKeys Assessment during the school year. Reports the selected value from the enrollment record. The student's grade level must be equal to state grade level 16 or 17. This is only for students who have not previously taken the ACT. Alphanumeric, 1 character | Student Information > General > Enrollments > State Reporting Fields > Assessments > ACT Workdays Enrollment.actWorkdays |
User Field 1 | N/A | N/A |
User Field 2 | N/A | N/A |
User Field 3 | N/A | N/A |