ISBE Regional Safe School Program (Illinois)

Classic View: IL State Reporting > ISBE Extracts > Regional Safe School Program

Search Terms: ISBE Extracts

The Regional Safe School Program (RSSP) Extract reports students in grades 6-12 who are actively participating in Regional Safe School Programs at any point during the selected calendar. 

Regional Safe School Program Extract

Report Logic

In order to be included: 

  • Students must have at least one enrollment record in the selected calendar where the Start Date is before or equal to the End Date entered on the Extract editor. Enrollments with a Primary Service Type report first, followed by Partial Service Types and Special Ed Service Types. 
  • The RSSP Start Date must fall BEFORE the entered Effective Date on the Report Editor and be ON or BEFORE the End Date of the selected calendar. 
  • The RSSP End Date must be blank (null) or AFTER the Start Date of the selected calendar. 

Students can have more than one RSSP per school year, but only the RSSP record with the most recent Start Date reports. 

Students are not included when:

  • The Enrollment Record is marked as State Exclude or No Show.
  • The Grade Level of Enrollment is marked as Exclude from State Reporting. 
  • The Calendar of Enrollment is marked as Exclude. 

Report Editor

FieldDescription
Extract TypeSelection determines the extract that is generated. For this instance, select the Regional Safe Schools Program option.
Effective Date

Entered date is used to return current enrollments for the report. This field automatically populates with the current date, but can be changed by entering a new date in mm/dd/yyyy format or by clicking the calendar icon to select a date. This date is required in order to generate the report.

  • If an enrollment record has an end date before the effective date, that record is not included
  • If an enrollment record has an end date after the effective date or does not have an end date, that record is included.
File IdentifierIndicates the number attached to the end of the file name and is used to differentiate the file from other files generated.
Students without State IDsWhen marked, the report returns students who do not have state IDs assigned.
Strip Apostrophes

