Nebraska 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	Trigger
Post	When an IEP is created and locked for a student. IEP must overlap an enrollment. Only 1 record will report per school year. If the student has multiple enrollments that are overlapping in the same school and year, report based on primacy of Service Type: P: Primary S: Partial 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. Enrollment start date must be after IEP start date. IEP end date must be NULL or after Enrollment start date.
Delete/Post	When any field part of the natural key is changed: When a SPED Setting is changed in an existing IEP, and is re-locked). When a SPED Entry Date is changed.
Put	When any field not part of the natural key is changed: endDate reasonExitedDescriptor levelOfProgramParticipationDescriptor placementTypeDescriptor specialEducationPercentage toTakeAlternateAssessment serviceDescriptor serviceBeginDate serviceEndDate
Delete	The locked IEP is deleted for a student.
Delete	A SPED Setting is changed for a student.
Delete	A Sped Entry Date is changed for a student.
Delete	All overlapping enrollments are deleted for a school.
Delete	When an IEP is unlocked it will delete.

School Exclude, Calendar Exclude, Resource Toggle and 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
When a new IEP is created, the record will report in the Scope Year(s) the IEP has overlapping enrollments with.
Data will only send for the years that have valid configuration.

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
educationOrganization Reference	The education organization where the student is participating in or receiving the program services.	Report the School the student's enrollment is associated. The School ID is a concatenation of the State District Number + State School Number. If the program is SPED, 504, Title I part A or Homeless, report only DistrictID + 000.	M	System Administration> Resources> District Information> State District Number + System Administration> Resources> School> State School Number	district.number + school.number
programReference	A reference to the related Program resource.	Reports the Natural Key from the Programs resource.	M
studentReference	A reference to the related Student resource.	Reports the Natural Key from the Student resource.	M
beginDate	The month, day, and year on which the student first received services.	First look at the most recent locked IEP's Enrollment Status editor > 'Entry Date' If <>NULL, report out value. If the IEP's Enrollment Status editor's 'Entry Date' is NULL, look at the Enrollment > Special Ed Fields > 'Entry Date' for the enrollment being reported and iIf the Enrollment > Special Ed Fields > 'Entry Date' <>NULL, report out the value. If 'Entry Date' is NULL, use the following logic: Look at all calendars for all grades within student's enrollment history to verify first locked reported IEP of IFSP. The date reported should be the start date located in the Education Plan editor for both the IEP and the IFSP. Report within the fiscal calendar 07/01-06/30.	M	Student Information > General > Enrollments > Special Ed Fields > Entry Date Student Information > Special Ed > Documents > Plan > Current Plan > Education Plan > Start Date
endDate	The month, day, and year on which the student exited the program or stopped receiving services.	Report the Special Ed Exit Date if populated on the overlapping enrollment record. If a new enrollment record is created with a Start Date after the Special Ed Exit Date, and the enrollment overlaps the locked IEP, then report the Special Ed Exit Date from the new enrollment; If NULL, report End Date as blank. If a new enrollment record is created that does not overlap the IEP, do not update the endDate. If the enrollment is deleted, the end date reported would revert to the value saved in the previous (overlapping) enrollment. If a previous year's record was closed without an end date and the school year has changed from the year that the record was created, do not report. Report within the fiscal calendar 07/01-06/30.	C	Student Information > General > Enrollment > Special Ed > Exit Date
reasonExitedDescriptor	Reports the reason the student exited from SPED.	Report the Ed-Fi Code from the Special Ed Exit Reason if populated on the overlapping enrollment being reported. If a new enrollment record is created with a Start Date after the Special Ed Exit Date, and the enrollment overlaps the locked IEP, then report the Special Ed Exit Reason from the new enrollment; If NULL, report Special Ed Exit Reason as blank. If a new enrollment record is created that does not overlap the IEP, do nothing; If the enrollment is deleted, the Special Ed Exit Reason reported would revert to the value saved in the previous (overlapping) enrollment.	C	Student Info > General > Enrollment> Current Enrollment > Special Ed > Special Ed Exit Reason
servedOutsideOf RegularSession	Indicates whether the student received services during the summer session or between sessions.	This is optional, do 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).	This is optional, do not report.	O
specialEducationSetting Descriptor	Reports the Special Education setting for the student.	Report the Ed-Fi code from the Special Ed Setting code selected in the locked IEP being reported.	M	Student Information > General > SPED > Documents > Plan > Enrollments > Special Ed Setting
specialEducationHours PerWeek	The number of hours per week for special education instruction and therapy.	This is optional, does not report.	M	Student Info> Special ED> General> IEP> Program Participation> Hours Per Week
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.	M	Student Info > Special ED> General > IEP > Program Participation
multiplyDisabled	Indicates whether the student receiving special education and related services has been designated as multiply disabled by the admission, review, and dismissal committee.	This is optional, do 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.	This is optional, do not report.	O
lastEvaluationDate	The date of the last special education evaluation.	This is optional, do not report.	O
iepReviewDate	The date of the last IEP review.	This is optional, do not report.	O
iepBeginDate	The effective date of the most recent IEP.	This is optional, do not report.	O
iepEndDate	The end date of the most recent IEP.	This is optional, do not report.	O
specaileducationprogram descritpor	Provides additional information regarding the student's level of participation in the program.	Report out the value based on the student's age as of August 31st of the reporting year. If the student is/will be 3 years of age or older as of August 31st, then report out '05'. If the student is/will be younger than 3 years of age as of Augst 31st, then report out '06'.	M
placementType Descriptor	Indicates placement type of the student.	Report Ed-Fi code from the Primary Placement Type selected in the enrollment being reported. If blank, report '0'.	M	Student Info > General > Enrollment > Current Enrollment > Special Ed > Primary Placement Type
toTakeAlternateAssessment	True = Indicates the student needs alternate assessment.	Report based on the locked IEP. If the 'Alternate Assessment' checkbox is selected, report "True". If the Alternate Assessment' .checkbox is not selected, OR there is no IEP, report "False".	M	Student Information > Special Ed > Documents > IEP > Plan Outline neIEP > Dist-Wide Assessments > Alternate Assessments
services	An unordered collection of studentProgramAssociationServices. This association represents the Special Education program(s) that a student participates in or receives services from.	Look at array logic.	O
disabilities	An unordered collection of studentDisabilities. This entity represents an individual for whom instruction, services and/or care are provided in an early childhood, elementary or secondary educational program under the jurisdiction of a school, education agency or other institution or program. A student is a person who has been enrolled in a school or other educational institution.	Report the Ed-Fi Code Value from the Disability Descriptor page linked below under Type/Descriptors NE based on the Ed-Fi code value for each disability the student meets. See the Array section below for Disabilities for full reporting requirements. Core solution allows up to 5 disabilities to report however NE only collects 3.	C	Student Information > General > Special Ed > Documents > IEP	enrollment.disability1 enrollment.disability2 enrollment.disability5
serviceProviders	An unordered collection of studentSpecialEducationProgram AssociationServiceProviders. This association represents the Special Education program(s) that a student participates in or receives services from.	This is optional, do not report.	O

