Service Provider Report (Illinois)

Classic View: IL State Reporting > Service Provider Report

Search Terms: Service Provider Report

The Service Provider Report collects student's Service Provider information, as recorded on the student's Enrollment record. 

Service Provider Report

Report Logic

Students who have an enrollment record (this includes primary, partial and special education enrollments) where the Service Provider field is populated on the Special Ed Fields Enrollment Editor are included in the report. Enrollment dates must fall within the Start and End Dates entered on the extract editor. 

Values for the Service Provider field are populated in the Attribute Dictionary within the Enrollment attribute.

Students are not included when:

  • The Enrollment record is marked as No Show or as State Exclude.
  • The Calendar of enrollment is marked as State Exclude.
  • The Grade Level of enrollment is marked as State Exclude. 

Report Editor

The following fields are available for selection. 

FieldDescription

Start Date

End Date

Entered dates are used to return service provider information.


The Start Date populates with the start date of the selected calendar. The End Date populates with the end date of the selected calendar. If multiple calendars are selected, the latest start and end dates are used.


Enter different dates by typing in mmddyy format or using the calendar icon to choose dates.

File IdentifierIndicates the number attached to the end of the file name and is used to differentiate the file from other files generated.
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 Comma Separate (CSV) (State format) when submitting the report to the state. Use the HTML option when reviewing data prior to state submission. 
Student Selection

Select students by choosing one or more grade levels or a saved ad hoc filter to use when generating this report.


Only those students in the selected grade levels report if they meet the reporting requirements. Only those students included in the filter 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 Service Provider Report

  1. Enter the Start Date and End Date required for the report. 
  2. Enter the File Identifier value.
  3. If desired, mark the Strip Apostrophes checkbox.
  4. If desired, mark the Report Protected Identities checkbox.
  5. Select the desired Format for the report. 
  6. Select students by choosing Grade Levels or an Ad hoc Filter from the dropdown list. 
  7. Select the desired Calendar(s)
  8. Click the Generate Report button to display the results of the report immediately; click the Submit to Batch button to determine when the report generates. 

Service Provider Report - State Format (CSV)

Service Provider Report - HTML Format

Report Layout

Report Header

Data ElementDescriptionLocation
Report Name
Reports the name of the extract being generated. This always reports a value of Service Provider.N/A
Student CountReports the total number of records that appear on the report.N/A
File NameSP + RCDT or District Name + _ + Date (mmddyyy)_File Identifier (i.e.,SP_310453000260_01302015_001.txt)N/A 
Sent DateIndicates the date the report was generated.N/A
RCDTS Code
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

Report Layout

Data ElementDescriptionLocation
Student IDReports the student's state ID.

Numeric, 9 digits
Census > People > Demographics > Person Identifiers > Student State ID

Person.stateID
SAPIDReports the student's locally assigned ID.

Numeric, 6 digits
Census > People > Demographics > Person Identifiers > Local Student Number

Person.studentID
Legal Last Name

Reports 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.


Alphanumeric, 20 characters

Census > People > Identity Information > Last Name



Identity.lastName


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


Identity.legalLastName

Legal First Name

Reports 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.


Alphanumeric, 20 characters

Census > People > Identity Information > First Name



Identity.firstName


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


Identity.LegalfirstName

Birth DateReports 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.


RRCCCDDDDDTTSSSS, 15 characters

System Administration > Resources > District Information > District Information


System Administration > Resources > School > School Editor > School Detail


Student Information > General > Enrollments > State Reporting Fields > Home District and Home School


District.districtID

District.county

District.region

School.number

Enrollment.resident School

Enrollment.resident District

RCDTS for Serving School

The Region-County-District-Type-School code that uniquely identifies the school/program where a student is being educated.


RRCCCDDDDDTTSSSS, 15 characters

System Administration > Resources > District Information > District Information


System Administration > Resources > School > School Editor > School Detail


Student Information > General > Enrollments > State Reporting Fields > Serving District and Serving School


District.districtID

District.county

District.region

School.number

Enrollment.serving School

Service Provider RCDTSReports the assigned code on the Special Education Fields Enrollment Editor.

Numeric, 15 digits

Student Information > General > Enrollment > Special Education Fields > Service Provider


EnrollmentIL.serviceProvider


System Administration > Custom > Attribute/Dictionary > Enrollment > Service Provider