Tool Search: ISEE Extracts
The Special Education Students extract reports active and exited Special Education students and those who have not yet been identified as needing special education services but have been evaluated. Students with Plans and/or Evaluations will be included in the report.
The 2013 or newer print formats should be used 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) for 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 an Inactive Date entered on the Enrollments tool that falls within the reporting date range.
Special Education Students (ISEE Extract Editor) Special Education Students Extract Logic
A record reports for each of the following scenarios. Multiple records may be reported 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 Student is 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 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 Evaluation is 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 is flagged as Initial.
- An Eligibility Determination Date that falls on or between the extract Date Range.
- A Reportable Student is 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 created in the Ad hoc Filter Designer. Only one Student Ad hoc filter may be selected. |
Format | The format in which the report will be generated. Options include:
|
Select Calendars | The calendar(s) from which data is pulled for the report can be set to display only the calendars in the active year or sorted by school or year. |
Batch Queue | Users can submit 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 be generated in the background without disrupting the use of Campus. See the Batch Queue article for more information about submitting a report to the batch queue. |
Special Education Students Extract Layout
Column | Description & Format | Location |
|---|---|---|
idStuId | The student's unique Idaho Student Identification Number. Numeric, 9 digits | 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 the student's active primary enrollment if not filled out on the plan. Numeric, 4 digits | School Information > School > School Detail > State School Number Special Ed > Documents > Evaluation > Student Demographics > School Name 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. When the reporting student ONLY has an Active or Exited IEP (Plan):
When the reporting student has BOTH a Plan and an EVAL:
When the reporting student ONLY has an Initial Evaluation (Eval):
Numeric, 4 digits | Special Ed > Documents > Plan > Enrollment Status editor > Serving School Special Ed > Documents > Eval > Student Demographics > School of Origination School Information > School > School Detail > State School Number EnrollmentID.servingSchool |
exceptionality1 | The primary exceptionality of the student.
See the Exceptionality Code List below this table. Numeric, 2 digits | Special Ed > Documents > ID IEP/Plan > Exceptionality 1 learningPlan.disability1 |
environment | The Special Education Environment from the IEP/Plan which 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 | 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 | 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, it reports as N. Otherwise, it reports as null. Reported from the most recent locked Evaluation active on or before the Start Date of the student's reportable plan where Eval Type is a value other than Reassessment. Where no Plan exists, the Transition Date will be reported if the Eligibility Determination Date is within the date range on an Evaluation. Alphanumeric, 1 character, Y or N | Special Ed > General > Documents > Evaluation > Evaluation Editor > Early Childhood Referring Agency ID Evaluation.ecReferringAgency |
ECDecTim | Indicates if the eligibility decision was made before the student's 3rd birthday. Reports as Y if the decision is made before the student's 3rd birthday and N if after. Alphanumeric, 1 character, Y or N | 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 | Special Ed > Documents > Evaluation > Eligibility Determination > Eligibility Determination
Calculated, not dynamically stored |
ECLateRea | The reason why the student's eligibility determination was delayed. Alphanumeric, 2 characters | 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 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) 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 | 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 | 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 before 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 | 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 | 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 | 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 | Special Ed > Documents > Eval > Eligibility Determination > State Exception Rule SEEvaluationResults.eDelayReason |
SpedEligible | Reports based on the type of plan/eval:
Options:
Alphanumeric, 1 character | Enrollments > Special Ed Fields > Exit Date; Special Ed > Documents > Evaluation > Eligibility Determination 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 | 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 | Enrollment > Special Ed fields Enrollment.spedExitDate |
SEExitReason | If the student is inactive, the reason that they are now inactive. Numeric, 2 digits | Enrollment > Special Ed fields Enrollment.spedExitReason |
caseManager | The Case Manager's unique Idaho Staff Identification Number for the staff person with 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 | Special Ed > Team Members Person.staffStateID |
notes | Any notes or comments about this student's record. Report text as entered in (dbo.SEEvaluationResults > discussionText) ONLY if field 18 Late Determination Reason (delayReason) reports as SD or ST. Late Determination Reason Comments is not visible when Late Determination Reason is blank and/or NOT = SD or ST. Alphanumeric, 250 characters | 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
