Target Table: SE_SERVICES_FACT
Data Submission Schedule: 40 Day, 80 Day, 120 Day, End of Year (EOY)
Grain: One record per district / location / school year / student / special education service
Load Sequences/Dependencies:
- Student Required
Template Description – This template tracks Special Education Services. This template contains details of services provided to special education students. Submit only students who are active as of the reporting date and are receiving services at that time.
School Year 2019-2020 Changes:
- Field 5 – New service codes added.
- IHP = NEW – Student’s IEP requires an individualized health plan
- LIFT = NEW – Student’s IEP requires a wheelchair lift
- NS = NEW – Student’s IEP requires nursing services
- SECDEV = NEW – Student’s IEP requires a security device such as harness, tethers, braces, restraints, seatbelts, or vest
- TRS = NEW – Student’s IEP requires transportation services
Delete Options:
1. Delete Special Education Services Fact By District and Service Start Date
2. Delete Special Education Services Fact By District, School Year, Service Start Date, and Student Id
3. Delete Special Education Services Fact By District, School Year, Service Start Date, and Student Id v2 – (Specific Records)
File Name Format: DDD_SE_SERVICES_FACT_YYYYMMDDHHMM.fff
File Name Format Example: 001_SE_SERVICES_FACT_201907071201.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 |
|
| 4 | STUDENT ID | Character, Required, Key | 9 digit student ID |
| 5 | SERVICE CODE | Character, Required, Key |
|
| 8 | SERVICE START DATE | Date, Required, Key |
|
| 13 | SERVICE DURATION | Number (in minutes, 0 Decimals), Required, Updateable | Enter the total number of minutes the service is provided per week. |
| 15 | INTEGRATED SERVICES STATUS | Character, Conditionally Required, Updateable |
|
| 28 | PRIMARY STAFF ID | Character, Required, Updateable | Enter the 9 digit staff ID |
TEMPLATE GUIDANCE