Student Special Education Program Associations (Core v3.X)

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.

ActionTrigger
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 if enrollment is in a calendar marked as Exclude.
  • Do not send a record if enrollment is in a school marked as Exclude.
  • The Print Format of the IEP can be either the Campus Default IEP or a State IEP.
  • Do not send a record if enrollment is marked as No Show.
Delete/Post

When any field part of the natural key is changed:

  • Start Date
Put

When any field not part of the natural key is changed:

  • Idea Eligibility
  • Special Education Setting Descriptor
DeleteThe locked IEP is deleted or unlocked for a student.
DeleteAll enrollments are deleted for a student.
DeleteIf the student's enrollment is marked as No Show.
DeleteIf the IEP no longer overlaps the configured year.
DeleteThe state reporting record is deleted.
DeleteThe 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.

ActionTrigger
NoneIf a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
ResyncIf 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.
ResyncIf 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.
ResyncIf a mapping is changed in Resource Preferences, a resync will need to be done to reflect the changes.
ResyncIf 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.

ActionTrigger
Post/DeleteNatural Key changes: If the IEP Start Date changes the resource will delete/repost.
DeleteCascading 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 DescriptorsEnrollment Special Ed Setting
OR
Special Education Setting DescriptorsPlan Special Ed Setting
OR
Special Education Setting DescriptorsState Reporting Special Ed Setting


Identity Mapping Object Key

This table describes the Identity Mapping Object Key of this object.

campusObjectTypeObject Key Data Source
PlanplanID
SpecialEDStatespecialEDStateID


Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus TableEd-Fi ActionFields
planPost/Put/DeleteThe primary table used for sending data for this resource.
enrollmentPutReports ideaEligibility and specialEducationSettingDescriptor.
specialedstatePost/Put/DeleteThe 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 LabelBusiness RequirementLogicM, C or O

Data Source GUI Path

Database Field
id The unique identifier of the resource.
M

beginDateThe month, day, and year on which the Student first received services.
  1. Report the IEP start date from locked IEP being reported.
  2. Report the start date from the State Reporting SPED tab.
  3. If the student has an eligible IEP and State Reporting record and they have different start dates, report both records.
    • If Start Dates are the same, report from the IEP.
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.
  1. Report the State District Number.
M

System Administration> Resources> District Information> State District Number

district.number

program
Reference
A reference to the Program Resource.
  1. Reports the Natural Key for the Special Education Program.
M

student
Reference
A unique alpha-numeric code assigned to a student.
  1. Reports the Natural Key for the Student resource.
M

disabilitiesThe disability condition(s) that best describes an individual’s impairment, as related to special education services received.
  1. This is optional, does not report.
O

endDateThe month, day, and year on which the student exited the program or stopped receiving services.
  1. This is optional, does not report.
O



ideaEligibility

Indicator of the eligibility of the student to receive special education services according to the Individuals with Disabilities Education Act (IDEA).

  1. Report 'True' if the student has a locked IEP with a Primary Disability.
  2. Report 'True' if this record is reported from a State Reporting tab.
  3. Report 'False' if the student has a locked IEP and the Primary Disability is NULL.
O

Special Ed> Documents> Plan> IEP> Primary Disability


or


Enrollments> Primary Disability

planstate.disability1


or


enrollment.disability1


iepBeginDateThe effective date of the most recent IEP.
  1. This is optional, does not report.
O

iepEndDate

The end date of the most recent IEP.

  1. This is optional, does not report.
O

iepReviewDate

The date of the last IEP review.

  1. This is optional, does not report.
O

lastEvaluation
Date 
The date of the last special education evaluation.
  1. This is optional, does not report.
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.

  1. This is optional, does not report.
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.

  1. This is optional, does not report.
O

reasonExited
Descriptor
This descriptor defines the reason a student exited a program.
  1. This is optional, does not report.
O

schoolHours
PerWeek

Indicate the total number of hours of instructional time per week for the school that the student attends.

  1. This is optional, does not report.
O

servedOutsideOf
RegularSession
Indicates whether the Student received services during the summer session or between sessions.
  1. This is optional, does not report.
O

serviceProviders

An unordered collection of student Special Education Program Association Service Providers. The staff providing Special Education services to the student.

  1. This is optional, does not report.
O

specialEducation
HoursPerWeek
The number of hours per week for special education instruction and therapy.
  1. This is optional, does not report.
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. 
  1. This is optional, does not report.
O

specialEducation
SettingDescriptor
Reports the Special Education setting for the student.
  1. Report the Ed-Fi code for the value selected in Special Ed setting from the IEP or State Reporting Record being reported.
  2. If field is blank or Ed-Fi Code is NULL, do not report.
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


Type/Descriptor

Click here to expand...

Special Education Setting Descriptor

Code ValueDescriptionNamespaceShort Description
Correctional FacilitiesCorrectional Facilitiesuri://ed-fi.org/SpecialEducationSettingDescriptorCorrectional Facilities
Homebound/HospitalHomebound/Hospitaluri://ed-fi.org/SpecialEducationSettingDescriptorHomebound/Hospital
Inside reg class between 40-79% of the dayInside regular class no more than 79% of day and no less than 40% of the dayuri://ed-fi.org/SpecialEducationSettingDescriptorInside reg class between 40-79% of the day
Inside regular class 80% or more of the dayInside regular class 80% or more of the dayuri://ed-fi.org/SpecialEducationSettingDescriptorInside regular class 80% or more of the day
Inside regular class less than 40% of the dayInside regular class less than 40% of the dayuri://ed-fi.org/SpecialEducationSettingDescriptorInside regular class less than 40% of the day
Parentally-placed in Private SchoolsParentally-placed in Private Schoolsuri://ed-fi.org/SpecialEducationSettingDescriptorParentally-placed in Private Schools
Residential FacilityResidential Facilityuri://ed-fi.org/SpecialEducationSettingDescriptorResidential Facility
Separate SchoolSeparate Schooluri://ed-fi.org/SpecialEducationSettingDescriptorSeparate School