Indiana Ed-Fi Data v2.4/3.1 - Student Special Education Program Associations

Classic View: System Administration > Ed-Fi

Search Terms: 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 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
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: LEA Reference - District Numbers cannot change after data has been sent. If a district number changes, we would expect an Ed-Fi error and this change would not be supported. If an Ed-Fi ID changes, a delete/post will occur with the cascading deletes from the Ed-Fi ID Change triggers. 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.

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	Format
id	The unique identifier of the resource.		M
beginDate	The month, day, and year on which the Student first received services.	Report the IEP start date from locked IEP being reported. Report the start date from the State Reporting SPED tab. 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	date-time
education Organization Reference	The education organization where the student is participating in or receiving the program services.	Report 10+District+School.	M	System Administration> Resources> District Information> State District Number System Administration> Resources> School	district.number school.Number	reference
programReference	A reference to the Program Resource: ProgramTypeID ProgramName	Reports the Natural Key for the Special Education Program. See Type/Name List below. If student has only a Locked Evaluation, report this as 'Undefined' for the programName.	M	Student Information > Special Ed > Documents > Plan > Current Plan > Education Plan >Student Placement	plan.studentPlacement	reference
studentReference	A unique alpha-numeric code assigned to a student.	Reports the Natural Key for the Student resource. Student Ed-FI ID	M			reference
disabilityDescriptor Id	Report the students Disability(s).	Report the primary disability if it exists. Report the secondary Disability, if it exists, in an array.	M	Student Information > Special Ed > Documents > Plan > Current Plan > Education Plan > Primary Disability and/or Secondary Disability	plan.primaryDisability plan.secondary Disability	array
endDate	The month, day, and year on which the student exited the program or stopped receiving services. This only reports if there is an endDate on the IEP.	Only reports if the End DAte exists on the IEP.	C	Student Information > Special Ed > Documents > Plan > Current Plan > Education Plan > End Date	plan.endDate	date-time
ideaEligibility	Indicator of the eligibility of the student to receive special education services according to the Individuals with Disabilities Education Act (IDEA).	Report 'True' if the student has a locked IEP with a Primary Disability. Report 'True' if this record is reported from a State Reporting tab. Report 'False' if the student has a locked IEP and the Primary Disability is NULL.	M	Student Information > Special Ed> Documents> Plan> IEP> Primary Disability or Student Information > Enrollments> Primary Disability	planstate. disability1 or enrollment. disability1	boolean
iepBeginDate	The effective date of the most recent IEP.	This is optional, does not report	O			date-time
iepEndDate	The end date of the most recent IEP.	This is optional, does not report.	O			date-time
iepReviewDate	The date of the last IEP review	Reports the IEP 'Meeting Date'.	C	Student Information > Special Ed > Documents > Plan > Current Plan > Education Plan > IEP Meeting Date	plan.meetingDate	date-time
lastEvaluationDate	The date of the last special education evaluation.	Reports the date of the last Eval saved for the student. If an eval does not exist, report the 'Eval Date' on the IEP.	C	Student Information > Special Ed> Documents> Plan> IEP> Eval	eval.startDate plan.evalDate	date-time
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.	This is optional, does not report.	O			boolean
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.	This is optional, does not report.	O			boolean
reasonExitedDescriptor	This descriptor defines the reason a student exited a program. This field only reports if the Reason for Service Term/Transition field is populated on the IEP and there is an endDate.	Reports the 'Reason for Service Term/Transition'. Reports only if the field is populated on the IEP and there is an end date.	C	Student Information > Special Ed> Documents> Plan> IEP> Reason for Service Term/Transition	plan.reasonFor TermTransition	string
schoolHoursPerWeek	Indicate the total number of hours of instructional time per week for the school that the student attends.	This is optional, does not report.	O			number
servedOutsideOf RegularSession	Indicates whether the Student received services during the summer session or between sessions.	This is optional, does not report.	O			boolean
serviceProviders	An unordered collection of studentSpecialEducationProgram AssociationServiceProviders. The staff providing Special Education services to the student.	This is optional, does not report.	O			array
specialEducation HoursPerWeek	The number of hours per week for special education instruction and therapy.	This is optional, does not report.	O			number
specialEducation ProgramServices	An unordered collection of studentProgramAssociationServices. This association represents the Special Education program(s) that a student participates in or receives services from.	This is optional, does not report.	O			array
specialEducation SettingDescriptor	Reports the Special Education setting for the student	Report the Ed-Fi code for the value selected in Special Ed setting from the IEP or State Reporting Record being reported. If field is blank or Ed-Fi Code is NULL, do not report.	M	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	string
specialEducation EvaluationTimeline DescriptorId	Reports circumstances relevant to timeline	Report the numeric code for the value selected for Circumstances Relevant to Timeline from the most recent locked Evaluation for the current active school year. Reports only if this data is populated on the student's IEP.	C	Student Information > Special Ed > General > Documents > Circumstances Relevant to Timeline	evaluation. circumstances RelevantToTimeline
timelineCompliance DescriptorId	Timeline Compliance	Report the Timeline Compliance from most recent locked Evaluation captured by the date range from the report Extract Editor criteria. Reports only if this data is populated on the student's IEP.	C	Student Information > Special Ed > General > Documents > Timeline Compliance	Evaluation. delayReason
orderOfDisability	Report the order of the disability. Reports if there is more than one disability for the student.	Reports if there are more than one disability listed for a student. If primary Disability, report orderOfDisability as 1. If there is a secondary Disability, report the orderOfDisability as 2.	C	Student Information > Special Ed > Documents > Plan > Current Plan > Education Plan > Primary Disability and/or Secondary Disability
firstStepsTransition Date	Date the special education services began for the student transitioning from first steps.	If the Special Education Evaluation Timeline Descriptor ID is 3 on the most recent locked Evaluation: Consider all locked IEPs active within the report date range. Report the Plan Start Date from the earliest locked IEP. Otherwise, report blank	C	Student Information > Special Ed > General > Documents > IN SPED Plan > IN SPED Data Plan Editor > Start Date	plan.startDate
parentalConsentDate	Reports the date the parent gave consent for the student to enter the program..	Report Consent Date from most recent locked evaluation captured by the date range from the report Extract Editor criteria. If Consent Date is NULL/ blank, report the Eval Date from that evaluation.	M	Student Information > Special Ed > General > Documents > Indiana Evaluation > Evaluation Header > Consent Date. or Student Information > Special Ed > General > Documents > Indiana Evaluation > Evaluation Header > Eval Date	evaluation.consentDate OR SEPlan.evalDate

