Nebraska Ed-Fi Data v3.1 - Student Special Education Program Associations

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 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
DeleteThe locked IEP is deleted for a student.
DeleteA SPED Setting is changed for a student.
DeleteA Sped Entry Date is changed for a student.
DeleteAll overlapping enrollments are deleted for a school.
DeleteWhen 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.

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
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 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

educationOrganization
Reference
The education organization where the student
is participating in or receiving the program services.
  1. Report the School the student's enrollment is associated.
    • The School ID is a concatenation of the State District Number + State School Number.
  2. 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

programReferenceA reference to the related Program resource.

Reports the Natural Key from the Programs resource.

M

studentReferenceA reference to the related Student resource.

Reports the Natural Key from the Student resource.

M

beginDateThe month, day, and year on which the student
first received services.
  1. First look at the most recent locked IEP's Enrollment Status editor > 'Entry Date' If <>NULL, report out value.
  2. 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.
  3. 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.
  4. 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


endDateThe 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.
  1. 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.
  2. If a new enrollment record is created that does not overlap the IEP, do not update the endDate.
  3. If the enrollment is deleted, the end date reported would revert to the value saved in the previous (overlapping) enrollment.
  4. 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.
  5. Report within the fiscal calendar 07/01-06/30.
C

Student Information > General > Enrollment > Special Ed > Exit Date


reasonExitedDescriptorReports 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.
  1. 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;
    1. If NULL, report Special Ed Exit Reason as blank.
  2. If a new enrollment record is created that does not overlap the IEP, do nothing;
  3. If the enrollment is deleted, the Special Ed Exit Reason reported would revert to the value saved in the previous (overlapping) enrollment.
CStudent 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

ideaEligibilityIndicator 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.

MStudent 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.

MStudent Info> Special ED> General> IEP> Program Participation> Hours Per Week
schoolHoursPerWeekIndicate the total number of hours of instructional
time per week for the school that the student
attends.
This is optional, does not report.
MStudent Info > Special ED> General > IEP > Program Participation
multiplyDisabledIndicates 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

medicallyFragileIndicates 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

lastEvaluationDateThe date of the last special education evaluation.

This is optional, do not report.

O

iepReviewDateThe date of the last IEP review.

This is optional, do not report.

O

iepBeginDateThe effective date of the most recent IEP.

This is optional, do not report.

O



iepEndDateThe 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.
  1. If the student is/will be 3 years of age or older as of August 31st, then report out '05'.
  2. 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.
  1. If blank, report '0'.
MStudent Info > General > Enrollment > Current Enrollment > Special Ed > Primary Placement Type
toTakeAlternateAssessmentTrue = Indicates the student needs
alternate assessment.
  1. 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".
MStudent Information > Special Ed > Documents > IEP > Plan Outline neIEP > Dist-Wide Assessments > Alternate Assessments
servicesAn 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

disabilitiesAn 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.
  1. 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.
  2. 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.
CStudent Information > General > Special Ed > Documents > IEP

enrollment.disability1

enrollment.disability2

enrollment.disability5

serviceProvidersAn unordered collection of studentSpecialEducationProgram
AssociationServiceProviders. This association represents the Special Education program(s) that a student participates in or receives services from.
  1. This is optional, do not report.
O

Array

Click here to expand...

studentProgramAssociationService

Data Element LabelLogicM, C or O

Data Source GUI Path

Database Field
serviceDescriptor 
  1. When the locked IEP contains services with an EdFi code value
    1. Otherwise ignore the record.
MStudent 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.OStudent Information > Special Ed > Documents > IEP > Plan Outline neIEP > Sped Services/Related Services
serviceEndDate Report the End Date value of the service being reported.OStudent Information > Special Ed > Documents > IEP > Plan Outline neIEP > Sped Services/Related Services

studentSpecialEducationProgramAssociationDisability

Data Element LabelBusiness RequirementLogicM, C or O

Data Source GUI Path

