Tool Search: Extended School Services Report
The Extended School Services Report lists all students who receive extended school services within a specific date range and set of calendars. This report is only available for Kentucky State Edition users.
Extended School Services Report EditorSelection Criteria
Students must meet the following criteria in order to report on the Extended School Services Report:
- The student must have a valid enrollment record for at least part of the Date Range entered on the extract editor.
- The student must have a valid ESS record for at least part of the Date Range entered on the extract editor.
- If the student has multiple ESS records, all records are reported.
Report Editor
Editor Field | Description |
|---|---|
Date Range | The date range from which students with a valid enrollment record and ESS record will report for the selected calendar(s). |
School Type | Indicates the type of school the student is enrolled in.
|
Calendar | The calendar(s) reporting ESS data. |
Format | The format in which the report will generate. Options include State Format (Fixed Width), CSV or HTML. |
Generating the Report
- Enter a Date Range in mmddyyyy format or by selecting the calendar icons.
- Select the School Type.
- Regular School - One record is returned for each student attending regular (non-summer) school.
- Summer School - One record is returned for each student attending summer school.
- Select the report Format. To review data, select HTML. For submission to the state, select the State Format (Fixed Width).
- Select which Calendar(s) to report data.
- To generate the report, select the Generate Extract button. The report will appear in the designated format.
Extended School Services Report - HTML FormatExtended School Services Report Layout
Element Name | Description | Location |
|---|---|---|
School Year | The school year reporting data. Numeric, 4 digits | N/A |
District Code | The School District Number of the district reporting data. Numeric, 3 digits | School & District Settings > District > District Information > State District Number District.number |
School Code | The State School Code of the school reporting data. Numeric, 3 digits | School & District Settings > Schools > School Information > Location Number School.number |
SSID | The reporting student's State ID number. Numeric, 10 digits | Census > People > Demographics > State ID person.StateID |
| Last Name | The reporting student's last name. Alphanumeric Not available in the State Format (Fixed Width). | Census > People > Demographics > Last Name Identity.lastName |
| First Name | The reporting student's first name. Not available in the State Format (Fixed Width). | Census > People > Demographics > First Name Identity.firstName |
Gender | The reporting student's gender. Alphanumeric, 1 character | Census > People > Demographics > Gender Identity.gender |
Ethnicity | The reporting student's race/ethnicity. Numeric, 1 digit | Census > People > Demographics > Race/Ethnicity Identity.raceEthnicity |
Grade Level | The reporting student's current grade level. Numeric, 2 digits | Student Information > General > Enrollments > Grade Enrollment.grade |
Total Hours for ESS Goal | The total number of hours served. Numeric, 5 digits | Student Information > General > ESS > Total Hours Served ESS.essHours |
ESS Transported | Indicates if the student is transported for the ESS activity. Numeric, 1 digit | Student Information > General > ESS > ESS Transported ESS.essTransported |
Learning Goal - Reading | Indicates if the student has a Learning Goal of Reading. Numeric, 1 digit | Student Information > General > ESS > Learning Goals > Reading ESS.essLearningGoalReading |
Learning Goal - Writing | Indicates if the student has a Learning Goal of Writing. Numeric, 1 digit | Student Information > General > ESS > Learning Goals > Writing ESS.essLearningGoalWriting |
Learning Goal - Mathematics | Indicates if the student has a Learning Goal of Mathematics. Numeric, 1 digit | Student Information > General > ESS > Learning Goals > Mathematics ESS.essLearningGoalMath |
Learning Goal - Science | Indicates if the student has a Learning Goal of Science. Numeric, 1 digit | Student Information > General > ESS > Learning Goals > Science ESS.essLearningGoalScience |
Learning Goal - Social Studies | Indicates if the student has a Learning Goal of Social Studies. Numeric, 1 digit | Student Information > General > ESS > Learning Goals > Social Studies ESS.essLearningGoalSocial |
Learning Goal - Arts & Humanities | Indicates if the student has a Learning Goal of Arts and Humanities. Numeric, 1 digit | Student Information > General > ESS > Learning Goals > Arts and Humanities ESS.essLearningGoalArt |
Learning Goal - Vocational Studies | Indicates if the student has a Learning Goal of Vocational Studies. Numeric, 1 digit | Student Information > General > ESS > Learning Goals > Vocational Studies ESS.essLearningGoalVocational |
Learning Goal - Practical Living | Indicates if the student has a Learning Goal of Practical Living. Numeric, 1 digit | Student Information > General > ESS > Learning Goals > Practical Living ESS.essLearningGoalPractical |
Summer School | Indicates if the student's current ESS record is for summer school. Numeric, 1 digit | Student Information > General > ESS > ESS Summer School ESS.essSummerSchool |
ESS Teacher | Indicates if the student is assigned an ESS teacher. Numeric, 1 digit | Student Information > General > ESS > ESS Providers > ESS Teacher ESS.essProviderESSTeacher |
Instructional Assistant | Indicates if the student is assigned an Instructional Assistant. Numeric, 1 digit | Student Information > General > ESS > ESS Providers > Instructional Assistant ESS.essProviderInstAssistant |
Peer Tutor | Indicates if the student is assigned a peer tutor. Numeric, 1 digit | Student Information > General > ESS > ESS Providers > Peer Tutor ESS.essProviderTutor |
Student's Regular Teacher | Indicates if the student is assigned to the regular teacher. Numeric, 1 digit | Student Information > General > ESS > ESS Providers > Student's Regular Teacher ESSessProviderTeacher |
Before School | Indicates if the student's learning goals service model is before school. Numeric, 1 digit | Student Information > General > ESS > Service Models > Before School ESS.essServiceModelArt1 |
After School | Indicates if the student's learning goals service model is after school. Numeric, 1 digit | Student Information > General > ESS > Service Models > After School ESS.essServiceModelArt2 |
Saturday | Indicates if the student's learning goals service model is on Saturdays. Numeric, 1 digit | Student Information > General > ESS > Service Models > Saturday ESS.essServiceModelArt3 |
Intersession | Indicates if the student's learning goals service model is intersession. | Student Information > General > ESS > Service Models > Intersession ESS.essServiceModelArt4 |
Daytime Waiver | Indicates if the student's learning goals service model is a daytime waiver. Numeric, 1 digit | Student Information > General > ESS > Service Models > Daytime Waiver ESS.essServiceModelArt5 |
Result of ESS Services | Indicates the results of the student's ESS services.
Alphanumeric, 1 character | Student Information > General > ESS > ESS Service Results ESS.essServiceResults |
Standardized Formal | Indicates if the student's ESS progress is measured by standardized/formal assessment. Numeric, 1 digit | Student Information > General > ESS > ESS Assessment Measures > Standardized/Formal ESS.essAssessmentFormal |
Teacher Made Informal | Indicates if the student's ESS progress is measured by a teacher made/informal assessment. Numeric, 1 digit | Student Information > General > ESS > ESS Assessment Measures > Teacher Made/Inform ESS.essAssessementInformal |
Analysis of Student Work | Indicates if the student's ESS progress is measured by an analysis of their work. Numeric, 1 digit | Student Information > General > ESS > ESS Assessment Measures > Formal Analysis of Student Work ESS.essAssessementStudentWork |
Student Grades | Indicates if the student's ESS progress is measured by their grades. Numeric, 1 digit | Student Information > General > ESS > ESS Assessment Measures > Student Grades ESS.essAssessementStudentGrades |
