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

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.

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
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 Descriptors	Enrollment Special Ed Setting
OR
Special Education Setting Descriptors	Plan Special Ed Setting
OR
Special Education Setting Descriptors	State Reporting Special Ed Setting

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

The unique identifier of the resource.

beginDate

The month, day, and year on which the student first received services.

Report the plan start date from the IEP if:
- IEP Start Date is after enrollment Start Date.
- Enrollment End Date must be NULL or after IEP start date.
Also report the start date from the Amended IEP if the original plan has been amended, or the 2nd consecutive plan, but report it with the 2nd .StudentSpecialEducationProgramAssocation record
Report the Enrollment Start Date if:
- Enrollment Start Date is after the IEP Start Date.
- IEP End Date is after the Enrollment Start Date.

AZ locked Plan > Education Plan > IEP Start Date

Student Information> General > Enrollments > Start Date

plan.startDate

educationOrganizationReference

The education organization where the student is participating in or receiving the program services.

Report the School Entity ID.

System Administration > Resources > Schools > school record > Entity ID

School.entityID

programReference

A reference to the Program Resource.

educationOrganizationId:

Report the entityID value from 'Funded SPED Service DOR' if it is filled in.
If it is not filled in, report from customdistrict.attributeid.

programName:

Report the value.

programTypeDescriptor:

Report 'Special Education'.

educationOrganizationId:

System Administration > Resources > District Information > Entity ID

OR:

Plan > Enrollment Status > Funded SPED Service DOR

programName:

Plan > Enrollment Status > Special Ed Setting

customdistrict.attributeid

Enrollment.specialEdSetting

studentReference

A unique alpha-numeric code assigned to a student.

Reports the Natural Key for the Student resource.

disabilities

The disability condition(s) that best describes an individual’s impairment, as related to special education services received.

This is optional, does not report.

endDate

The month, day, and year on which the student exited the program or stopped receiving services.

Report the Exit Date from AZ ESR yyyy Format (current) Evaluation.
- Look for the most recent Evaluation where Evaluation Exit Date is later than the IEP start date and before enrollment end date or last instructional day.
Report Enrollment End Date
- Enrollment End must be on or after IEP Start Date and on or before IEP End Date.
- Enrollment End date must be on or before Exit Date from Evaluation and on or before last Instructional Day.
Report the IEP End Date if the end date falls in within the school year being reported.
- If the IEP end date is NULL or after the last instructional day of the year, report last instructional day of calendar.
Report the following if an IEP does not have an end date and a new IEP is created:
- Report the last instructional day that occurs right before the start date of the new IEP.

Note: whatever end date we are sending (minimum of plan end, exit evail or enrollment end date), if it is not an instructional date, take the most previous instructional date and send that.

Student Information> General > SPED > Documents > Exit Evaluation > Exit Date

Student Information > General > Enrollment > End Date

IEP End Date

IEP Start Date

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.

iepBeginDate

The effective date of the most recent IEP.

This is optional, does not report.

iepEndDate

The end date of the most recent IEP.

This is optional, does not report.

iepReviewDate

The date of the last IEP review.

This is optional, does not report.

lastEvaluationDate

The date of the last special education evaluation.

This is optional, does not report.

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.

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.

reasonExitedDescriptor

The reason the child left the Program within a school or district.

Note: When reporting Sped data for a plan that has ended, you may need to complete an exit evaluation in order to correctly send the reasonExitedDescriptor.

Report the Ed-Fi code from the Exit Reason selected in the Exit Evaluation.
- Evaluation Exit Date must be after enrollment start date.
- Evaluation Exit Date must be before enrollment end date or last instructional day and before IEP End Date.
Report based on the table below, when a student's enrollment is ended with the following End Status or a new or amended plan is created and locked.
In the scenario where a student has either amended an existing plan or added a new plan directly after the end of the first, a reasonExitedDescriptor will only send for the 2nd record - the earlier record (which has either been amended or replaced) will not report a reasonExitedDescriptor.

