Reading Intervention Extract (Kentucky)

PATH:   KY State Reporting > Reading Intervention Extract 

The Reading Intervention Extract provides information about students and teachers who take part in Reading Intervention programs. The extract includes general demographic and program data as well as information about the student's teacher.

This article includes the following topics:


 Image 1: Reading Intervention Extract Editor 

Selection Criteria

Only students who meet the following criteria will be reported within the Reading Intervention Extract:

  • Students must be in grade levels 00,01, 02, 03, or 14.
  • Students must be actively enrolled and the Effective Date entered on the extract editor must fall within the student's active enrollment.
  • Students must be rostered into a course that is marked Homeroom on the Course editor. This extract pulls homeroom status from the course, not the section.
  • No Show students are excluded from the extract.
  • Students marked as State Exclude are excluded from the extract.
  • Calendars and Grades marked Exclude are included within the extract.

Generating the Extract

  1. Enter the Effective Date. Active enrollment records as of this date are reported.
  2. Select which Calendar(s) to report data.
  3. Select the report Format. Use the HTML format for data analysis and the State Format (CSV) format when submitting data to the state.
  4. Click the Generate Extract button. The report will generate in a separate window in the designated format. 


 

 Image 2: Example of the Preschool Enrollment Count (HTML Format) 

Reading Intervention Extract Elements

The following data elements are included in the Reading Intervention Extract: 

Element Name

Description

Type, Format and Length

Campus Location

Campus Interface

Student Last Name

The reporting student's last name. Alphanumeric, 20 characters

Identity.lastName

Census > People > Demographics > Last Name

Student First Name The reporting student's first name. Alphanumeric, 20 characters Identity.firstName Census > People > Demographics > First Name
Student Middle Name The reporting student's middle name. Alphanumeric, 20 characters

Identity.
middleName

Census > People > Demographics > Middle Name
Student ID Number The reporting student's local Student ID number. Alphanumeric, 10 characters

Person.
studentNumber

Census > People > Demographics > Local Student Number
Student SSID The reporting student's Student State ID number. Alphanumeric, 10 characters Person.stateID Census > People > Demographics > Student State ID
Grade Grade of the reporting student. Text, 2 characters Enrollment.grade Student Information > General > Enrollments > Grade
Date of Birth The reporting student's date of birth.

Date field, 8 digits

YYYY/MM/DD

Identity.birthDate Census > People > Demographics > Birth Date
Gender Gender of the reporting student. Text, 1 character Identity.gender Census > People > Demographics > Gender
Ethnicity The reporting student's race/ethnicity. Alphanumeric, 2 characters

Identity.
raceEthnicityFed

Census > People > Demographics > Race/Ethnicity > State Race/Ethnicity
Current District Name Name of the student's current district. Text, 20 characters District.name System Administration > Resources > District Information > Name
School Name Name of the student's current school. Text, 20 characters School.name System Administration > Resources > School > Name
District and School Number

The reporting student's district and school number.

The first 3 digits are the District Number and the final 3 digits are the School Number.

Text, 6 characters

 District.number 

School.number

System Administration > Resources > District Information > State District Number

System Administration > Resources > School > Location Number

Free or Reduced Lunch Code

Indicates the student's FRAM Eligibility.

Eligibility is determined using the following logic:

  • If a student has a FRAM Eligibility state code of F (Free) with a date range which falls within the start and end dates of the calendar selected in the tool bar, the field will report F, regardless of any other Eligibility entries with different codes which may exist in the time frame.
  • If the student has an entry of R (Reduced) within the start and end dates of the calendar selected in the tool bar and no additional Eligibility entries exist within the time period with a code of F, a value of R will report regardless of the presence of an Eligibility entry of S (Paid) or a period with no Eligibility entry during this time frame.
  • FRAM Eligiblity records from a previous school year which overlap the start/end dates of the calendar selected are reported.
  • If no FRAM Eligibility records exist within the start/end dates of the selected calendar, a value of S (Paid) is reported.
Text, 4 characters

POSEligibility.
eligibility

FRAM > Eligibility
Migrant Student

Indicates if the student is a migrant.

A value of 1 is reported if the Migrant field is marked. If not, a value of 0 is reported.

Text, 1 character Enrollment.migrant Student Information > General > Enrollments > State Reporting Fields > Migrant
Title 1

Indicates if the student is considered Title 1.

A value of 1 is reported if the Title 1 field is marked. If not, a value of 0 is reported.

Text, 1 character

ActiveEnrollment.
title1

Student Information > General > Enrollments > State Reporting Fields > Title 1
LEP

Indicates if the student is considered Limited English Proficient.

If English Proficiency = 02: LEP, a value of 1 is reported. If English Proficiency is any other value, a value of 0 is reported.

Text, 1 character Lep.programStatus Student Information > General > Enrollments > State Reporting Fields > English Proficiency
Student's Homeroom Number The student's homeroom number. Text, 10 characters

CourseSection.
homeroomSection

Scheduling > Courses > Section
Homeroom Teacher The first and last name of the student's homeroom teacher. Text, 40 characters

CourseSection.
teacherFullName

Scheduling > Courses > Sections > Teacher Name
Teacher's First Name The first name of the student's teacher. Text, 20 characters Identity.firstName Scheduling > Courses > Sections > Teacher Name
Teacher's Last Name The last name of the student's teacher Text, 20 characters Identity.lastName Scheduling > Courses > Sections > Teacher Name
Local Staff ID The Staff ID of the student's teacher. Text, 9 characters

Identity.
staffNumber

Census > People > Demographics > Staff ID
Teacher's District Name The name of the teacher's district. Text, 20 characters District.name Census > People > District Assignment
Teacher's School Name The name of the teacher's school. Text, 20 characters

SchoolEmployment.
schoolName

Census > People > District Assignment
Teacher's District and School Number The teacher's district and school number. Text, 6 characters

District.name

SchoolEmployment.
schoolName


System Administration > Resources > District Information > State District Number

System Administration > Resources > School > Location Number

Teacher's Homeroom The teacher's homeroom. Text, 10 characters

SectionInfo.
homeroomSection

Scheduling > Courses > Section