Tool Search: Ed-Fi
Reports the Special Education data for a student.
Object Triggering Logic
This table describes logic for triggering syncing of this object.
| Action | Trigger |
|---|---|
| Post | When an IEP is created and locked and overlaps the configured year and the student has an enrollment in the configured year OR the student has a State Reporting SPED record that overlaps the configured year and the student has an enrollment in the configured year. Do not send a record when:
The Print Format of the IEP can be either the Campus Default IEP or a State IEP |
| Delete/Post/Put | When any field part of the natural key is changed:
When any field not part of the natural key is changed
|
| Delete |
|
Resource Toggle/Resync Logic
This table describes the School Exclude, Calendar Exclude, Resource Toggle and Resync logic of this object.
| Action | Trigger |
|---|---|
| None | When a resource is toggled to off after data has sent, all sent data remains in the ODS but no new data will send. |
| Resync | When a record is in the Ed-Fi Identity Mapping table and not in the ODS, it is deleted from the Ed-Fi Identity Mapping table. |
| Resync | When a record is in the ODS and it does not have a matching record in Campus or the Ed-Fi Identity Mapping table, it is deleted from the ODS. |
| Resync | When a mapping is changed in Resource Preferences, a resync needs to be done to reflect the changes. |
| Resync | When the Student Special Education Program Association is toggled off, records are not deleted from this resource in the State ODS when resyncing. |
Natural Key Changes, Cascading Updates, and Deletes Logic
This table describes the Natural Key Changes/Cascading Updates and Deletes logic of this object.
| Action | Trigger |
|---|---|
| Post/Delete | Natural Key changes: When the IEP Start Date changes the resource will delete/repost. |
| Delete | Cascading Deletes: N/A there are no dependent resources. |
Scope Year Logic
This table describes scope year logic of this object.
| Business Rules |
|---|
| The record sends to any year the IEP or State Reporting record overlaps with. |
| Data only sends for the years that have valid configuration. |
Resource Preferences
This table describes the Resource Preferences of this object.
Data Element Label | Mapping Needed |
|---|---|
| Special Education Setting Descriptors | Primary Setting Code |
| Level of Integration Descriptors | SPED Service Level |
| Annual Review Delay Reason Descriptors | Annual Review Delay Reason |
| Triennial Review Delay Reason Descriptors | Triennial Review Delay Reason |
| Planned Post Graduate Activity Descriptors | Post Grad Plan |
| Expected Diploma Type Descriptors | Expected Diploma Type |
| Special Education Program Service Descriptors | Service Code |
| Disability Descriptors | Disability |
Identity Mapping Object Key
This table describes the Identity Mapping Object Key of this object.
| campusObjectType | Object Key Data Source |
|---|---|
| Plan | planID |
| SpecialEDState | specialEDStateID |
Event Queue Detail
This table describes the Event Queue Detail of this object.
| Campus Table | Ed-Fi Action | Fields |
|---|---|---|
| plan | Post/Put/Delete | The primary table used for sending data for this resource. |
| enrollment | Put | Reports ideaEligibility and specialEducationSettingDescriptor. |
| specialedstate | Post/Put/Delete | The primary table used for sending data for this resource. |
Object Data Elements
This table describes data elements sent within the Student Special Education Program Associations resource.
| Data Element Label | Description | M, C, or O | Database Location |
|---|---|---|---|
| id | The unique identifier of the resource. | M | |
| beginDate | The month, day, and year on which the Student first received services. Reports the IEP start date from locked IEP being reported. Reports the Start Date from the State Reporting Special Ed tool. When the student has an eligible IEP and State Reporting record and they have different start dates, both records reports. When Start Dates are the same, reports from the IEP. | M | Special Ed Documents > Plan > Current Plan > Education Plan > Start Date OR Special Ed State Reporting> Start Date plan.startDate or specialedstate.startDate |
| educationOrganizationReference | The education organization where the student is participating in or receiving the program services. Reports the fields that are part of the Natural Key for the Local Education Agency resource where the educationOrganizationID is the State District Number. | M | District Information > State District Number district.number |
| programReference | A reference to the Program Resource. Reports the fields that are part of the Natural Key for the Programs resource.
| M | Student Information > General > Enrollments > Special Ed Fields > Special Ed Setting |
| studentReference | A unique alpha-numeric code assigned to a student. Reports the fields that are part of the Natural Key for the Students resource where the studentUniqueId is the Student State ID. | M | |
| programParticipationStatuses | An unordered collection of generalStudentProgramAssociationProgramParticipationStatuses. The status of the student's program participation. See the Arrays section below. | M | |
| reasonExitedDescriptor | Code that identifies status of exiter using Special Education exit categories. Returns the mapped Exit Reason when it exists AND the Primary Disability is not 00 or blank. Otherwise, this reports as null. | M | Enrollments > Special Ed Fields > Exit Reason |
| specialEducationProgramServices | An unordered collection of studentProgramAssociationServices. This association represents the Special Education program(s) that a student participates in or receives services from. See the Arrays section below. | M | |
| specialEducationMetDefinitionIndicator | Meets the Special Education definition related to follow-up status: Enrolled for at least one complete term (Continuing education) or Worked for a period of 20 hours a week for at least 90 days (Employment). Looks at the student's Enrollment from the previous school year, when the Special Ed Status is Y and the Follow-Up Status on the Graduation Tab is EMP, 2YR, 4YR, NOC, or ENC, the value from the Sped Definition Met field reports. First reports the code selected in from the Sped Definition Met dropdown in Enrollment Special Education fields. Otherwise, reports as N. | C | Enrollments > Special Ed Fields > Sped Definition Met drop list |
Arrays