Array

studentProgramAssociationService

Data Element Label	Logic	M, C or O	Data Source GUI Path
serviceDescriptor	When the locked IEP contains services with an EdFi code value Otherwise ignore the record.	M	Student Information > Special Ed > Documents > IEP > Plan Outline neIEP > Sped Services/Related Services
primaryIndicator	Does not report.	O
serviceBeginDate	Report the Start Date value of the service being reported.	O	Student Information > Special Ed > Documents > IEP > Plan Outline neIEP > Sped Services/Related Services
serviceEndDate	Report the End Date value of the service being reported.	O	Student Information > Special Ed > Documents > IEP > Plan Outline neIEP > Sped Services/Related Services

studentSpecialEducationProgramAssociationDisability

Data Element Label	Business Requirement	Logic	M, C or O	Data Source GUI Path	Database Field
disabilityDescriptor	A disability category that describes a child's impairment.	Report the Ed-Fi code from the Disabilities for the student being reported. The student must have a locked IEP which overlaps In the current year: the student's enrollment end date. Or if NULL, today's date. In previous scope years: the student's enrollment endb date Or if NULL, the last instructional date of the year for previous scope years. The IEP must overlap with the student's enrollment record If the student has a Special Education Exit Date that is on or before today's date; If the SPED Exit date is on or after the enrollment end date, continue to report disabilities. If the Enrollment has not ended OR the SPED Exit date is before the enrollment end date, do not report a disability If the student has more than 1 disability, report each disability up to 3 disabilities.	M	Special Ed> Documents> Plan> IEP> Primary Disability, Secondary Disability, Tertiary Disability, Fourth Disability, Fifth Disability	planstate.disability1 planstate.disability2 planstate.disability3 planstate.disability4 planstate.disability5
disabilityDiagnosis	A description of the disability diagnosis.	Does not report.	O
orderOfDisability	The order by severity of student's disabilities: 1- Primary, 2 - Secondary, 3 - Tertiary, etc	Report the order of disability based on the disability being reported from above. If Primary Disability, report '1'. if Secondary Disability, report '2'. if Fifth Disability, report '3'.	O
disabilityDeterminationSourceType	The source that provided the disability determination.	Does not report.	O

