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.
|
| Delete/Post | When any field part of the natural key is changed:
|
| Put | When any field not part of the natural key is changed:
|
| Delete | The locked IEP is deleted or unlocked for a student. |
| Delete | All enrollments are deleted for a student. |
| Delete | If the student's enrollment is marked as No Show. |
| Delete | If the IEP no longer overlaps the configured year. |
| Delete | The state reporting record is deleted. |
| Delete | The state reporting record no longer overlaps the configured year. |
Resource Toggle/Resync Logic
This table describes the School Exclude, Calendar Exclude, Resource Toggle and Resync logic of this object.
| Action | Trigger |
|---|---|
| None | If a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send. |
| Resync | If a record is in the Ed-Fi Identity Mapping table and not in the ODS, it will be deleted from the Ed-Fi Identity Mapping table. |
| Resync | If a record is in the ODS and it does not have a matching record in Campus or the Ed-Fi Identity Mapping table, it will be deleted from the ODS. |
| Resync | If a mapping is changed in Resource Preferences, a resync will need to be done to reflect the changes. |
| Resync | If the Student Special Education Program Association is toggled off, do not delete records 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: If 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 will send to any year the IEP or State Reporting record overlaps with. |
| Data will only send 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 | Enrollment Special Ed Setting |
| OR | |
| Special Education Setting Descriptors | Plan Special Ed Setting |
| OR | |
| Special Education Setting Descriptors | State Reporting Special Ed Setting |
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 | Business Requirement | Logic | M, C or O | Data Source GUI Path | Database Field |
|---|---|---|---|---|---|
| id | The unique identifier of the resource. | M | |||
| beginDate | The month, day, and year on which the Student first received services. |
| M | Student Information > Special Ed > Documents > Plan > Current Plan > Education Plan > Start Date OR Student Information > Special Ed > State Reporting> Start Date | plan.startDate or specialedstate.startDate |
| education Organization Reference | The education organization where the student is participating in or receiving the program services. |
| M | System Administration> Resources> District Information> State District Number | district.number |
| program Reference | A reference to the Program Resource. |
| M | ||
| student Reference | A unique alpha-numeric code assigned to a student. |
| M | ||
| disabilities | The disability condition(s) that best describes an individual’s impairment, as related to special education services received. |
| O | ||
| endDate | The month, day, and year on which the student exited the program or stopped receiving services. |
| O | ||
| ideaEligibility | Indicator of the eligibility of the student to receive special education services according to the Individuals with Disabilities Education Act (IDEA). |
| O | Special Ed> Documents> Plan> IEP> Primary Disability or Enrollments> Primary Disability | planstate.disability1 or enrollment.disability1 |
| iepBeginDate | The effective date of the most recent IEP. |
| O | ||
| iepEndDate | The end date of the most recent IEP. |
| O | ||
| iepReviewDate | The date of the last IEP review. |
| O | ||
| lastEvaluation Date | The date of the last special education evaluation. |
| O | ||
| medicallyFragile | Indicates whether the Student receiving special education and related services is: 1) in the age range of birth to 22 years, and 2) has a serious, ongoing illness or a chronic condition that has lasted or is anticipated to last at least 12 or more months or has required at least one month of hospitalization, and that requires daily, ongoing medical treatments and monitoring by appropriately trained personnel which may include parents or other family members, and 3) requires the routine use of medical device or of assistive technology to compensate for the loss of usefulness of a body function needed to participate in activities of daily living, and 4) lives with ongoing threat to his or her continued well-being. Aligns with federal requirements. |
| O | ||
| multiplyDisabled | Indicates whether the Student receiving special education and related services has been designated as multiply disabled by the admission, review, and dismissal committee as aligned with federal requirements. |
| O | ||
| reasonExited Descriptor | This descriptor defines the reason a student exited a program. |
| O | ||
| schoolHours PerWeek | Indicate the total number of hours of instructional time per week for the school that the student attends. |
| O | ||
| servedOutsideOf RegularSession | Indicates whether the Student received services during the summer session or between sessions. |
| O | ||
| serviceProviders | An unordered collection of student Special Education Program Association Service Providers. The staff providing Special Education services to the student. |
| O | ||
| specialEducation HoursPerWeek | The number of hours per week for special education instruction and therapy. |
| O | ||
| specialEducation ProgramServices | An unordered collection of student Program Association Services. This association represents the Special Education program(s) that a student participates in or receives services from. |
| O | ||
| specialEducation SettingDescriptor | Reports the Special Education setting for the student. |
| O | Student Information > Special Ed > Documents > Plan > Current Plan > Enrollment Status> Special Ed Setting OR Student Information > Special Ed > Special Ed Setting | enrollment.specialEdSetting OR plan.specialEdSetting OR specialedstate.specialEdSetting |
