Tool Search: ISEE Extracts
The Special Education Students reports active and exited Special Education students and those students who are not yet identified as needing special education services but who have been evaluated. Students with Plans and/or Evaluations will be included in the report.
Users are recommended to use the 2013 or newer print formats for Idaho Evaluations. These formats include the fields needed for data collection found in the Eligibility Determination editor.
- Active Special Education students have an enrollment and a locked IEP that is active (based on start and end date) at least one day during the reporting date range.
- Exited Special Education students have a locked IEP that is active (based on start and end date) at least one day during the date range AND they have a date entered for Inactive Date on the Enrollments Tab that falls within the reporting date range.
Image 1: Special Education Students (ISEE Extract Editor)
Special Education Students Extract Logic
A record reports for each of the following scenarios. Multiple records may report per student:
- Student has one or more locked IEPs active on the extract End Date. Data reports from the most recent locked IEP.
- Student has only an Initial Evaluation active during the extract date range. To report, student may not have an IEP active between the Initial Eval Date and the extract End Date.
- Student has a Special Ed Exit Date on their Enrollment that falls within the extract date range.
- For each reportable student, one record reports for each reportable IEP or Evaluation:
- A Reportable Studentis one who:
- Has at least one active enrollment in the selected calendar(s) that is not marked as No Show or State Exclude and is not in a Grade Level or Calendar marked as State Exclude.
- Students with partial enrollments are included if the 'Include Partial Enrollments' checkbox is marked.
- A Reportable Planis one that:
- Belongs to a student with a Special Ed Status of SE: Special Education or U: Undetermined and is
- Locked and active during the Date Range entered in the extract editor.
- An Active student should only report one record per IEP. If a student has two Plans that are active and locked during the date range; i.e., the Plan is renewed during the reporting period, one record from the most recent locked IEP is reported.
- An Exited Student reports one record per Special Ed Exit Date on their Enrollment that falls within the extract date range.
- A Reportable Evaluationis one that:
- Belongs to a student with no active special education record within the extract Date Range or who has an Eligibility Determination Date on their evaluation that falls after their Enrollment's Special Ed Exit Date and is
- Locked and not under Reassessment and has is flagged as Initial.
- An Eligibility Determination Date that falls on or between the extract Date Range.
- A Reportable Studentis one who:
If the document format does not contain all editors that capture data used in this report, a student record may not include all state-required data.
Report Editor Field Descriptions
Field | Description |
|---|---|
Report Type | Select Special Education Students. The following ISEE extract types are also available: |
Start Date | The earliest date from which data is pulled for the report. (Required) |
End Date | The latest date from which data is pulled for the report. (Required) |
Include Partial Enrollments | This checkbox indicates that secondary enrollments should also be included. |
Ad Hoc Filter | This field allows users to use an Ad hoc filter that was created in the Ad hoc Filter Designer. Only one Student Ad hoc filter may be selected. |
Format | The format in which the report will generate. Options include CSV (State Format) and HTML. |
Select Calendars | The calendar(s) from which data is pulled for the report. Can be set to display only the active year's calendars, or be sorted by school or by year. |
Batch Queue | Users have the option of submitting a District Calendar report request to the batch queue by clicking Submit to Batch instead of Generate Extract. This process will allow larger reports to generate in the background, without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article. |
Special Education Students Extract Layout
Column | Description & Format | Campus Location |
|---|---|---|
idStuId | The student's unique Idaho Student Identification Number. Numeric, 9 digits | Census > People > Demographics > Person Identifiers > Student State ID Person.stateID |
resSchoolId | The State School Number from the student's School of Origination. This is the school responsible for the student's education according to IDEA. For Evaluation records, reports the school code of the school in the Student Demographics editor of the evaluation. For active or exited Plan records, reports the school code of the Resident School in the Enrollment Status editor of the plan. Reports based on student's active primary enrollment if not filled out on the plan. Numeric, 4 digits | School & District Setup > School Information > School > School Detail > State School Number; Student Information > Special Ed > Documents > Evaluation > Student Demographics > School Name; Student Information > Special Ed > Documents > IEP > Enrollment Status > Resident School School.number |
servSchoolId | The school where the student receives their education, based on the student's School of Origination. If Serving School is not populated, reports the State School Number For Evaluation records, reports as null. For active or exited Plan records, reports the Serving School in the Enrollment Status editor of the plan. Reports based on student's active primary enrollment if not filled out on the plan. Numeric, 4 digits | Student Information > General > Enrollments > State Reporting Fields > Serving School OR School & District Setup > School Information > School > State School Number; Student Information > Special Ed > Documents > Plan > Enrollment Status editor > Serving School EnrollmentID.servingSchool |
exceptionality1 | The primary exceptionality of the student.
See the Exceptionality Code List following this table. Numeric, 2 digits | Student Information > Special Ed > Documents > ID IEP/Plan > Exceptionality 1 learningPlan.disability1 |
environment | The Special Education Environment from the IEP/Plan that is active and locked at any time during the reporting date range. For an "Exited" student, this is the environment that was active at the time of the Special Ed Exit Date. Will report as Null for evaluation records. Numeric, 2 digits | Student Information > Special Ed > Documents > ID IEP/Plan > Special Ed Setting PlanState.specialEdSetting |
minPerWeek | The number of direct and indirect minutes per week the student receives services or that service providers consult on this student. For active and exited plans, calculated from all active, reportable related or ancillary services provided to the student in the IEP/Plan of record. Reports as Null for evaluation records. This field only reports if the student is enrolled in a grade level mapped to a State Grade of PK. Value reports as a whole number. Numeric, 4 digits | Student Information > Special Education > IEP/Plan > Related Services > Minutes per Session/Session Frequency Calculated, Not stored. |
| ECReferredDhw | Reports as Y if the student's Determination Date is within the extract date range and the Early Childhood Referring Agency ID is ecDHW. If the Agency ID is not ecDHW, reports as N. Otherwise reports as null. Reported from the most recent locked Evaluation active on or prior to the Start Date of the student's reportable plan where Eval Type is a value other than Reassessment. Where no Plan exists, will report Transition Date if the Eligibility Determination Date is within the date range on an Evaluation. Alphanumeric, 1 character, Y or N | Student Information > Special Ed > General > Documents > Evaluation > Evaluation Editor > Early Childhood Referring Agency ID Evaluation.ecReferringAgency |
ECDecTim | Indicates if the eligibility decision was made prior to the student's 3rd birthday. Reports as Y if the decision is made prior to the student's 3rd birthday and N if after. Alphanumeric, 1 character, Y or N | Student Information > Special Ed > Documents > Evaluation > Eligibility Determination > Eligibility Determination; Calculated, not dynamically stored |
ECDecLate | Indicates how many days late the eligibility of IEP decision occurred if on or after the student's 3rd birthday. Must only report a value when the student is in a grade mapped to stateGrade=PK. When gradeLevel !=PK, ECDecLate must be blank. When gradeLevel=PK, calculates the number of days between the student's Birth Date and the EC Eligibility Determination Date. Numeric, 3 digits | Student Information > Special Ed > Documents > Evaluation > Eligibility Determination > Eligibility Determination; Calculated, not dynamically stored |
ECLateRea | The reason entered for why the student's eligibility determination was delayed. Alphanumeric, 2 characters | Student Information > Special Ed > Documents > Evaluation > Eligibility Determination > EC Late Determination Reason SEEvaluationResults.ecDeterminationReason |
ECLROther | Additional information about why the student's eligibility determination was delayed. Alphanumeric, 250 characters | Student Information > Special Ed > Documents > Evaluation > Eligibility Determination > EC Later Determination Reason Detail SEEvaluationResults.ecDeterminationReasonDetail |
IDSpedDate | The date on which the student was first identified as qualifying for Special Education services. Reports Eligibility Determination Date from the Eval marked as Initial. Otherwise reports as null. Date field, 10 characters, MM/DD/YYYY | (2012 Formats) Student Information > Special Ed > Documents > Evaluation > Eligibility Determination Date Evaluation.eligibilityDeterminationDate |
SEEntryDate | The date the student first received Special Education services in the reporting year. If the student has an active, locked Plan, reports the Start Date if it falls on or after the current year enrollment Start Date. If the Plan Start Date falls before the current enrollment Start Date, reports the current year enrollment Start Date. For reporting purposes, multiple IEPs with no gaps between services are considered continuous service. In that instance, this field reports the date continuous service began in the reporting year, either the earliest IEP Start Date if it falls after the earliest Enrollments Start Date, or the earliest Enrollment Start Date if not. Date field, 10 characters, MM/DD/YYYY | Student Information > Special Education > Plan > Start Date Plan.startDate |
IEPDate | Reports the Start Date of the active locked ID IEP. Date field, 10 characters, MM/DD/YYYY | Student Information > Special Education > Documents > Plan > Start Date Plan.startDate |
| consentDate | Reports the Eval Consent Date. When reporting a record for an IEP, date reports from the locked Eval with the most recent Evaluation Date that is on or prior to the Start Date of the plan of record. When reporting a record for an Initial Evaluation, date reports from the locked Eval with an Eligibility Determination Date within the reporting date range. Only reports if the IDSpedDate is in the current year. Date field, 10 characters, MM/DD/YYYY | Student Information > Special Ed > Documents > Evaluation Evaluation.consentDate |
60DTline | Calculates the number of days from the locked Eval of record. If the number of days between the Eval Consent Date and the Reg Eligibility Determination Date from only a non EC Evaluation (or Evaluation Date if null) is less than or equal to 60, reports as Y. Otherwise reports as N. Only reports if the IDSpedDate is in the current year. Alphanumeric, 1 character | Student Information > Special Ed > Documents > Plan > Consent Date and Evaluation > Eligibility Determination Date OR Evaluation > Evaluation Date OR Plan > Eval Date Calculated, not dynamically stored |
DaysLate | If 60DTline reports as Y, reports the number of days calculated. Numeric, 3 digits | Student Information > Special Ed > Documents > Plan > Consent Date and Evaluation > Eligibility Determination Date OR Evaluation > Evaluation Date OR Plan > Eval Date Calculated, not dynamically stored |
LDRea | If 60DTline reports as N, reports the Late Determination Reason. Reports from only a non EC Evaluation. Alphanumeric, 2 characters | Student Information > Special Ed > Documents > Evaluation > Eligibility Determination > Late Determination Reason SEEvaluationResults.determinationReason |
ExRule | If Late Determination Reason is SE, reports the State Exception Rule. Reports from only a non EC Evaluation. Alphanumeric, 2 characters | Student Information > Special Ed > Documents > Eval > Eligibility Determination > State Exception Rule SEEvaluationResults.eDelayReason |
SpedEligible | Reports based on the type of plan/eval:
Options:
Alphanumeric, 1 character | Student Information > General > Enrollments > Special Ed Fields > Exit Date; Student Information > Special Ed > Documents > Evaluation > Eligibility Determination; Student Information > Special Ed > Documents > Plan > Special Ed Status Plan.specialEdStatus |
UndetRea | When reporting from an IEP that is Active or Exited and Special Ed Status contains a U:
When reporting from an Initial Evaluation and student has no IEP, reports as NC if Eligibility Determination is U and Consent Not Received is marked. Otherwise reports as null. Alphanumeric, 1 character | Calculated, not dynamically stored |
SEStatus | The status of the student relative to Special Education. If the Special Ed Exit Date is within the extract date range, reports as I (Inactive). If the student has an active, locked Plan and the Exit Date is null or not within the extract date range, reports based on Special Ed Status: A if SE: Special Education, I if N: Not Eligible or U: Undertermined. If the student does not have an active, locked Plan, reports based on whether the student has an Evaluation, as follows based on Eligibility Determination:
Alphanumeric, 1 character | Student Information > Enrollment > Special Ed Exit Date OR Student Information > Special Ed > Documents > Plan > Special Ed Status OR Student Information > Special Ed > Documents > Evaluation > Eligibility Determination Calculated, not dynamically stored. |
SEExitDate | If the student is inactive, the date they left Special Education. Reported only if the date is within the reporting date range. Date Field, 10 digits in, MM/DD/YYYY | Student Information > Enrollment > Special Ed fields Enrollment.spedExitDate |
SEExitReason | If the student is inactive, the reason that they are now inactive. Numeric, 2 digits | Student Information > Enrollment > Special Ed fields Enrollment.spedExitReason |
caseManager | The Case Manager's unique Idaho Staff Identification Number for the staff person who has the active Case Manager role during the reporting date range. If there is more than one staff person listed as the Case Manager during the reporting date range, the person who has that role at the end of the date range reports. If more than one person has an active Case Manager Role at the end of the date range, the Staff ID of the person with the most recent Team Member Start Date reports. Alphanumeric, 10 characters | Student Information > Special Ed > Team Members Person.staffStateID |
notes |
Alphanumeric, 250 characters | Student Information > Special Ed > Eval |
Exceptionality Code List
Code | Name |
|---|---|
01 | Specific Learning Disability |
02 | Intellectual Disability |
04 | Speech Impairment |
05 | Language Impairment |
06 | Emotional Behavioral Disorder |
07 | Other Health Impairment |
08 | Orthopedic Impairment |
10 | Hearing Impairment |
11 | Visual Impairment |
12 | Deaf-Blindness |
13 | Multiple Disabilities |
14 | Developmental Delay |
15 | Autism Spectrum Disorder |
16 | Traumatic Brain Injury |
Service Type Options
Code | Description |
|---|---|
01 | Speech Therapy |
02 | Language Therapy |
03 | Occupational Therapy |
04 | Physical Therapy |
05 | School Psychological Services |
06 | Social Work |
07 | Licensed Psychological Services |
08 | Adaptive PE |
09 | School Health |
10 | Counseling |
11 | Vision Services |
12 | Hearing Services |
13 | Specially Arranged Transportation |
14 | Family Support Services |
15 | One-to-one Paraprofessional in general classroom |
16 | Vocational services (Job coach/placement) |
17 | Vocational rehabilitation |
18 | Assistive Technology Device |
19 | Assistive Technology Service |
20 | Intensive Behavior Intervention |
21 | One-to-one Paraprofessional outside of gen classrm |
22 | Hearing Interpretive Services |
23 | Title I Services |
25 | Psycho-Social rehabilitation |
31 | Orientation and Mobility |
32 | Community-based education |
33 | Emotion/Behavior intervention |
34 | Extended School Year |
99 | Other Spec Ed Services |
ECDecTim Field Logic
Value | Logic |
|---|---|
Y |
|
N |
|
Exit Reason Codes
Code | Name | Description |
|---|---|---|
01 | Graduated - Met State Standards | Student exited by meeting comparable academic requirements that are equally as rigorous as regular academic requirements established by the district and received an identical diploma. Also include:
|
02 | Completed - Adapted Requirements | Student received a diploma by completing graduation requirements that modified the coursework, exempted the student from the course, or identified alternate methods of demonstrating competence as identified by the IEP team. |
04 | Reached maximum age | Student completed the semester in which he or she turned 21 without receiving a diploma or certificate. |
05 | Dropped out | Student was on last year’s child count, is not currently enrolled, and does not meet the definition for any other inactive reason.
|
06 | Transfer to Another Education Environment | Student moved out of the district’s catchment area or otherwise transferred to another district or LEA and is known to be continuing in a general or special education program. Include students receiving education in:
|
07 | No Longer Eligible for Program | Student no longer has an IEP and receives all educational services from a regular education program. Include: • Students placed in a private school who are receiving general but not special education • Students known to be receiving general but not special education in a home school setting. • Students no longer receiving special education due to parental revocation of consent. |
08 | Deceased | Student died since the last count. |
09 | Revoked Consent | |
| 10 | Extended School Year | |
| 12 | Summer Break |