Type/Descriptor

Click here to expand...

Special Education Setting Descriptor

Code	Name	Notes	Reports as (NameType)
26	Receiving the majority of hours of Special education and related services in the Regular Early Childhood Program	Child attending a Regular Early Childhood Program at least 10 hours per week:	Regular Early Childhood, at least 10 Hours
27	Receiving the majority of hours of special education and related services in some other location	Child attending a Regular Early Childhood Program at least 10 hours per week:	Regular Early Childhood, at least 10 Hours, Other Location
28	Receiving the majority of hours of special education and related services the regular Early Childhood Program	Child attending a Regular Early Childhood Program less than 10 hours per week:	Regular Early Childhood, less than 10 Hours
29	Receiving the majority of hours of special education and related services in some other location	Child attending a Regular Early Childhood Program less than 10 hours per week:	Regular Early Childhood, less than 10 Hours, Other Location
33	Separate Class	Child attending a special Education program (not in ANY regular early childhood program)	Special Education Program, Separate Class
34	Separate School	Child attending a special Education program (not in ANY regular early childhood program)	Special Education Program, Separate School
35	Residential Facility	Child attending a special Education program (not in ANY regular early childhood program)	Special Education Program, Residential Facility
36	Receiving the majority of hours of special education and related services at home	Child attending NEITHER a regular Early Childhood Program, NOR a special education program	Other Services at Provider Location
37	Receiving the Majority of hours of Special Education and related services at home	Child attending NEITHER a regular Early Childhood Program, NOR a special education program	Other Services at Home
38	Child is parentally placed in a private pre-school	Child attending NEITHER a regular Early Childhood Program, NOR a special education program	Parentally placed in Private School
50	Regular Classroom (80% or more)	School Age Codes: 50-57, if 5-years old and enrolled in KG as of December 1 or age 6-22 as of December 1 regardless of grade	Regular Classroom (80% or more)
51	Resource Room (40%-79%)	School Age Codes: 50-57, if 5-years old and enrolled in KG as of December 1 or age 6-22 as of December 1 regardless of grade	Resource Room (40% - 79%)
52	Separate Class (Less than 40%)	School Age Codes: 50-57, if 5-years old and enrolled in KG as of December 1 or age 6-22 as of December 1 regardless of grade	Separate Class (less than 40%)
53	Separate Day School Facility (+50%)	School Age Codes: 50-57, if 5-years old and enrolled in KG as of December 1 or age 6-22 as of December 1 regardless of grade	Separate Day School Facility (+50%)
54	Residential Facility (+50%)	School Age Codes: 50-57, if 5-years old and enrolled in KG as of December 1 or age 6-22 as of December 1 regardless of grade	Residential Facility (+50%)
55	Correctional Facility	School Age Codes: 50-57, if 5-years old and enrolled in KG as of December 1 or age 6-22 as of December 1 regardless of grade	Correctional Facility
56	Parentally Placed in Private School	School Age Codes: 50-57, if 5-years old and enrolled in KG as of December 1 or age 6-22 as of December 1 regardless of grade	Parentally placed in Private School
57	Students Disability requires home services as determined by case conference committee	School Age Codes: 50-57, if 5-years old and enrolled in KG as of December 1 or age 6-22 as of December 1 regardless of grade	Student's disability requires home services

