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

ActionTrigger
PostWhen an Enrollment record is created and has a Special Ed Service value of '4', '5', '6', or 7.
  • When a student has two enrollments in the same School, Calendar & Schedule Structure with the same start date, report from the enrollment service type in the following order:

    1. P: Primary Enrollment
    2. S: Partial/Ancillary
    3. N: Special Ed Services
  • When an enrollment with a higher priority is deleted, the enrollment with lower priority will post a new record.
  • 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.
  • Do not send a record if enrollment is marked as No Show.
  • Do not send records if the Calendar Grade Level "Exclude from State Reporting" checkbox is selected for the grade level that the student's enrollment is tied to.
Put

When the disability values are changed:

  • When the End Date value changes.
  • When the Special Ed Disability Setting value changes.
  • When the Service Hours value changes.
Delete

When the Special Ed Service value changes from '4', '5', '6', or '7'.

  • When all enrollment records with a Special Ed Service value of '4', '5', '6' or '7' are deleted.
  • If the student's enrollment is marked as No Show.
  • The state reporting record no longer overlaps the configured year.

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.

Natural Key Changes, Cascading Updates, and Deletes Logic

This table describes the Natural Key Changes/Cascading Updates and Deletes logic of this object.

ActionTrigger
Post/DeleteNatural Key changes: If the IEP Start Date changes the resource will delete/repost.
DeleteCascading Deletes:  N/A there are no dependent resources.


Scope Year Logic

This table describes scope year logic of this object.

Business Rules
The record will send to any year the IEP or State Reporting record overlaps with.
Data will only send for the years that have valid configuration.

Resource Preferences

This table describes the Resource Preferences of this object.

Data Element Label

Mapping Needed

Special Education Setting DescriptorsEnrollment Special Ed Disability Setting
Disability DescriptorsDisability


Identity Mapping Object Key

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

campusObjectTypeObject Key Data Source
PlanplanID
SpecialEDStatespecialEDStateID


Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus TableEd-Fi ActionFields
planPost/Put/DeleteThe primary table used for sending data for this resource.
enrollmentPutReports ideaEligibility and specialEducationSettingDescriptor.
specialedstatePost/Put/DeleteThe primary table used for sending data for this resource.


Object Data Elements

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

Data Element LabelBusiness RequirementLogicM, C or O

Data Source GUI Path

Database
Field
id The unique identifier of the resource.
M

beginDateThe month, day, and year on which the 
Student first received services.
Report the Start Date from the Enrollment record.MStudent Information > General > Enrollments > Start DateEnrollment.
startDate
education
Organization
Reference
educationOrganizationId

The identifier assigned to an 

education organization.

  1. Report the Ed-Fi School ID.
  2. If Ed-Fi School ID is NULL, report:
    1. ttddddsssmmm

      where:

      • tt = district type
      • dddd = district number, left zero filled
      • sss = school number, left zero filled
      • mmm = 000 for all organizations reported in Ed-Fi

M

System Administration > Resources > School > school record > Ed-Fi School ID


tt: System Administration > Resources > District Information > district record > Type


dddd: System Administration > Resources > District Information > district record > State District Number


SSS: System Administration > Resources > School > school record > State School Number

School.entityID

District.type

District.number

School.number

programReferenceeducationOrganizationId

The identifier assigned to an 

education organization.

programName


The formal name of the Program of 

instruction, training, services, or 

benefits available through federal, 

state, or local agencies.


programTypeDescriptor

The type of program.

Report the following values within the program.

  • educationOrganizationId:
    • Report the Ed-Fi District Number, if it exists
    • If Ed-Fi District Number is NULL, report:
      1. ttddddsss

        where:

        1. tt = district type
        2. dddd = district number, left zero filled
        3. sss = 000
  • programName: 'Special Education'
  • programTypeDescriptor: 'Special Education'
M

System Administration > Resources > District Information > district record > Ed-Fi District Number


tt: System Administration > Resources > District Information > district record > Type


dddd: System Administration > Resources > District Information > district record > State District Number