Database Field
disabilityDescriptorA disability category that describes a child's impairment.Report the Ed-Fi code from the Disabilities for the student being reported.
  1. 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.
  2. The IEP must overlap with the student's enrollment record
  3. 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
  4. If the student has more than 1 disability, report each disability up to 3 disabilities.
MSpecial Ed> Documents> Plan> IEP> Primary Disability, Secondary Disability, Tertiary Disability, Fourth Disability, Fifth Disability

planstate.disability1

planstate.disability2

planstate.disability3

planstate.disability4

planstate.disability5

 
disabilityDiagnosisA description of the disability diagnosis.Does not report.O

orderOfDisabilityThe 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.
  1. If Primary Disability, report '1'.
  2. if Secondary Disability, report '2'.
  3. if Fifth Disability, report '3'.
O

disabilityDeterminationSourceTypeThe source that provided the disability determination. Does not report.O

Type/Descriptor

Click here to expand...

Reason Exited Descriptor

Ed-Fi Code ValueShort DescriptionDescription
01Died or is permanently incapacitatedDied or is permanently incapacitated
02Discontinued schoolingDiscontinued schooling
03Graduated with a high school diplomaGraduated with a high school diploma
04Moved out of stateMoved out of state
05OtherOther
06Reached maximum ageReached maximum age
07Received cert of completion, modified diploma, or finished IEP requirementsReceived certificate of completion, modified diploma, or finished IEP requirements
08Suspended or expelled from schoolSuspended or expelled from school
09Transferred to another district or schoolTransferred to another district or school
10Unknown reasonUnknown reason
11Withdrawal by a parent (or guardian)Withdrawal by a parent (or guardian)
SPED01Transferred to another school districtTransferred to another school district in Nebraska and continues with Early Intervention Services
SPED02Returned to full-time regular education programReturned to full-time regular education program. Include students with a disability whose parent revokes consent for special education and related services.
SPED03Graduated with a regular high school diplomaGraduated with a regular high school diploma
SPED04Received a certificate of completionReceived a certificate of completion
SPED05Reached maximum ageReached maximum age
SPED06DeceasedDeceased
SPED07Dropped OutDropped Out
SPED09Withdrawn by parentWithdrawn by parent
SPED11Transferred to another school district (Moved known to be continuing)Transferred to another school district (Moved known to be continuing)
SPED12Completion of the IFSP prior to the age of 3 years oldCompletion of the IFSP prior to the age of 3 years old
SPED13Exit to other programExit to other program, reached age 3 years old, re-evaluated and found no longer eligible for Special Education Services
SPED14Exit with no referralExit with no referral, reached age 3 years old, re-evaluated and found no longer eligible for Special Education Services
SPED16Moved out of stateMoved out of state
SPED17Attempts to contact parents unsuccessfulAttempts to contact parents unsuccessful

Special Education Setting Descriptor

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
01Home - not School AgedHome - not School Aged
02Community Based - not School AgedCommunity Based - not School Aged
03Other - not School AgedOther - not School Aged
05Separate SchoolSeparate School
06Separate ClassSeparate Class
07Residential FacilityResidential Facility
08Home - School AgedHome - School Aged
09Service Provider LocationService Provider Location
10Public SchoolPublic School
13Homebound/HospitalHomebound/Hospital
14Private School or Exempt (Home) SchoolPrivate School or Excempt (Home) School
15Correction/Detention FacilityCorrection/Detention Facility
16Regular Early Childhood Program, 10+ h/wk; Services at EC ProgramRegular Early Childhood Program, 10+ h/wk; Services at EC Program
17Regular Early Childhood Program, 10+ h/wk; Services outside EC ProgramRegular Early Childhood Program, 10+ h/wk; Services outside EC Program
18Regular Early Childhood Program, LT 10 h/wk; Services at EC ProgramRegular Early Childhood Program, LT 10 h/wk; Services at EC Program
19Regular Early Childhood Program, LT10 h/wk; Services outside EC ProgramRegular 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 ValueEd-Fi Short DescriptionEd-Fi Descriptionk
05IDEA Part BIDEA Part B
06IDEA Part CIDEA Part C

Placement Type Descriptor

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