Tool Search: i4see Extracts

The Special Education Public Schools Report sends information to the state for all students who enter the district after a user specified date.

Image of the Special Ed Public Schools Report Editor. Special Ed Public Schools Report Editor

Report Logic

The report includes all students meeting these requirements:

The student has locked IEP.
The student's Start Date in their IEP falls between the Editor Start Date and Editor End Date.
The student has IEP End Date.

Report Editor Options

Data Element	Description
Extract Type	Indicates the type of extract selected. Select Special Ed Public Schools Report from the list of options.
Start Date	Beginning date of the student enrollment records. Dates are entered in mmddyy format or can be selected by using the calendar icon.
End Date	End date of the student enrollment records. Dates are entered in the mmddyy format or can be selected by using the calendar icon.
Ad Hoc Filter	Selection of previously made filter that contains specific students to include in the label request.
Report Format	Determines how the request is generated - in the State Format (CSV) or HTML. Use the HTML format when reviewing data. Use the State Format when submitting the list to the state.
Select Calendars	At least one calendar must be selected in order for the extract to generate. Calendars are selected by the active year, by the school or by the year. Students in the chosen calendars are included in the extract.

Select the Special Ed Public Schools Report from the Extract Type dropdown list.
Enter the Start Date and End Date of the enrollment records to include.
Select an Ad Hoc Filter from the dropdown list to reduce the amount of students included in the extract.
Select the Report Format.
Select the Calendars from which to pull students in the report.
Click the Generate Extract button. The report will display in the selected format.

Data Element	Description	Location
SASID	State-assigned student identification number. Numeric, 10 digits	Census > People > Demographics > Person Identifiers > State ID Person.stateID
Date of Birth	Student's date of birth. Date field, 10 characters MM/DD/YYYY	Census > People > Demographics > Person Information > Birth Date Identity.birthdate
IEP Begin Date	Identifies the begin date for the period during the school year the student was under IEP. Date field, 10 characters MM/DD/YYYY	Student Information > Special Ed > Documents > Plan > Plan Outline > Education Plan > Start Date Plan.startDate
IEP End Date	Identifies the end date for the period during the school year the student was under IEP. If no End Date is in the student's IEP, reports blank. Date field, 10 characters MM/DD/YYYY	Student Information > Special Ed > Documents > Plan > Plan Outline > Education Plan > End Date Plan.endDate

Data Element

Description

Location

SASID

State-assigned student identification number.

Numeric, 10 digits

Census > People > Demographics > Person Identifiers > State ID

Person.stateID

Date of Birth

Student's date of birth.

Date field, 10 characters
MM/DD/YYYY

Census > People > Demographics > Person Information > Birth Date

Identity.birthdate

IEP Begin Date

Identifies the begin date for the period during the school year the student was under IEP.

Date field, 10 characters
MM/DD/YYYY

Student Information > Special Ed > Documents > Plan > Plan Outline > Education Plan > Start Date

Plan.startDate

IEP End Date

Identifies the end date for the period during the school year the student was under IEP. If no End Date is in the student's IEP, reports blank.

Date field, 10 characters
MM/DD/YYYY

Student Information > Special Ed > Documents > Plan > Plan Outline > Education Plan > End Date

Plan.endDate