Classic View: KS State Reporting > Collection Extract > EOYA: End of Year Accountability
Search Terms: Collection Extract
The KIDS Collection EOYA Extract reports student attendance, membership, truancy and program participation data for all students who were in membership at the AYP school at any point during the school year.
Report Logic
All students, both active and inactive (including those who exited before the end of the school year) from all grade levels including preschool and non-graded students, are included if the school of enrollment was considered the AYP/QPA school at any point during the school year for the student.
If there is more than one enrollment record within the reporting range for a student, only one record reports.
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.
See the KIDS Collection Extracts article for additional information on Reporting Logic and Report Editor elements.
Truant Student Calculation
Truancy is based on the number of unexcused absences a student has accrued during the school year. An unexcused absence day is a part of the Truant calculation if one of the following is true:
- 100% of an instructional day is marked as absent - unexcused
- The number of minutes marked as absent/unexcused is above the Whole Day Absence (minutes) threshold in the Calendar > Calendar > Calendar > Whole Day Absence (minutes)
- The number of minutes marked as absent/unexcused is above the Whole Day Absence (minutes) threshold in the Calendar > Calendar > Grade Levels > Whole Day Absence (minutes)
If multiple calendars are selected on the extract editor, Campus searches for the student in those calendars for multiple enrollment records while maintaining the State Exclude logic that may be in place. If the student is enrolled in multiple calendars, Campus looks for the different calendar enrollments tied to a unique or identical AYP number.
- If there is more that one identical AYP number, those enrollments are merged into a single row. Campus combines the data from the following fields for each enrollment record:
- Membership Days - a count of the total number of unique days between all applicable calendars in which at least one class period is scheduled.
- Attended Days - a count of all uniquely enrolled minutes in a given day where the enrollment service type is Primary. If there is no primary enrollment or there are multiple primary enrollments, the enrollment record with the most recent start date is used.
- Truant Student - When calculating truant absences, the total number of attended minutes is derived by summing the total unique enrolled minutes in a given day, looking at all enrollments tied to calendars with the same AYP number.
- For all reported columns, the enrollment with the service type of Primary is used. If there is no primary enrollment or multiple primary enrollments, the enrollment with the most recent start date is used.
- If the AYP numbers are all unique, each enrollment is reported as a unique row in the event that multiple calendars are selected in the editor.
Generate the Report
See the KIDS Collection Extracts editor for description of the Report Editor fields and Sample Report Formats.
- Select the EOYA: End of Year Accountability from the Extract Type dropdown list.
- Enter a Data Filter From Date, if desired.
- Enter a Data Filter To Date, if desired.
- Enter an Attendance 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 | Data not 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 will report 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. | Census > People > Demographics > Person Identifiers > Student Number |
Hispanic Ethnicity | Indication of student being of Hispanic/Latino ethnicity. If yes, will report as Y; if No, will report as N. Alphanumeric, 20 characters | 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 | Indication of student taking classes virtually. Options are:
If no value is selected, a blank value reports. Numeric, 1 character | Student Information > General > Enrollments > State Reporting Fields > Virtual Education Student EnrollmentKS.virtualeducation |
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/D/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 (month, day and year) 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 | Calculated field. See the Report Logic section for details on the attendance calculations. Reports the number of days the student has been enrolled (days present plus days absent) in this school when school was in session during the current school year. Dates are calculated for ALL enrollments in the selected calendar. For kindergarten students, partial day attendance is based on the half day attendance period that constitutes an entire attendance day. If the student's most recent enrollment has an End Status of 18, a value of 0 reports. COVID-19 Reporting: When the Attendance Filter To Date is populated on the Extract Editor, student membership days are calculated up to and including the entered date. Numeric, 5 digits (XXX.X) | Data not stored |
Attended Days | Calculated field. See the Report Logic section for details on the attendance calculations. The number of days the student has been present in this school when school was in session during the current school year. Dates are calculated for ALL enrollments in the selected calendar. For kindergarten students, partial day attendance is based on the half day attendance period that constitutes an entire attendance day. Part-time students are marked as a full day of attendance if they were present for all of their scheduled time of education. If the student's most recent enrollment has an End Status of 18, a value of 0 reports. COVID-19 Reporting: When the Attendance Filter To Date is populated on the Extract Editor, student attended days are calculated up to and including the entered date. Numeric, 5 digits (XXX.X) | Data not stored |
Truant Student | This field reports as Yes or No, indicating whether a student has met the state definition of truant at any point during the year. See the Truant Student Calculation section for additional information. If no value is selected, a default value of zero (0) reports. COVID-19 Reporting: When the Attendance Filter To Date is populated on the Extract Editor, truant days are calculated up to and including the entered date. Alphanumeric, 1 character | Data not stored |
Minutes Enrolled | No value reports for this field in the EOYA Extract. | N/A |
Concurrent HS Enrollment | No value reports for this field in the EOYA Extract. | N/A |
Exit Withdrawal Date | No value reports for this field in the EOYA Extract. | N/A |
Exit Withdrawal Type | No value reports for this field in the EOYA Extract. | N/A |
Unweighted Grade Point Average | No value reports for this field in the EOYA Extract. | N/A |
Special Circumstance Transfer Choice | This field indicates the circumstances of the student's transfer out of the district. See the Kansas Enrollment Editor page for a list of options. If no value is selected, a default value of zero (0) reports. Alphanumeric, 1 character | Student Information > General > Enrollment > State Reporting Fields > Special Transfer EnrollmentKS.endType |
Post Graduation Plans | No value reports for this field in the EOYA 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 | 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. 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. Otherwise, a blank value reports. 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 | Indicates whether student is qualified for Section 504 services. Logic reports in the following order:
When a student's status changed between the last day of school and June 30, schools can choose to report the student's status as of June 30. Alphanumeric, 1 character | Student Information > Special Education > General > State Reporting > Disability SpecialEDState.primaryDisability Student Information > General > Enrollments > State Reporting Fields > Section 504 Enrollment.section504 |
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 EnrollmentKS.ESOLentryDate 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 | This is required for all students. If no value is selected, a value of ENG reports. Alphanumeric, 3 characters | Census > People > Demographics > Person Information > Home Primary Language Identity.HomePrimaryLanguage |
ESOL/Bilingual Program Participation Code | Indicates the status of the student's ESOL Participation. See the ESOL Participation section for reporting logic. If no value is selected, a 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 EOYA Extract. | N/A |
ESOL/Bilingual Program Ending Date | Reports the student's EL Program Exit Date when the ESOL/Bilingual Program Participation Code field reports a value of 7 or 8. This date should be AFTER the date reported for ESOL/Bilingual Program Entry Date. Date field, 10 characters (MM/DD/YYYY) | Student Information > Program Participation > English Learners (EL) > EL Program Exit Date LEP.exitDate |
ESOL/Bilingual Student Contact Minutes | No value reports for this field in the EOYA Extract. | N/A |
Career and Technical Contact Minutes | No value reports for this field in the EOYA Extract. | N/A |
Title 1 Participation | Indicates the student's Title 1 Participation Status. Options are:
If no value is selected, a default value of zero (0) reports. Alphanumeric, 1 character | Student Information > General > Enrollments > State Reporting Fields > Title 1 Enrollment.title1 |
Miles Transported | No value reports for this field in the EOYA Extract. | N/A |
Transportation FTE | No value reports for this field in the EOYA Extract. | N/A |
Student's Street Address | No value reports for this field in the EOYA Extract. | N/A |
Student's City | No value reports for this field in the EOYA Extract. | N/A |
Student's Zip | No value reports for this field in the EOYA Extract. | N/A |
Non-Resident Transportation 10 Mile Law | No value reports for this field in the EOYA Extract. | N/A |
Military Connect Student Indicator | Reports the value selected in the Military Connected Student Indicator field on the Enrollment editor.
Numeric, 1 digit | Student Information > General > Enrollments > State Reporting Fields > Military Connected Student Indicator EnrollmentKS.militaryFamily |
Immigrant Student | Indicates whether or not a student is an immigrant student and if they are receiving Title III services. Options are:
If a value is selected for the Immigrant Student field on the Enrollment record, that value reports. If there is a not a value selected for Immigrant Student, the Birth Country field is used:
If no value is selected, a default value zero (0) reports. Alphanumeric, 1 character | Student Information > General > Enrollments > State Reporting Fields > Immigrant Student EnrollmentKS.immigrant |
Country of Birth | Country in which student was born. Alphanumeric, 30 characters | Census > People > Demographics > Person Information > Birth Country Identity.birthCountry |
Neglected Student | A flag that identifies a neglected student who was served under Title I Part A funds at some time during the year. Students who were not served with these funds should have a blank in this field. If no value is selected, a default value of zero (0) reports. Alphanumeric, 1 character | Student Information > General > Enrollments > State Reporting Fields > Neglected Student EnrollmentKS.neglectedDelinquent |
Kansas Preschool Program (KPP) | Reports whether the student enrolled in grades 01, 02, 33 and 04 was an Early Learning Participant. When an Early Learning record exists that was active at any time with the student's enrollment from the selected calendar AND the Early Learning Participant (KS PreK Pilot Program) checkbox was marked, a value of 1 reports. If there is no Early Learning record or the Early Learning Participant (KS PreK Pilot Program) is not marked, a value of 0 reports. Otherwise, this field reports blank. An Early Learning record is considered active when the start date is before the student's enrollment end date and the end date is either blank or after the student's enrollment start date. If the student's enrollment end date is blank, the selected calendar's end date is used. Numeric, 1 digit | Student Information > Program Participation > Early Learning > KS PreK Pilot Program EarlyLearning.EarlyLearningParticipant |
Kansas Parents as Teachers Participant (KPAT) | Reports whether the student enrolled in grades 00, 01, 02, 33 and 04 was a Parents as Teachers Participant. When an Early Learning record exists that was active at any time with the student's enrollment from the selected calendar AND the Parents as Teachers checkbox was marked, a value of 1 reports. If there is no Early Learning record or the Parents as Teachers checkbox is not marked, a value of 0 reports. Otherwise, this field reports blank. An Early Learning record is considered active when the start date is before the student's enrollment end date and the end date is either blank or after the student's enrollment start date. If the student's enrollment end date is blank, the selected calendar's end date is used. Numeric, 1 digit | Student Information > Program Participation > Early Learning > Parents as Teachers EarlyLearning.ParentsAsTeachers |
Dyslexia Screener | For students in grades 05, 06 and 07, the assigned value where the start and end date of the Dyslexia Program fall within the start and end date entered on the extract editor reports. If there is no selected value or a Dyslexia record does not exist, a value of 00 reports. Otherwise, a blank value reports. A Dyslexia record that ended prior to the selected calendar year does not report when the Date From field is not populated on the extract editor. Alphanumeric, 2 characters | Student Information > Program Participation > State Programs > Dyslexia > Dyslexia Screener Dyslexia.screening |
Dyslexia Subtest | For students in grades 05, 06 and 07, the assigned value where the start and end date of the Dyslexia Program fall within the start and end date entered on the extract editor reports. If there is no selected value or a Dyslexia record does not exist, a value of 00 reports. Otherwise, a blank value reports. A Dyslexia record that ended prior to the selected calendar year does not report when the Date From field is not populated on the extract editor. Alphanumeric, 2 characters | Student Information > Program Participation > State Programs > Dyslexia > Dyslexia Subtest Dyslexia.services |
Dyslexia Spring Benchmark Performance Level | For students in grades 05, 06 and 07, the assigned value where the start and end date of the Dyslexia Program fall within the start and end date entered on the extract editor reports. If there is no selected value or a Dyslexia record does not exist, a value of 00 reports. Otherwise, a blank value reports. A Dyslexia record that ended prior to the selected calendar year does not report when the Date From field is not populated on the extract editor. Alphanumeric, 2 characters | Student Information > Program Participation > State Programs > Dyslexia > Dyslexia Performance Level Dyslexia.indicator |
Math Grouping Indicator 1 | No value reports for this field in the EOYA Extract. | N/A |
Math Grouping Indicator 2 | No value reports for this field in the EOYA Extract. | N/A |
English Language Arts - ELA Grouping Indicator 1 | No value reports for this field in the EOYA Extract. | N/A |
English Language Arts - ELA Grouping Indicator 2 | No value reports for this field in the EOYA Extract. | N/A |
Science Grouping | No value reports for this field in the EOYA Extract. | N/A |
Science Grouping | No value reports for this field in the EOYA Extract. | N/A |
Comprehensive Agriculture Grouping Indicator | No value reports for this field in the EOYA Extract. | N/A |
Animal Systems Grouping Indicator | No value reports for this field in the EOYA Extract. | N/A |
Plant Systems Grouping Indicator | No value reports for this field in the EOYA Extract. | N/A |
KELPA2 Grouping Indicator 1 | No value reports for this field in the EOYA Extract. | N/A |
KELPA2 Grouping | No value reports for this field in the EOYA Extract. | N/A |
State Mathematics Assessment | No value reports for this field in the EOYA Extract. | N/A |
State English Language - ELA Assessment | No value reports for this field in the EOYA Extract. | N/A |
State Science Assessment | No value reports for this field in the EOYA Extract. | N/A |
State History/Gov Assessment | No value reports for this field in the EOYA Extract. | N/A |
History/Gov Claim/Thesis Score | Reports the performance level the student achieved for the Recognize and Evaluate Score child assessment result when the following conditions are met:
See the Kansas Assessments article for information on setting up these assessments for proper reporting.
Numeric, 2 digits | Student Information > General > Assessment > Result Test.result |
History/Gov Evidence Score | Reports the performance level the student achieved for the Analyze Context and Draw Conclusions Score child assessment result when the following conditions are met:
See the Kansas Assessments article for information on setting up these assessments for proper reporting.
Numeric, 2 digits | Student Information > General > Assessment > Result Test.result |
History/Gov Reasoning Score | Reports the performance level the student achieved for the Research and Make Connections Score child assessment result when the following conditions are met:
See the Kansas Assessments article for information on setting up these assessments for proper reporting.
Numeric, 2 digits | Student Information > General > Assessment > Result Test.result |
Comprehensive Agriculture Assessment | No value reports for this field in the EOYA Extract. | N/A |
Animal Systems Assessment | No value reports for this field in the EOYA Extract. | N/A |
Plant Systems Assessment | No value reports for this field in the EOYA Extract. | N/A |
Kansas English Language Proficiency Assessment (KELPA) | No value reports for this field in the EOYA Extract. | N/A |
KELPA Proctor ID | No value reports for this field in the EOYA Extract. | N/A |
KELPA Proctor First Name | No value reports for this field in the EOYA Extract. | N/A |
KELPA Proctor Last Name | No value reports for this field in the EOYA Extract. | N/A |
American College Testing (ACT) Assessment | No value reports for this field in the EOYA Extract. | N/A |
ACT WorkKeys Assessment | No value reports for this field in the EOYA Extract. | N/A |
Individual Plan of Study | Reports whether the student has an IPS Plan when the student is in grades 11-17.
Otherwise, a blank value reports. Numeric, 1 digit | Student Information > Program Participation > State Programs > IPS PlanofStudy.startDate |
User Field 1 | N/A | N/A |
User Field 2 | N/A | N/A |
User Field 3 | N/A | N/A |