KIDS Collection EOYA
End of Year Accountability
The KIDS Collection EOYA report will be used to submit end of year accountability data, based on the EOYA collection cycle, to the Kansas Individual Data on Students (KIDS) system.
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.
Note: Students selected based on a previous enrollment now have their Attendance_Days values reported to tenths, to match students selected based on current enrollment.
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:
Note:
|
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.
This report pulls the recent enrollment record in case there are multiple enrollments in the same year at the same school.
Field Ref | Data Element | [Table]FieldName |
H1 - H6 | Header records | See KIDS Collection for more information. |
D1 | Record Type | "EOYA" |
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 | 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 | [Students]EntryDate [Students]ExitDate |
D22 | Cumulative Number of Days Attended | [Attendance]Date |
D23 | Truant Student | Reported. |
Truant Student Override | [S_KS_STU_X]Truant_Override | |
D24 | Minutes Enrolled | Not Reported |
D25 | Concurrent High School Enrollment | Not Reported |
D26 | Exit/Withdrawal Date | Not Reported |
D27 | Exit/Withdrawal Type | Not Reported |
D28 | Unweighted Grade Point Average (GPA) | Not Reported |
D29 | High School Credits Earned | Not Reported |
D30 | High School Credits Earned Required to Graduate | Not Reported |
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 | [S_KS_STU_X]Qualified_504 |
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. Kansas At-Risk Program Participation field extracts for preschool students (grade level less than 0=KG) |
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 | Not Reported |
D46 | Career and Technical Education Contact Minutes | Not Reported |
D47 | Title I Participation | [S_KS_STU_ X]Title_I_Participation |
D48 | Miles Transported | Not Reported |
D49 | Transportation FTE | Not Reported |
D50 | Student’s Street Address | Not Reported |
D51 | Student’s City | Not Reported |
D52 | Student’s Zip Code | Not Reported |
D53 | Non-Resident Transportation | Not Reported |
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/Delinquent Note: If the D57 field is blank then 0 will extracted in the TEST and EOYA report. Valid values:
| [S_KS_STU_X]Neglected_Student |
D58 | Preschool-Aged At-Risk Program Participation | [S_KS_STU_X]PREKG_Program_Participation |
D59 | Kansas Pre-K Pilot Program (KPP) Note:
| [S_KS_STU_X]EL_Participant |
D60 | Kansas Parents as Teachers Program (KPAT) Note:
| [S_KS_STU_X]PAT_Participant |
D61 | Dyslexia Screener | [S_KS_STU_X]Dyslexia_Screener |
D62 | Dyslexia Subtest | [S_KS_STU_X]Dyslexia_Subtest |
D63 | Dyslexia Spring Benchmark Performance Level | [S_KS_STU_X]Dyslexia_sprgbmrkperflvl |
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 | [S_KS_STU_X]HIST_ASSESSMENT_TASK1 |
D79 | History/Gov Evidence Score | [S_KS_STU_X]HIST_ASSESSMENT_TASK2 |
D80 | History/Gov Reasoning Score | [S_KS_STU_X]HIST_ASSESSMENT_TASK3 |
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) | [S_KS_STU_X]Individual_Plan_Study |
D89 | First Instructional Date | [S_KS_STU_X]FIRST_INSTR_DATE |
D90 | Community Service Postsecondary Asset | [S_KS_STU_X]COMM_SERV_POSTSEC_ASSET |
D91 | Two or More High School Athletics/Activities Postsecondary Asset | [S_KS_STU_X]ATHL_ACT_POSTSEC_ASSET |
D92 | Junior ROTC Postsecondary Asset | [S_KS_STU_X] JNR_ROTC_POSTSEC_ASSET |
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 |
Truant Student Calculation
Truant students are calculated using the Attendance Tracking and Notification (ATN) functionality.
If the Truant Student Override checkbox is selected, 1 is extracted.
If the Truant Student Override checkbox is not selected, the field value is set to 1 when the student satisfies any one of the following conditions:
The student is absent 5 or more days in semester 1 or
The student is absent 5 or more days in semester 2 or
The student is absent 7 or more days during the full year or
The student is absent 3 days in a row
Else the value is set to 0
Note: The Truant_Student value for students who are selected based on a previous enrollment is determined by attendance records or by the override field, rather than being hardcoded to 0.