Tool Search: Special Ed Exit Report
The Special Ed Exit Report is a list of students that were in special education at the beginning of the reporting period but not in special education at the end of the reporting period.
Special Ed Exit Report Editor
Report Logic
The reporting period is July 1 (of the prior year) – June 30 (e.g., July 1, 2017 - June 30, 2018)
The report can be run against a district’s active (current) year as well as any prior year.
The report can be run in District Edition or State Edition.
All instances of students that have exited special education based on their Special Ed Exit Date and Special Ed Exit Reason report.
- Report pulls enrollments with Service Type = P or N.
- Student must have a Special Ed Exit Date within the Date Range of the extract editor.
- Student must be at least 14 years of age as of the Count Date selected on the extract editor.
- Student must be enrolled on or prior to the first instructional day of the calendar.
The report will sort by School Number, then by Last Name, First Name, and Middle Name.
When the District-Wide checkbox is marked, the report will generate all applicable records for the full district utilizing the Date Range from the extract editor.
| Data Element | Description | Location |
|---|---|---|
| District Number | The District Number on the student's primary enrollment. Numeric, 9 digits | District Information > Number District.number |
| District Name | The District Name on the student's primary enrollment. Alphanumeric, 40 characters | District Information > Name District.name |
| School Number | The school number on the student's primary enrollment. Numeric, 7 digits | District Information > Number School Information > Number District.number School.number |
| School Name | The school name of the student's primary enrollment. Alphanumeric, 60 characters | School Information > School Detail > Name School.name |
| State Unique ID | State Assigned student ID. Numeric, 10 digits | Demographics > Student State ID Person.stateID |
| Student ID | District-assigned student identification number. Numeric, 7 digits | Demographics > Student Number Person.studentNumber |
| Last Name | The student's last name. Alphanumeric | Demographics > Last Name Identity.lastName |
| First Name | The student's first name. Alphanumeric | Demographics > First Name Identity.firstName |
| Middle Name | The student's middle name. Alphanumeric | Demographics > Middle Name Identity.middleName |
| DOB | The student's date of birth. Date Format, MM/DD/YYYY | Demographics > Birth Date Identity.birthdate |
| Age | The student's age as of the Count Date on the editor. Numeric, 2 digits | Demographics > Birth Date Enrollments > Special Ed > Exit Date |
| Gender | The student's gender. Alphanumeric, 1 character | Demographics > Gender Identity.gender |
| Ethnicity Code | The student's ethnicity. Alphanumeric, 3 characters | Demographics > Race Ethnicity Identity.raceEthnicity |
| Primary Disability | The student's primary disability. Alphanumeric, 2 characters | Student Information > Special Ed > General > Documents > Enrollment Status > Primary Disability Enrollment.disability1 |
| Special Ed Setting | The student's special ed setting for services provided. Alphanumeric | Special Ed > Documents > Documents > IEP > PlacementPopulates from the 'Federal Placement Code' field designated under the Placement section of new IEPs starting 2023. |
| Basis of Exit | The student's Special Ed exit reason. Alphanumeric, 1 character | Student Information > General > Enrollments > Special Ed > Special Ed Exit Reason Enrollment.spedExitReason |
| Special Ed Exit Date | The date the student exited Special Ed services. The latest/most recent locked IEP End Date that falls within the report date range reports as the student's Special Education Exit Date when they meet all other criteria for the report.Date, 10 characters MM/DD/YYYY | Student Information > Special Ed > Documents > IEP > Plan End Date Plan.endDate |
| Enrollment Exit Status | The end status of the student's enrollment. Alphanumeric | Enrollments > End Status Enrollment.endStatus |
| Enrollment Exit Date | The end date of the student's enrollment. Alphanumeric | Enrollments > End Date Enrollment.endDate |
| LEP Indicator | Indicates whether the student was assigned EL status. If the student's Program Participation Standard Code is EL and the Identified Date is prior to the Special Ed Exit Date, this field reports EL. If the student's Program Participation Standard Code is Exited EL and the Program Exit Date is equal to or before the Special Ed Exit Date, this field reports EL. All other scenarios report NLEP. Alphanumeric, 4 characters | English Learners (EL) > EL > Program Status LEP.programStatus LEP.identifiedDate |
Errors and Warnings
The Special Education Exit Report contains a set of Errors and Warnings if any portion of your data must be cleaned up prior to a final submission of the Special Education Exit Report. You must address any students who show in the warnings in order for those students to pull on the report.
The Warning page is a report that runs when you click the Generate Report button in the extract editor. The Warning report displays first. You may then click the "Click Here to Generate the final extract" button to generate the actual report.
A placeholder line for each Error or Warning exists on the Error/Warning page as a reference, even if there are no actual Errors or Warnings. These warnings are informative and do not prevent you from generating the extract.
Until the exit statuses are fixed, the report displays a blank for that student's exit date and/or exit status.
| Warning Code | Description | Selection Criteria | Fields |
|---|---|---|---|
| WA01 | Exit DateIExit Status Validation | This is a critical warning. Students who appear on this warning do NOT appear on the report. Warning Text WAOl: the following record(s) contain a Special Education Exit Status but no Special Education Exit Date OR contain Special Education Exit Date but no Special Education Exit Status. (Number of Records:N) Warning Logic This warning only pulls students who are missing a Sped status or a Sped Exit date when the other item is present. | districtNumber, SchoolNumber, SSID, LastName, FirstName, Grade, SpedExitStatus, spedExitDate |
| WA02 | End Status Validation | This is a critical warning. Students who appear on this warning do NOT appear on the report. Warning Text WA02: the following record(s) contain a Special Education Status of l:Yes an End Status that is Not Null, but do not contain a corresponding Special Education Exit Status or Date (Number of Records:7) Warning Logic Warning pulls any students who meet report selection criteria who do not also have both a Sped Exit Status and a Sped Exit Date in the current year. | districtNumber, SchoolNumber, SSID, LastName, FirstName, Grade, SpedExitStatus, spedExitDate |
| WA03 | IEP End Date with no Special Ed Exit Date in the Special Ed Fields in Enrollment | Student has a IEP with an Exit date within the reporting period, AND Student does not have an new IEP with a state Date within the reporting period, Student does not have a Special Ed Exit Date in the Special Ed Fields in Enrollment. | districtNurnber, SchoolNurnber, SSID, LastName, FirstName, Grade, IEP End Date, SpedExitStatus, spedExitDate |
| RMA | Exit Status Validation | This is a warning. Students who appear on this warning DO appear on the report. Warning Text RMA: the following record(s) contain a Special Education exit status of RMA and a age not equal to 21. Warning Logic Warning pulls any students who meet report selection criteria who have an exit status of RMA but are not age 21. | districtNurnber, SchoolNurnber, SSID, LastName, FirstName, Grade, Age, SpedExitStatus, spedExitDate |
| GHS | Exit Status Validation | This is a warning. Students who appear on this warning DO appear on the report. Warning Text GHS: the following record(s) contain a Special Education exit status of GHS and an age of 14, 15, or 16. Warning Logic Warning pulls any students who meet report selection criteria who have an exit status of GHS and an age of 14, 15, or 16. | districtNurnber, SchoolNurnber, SSID, LastName, FirstName, Grade, Age, SpedExitStatus, spedExitDate |
