Licensure
Column Title
Column Title
Column Title
Haven’t found what you’re looking for?
Target Table: SPECIAL_ED_SNAP
Data Submission Schedule: 40 Day, 80 Day, 120 Day, End of Year (EOY)
Grain: One record per district / location / school year / student / snapshot date
Load Sequences/Dependencies:
TEMPLATE DESCRIPTION – This template tracks general information on Special Education students. This template describes the details of students’ participation in special education at a given point in time designated by the Snapshot Date. Submit only for active students including; EOY graduating seniors, returning 12th graders with a Non-Graduate Continuing (C), Non-Graduate Transition (T), Graduate Continuing (GC), or Graduate Transition (GT). DO NOT SUBMIT newly exited students (students who have exited special education since the last reporting period) in the Special Education Snapshot Template. Report these students in the Special Education Events Template.
School Year 2019-2020 Changes
Delete Options:
1. Delete Special Education Snapshot by District and Snapshot Date
2. Delete Special Education Snapshot by District, School Year, Snapshot Date, and Student Id
File Name Format: DDD_SPECIAL_ED_SNAP_YYYYMMDDHHMM.fff
File Name Format Example: 001_SPECIAL_ED_SNAP_201807071201.csv
| Field Number | Field Name | Data Type, Required, Code | Valid Values |
|---|---|---|---|
| 1 | DISTRICT CODE | Character, Required, Key | |
| 2 | LOCATION CODE | Character, Required, Key | |
| 3 | SCHOOL YEAR DATE | Date, Required, Key |
|
| 5 | STUDENT ID | Character, Required, Key | 9 digit student ID |
| 11 | PRIMARY DISABILITY | Character, Conditionally Required, Updateable |
Valid Values
AU – Autism Required if the SPECIAL EDUCATION FIELD (#38) in the Student / Student Snapshot Template = Y. |
| 12 | SECONDARY DISABILITY | Character, Conditionally Required, Updateable |
Valid Values
AU – Autism Required if a Secondary Disability exists. |
| 13 | LAST IEP DATE | Date, Required, Updateable | YYYY-MM-DD |
| 14 | LAST EVALUATION DATE | Date, Required, Updateable | YYYY-MM-DD |
| 18 | SPECIAL EDUCATION TEACHER ID | Character, Required, Updateable | 9 digit Staff SSN |
| 21 | EXPECTED DIPLOMA TYPE (Graduation Option) | Character, Conditionally Required, Updateable |
|
| 23 | ALTERNATE ASSESSMENT | Character, Required, Updateable |
|
| 26 | BRAILLE INSTRUCTION | Character, Required, Updateable |
|
| 33 | SPECIAL ED ENTRY DATE | Date, Required, Updateable | YYYY-MM-DD |
| 35 | SNAPSHOT DATE | Date, Required, Key |
|
| 44 | PRIMARY SETTING CODE | Character, Required, Updateable |
Early Childhood Students (Ages 3-5)
School Age Students (Ages 6-21)
For either School age students (Ages 6 – 21) or Early Childhood students (Ages 3-5)
Do not include students who received education programs at the facility, but do not live there. |
| 59 | PRIMARY AREA OF EXCEPTIONALITY | Character, Required, Updateable |
|
SUBMIT FOR:
DO NOT SUBMIT FOR:
In field #33 SPECIAL ED ENTRY DATE do we enter the exact date the student began receiving services in the current school year?
Yes.
Example 1. If the student was receiving services (IDEA or Gifted) since the end of last year the date would be either be (the first day of school or the first day in the school year (ex. 7/1/yyyy). Either date is acceptable.
Example 2. If the student transferred in from another district during the school year. The date is when the student began receiving services at the district.
Example 3. If the student transferred from another school within the same district during the school year. Use the date when the student began receiving services at the district.
Do they want all students who are SPED who are not in the “Referral Process”?
This field applies to all students receiving special education services. [Student/Student Snapshot].[Special Education] (field #38) must equal “Y” and/or [Student/Student Snapshot].[Gifted Participation Code] (field #80 must equal “Y”).