Type/Descriptor

Reason Exited Descriptor

Ed-Fi Code Value	Short Description	Description
01	Died or is permanently incapacitated	Died or is permanently incapacitated
02	Discontinued schooling	Discontinued schooling
03	Graduated with a high school diploma	Graduated with a high school diploma
04	Moved out of state	Moved out of state
05	Other	Other
06	Reached maximum age	Reached maximum age
07	Received cert of completion, modified diploma, or finished IEP requirements	Received certificate of completion, modified diploma, or finished IEP requirements
08	Suspended or expelled from school	Suspended or expelled from school
09	Transferred to another district or school	Transferred to another district or school
10	Unknown reason	Unknown reason
11	Withdrawal by a parent (or guardian)	Withdrawal by a parent (or guardian)
SPED01	Transferred to another school district	Transferred to another school district in Nebraska and continues with Early Intervention Services
SPED02	Returned to full-time regular education program	Returned to full-time regular education program. Include students with a disability whose parent revokes consent for special education and related services.
SPED03	Graduated with a regular high school diploma	Graduated with a regular high school diploma
SPED04	Received a certificate of completion	Received a certificate of completion
SPED05	Reached maximum age	Reached maximum age
SPED06	Deceased	Deceased
SPED07	Dropped Out	Dropped Out
SPED09	Withdrawn by parent	Withdrawn by parent
SPED11	Transferred to another school district (Moved known to be continuing)	Transferred to another school district (Moved known to be continuing)
SPED12	Completion of the IFSP prior to the age of 3 years old	Completion of the IFSP prior to the age of 3 years old
SPED13	Exit to other program	Exit to other program, reached age 3 years old, re-evaluated and found no longer eligible for Special Education Services
SPED14	Exit with no referral	Exit with no referral, reached age 3 years old, re-evaluated and found no longer eligible for Special Education Services
SPED16	Moved out of state	Moved out of state
SPED17	Attempts to contact parents unsuccessful	Attempts to contact parents unsuccessful

Special Education Setting Descriptor

Ed-Fi Code Value	Ed-Fi Short Description	Ed-Fi Description
01	Home - not School Aged	Home - not School Aged
02	Community Based - not School Aged	Community Based - not School Aged
03	Other - not School Aged	Other - not School Aged
05	Separate School	Separate School
06	Separate Class	Separate Class
07	Residential Facility	Residential Facility
08	Home - School Aged	Home - School Aged
09	Service Provider Location	Service Provider Location
10	Public School	Public School
13	Homebound/Hospital	Homebound/Hospital
14	Private School or Exempt (Home) School	Private School or Excempt (Home) School
15	Correction/Detention Facility	Correction/Detention Facility
16	Regular Early Childhood Program, 10+ h/wk; Services at EC Program	Regular Early Childhood Program, 10+ h/wk; Services at EC Program
17	Regular Early Childhood Program, 10+ h/wk; Services outside EC Program	Regular Early Childhood Program, 10+ h/wk; Services outside EC Program
18	Regular Early Childhood Program, LT 10 h/wk; Services at EC Program	Regular Early Childhood Program, LT 10 h/wk; Services at EC Program
19	Regular Early Childhood Program, LT10 h/wk; Services outside EC Program	Regular Early Childhood Program, LT10 h/wk; Services outside EC Program
20	Public Sool - inside regular class 80% or more of the day	Public School - inside regular class 80% or more of the day
21	Public School - Inside regular class 40% through 79% of the day	Public School - Inside regular class 40% through 79% of the day
22	Public School - inside regular class less than 40% of the day	Public School - inside regular class less than 40% of the day

Level of Program Participation Descriptor

Ed-Fi Code Value	Ed-Fi Short Description	Ed-Fi Descriptionk
05	IDEA Part B	IDEA Part B
06	IDEA Part C	IDEA Part C

Placement Type Descriptor

Ed-Fi Code Value	Ed-Fi Short Description	Ed-Fi Description
0	Not Applicable	Not Applicable – Does not attend a Nonpublic School
1	Nonpublic Placement - Parental Placement	Nonpublic Placement - Parental Placement
2	Nonpublic Placement - Other than Parental Placement	Nonpublic Placement - Other than Parental Placement
3	Nonpublic Placement – Parent Placemnt SPED Svcs from Res Dist Stud on IEP	Nonpublic Placement – Parental Placement, Special Education Services from Resident District, Student on IEP
4	Nonpublic Placement – Parent Placemnt SPED Svcs Stud on Equitable Svcs Plan	Nonpublic Placement – Parental Placement, Special Education Services, Student on Equitable Services Plan