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 | Not Reported. |
D22 | Cumulative Number of Days Attended | Not Reported. |
D23 | Truant Student | Not Reported. |
Truant Student Override | Not Reported. | |
D24 | Minutes Enrolled | [S_KS_STU_X]Minutes_Enrolled |
D25 | Concurrent High School Enrollment | [S_KS_STU_X]Concurrent_School |
D26 | Exit/Withdrawal Date | Not Reported. |
D27 | Exit/Withdrawal Type | Not Reported. |
D28 | Unweighted Grade Point Average (GPA) | [S_KS_STU_X]Unweighted_GPA |
D29 | High School Credits Earned | [S_KS_STU_X]HS_Credits_Earned |
D30 | High School Credits Earned Required to Graduate | [S_KS_STU_X]HS_Credits_Graduate |
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 | Not Reported. |
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 | [S_KS_STU_ELL_X]ESOL_Minutes |
D46 | Career and Technical Education Contact Minutes | [S_KS_STU_X]Tech_Ed_Minutes |
D47 | Title I Participation | Not Reported |
D48 | Miles Transported | [S_KS_STU_X]Miles_Transported |
D49 | Transportation FTE | [S_KS_STU_X]Transport_FTE |
D50 | Student’s Street Address | [S_KS_STU_X]Transport_Address |
D51 | Student’s City | [S_KS_STU_X]Transport_City |
D52 | Student’s Zip Code | [S_KS_STU_X]Transport_Zip |
D53 | Non-Resident Transportation | [S_KS_STU_X]Ten_Mile_Law |
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 Student | Not Reported |
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) | Not Reported |
D89 | User Field 1 | [S_KS_STU_X]UserField_1 |
D90 | User Field 2 | [S_KS_STU_X]UserField_2 |
D91 | 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.