Michigan Ed-Fi Data v3.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	Business Rules
Post	Special Education: When a student in the year and calendar reporting has the following: 1. A locked IEP: a). IEP has a Special Ed Program(s) mapped to a state code with an Ed-Fi Code. b). Print Format: ‘miIEP%’. 2. A locked NPSP: a). NPSP has a Special Ed Program(s) mapped to a state code with an Ed-Fi Code. b). Print Format: 'miNPSP%' IEP/NPSP must overlap an enrollment. An IEP will trump an IFSP if more than one document is found with the same Start Date. If the student has multiple enrollments that are overlapping in the same school and year, report based on Service Type: 1. P: Primary 2. S: Partial 3. N: Special Ed If the student only has one enrollment, report a record regardless of Service Type. Do not send a student record for an enrollment that is marked as State Exclude or No Show. 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.
Post	When a new enrollment is created for a student that has an active IEP/IFSP: Enrollment start date must be after IEP/IFSP start date. IEP/IFSP end date must be NULL or after Enrollment start date.
Delete/Post	When any part of the natural key is changed: When a SPED Entry Date is changed (see reporting logic below in beginDate)
Put	When any field that is not part of the natural key is changed, including the following: endDate reasonExitedDescriptor section52FTE section53FTE
Put	Fields in the Evaluation/ESR will trigger a Put: partCTransitionTimelinessDescriptor resultOfInitialIEPDescriptor timelinessOfInitialIEPDescriptor initialIEPCompletionDate
Delete	A Sped Start Date is changed for a student.
Delete	All overlapping enrollments are deleted for a school.

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.

Scope Year Logic

This table describes scope year logic of this object.

Logic
SPED: Record will report for each year where an active IEP or IFSP record exists.
IEP/IFSP Start or End Date must occur within the Scope Year.
IEP/IFSP must have at least one Special Ed Program or Early Intervention Service with Start or End Date that occurs within the Scope Year.
If the school year Start and End Date = Null, then report 07/01/XXXX as the Start Date and an End Date of 06/30/XXXX.

Object Data Elements

