PATH: KY State Reporting > 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.

As of Release Pack .1717, this report is only available for Kentucky State Edition users of Campus.

Image 1: Extended School Services Report Editor

Selection 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. 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.
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.
1. Regular School - One record is returned for each student attending regular (non-summer) school.
2. 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.

Image 2: Extended School Services Report - HTML Format

Extended School Services Report Layout

Element Name	Description	Type, Format and Length	Campus Location	Campus Interface
School Year	The school year reporting data.	Numeric, 4 digits CCYY	N/A	N/A
District Code	The School District Number of the district reporting data.	Numeric, 3 digits NNN	District.number	System Administration > Resources > District Information > State District Number
School Code	The State School Code of the school reporting data.	Numeric, 3 digits NNN	School.number	System Administration > Resources > School > Location Number
SSID	The reporting student's State ID number.	Numeric, 10 digits NNNNNNNNNN	person.StateID	Census > People > Demographics > State ID
Last Name	The reporting student's last name. Not available in the State Format (Fixed Width).	Alphanumeric	Identity.lastName	Census > People > Demographics > Last Name
First Name	The reporting student's first name. Not available in the State Format (Fixed Width).	Alphanumeric	Identity.firstName	Census > People > Demographics > First Name
Gender	The reporting student's gender.	Alphanumeric, 1 character M or F	Identity.gender	Census > People > Demographics > Gender
Ethnicity	The reporting student's race/ethnicity.	Numeric, 1 digit	Identity. raceEthnicity	Census > People > Demographics > Race/Ethnicity
Grade Level	The reporting student's current grade level.	Numeric, 2 digits NN (pad with leading zeros if less than 2 digits)	Enrollment.grade	Student Information > General > Enrollments > Grade
Total Hours for ESS Goal	The total number of hours served.	Numeric, 5 digits NNNNN	ESS.essHours	Student Information > General > ESS > Total Hours Served
ESS Transported	Indicates if the student is transported for the ESS activity. If the ESS Transported checkbox is marked, a value of Y is reported. If unmarked, a value of N is reported.	Numeric, 1 digit Y or N	ESS. essTransported	Student Information > General > ESS > ESS Transported
Learning Goal - Reading	Indicates if the student has a Learning Goal of Reading. If the Reading checkbox is marked, a value of Y is reported. If unmarked, a value of N is reported.	Numeric, 1 digit Y or N	ESS. essLearningGoalReading	Student Information > General > ESS > Learning Goals > Reading
Learning Goal - Writing	Indicates if the student has a Learning Goal of Writing. If the Writing checkbox is marked, a value of Y is reported. If unmarked, a value of N is reported.	Numeric, 1 digit Y or N	ESS. essLearningGoalWriting	Student Information > General > ESS > Learning Goals > Writing
Learning Goal - Mathematics	Indicates if the student has a Learning Goal of Mathematics. If the Mathematics checkbox is marked, a value of Y is reported. If unmarked, a value of N is reported.	Numeric, 1 digit Y or N	ESS. essLearningGoalMath	Student Information > General > ESS > Learning Goals > Mathematics
Learning Goal - Science	Indicates if the student has a Learning Goal of Science. If the Science checkbox is marked, a value of Y is reported. If unmarked, a value of N is reported.	Numeric, 1 digit Y or N	ESS. essLearningGoalScience	Student Information > General > ESS > Learning Goals > Science
Learning Goal - Social Studies	Indicates if the student has a Learning Goal of Social Studies. If the Social Studies checkbox is marked, a value of Y is reported. If unmarked, a value of N is reported.	Numeric, 1 digit Y or N	ESS. essLearningGoalSocial	Student Information > General > ESS > Learning Goals > Social Studies
Learning Goal - Arts & Humanities	Indicates if the student has a Learning Goal of Arts and Humanities. If the Arts and Humanities checkbox is marked, a value of Y is reported. If unmarked, a value of N is reported.	Numeric, 1 digit Y or N	ESS. essLearningGoalArt	Student Information > General > ESS > Learning Goals > Arts and Humanities
Learning Goal - Vocational Studies	Indicates if the student has a Learning Goal of Vocational Studies. If the Vocational Studies checkbox is marked, a value of Y is reported. If unmarked, a value of N is reported.	Numeric, 1 digit Y or N	ESS. essLearningGoalVocational	Student Information > General > ESS > Learning Goals > Vocational Studies
Learning Goal - Practical Living	Indicates if the student has a Learning Goal of Practical Living. If the Practical Living checkbox is marked, a value of Y is reported. If unmarked, a value of N is reported.	Numeric, 1 digit Y or N	ESS. essLearningGoalPractical	Student Information > General > ESS > Learning Goals > Practical Living
Summer School	Indicates if the student's current ESS record is for summer school. If the student is in regular school a value of N is reported. If the student is in summer school, a value of Y is reported.	Numeric, 1 digit Y or N	ESS. essSummerSchool	Student Information > General > ESS > ESS Summer School
ESS Teacher	Indicates if the student is assigned an ESS teacher.	Numeric, 1 digit Y or N	ESS. essProviderESSTeacher	Student Information > General > ESS > ESS Providers > ESS Teacher
Instructional Assistant	Indicates if the student is assigned an Instructional Assistant.	Numeric, 1 digit Y or N	ESS. essProviderInstAssistant	Student Information > General > ESS > ESS Providers > Instructional Assistant
Peer Tutor	Indicates if the student is assigned a peer tutor.	Numeric, 1 digit Y or N	ESS. essProviderTutor	Student Information > General > ESS > ESS Providers > Peer Tutor
Student's Regular Teacher	Indicates if the student is assigned to the regular teacher.	Numeric, 1 digit Y or N	ESS. essProviderTeacher	Student Information > General > ESS > ESS Providers > Student's Regular Teacher
Before School	Indicates if the student's learning goals service model is before school. If the Before School checkbox is marked, a value of Y is reported. If unmarked, a value of N is reported.	Numeric, 1 digit Y or N	ESS.essServiceModelArt1 ESS.essServiceModelMath1 ESS.essServiceModelPractical1 ESS.essServiceModelReading1 ESS.essServiceModelScience1 ESS.essServiceModelSocial1 ESS.essServiceModelVocational1 ESS.essServiceModelWriting1	Student Information > General > ESS > Service Models > Before School
After School	Indicates if the student's learning goals service model is after school. If the After School checkbox is marked, a value of Y is reported. If unmarked, a value of N is reported.	Numeric, 1 digit Y or N	ESS.essServiceModelArt2 ESS.essServiceModelMath2 ESS.essServiceModelPractical2 ESS.essServiceModelReading2 ESS.essServiceModelScience2 ESS.essServiceModelSocial2 ESS.essServiceModelVocational2 ESS.essServiceModelWriting2	Student Information > General > ESS > Service Models > After School
Saturday	Indicates if the student's learning goals service model is on Saturdays. If the Saturday checkbox is marked, a value of Y is reported. If unmarked, a value of N is reported.	Numeric, 1 digit Y or N	ESS.essServiceModelArt3 ESS.essServiceModelMath3 ESS.essServiceModelPractical3 ESS.essServiceModelReading3 ESS.essServiceModelScience3 ESS.essServiceModelSocial3 ESS.essServiceModelVocational3 ESS.essServiceModelWriting3	Student Information > General > ESS > Service Models > Saturday
Intersession	Indicates if the student's learning goals service model is intersession. If the Intersession checkbox is marked, a value of Y is reported. If unmarked, a value of N is reported.	Numeric, 1 digit Y or N	ESS.essServiceModelArt4 ESS.essServiceModelMath4 ESS.essServiceModelPractical4 ESS.essServiceModelReading4 ESS.essServiceModelScience4 ESS.essServiceModelSocial4 ESS.essServiceModelVocational4 ESS.essServiceModelWriting4	Student Information > General > ESS > Service Models > Intersession
Daytime Waiver	Indicates if the student's learning goals service model is a daytime waiver. If the Daytime Waiver checkbox is marked, a value of Y is reported. If unmarked, a value of N is reported.	Numeric, 1 digit Y or N	ESS.essServiceModelArt5 ESS.essServiceModelMath5 ESS.essServiceModelPractical5 ESS.essServiceModelReading5 ESS.essServiceModelScience5 ESS.essServiceModelSocial5 ESS.essServiceModelVocational5 ESS.essServiceModelWriting5	Student Information > General > ESS > Service Models > Daytime Waiver
Result of ESS Services	Indicates the results of the student's ESS services. 01: Improved = A 02: Did Not Improve = B 03: Sustained = C	Alphanumeric, 1 character A, B or C	ESS. essServiceResults	Student Information > General > ESS > ESS Service Results
Standardized Formal	Indicates if the student's ESS progress is measured by standardized/formal assessment. If the Standardized/Formal checkbox is marked, a value of Y is reported. If unmarked, a value of N is reported.	Numeric, 1 digit Y or N	ESS. essAssessmentFormal	Student Information > General > ESS > ESS Assessment Measures > Standardized/Formal
Teacher Made Informal	Indicates if the student's ESS progress is measured by a teacher made/informal assessment. If the Teacher Made/Informal checkbox is marked, a value of Y is reported. If unmarked, a value of N is reported.	Numeric, 1 digit Y or N	ESS. essAssessementInformal	Student Information > General > ESS > ESS Assessment Measures > Teacher Made/Informal
Analysis of Student Work	Indicates if the student's ESS progress is measured by an analysis of their work. If the Formal Analysis of Student Work checkbox is marked, a value of Y is reported. If unmarked, a value of N is reported.	Numeric, 1 digit Y or N	ESS. essAssessementStudentWork	Student Information > General > ESS > ESS Assessment Measures > Formal Analysis of Student Work
Student Grades	Indicates if the student's ESS progress is measured by their grades. If the Student Grades checkbox is marked, a value of Y is reported. If unmarked, a value of N is reported.	Numeric, 1 digit Y or N	ESS. essAssessementStudentGrades	Student Information > General > ESS > ESS Assessment Measures > Student Grades

Extended School Services Report (Kentucky)

Selection Criteria

Report Editor

Generating the Report

Extended School Services Report Layout

Related Articles