Descriptor	Business Rule
SPED02	Reports when a student has an active plan and their enrollment is ended on or before the last instructional day and has an end status of W7, W15, W17-W20, D2. If end status is NULL, but "Graduation (Year End Status) = 'G', also reports.
SPED03	Reports when a student has an active plan and their enrollment is ended on or before the last instructional day and has an end status of W6, but whose enrollment Grade Level is not mapped to one of the following state grade levels: 'PS, KG, UE'.
SPED04	Reports when a student has an active plan and their enrollment is ended on or before the last instructional day and has an end status of W8.
SPED05	Reports when a student has: An active plan. Their enrollment is ended on or before the last instructional day. Has an end status of: W1, W10 W9 Is in grades PS, K, or UE Isn't 3-5 years old.
SPED07	Reports when a student has an active plan and their enrollment is ended on or before the last instructional day and has an end status of W2, W3, W4, W5, W11, W12, W13.
SPED09	Reports when a plan is amended or followed by a new plan where the disabilities did OR did not change. Reports when a student has an active plan and their enrollment is ended on or before the last instructional day and has an end status of WK, WD, WP.
SPED10	Reports when a student has: An active plan. Their enrollment is ended on or before the last instructional day. Has one of the following end status codes: 'W9' Is in state mapped grades 'PS', 'K', or 'UE'. Is 3-5 years old. 'W6 Is in state mapped grades 'PS', 'K', or 'UE'.
SPED13	Reports when the IEP or school year ends and none of the above applies. If a new IEP is added within the same school year, this should be changed based on the information in the new IEP.

Student Information > General > SPED > Documents > Exit Evaluation > Exit Reason

Student Information > General > Enrollment > Exit Status

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.

servedOutsideOfRegularSession

Indicates whether the Student received services during the summer session or between sessions.

This is optional, does not report.

serviceProviders

An unordered collection of studentSpecialEducationProgramAssociationServiceProviders. The staff providing Special Education services to the student.

This is optional, does not report.

specialEducationHoursPerWeek

The number of hours per week for special education instruction and therapy.

This is optional, does not report.

specialEducationProgramServices

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.

specialEducationSettingDescriptor

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.

Student Information > Special Ed > Documents > Plan > Current Plan > Enrollment Status> Special Ed Setting

Student Information > Special Ed > Special Ed Setting

enrollment.specialEdSetting

plan.specialEdSetting

specialedstate.specialEdSetting

MainSPEDSchool (R)

This field tells(True or False) whether this is Primary school for SPED concurrency or not.

Report "True" if SPED Concurrency Type is = Primary or NULL.
Report "False" if SPED Concurrency Type is = Secondary.

Plan > Enrollment Status > SPED Concurrency Type

plan.spedConcurrencyType

Type/Descriptor

Click here to expand...

Special Education Setting Descriptor

Code Value	Description	Namespace	Short Description
Correctional Facilities	Correctional Facilities	uri://ed-fi.org/SpecialEducationSettingDescriptor	Correctional Facilities
Homebound/Hospital	Homebound/Hospital	uri://ed-fi.org/SpecialEducationSettingDescriptor	Homebound/Hospital
Inside reg class between 40-79% of the day	Inside regular class no more than 79% of day and no less than 40% of the day	uri://ed-fi.org/SpecialEducationSettingDescriptor	Inside reg class between 40-79% of the day
Inside regular class 80% or more of the day	Inside regular class 80% or more of the day	uri://ed-fi.org/SpecialEducationSettingDescriptor	Inside regular class 80% or more of the day
Inside regular class less than 40% of the day	Inside regular class less than 40% of the day	uri://ed-fi.org/SpecialEducationSettingDescriptor	Inside regular class less than 40% of the day
Parentally-placed in Private Schools	Parentally-placed in Private Schools	uri://ed-fi.org/SpecialEducationSettingDescriptor	Parentally-placed in Private Schools
Residential Facility	Residential Facility	uri://ed-fi.org/SpecialEducationSettingDescriptor	Residential Facility
Separate School	Separate School	uri://ed-fi.org/SpecialEducationSettingDescriptor	Separate School