This table describes data elements sent within the Student Special Education Program Associations resource.

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
id	The unique identifier of the resource.		M
educationOrganization Reference	A reference to the related EducationOrganization resource.	Report the State School Number. If student has multiple enrollments report first from: P: Primary S: Partial N: Special Ed	M
programReference	A reference to the related Program resource.	Report Special Education Program reference.	M
studentReference	A reference to the related Student resource.	Reports the data that is part of the Natural Key for the Student resource.	M
beginDate	The month, day, and year on which the Student first received services.	Report Start Date of IEP/NPSP. printedFormat: ‘miIEP%’, 'miNPSP%'	M	Student Information > SPED > Docs > IEP/NPSP/IFSP > Start Date	Plan.startDate
endDate	The month, day, and year on which the Student exited the Program or stopped receiving services.	Report Special Ed Exit Date. If there are multiple resources for the student, report in resource with most recent Begin Date prior to Exit Date.	O	Student Information > General> Enrollments > SPED > Special Ed Exit Date	Enrollment.spedExit Date
reasonExitedDescriptor	A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.	Report mapped Ed-Fi Code of Special Ed Exit Reason If there are multiple resources for the student, report in resource with most recent Begin Date prior to Exit Date.	O	Stu Info > General> Enrollments > SPED > Exit Reason	Enrollment.spedExit Reason
servedOutsideOfRegular Session	Indicates whether the student received services during the summer session or between sessions.	This is optional, does not report.	O
enrollmentStatus		This is optional, does not report.	O
partCTransitionTimeliness Descriptor	This descriptor holds the description of the timeliness of the IEP by the students's third birthday for all students referred by Part C as potentially eligible for Part B.	Report mapped Ed-Fi Code of Part C Transition Timeliness.	O	Student Information > SPED> Docs > Evaluation	Evaluation. timeliness
resultOfInitialIEPDescriptor	This descriptor holds the description of the outcome of the initial IEP determining if the student is eligible or ineligible for special education programs and services.	Report mapped Ed-Fi Code of Initial Eval Result.	O	Student Information > SPED> Docs > Evaluaion	Evaluation.eval Result
specialEducationSetting Descriptor	This descriptor defines the major instructional setting (more than 50 percent of a student's special education program).	Report Special Ed Setting. printedFormat: 'miNPSP%', 'miIFSP%'	O	Student Information > SPED > Docs > IEP/NPSP > enrollment status > Special Ed Setting	PlanState.special EdSetting
timelinessOfInitialIEP Descriptor	This descriptor holds the description of the timeliness status for the evaluation of eligibility.	Report mapped Ed-Fi Code of Evaluation Compliance.	O	Student Information > SPED > Docs > Eval > Evaluation Compliance	Evaluation.eval Compliance
typeOfPlanDescriptor	To indicate the type of plan a child is receiving services under.	If plan = IEP, report 02. If plan = NPSP, report 03. printedFormat: ‘miIEP%’, 'miNPSP%',	O	Student Information > SPED > Docs	PlanType.printed Format
ideaEligibility	Indicator of the eligibility of the student to receive special education services according to the Individuals with Disabilities Education Act (IDEA).	This is optional, does not report.	O
specialEducationHours PerWeek	The number of hours per week for special education instruction and therapy.	This is optional, does not report.	O
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
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
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
lastEvaluationDate	The date of the last special education evaluation.	This is optional, does not report.	O
iepReviewDate	The date of the last IEP review.	This is optional, does not report.	O
iepBeginDate	The effective date of the most recent IEP.	Report Start Date of IEP/NPSP. printedFormat: ‘miIEP%’, 'miNPSP%',		Student Information > SPED > Docs > IEP/NPSP/IFSP > Start Date	Plan.startDate
iepEndDate	The end date of the most recent IEP.	Report End Date of IEP/NPSP. printedFormat: ‘miIEP%’, 'miNPSP%',		Student Information > SPED > Docs > IEP/NPSP/IFSP > End Date	Plan.endDate
planDate	The date of the notice/offer of a Free Appropriate Public Education (FAPE) associated with the student's most recent individualized education program (IEP).	If reporting from an IEP/NPSP Report Offer of a FAPE.		Student Information > SPED > Docs > IEP/NPSP > Offer of a FAPE	For planType.printed Format starts with "miIEP" or "miNPSP", SEPlan. fapeOfferDate.
section52FTE	The full-time equivalency (FTE) for which the student is eligible for special education programs or services provided only to students with disabilities who do not qualify for Section 52 membership.	Reports Section 52 FTE.		Student Information > General > Enrollments > SPED > Section 52 FTE	CustomStudent value for enrollment. fteSection52
section53FTE	The full-time equivalency (FTE) for which the student is eligible for special education programs or services provided only to students with disabilities who do not qualify for Section 53 membership.	Reports Section 53 FTE		Student Information > General > Enrollments > SPED > Section 53 FTE	CustomStudent value for Enrollment.fte Section53
dateOfParentalConsent	The date on which the entity received the signed Parental Consent to Evaluate form. It is the beginning of the timeline for completion of the initial IEP.	Report Consent Date. printedFormat: miESR12, zzESREval Reports from most recent ESR prior to or on the Start Date of the IEP. Use ESR Consent Date to determine.		Student Information > General > Special Ed > Documents Tab > Evaluation > Consent Date	Evaluation.consent Date
daysBeyondTimeline	The number of calendar days that the evaluation and completion of the initial IEP went beyond the 30 school-day timeline or agreed- upon written extension.	If Extension Days is > 0, report DaysBeyondTimeline with corresponding integer. If Extension Days is = 0 or NULL, this field should not be included. printedFormat: miESR12, zzESREval Reports from most recent ESR prior to or on the Start Date of the IEP. Use ESR Consent Date to determine.		Student Information > General > Special Ed > Documents Tab > Evaluation > Extension Days	Evaluation. extensionDays
initialIEPCompletionDate	The completion of an initial individualized education program (IEP) is the date on the notice of the offer of a free appropriate public education (FAPE).	Report FAPE Date. printedFormat: miESR12, zzESREval Reports from most recent ESR prior to or on the Start Date of the IEP. Use ESR Consent Date to determine.		Student Information > SPED > documents > eval > FAPE Date	Evaluation.fape OfferDate
additionalPlanDate	If a student has had more than plan conducted since s/he was last reported, districts may utilize this characteristic to report the additional plan dates between the previous and current plan.	This is optional, does not report.
specialEducationProgram Services	An unordered collection of studentProgramAssociationServices. Indicates the services being provided to the student by the program.	See array for field logic.
programSupports	An unordered collection of studentSpecialEducationProgram AssociationProgramSupports. (MI EXT) Support services student receives through program.	See array for field logic.
serviceProviders	An unordered collection of studentSpecialEducationProgram AssociationServiceProviders. The staff providing Special Education services to the student.	This is optional, does not report.
disabilities	The disability condition(s) that best describes an individual’s impairment, as related to special education services received.	See array for field logic.
placedByAnotherDistIEP	Indicates when the student, as stipulated in his/her current IEP, participates in a center program, a cooperative-agreement program designed specifically for special education students or a cross-district special education program.	If overlapping enrollment Start Status = 21 and Special Ed Status = 1, report true.		Student Information > general > enrollments

Arrays

Special Education Program Services

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
specialEducationProgram ServiceDescriptor	The ID of the Service Descriptor.	IEP/NPSP: Report the Ed-Fi Code associated with the assigned Special Education Program service. Service must be active at least one day in the Scope Year to report. printedFormat: ‘miIEP%’, 'miNPSP%',	M	Student Information > SPED > Docs > IEP/NPSP > Special Ed Program	PlanService.stateCode
primaryIndicator	True if service is a primary service.,	Optional, do not report.	O
serviceBeginDate	First date the Student was in this option for the current school year.,	Report service Start Date.	M		PlanServiceProvided. startDate
serviceEndDate	Last date the Student was in this option for the current school year.	Report service End Date.	O		PlanServiceProvided. endDate

Program Supports

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
programSupportDescriptor	The ID of the Service Descriptor.	IEP/NPSP: 1. Report the Ed-Fi Code associated with the assigned Related Service. 2. Service must be active at least one day in the Scope Year to report. printedFormat: ‘miIEP%’, 'miNPSP%'.	M	Student Information > SPED > Docs > IEP/NPSP > Related Service	PlanService.stateCode

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source GUI Path

Database Field

programSupportDescriptor

The ID of the Service Descriptor.

IEP/NPSP:

1. Report the Ed-Fi Code associated with the assigned Related Service.

2. Service must be active at least one day in the Scope Year to report.

printedFormat: ‘miIEP%’, 'miNPSP%'.

Student Information > SPED > Docs > IEP/NPSP > Related Service

PlanService.stateCode

Disabilities

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path
disabilityDescriptor	A disability category that describes a child’s impairment.	Report mapped Ed-Fi Code for Primary Disability or Additional Disability.	M	Student Information > SPED > Docs > IEP/NPSP > Enrollment Status
disabilityDeterminationSource TypeDescriptor	The source that provided the disability determination.	This is optional, does not report.	O
disabilityDiagnosis	A description of the disability diagnosis.	This is optional, does not report.	O
orderOfDisability	The order by severity of student’s disabilities: 1- Primary, 2 - Secondary, 3 - Tertiary, etc.	If reporting Primary Disability, report '1' If reporting Additional Disability, report '2'	O	Student Information > SPED > Docs > IEP/NPSP > Enrollment Status
designations	Whether the disability is IDEA, Section 504, or other disability designation.	This is optional, does not report.	O

Type/Descriptor

Service Descriptor

Ed-Fi Code Value	Short Description	Description
110	Programs for Mild Cognitive Impairment	Programs for Mild Cognitive Impairment
120	Programs for Moderate Cognitive Impairment	Programs for Moderate Cognitive Impairment
130	Programs for Severe Cognitive Impairment	Programs for Severe Cognitive Impairment
140	Programs for Emotional Impairment	Programs for Emotional Impairment
150	Programs for Learning Disabled	Programs for Learning Disabled
160	Programs for Hearing Impairment	Programs for Hearing Impairment
170	Programs for Visual Impairment	Programs for Visual Impairment
180	Programs for Physical or Other Health Impairment	Programs for Physical or Other Health Impairment
190	Programs for Severe Multiple Impairment	Programs for Severe Multiple Impairment
191	Early Childhood Special Education (Classroom) Program	Early Childhood Special Education (Classroom) Program
192	Programs for Severe Language Impairment	Programs for Severe Language Impairment
193	Programs for Autism Spectrum Disorder	Programs for Autism Spectrum Disorder
194	Elementary or Secondary-Level Resource Program	Elementary or Secondary-Level Resource Program
270	Early Childhood Special Education Services	Early Childhood Special Education Services

Special Ed Setting Descriptor

Ed-Fi Code Value	Short Description	Description
02	Public or Private Special Education School Building at Public Expense	Public or Private Special Education School Building at Public Expense
03	Public or Private Residential Facility at Public Expense	Public or Private Residential Facility at Public Expense
05	Correctional Facility	Correctional facility including juvenile detention facilities (community-based, community jail or residential)
06	Homebound/Hospitalized	The student receives special education and related services at home or in hospital facilities because of illness.
07	Private or Home School at Private/Parent Expense	Parentally Placed in Private or Home School at Private/Parent Expense
11	Inside the Gen Ed Classroom 80% or more	The student remains in the general education setting for greater than or equal to 80 percent of the school day.
12	Inside the Gen Ed Classroom 40% - 79% of school day	The student remains in the general education setting for less than 80 percent of the school day and greater than or equal to 40 percent of the school day.
13	Inside the Gen Ed Classroom less than 40% of school day	The student remains in the general education setting for less than 40 percent of the school day.
22	Early Childhood Special Education Program	Special education services designed primarily for children with disabilities provided by a program housed in regular school buildings or other community based settings.
23	Home	The student receives his/her special education and related services in the principal residence of the child's families or caregivers.
25	Residential Facility	Publicly or privately operated residential school or residential medical facility on an inpatient basis.
26	Separate School	Public or private day school designed specifically for children with disabilities.
27	Service Provider Location	Service Provider Location
31	Home	Home
38	Other	Setting that is not home or community-based.
41	Community-based	Community-based
46	A1	Regular EC program at least 10 hrs/wk, majority of SE hrs. in EC program (A1)
47	A2	Regular EC program at least 10 hrs/wk, majority of SE hrs. in other location (A2)
48	B1	Regular EC program less than 10 hrs/wk, majority of SE hrs. in EC program (B1)
49	B2	Regular EC program less than 10 hrs/wk, majority of SE hrs. in other location (B2)

Program Support Descriptor

Ed-Fi Code Value	Short Description	Description
200	Teacher Consultant (T.C.)	Autism Spectrum Disorder MARSE R340.1749
210	T.C. Mentally Impaired	MARSE R340.1749
220	T.C. Emotionally Impaired	MARSE R340.1749
230	T.C. Learning Disabled	MARSE R340.1749
240	T.C. Hearing Impaired	MARSE R340.1749
250	T.C. Visually Impaired	MARSE R340.1749
261	T.C. Physical Impairment	MARSE R340.1749
262	T.C. Other Health Impairment	MARSE R340.1749
280	Homebound/Hospitalized	MARSE R340.1746
290	Speech and Language Impaired	MARSE R340.1745
291	Adaptive Physical Education	Instruction in physical education to students with disabilities receiving special education programs/services (pupils whose disabilities preclude integration into regular physical education classes).
310	School Social Worker	MARSE R340.1011Ã¢â‚¬â€œR340.1018. To be counted as a special service, the school social work service must be listed as a service on the student's IEP.
320	School Psychologist	MARSE R340.1151Ã¢â‚¬â€œR340.1158. To be counted as a special education service, school psychological services must be listed as a service on the student's IEP.
360	Occupational Therapy	Occupational therapy deals with improving, developing or restoring functions impaired or lost through illness, injury or deprivation; improving ability to perform tasks for independent functioning when functions are impaired or lost; and preventing, through early intervention, initial or further impairment or loss of function.
370	Physical Therapy	Physical therapy is defined in the Michigan Public Health code under Section 17801. Services are provided by a licensed physical therapist.
383	Music Therapy	Music therapy activities are provided to students with disabilities receiving special education programs/services by a certified music therapist.
390	Art Therapy	Art therapy activities are provided to students with disabilities receiving special education programs/services by a certified art therapist.
400	Audiological Services	Audiological services are services provided by an audiologist to identify students with hearing loss and provide rehabilitation and counseling concerning hearing loss.
406	Interpreter for the Deaf	Services provided by a qualified interpreter who assists the student with a hearing impairment and school personnel with communication.
410	Recreation Service	Recreation services are the assessment of a student's leisure functioning, providing therapeutic recreation services, participation in a recreation program in a school designed specifically for students with disabilities receiving special education programs/services, or providing leisure education.
440	Special Transportation	Special transportation must be provided in an approved school vehicle in a regular seat, wheelchair or an approved baby seat. This specifically excludes students who need ambulance service, a medical attendant or other care outside the responsibility of the schools.
450	School Health Services	School health services must be provided by a qualified school nurse or other qualified person. To be counted as a special education service, the school nurse must be working solely with students with disabilities receiving special education programs/services or the service should be indicated in the student's IEP.
460	Rehabilitation Counseling Services	The student receives counseling services provided by a qualified rehabilitation counseling professional. Such services are intended to explore the effect of the student's disability on employment and other post-school activities, which include vocational programs funded by Michigan Rehabilitation Services or the Michigan Commission for the Blind.
470	Orientation & Mobility Services	Orientation and mobility instruction for the visually impaired must be provided by an approved orientation and mobility instructor.
480	Worksite Ã¢â‚¬â€œ Based Learning	Worksite-based learning means transition services, such as on-the-job training, related counseling and follow-up services. A written agreement plan is required as specified in MARSE R340.1733 (i).
490	Community Training/Vocational Education (General Education)	Students with disabilities receiving special education programs/services who also receive vocational training in a community setting or individual vocational training program at a worksite with non-disabled peers.
491	Special Needs (Adapted Vocational Ed.)	Alteration of a vocational education program is being provided by general education to accommodate different needs of a student with disabilities receiving special education programs/services.
492	Individual Vocational Education	Training programs designed to fit the special interests of a student with disabilities receiving special education programs/services that are generally not available in a general-education vocational program.
493	Community Training/Vocational Education (Special Education)	Students with disabilities receiving special education programs/services who receive vocational training in a community setting or individual vocational training program at a work site primarily with peers with disabilities receiving special education programs/services.

Reason Exited Descriptor

Ed-Fi Code Value	Short Description	Description
30	IEP team determined student no longer in need of special education service	The child or student was exited from special education programs and/or services after the IEP team determined that s/he no longer met the criteria to be eligible for special education programs or services.
31	Parent revoked consent for student to receive special education services	The student was exited from special education programs or services because his/her parent or guardian revoked his/her consent for the student to participate in special education programs and/or services.

Ed-Fi Code

Value

Short Description

Description

IEP team determined student no longer in need of special education service

The child or student was exited from special education programs and/or services after the IEP team determined that s/he no longer met the criteria to be eligible for special education programs or services.

Parent revoked consent for student to receive special education services

The student was exited from special education programs or services because his/her parent or guardian revoked his/her consent for the student to participate in special education programs and/or services.

Part C Transition Timeliness Descriptor

Ed-Fi Code Value	Short Description	Description
50	IEP on or before child's third birthday	IEP held on or before the child's third birthday
53	IEP after child's 3rd birthday: Parent did not make child available	IEP held after the child's third birthday: Parent did not make child available
54	IEP after child's 3rd birthday: Timeline began in previous district	IEP held after the child's third birthday: Timeline began in previous district
55	IEP after child's 3rd birthday: Personnel not available for evaluation	IEP held after the child's third birthday: Personnel not available for evaluatioN
56	IEP after child's 3rd birthday: Personnel not available for IEP	IEP held after the child's third birthday: Personnel not available for IEP
57	IEP after child's 3rd birthday: External reports not available	IEP held after the child's third birthday: External reports not available
61	IEP after child's 3rd birthday: Late Notification from Part C to Part B LEA	IEP held after the child's third birthday: Late Notification from Part C to Part B LEA
62	IEP after child's 3rd birthday: Late referral to Part C	IEP held after the child's third birthday: Late referral to Part C

Result of Initial IEP Descriptor

Ed-Fi Code Value	Short Description	Description
1	Student was found eligible	The student was evaluated and found eligible for special education programs and/or services.
2	Student was found not eligible	The student was evaluated and found not eligible for special education programs and/or services.
3	Student found eligible, services refused	The student was evaluated and found eligible for special education programs and/or services; however, the parent or guardian refused special education programs and services.

Type Of Plan Descriptor

Ed-Fi Code Value	Short Description	Description
1	IFSP	IFSP
2	IEP	IEP
3	Non Public Service Plan	Non Public Service Plan