District.entityID

District.type

District.number

placingLocal
EducationAgency
Reference
The identifier assigned to a local
education agency.

  1. Look to see if the Placing District is not Null.
    1. If so, report the Placing District Number.
    2. Otherwise, do not report.

CStudent Information > General > Enrollments > State Reporting Fields > Placing DistrictEnrollment.
placingDistrict
disabilities

An unordered collection of student Special Education Program Association Disabilities. 

The disability condition(s) that best 

describes an individual’s impairment, as related to special education services received.


disabilityDescriptor

A disability category that describes 

a child’s impairment.


orderOfDisability

The order by severity of student’s disabilities: 

1- Primary, 2 - Secondary, 3 - Tertiary, 

etc.

  1. Report all disability values saved in the enrollment record that are mapped to a valid disabilityDescriptor value
    • report the orderOfDisability according to the chart below
  2. If there are no mapped disability values, do not report.
#Disability
Field Name

orderOFDisability
value

1Primary Disability1
2Secondary Disability 12
3Secondary Disability 23
M

Student Information > General > Enrollments > Special Ed Fields > Primary Disability


Student Information > General > Enrollments > Special Ed Fields > Secondary Disability 1


Student Information > General > Enrollments > Special Ed Fields > Secondary Disability 2

Enrollment.

disability1


Enrollment.

disability2


Enrollment.

disability3


endDateThe month, day, and year on which the Student exited the Program or stopped receiving services.
  1. Report the Start Date from the Enrollment record, if it exists.
  2. Otherwise, do not report.
C

Student Information > General > Enrollments > End Date

Enrollment.
endDate
ideaEligibility

Indicator of the eligibility of the student to receive special education services according to the Individuals with 

Disabilities Education Act (IDEA).

  1. This is optional, does not report.
O




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

iepEndDate

The end date of the most recent IEP.

  1. This is optional, does not report.
O

iepReviewDate

The date of the last IEP review.

  1. This is optional, does not report.
O

lastEvaluationDate The date of the last special education 
evaluation.
  1. This is optional, does not report.
O

medicallyFragile

Indicates whether the Student receiving 

special education and related services is: 

1) in the age range of birth to 22 years, and 2) has a serious, ongoing illness or a chronic condition that has lasted or is anticipated to

last at least 12 or more months or has required at least one month of hospitalization, and that requires daily, ongoing medical 

treatments and monitoring by appropriately trained personnel which may include parents

 or other family members, and 3) requires the routine use of medical device or of assistive technology to compensate for the loss of usefulness of a body function needed to participate in activities of daily living, and 4) lives with ongoing threat to his or her continued well-being. Aligns with federal requirements.

  1. This is optional, does not report.
O

multiplyDisabled

Indicates whether the Student receiving special education and related services has been designated as multiply disabled by 

the admission, review, and dismissal committee as aligned with federal requirements.

  1. This is optional, does not report.
O

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

schoolHours
PerWeek

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

  1. This is optional, does not report.
O

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

serviceProviders

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

  1. This is optional, does not report.
O

specialEducation
HoursPerWeek
The number of hours per week for special education instruction and therapy.
  1. This is optional, does not report.
O

specialEducation
ProgramServices
An unordered collection of student Program Association Services. This association represents the Special Education program(s) that a student participates in or receives services from. 
  1. This is optional, does not report.
O

specialEducation
SettingDescriptor
The major instructional setting (more than 50 percent of a student’s special education program).
  1. Report the mapped descriptor value to any setting value saved in the enrollment record
  2. If there are no mapped setting values, do not report.
CStudent Information > General > Enrollments > Special Ed Fields > Special Ed Disability SettingEnrollment.
specialEd
Setting
specialEducation
ServiceHours
Special Education Service Hours.
  1. If Special Ed Service value = '4' or '6', report any numeric value saved in the enrollment record (UI has a 6 character max).
  2. Otherwise, do not report.
CStudent Information > General > Enrollments > Special Ed Fields > Service Hoursenrollment. spedService
Hours