Extended School Services Report (Kentucky)

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

  1. Enter a Date Range in mmddyyyy format or by selecting the calendar icons.
  2. 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.
  3. Select the report Format. To review data, select HTML. For submission to the state, select the State Format (Fixed Width).
  4. Select which Calendar(s) to report data. 
  5. 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