Type/Name for Program Reference

Note the following for reporting Special Education:

1. If student is reporting a SSEPA record, a Student Program record will not be sent. The Student Program record is created by the state using the SSEPA data.
2. If a student is not reporting a SSEPA record, a Student Program record will be sent..

Program Type	Program Name	EdOrg	Logic	GUI Path
Special Education	Choice Voucher	Student School and District 10+DistrictID+SchoolID	Report programType as Special Education in programReference. Report programName as Choice Voucher in programReference. Report the students district+School from their active enrollment In programReference.	Student Information > Special Education> LOCKED IEP> Enrollment Status> Student Placement: Students IEP has to have active dates within the current school year. Students IEP must be locked. Campus Value = Choice Voucher
Special Education	Correctional Facility	Student School and District 10+DistrictID+SchoolID	Report programType as Special Education in programReference. Report programName as Correctional Facility in programReference. Report the students district+School from their active enrollment In programReference.	Index> Student> Special Education> LOCKED IEP> Enrollment Status> Student Placement: Students IEP has to have active dates within the current school year. Students IEP must be locked. Campus Value = Correctional Facility
Special Education	Other Services at Home	Student School and District 10+DistrictID+SchoolID	Report programType as Special Education in programReference. Report programName as Other Services at Home in programReference. Report the students district+School from their active enrollment In programReference.	Student Information > Special Education> LOCKED IEP> Enrollment Status> Student Placement: Students IEP has to have active dates within the current school year (Can start before calendar or end after). Students IEP must be locked. Campus Value = Other at Home Services
Special Education	Other Services at Provider Location	Student School and District 10+DistrictID+SchoolID	Report programType as Special Education in programReference Report programName as Other Services at Provider Location in programReference Report the studnets district+School from their active enrollment In programReference	Student Information > Special Education> LOCKED IEP> Enrollment Status> Student Placement: Students IEP has to have active dates within the current school year. Students IEP must be locked. Campus Value = Other Services at Provider Location
Special Education	Parentally placed in Private School	Student School and District 10+DistrictID+SchoolID	Report programType as Special Education in programReference. Report programName as Parentally Placed in Private School in programReference. Report the students district+School from their active enrollment In programReference.	Student Information > Special Education> LOCKED IEP> Enrollment Status> Student Placement: Students IEP has to have active dates within the current school year. Students IEP must be locked. Campus Value = Parentally Placed in Private School
Special Education	Regular Classroom (80% or More)	Student School and District 10+DistrictID+SchoolID	Report programType as Special Education in programReference. Report programName as Regular Classroom (80% or more) in programReference. Report the students district+School from their active enrollment In programReference.	Student Information > Special Education> LOCKED IEP> Enrollment Status> Student Placement: Students IEP has to have active dates within the current school year. Students IEP must be locked. Campus Value = Regular Classroom (80% or More)
Special Education	Regular Early Childhood, at least 10 hours	Student School and District 10+DistrictID+SchoolID	Report programType as Special Education in programReference. Report programName as Regular early Childhood, at least 10 hours in programReference. Report the students district+School from their active enrollment In programReference.	Student Information > Special Education> LOCKED IEP> Enrollment Status> Student Placement: Students IEP has to have active dates within the current school year. Students IEP must be locked. Campus Value = (Regular Early Childhood, at least 10 Hours
Special Education	Regular Early Childhood, at least 10 hours, other location	Student School and District 10+DistrictID+SchoolID	Report programType as Special Education in programReference. Report programName as Regular early Childhood, at least 10 hours or more, other location in programReference. Report the students district+School from their active enrollment In programReference.	Student Information > Special Education> LOCKED IEP> Enrollment Status> Student Placement: Students IEP has to have active dates within the current school year. Students IEP must be locked. Campus Value = Regular Early Childhood, at least 10 hours, Other Location
Special Education	Regular Early Childhood, Less than 10 hours	Student School and District 10+DistrictID+SchoolID	Report programType as Special Education in programReference. Report programName as Regular early Childhood, Less Than 110 Hours in programReference. Report the students district+School from their active enrollment In programReference.	Student Information > Special Education> LOCKED IEP> Enrollment Status> Student Placement: Students IEP has to have active dates within the current school year. Students IEP must be locked. Campus Value = Regular Early Childhood, Less than 10 hours
Special Education	Regular Early Childhood, less than 10 Hours, Other Location	Student School and District 10+DistrictID+SchoolID	Report programType as Special Education in programReference. Report programName as Regular Early Childhood, Less Than 10 Hours, Other Location in programReference. Report the students district+School from their active enrollment In programReference.	Student Information > Special Education> LOCKED IEP> Enrollment Status> Student Placement: Students IEP has to have active dates within the current school year. Students IEP must be locked. Campus Value = Regular Early Childhood, less than 10 hours, Other Location
Special Education	Residential Facility (+50%)	Student School and District 10+DistrictID+SchoolID	Report programType as Special Education in programReference. Report programName as Residental Facility (+50%) in programReference. Report the students district+School from their active enrollment In programReference.	Student Information > Special Education> LOCKED IEP> Enrollment Status> Student Placement: Students IEP has to have active dates within the current school year. Students IEP must be locked. Campus Value = Residential Facility (+50%)
Special Education	Resource Room (40%-79%)	Student School and District 10+DistrictID+SchoolID	Report programType as Special Education in programReference. Report programName as Resource Room (40%-79%) in programReference. Report the students district+School from their active enrollment In programReference.	Student Information > Special Education> LOCKED IEP> Enrollment Status> Student Placement: Students IEP has to have active dates within the current school year. Students IEP must be locked. Campus Value = Resource Room (40% - 70%)
Special Education	Separate Class (Less than 40%)	Student School and District 10+DistrictID+SchoolID	Report programType as Special Education in programReference. Report programName as Separate Class (Less than 40%) in programReference. Report the students district+School from their active enrollment In programReference.	Student Information > Special Education> LOCKED IEP> Enrollment Status> Student Placement: Students IEP has to have active dates within the current school year. Students IEP must be locked. Campus value = Separate Class (Less than 40%)
Special Education	Separate Day School Facility (+50%)	Student School and District 10+DistrictID+SchoolID	Report programType as Special Education in programReference. Report programName as Separate Day Facility (+50%) in programReference. Report the students district+School from their active enrollment In programReference.	Student Information > Special Education> LOCKED IEP> Enrollment Status> Student Placement: Students IEP has to have active dates within the current school year. Students IEP must be locked. Campus Value = Separate Day School Facility (+50%)
Special Education	Special Education Program, Residential Facility	Student School and District 10+DistrictID+SchoolID	Report programType as Special Education in programReference. Report programName as Special Education Program, Residential Facility in programReference. Report the students district+School from their active enrollment In programReference.	Student Information > Special Education> LOCKED IEP> Enrollment Status> Student Placement: Students IEP has to have active dates within the current school year. Students IEP must be locked. Campus Value = Residential Facility
Special Education	Special Education Program, Separate Class	Student School and District 10+DistrictID+SchoolID	Report programType as Special Education in programReference. Report programName as Special Education Program, Separate Class in programReference. Report the studnents district+School from their active enrollment In programReference.	Student Information > Special Education> LOCKED IEP> Enrollment Status> Student Placement: Students IEP has to have active dates within the current school year. Students IEP must be locked. Campus Value = Separate Class
Special Education	Special Education Program, Separate School	Student School and District 10+DistrictID+SchoolID	Report programType as Special Education in programReference. Report programName as Special Education Program, Separate School in programReference. Report the students district+School from their active enrollment In programReference.	Student Information > Special Education> LOCKED IEP> Enrollment Status> Student Placement: Students IEP has to have active dates within the current school year. Students IEP must be locked. Campus Value = Separate School
Special Education	Private Preschool	Student School and District 10+DistrictID+SchoolID	Report programType as Special Education in programReference. Report programName as Private School in programReference. Report the students district+School from their active enrollment In programReference.	Student Information > Special Education> LOCKED IEP> Enrollment Status> Student Placement: Students IEP has to have active dates within the current school year. Students IEP must be locked. Campus Value = Private School
Special Education	Student's disability requires home services	Student School and District 10+DistrictID+SchoolID	Report programType as Special Education in programReference. Report programName as Student's Disability requires home services in programReference. Report the students district+School from their active enrollment In programReference.	Student Information > Special Education> LOCKED IEP> Enrollment Status> Student Placement: Students IEP has to have active dates within the current school year Students IEP must be locked. Campus Value = Student's disability requires home services
Special Education	undefined	Student School and District 10+DistrictID+SchoolID	Report programType as Special Education in programReference. Report programName as Undefined in programReference. Report the students district+School from their active enrollment In programReference.	Student Information > Special Education> LOCKED IEP> Enrollment Status> Student Placement: Students IEP has to have active dates within the current school year. Students IEP must be locked. Campus Value = Undefined

Previous Versions

Indiana Ed-Fi Data v2.4/3.1 - Student Special Education Program Associations [Campus.2144-2219]