When marked, the following marks are removed from student names and other reported data:

  • Apostrophes ('), Commas (,), Periods (.)
  • Umlaut (Ö)
  • Tilde (Ñ)
  • Grave Accents (Ò), Acute Accents (Ó)
  • Circumflex (Ô)

When not marked, these marks are not removed.

Report Protected IdentitiesWhen marked, student identity information (last name, first name, etc.) reports from the Protected Identity Information fields.
FormatDetermines how the report generates. Use the State Format (Comma Delimited) when submitting the report to the state. Use the HTML or Tab Delimited option when reviewing data prior to state submission. 
Ad hocSelect a saved ad hoc filter to use when generating this report. Only those students included in the filter will be returned on the report if they meet the reporting requirements.
Calendar SelectionAt least one calendar needs to be selected for the report to generate. Calendars can be chosen by Active Year, by School or by Year. If a calendar is selected in the Campus toolbar, that calendar is automatically selected.
Report GenerationThe report can be generated immediately using the Generate Extract button. When there is a larger amount of data chosen (several calendars, large date range, etc.), use the Submit to Batch button, which allows the user to choose when the report is generated. See the Batch Queue article for more information.

Generate the Report

  1. Select Regional Safe School Program from the Extract Type field.
  2. Enter the Effective Date for the report.
  3. Enter a File Identifier. This is a three digit number attached to the file name used to differentiate itself from other ISBE Demographic and Enrollment Extract files generated.
  4. Select the Students w/o stateIDs checkbox to include students without state IDs within the report. 
  5. If desired, mark the Strip Apostrophes checkbox.
  6. If desired, mark the Report Protected Identities checkbox.
  7. Select which Format to generate the report in. To preview information prior to submission to the state, use the HTML format. When submitting data to the state, use the State Format (Comma Delimited).
  8. If desired, select an Ad hoc Filter from which to pull the student set.
  9. Select which Calendars to include within the report.
  10. Select the Generate Extract button or use the Submit to Batch option. The report displays in a separate window in the designated format. 

Regional Safe Schools Program - State Format (comma delimited)

Regional Safe Schools Program - HTML Format

Regional Safe Schools Program - Tab Delimited

Report Layout

Header Layout

Element

Description

Location

File Type

The name of the extract being generated. Always reports a value of RSSP.

N/A

Total Records

The total amount of records generated.

N/A

File Name

RSSP_RCDTS_Date_File Identifier.ext

N/A

File Date

The date the extract was generated.

N/A

RCDTS

The Region-County-District-Type-School code that uniquely identifies the school generating the extract.


RRCCCDDDDDTTSSSS, 15 characters

System Administration > Resources > District Information > State District Number, Type, Region Number, County


System Administration > Resources > School > State School Number


District.districtID

District.county

District.region

School.number

Extract Layout

Element

Description

Location

Student ID

The student identifier assigned in the ISBE SIS.


Numeric, 9 digits

Census > People > Demographics > Person Identifies > State ID


Person.studentStateID

SAP ID

The Student ID number used by the school to identify the student within their local system.


Numeric, 50 digits

Census > People > Demographics > Person Identifiers > Student Number


Person.studentNumber

Legal Last Name

The student's legal last name.


When the Report Protected Identities checkbox is marked on the report editor, the student's last name reports from the Legal Last Name field if populated.


Alphabetical, 30 characters

Census > People > Identity Information > Last Name


Identity.lastName


Census > People > Identities > Protected Identity Information > Legal Last Name


Identity.legalLastName

Legal First Name

The student's legal first name.


When the Report Protected Identities checkbox is marked on the report editor, the student's first name reports from the Legal First Name field if populated.


Alphabetical, 30 characters

Census > People > Identity Information > First Name


Identity.firstName


Census > People > Identities > Protected Identity Information > Legal First Name


Identity.legalFirstName

Date of Birth

The student's date of birth.


Date field, 10 characters (MM/DD/YYYY)

Census > People > Demographics > Person Information > Birth Date


Identity.birthDate

RCDTS for Home School

The Region-County-District-Type-School code that uniquely identifies the elementary, middle/junior, or high school the student attends or would attend if not placed/transferred to another school/program to receive needed services.


When the Enrollment Home District and Enrollment Home School fields are populated, the two codes are concatenated.


RRCCCDDDDDTTSSSS, 15 characters

System Administration > Resources > District Information > State District Number, Type, Region Number, County


System Administration > Resources > School > State School Number


District.districtID

District.county

District.region

School.number

School Year

Reports the school year for which data is being submitted. Data for school year 2020-2021 reports as 2021.



Numeric, 4 digits (YYYY)

System Administration > Calendar > Calendar > Calendar Info > End Year

Calendar.endYear
Reason for ReferralIdentifies the reason the student was referred to RSSP.

Numeric, 2 digits
Student Information > Program Participation > State Program > RSSP > Reason for Referral

SafeSchools.referral Reason
Eligibility StatusReports the eligibility status of the student.

Numeric, 2 digits
Student Information > Program Participation > State Program > RSSP > Eligibility Status

SafeSchools.eligibility Status
GED TutoringIndicates the student is enrolled in an instructional program in order to receive a GED certificate.

Reports a value of 01 if the GED Tutoring checkbox is marked.

Numeric, 2 digits
Student Information > Program Participation > State Program > RSSP > GED Instruction

SafeSchools.ged Instruction
TutoringIndicates the student is enrolled in a program to receive additional educational services on a one-on-one basis to supplement regular instruction.

Reports a value of 01 if the Tutoring checkbox is marked.

Numeric, 2 digits
Student Information > Program Participation > State Program > RSSP > Tutoring

SafeSchools.tutoring
GED Test Successfully CompletedIndicates the student completed the GED assessment successfully.

Reports a value of 01 if the Tutoring checkbox is marked.

Numeric, 2 digits
Student Information > Program Participation > State Program > RSSP > GED Test Completed

SafeSchools.gedTestCompleted
Curriculum Related EmploymentIndicates the student is employed or working in a position that relates to the curriculum.

Reports a value of 01 if the Tutoring checkbox is marked.

Numeric, 2 digits
Student Information > Program Participation > State Program > RSSP > Curriculum Employment
Date of Alternate Education PlanReports the date of the Alternate Education Plan.

Date Field, 10 characters (MM/DD/YYYY)
Student Information > Program Participation > State Program > RSSP > Date of Alternate Education Plan

SafeSchools.aepDate
Behavior Modification TrainingIndicates any behavior management/conflict resolution training systems that help students improve their behavior, manage stress, control anger, and make better choices.

Reports a value of 01 if the Tutoring checkbox is marked.

Numeric, 2 digits
Student Information > Program Participation > State Program > RSSP > Behavior Training

SafeSchools.behaviorTraining
Community Service ParticipationIndicates the student is participating in RSSP-sponsored individual or group community service projects.

Reports a value of 01 if the Tutoring checkbox is marked.

Numeric, 2 digits
Student Information > Program Participation > State Program > RSSP > Community Service

SafeSchools.communityService 
Individual/Group CounselingIndicates the student is participating in
RSSP programs that provide individual and/or group counseling that may relate to social, emotional, or health problems.

Reports a value of 01 if the Tutoring checkbox is marked.

Numeric, 2 digits
Student Information > Program Participation > State Program > RSSP > Individual/Group Counseling

SafeSchools.individualGroupCounseling
Life Skills TrainingIndicates the student is participating in training that may include decision-making (critical thinking, problem solving, and communication), social skills, cultural awareness, financial management, etc.

Reports a value of 01 if the Tutoring checkbox is marked.

Numeric, 2 digits
Student Information > Program Participation > State Program > RSSP > Life Skills

SafeSchools.lifeSkills
MentoringIndicates the student is receiving program related to coaching and/or guiding students with their career/educational goals.

Reports a value of 01 if the Tutoring checkbox is marked.

Numeric, 2 digits
Student Information > Program Participation > State Program > RSSP > Mentoring

SafeSchools.mentoring
Parenting Classes for ParentsIndicates the parents of RSSP students  are receiving guidance as part of parental involvement in the RSSP program or as needed in individual circumstances on a caseby-case basis.

Reports a value of 01 if the Tutoring checkbox is marked.

Numeric, 2 digits
Student Information > Program Participation > State Program > RSSP > Parenting Classes

SafeSchools.parentClass
Referral to Social ServicesIndicates the student was referred for services provided by government agencies, public or private social service agencies, or community-based organizations.

Reports a value of 01 if the Tutoring checkbox is marked.

Numeric, 2 digits
Student Information > Program Participation > State Program > RSSP > Referral to Social Services

SafeSchools.referralSocialServices
School to WorkIndicates the student is receiving guidance for Career development training, skills training, and/or activities offered by the school to prepare students for jobs or employment.

Reports a value of 01 if the Tutoring checkbox is marked.

Numeric, 2 digits
Student Information > Program Participation > State Program > RSSP > School to Work

SafeSchools.schoolToWork
School YearReports the last four digits of the applicable school year. For school year 2020-2021, a value of 2021 reports.

Numeric, 4 digits
System Administration > Calendar > Calendar > End Year

Calendar.endYear