Arizona Ed-Fi Data v3.5 - 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	Report a record based on the students enrollment record and a new IEP is created and saved for a student and locked in a given scope year: Service Type = P. If a student has multiple overlapping enrollments within the same school with the same start date, report from the most recent enrollment with a Service Type of 'P: Primary'. If the student has multiple overlapping enrollments within the same school with the same start date, but no 'P: Primary' enrollment, report the most recent 'T: AOI' enrollment. If the student has multiple overlapping enrollments within the same school with the same start date, but no 'P: Primary' or 'T: AOI' enrollment, report the most recent 'A: Ancillary' enrollment. If the student has multiple overlapping enrollments within the same school with the same start date, but no 'P: Primary', 'T: AOI', or 'A: Ancillary' enrollment, report the most recent 'O: Program Only' enrollment. If a student has multiple overlapping enrollments from any school with different start dates, report with the following logic for end date: If the SPED Funded School is populated, report from the enrollment that is in the SPED Funded School: If a student has multiple overlapping enrollments within the SPED Funded School: Report a need from the enrollment with the earliest start date and set the end date to one day prior to the start date of the next enrollment. Report a second need from the enrollment with the later start date and set the start date to the enrollment start date and the end date to the enrollment end date. If enrollment end date is blank, set the end date to blank. Otherwise: Report a record from the enrollment with the earliest start date and set the end date to one day prior to the start date of the next enrollment. Report a second record from the enrollment with the later start date and set the start date to the enrollment start date and the end date to the enrollment end date. If enrollment end date is blank, set the end date to blank. IEP start date must be on or after enrollment start date and on or before the enrollment end date. Do not send a 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 State Exclude. Do not send a record if the enrollment Start Status = E: NON-SAIS DISTRICT USE ONLLY!. Do not send a record for enrollments that have a Local Service Type OTHER than 'P:Primary" OR 'T:AOI" AND the enrollment Resident District does not match the following: District Information > State District Number. If enrollment Resident District does not match the District Information > State District Number, loop through all of the credentials and compare to the District Number.
Post	When a new enrollment is created for a student that has an existing IEP. Enrollment start date must be after IEP start date. IEP end date must be NULL or after Enrollment start date. If the student has more than 1 IEP started in previous schools years, only report the most recent IEP.
Delete/Post	When a start date is entered or changed for an existing record. If Responsibility was posted from IEP, update if start date was changed. If Responsibility was posted from Enrollment, update if start date was changed.
Put	When a end date is entered or changed for an existing record. If Responsibility was posted from IEP, update if start date was changed. If Responsibility was posted from Enrollment, update if start date was changed.
Delete/Post	When the student has two locked IEPs with the same start date and 1 record is deleted or unlocked, the remaining IEP will post.
Delete/Post	When an enrollment end date is entered for a student with a valid enrollment end status: W1-W13.
Delete/Post	When an Exit Eval is entered for a student, update the end date of the active IEP.
Delete	IEP is deleted for a student.
Delete	When a student's enrollment Start Status is changed from a valid code to E: NON-SAIS DISTRICT USE ONLY! and saved.
Delete	When an existing enrollment is marked as State Exclude or No Show.
Delete	If the IEP Start or End Dates OR the Enrollment Start or End Dates have been updated so the IEP and Enrollment no longer overlap, delete the record if one was created.
Delete	If a plan is unlocked.

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
Reason Exited Descriptors	Enrollment Special Ed Exit Reason

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 Student Special Education Program Association 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.

Notes:

If there are enrollments with an end status of ZZZ and a subsequent enrollment with a start status of ZZZ, combine the enrollments and report the earliest start date (where the start status is NOT ZZZ) for the enrollment start date.
- Note, the enrollments must be in the same school, grade, and local service type. Also, the enrollment start date must be the next instructional day after the ZZZ end status, or be before or equal to the ZZZ end status.
If the SPED Funded School is populated, then always use the enrollment tied to the SPED Funded School for the enrollment start date.

AZ locked Plan > Education Plan > IEP Start Date

Student Information> General > Enrollments > Start Date

plan.startDate

enrollment.

startdate

education
Organization
Reference

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

If the SPED Funded School is populated on the locked IEP, report the School Entity ID from the school selected.
Report the School Entity ID.

AZ locked Plan > Enrollment Status > SPED Funded School

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

School.entityID

program
Reference

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

education
OrganizationId:

System Administration > Resources > District Information > Entity ID

Plan > Enrollment Status > Funded SPED Service DOR

programName:

Plan > Enrollment Status > Special Ed Setting

customdistrict.
attributeid

Enrollment.
specialEdSetting

student
Reference

A unique alpha-numeric code assigned
to a student.

Reports the Natural Key for the Student resource.

Note: The Ed-Fi ID reports from the Student State Id field.

disabilities

The disability condition(s) that best
describesan 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.

If Enrollment End Date is NOT null:
- Report the earliest of the following dates:
  1. Exit Date from the most recent Evaluation of the type 'Exit'.
  2. Enrollment End Date
  3. IEP End Date
If Enrollment End Date IS null:
- If an IEP exists starting immediately after an existing plan or an IEP has an end date that is prior to the last instructional day of the school year or the most recent Evaluation of type 'Exit' has an exit reason of SPED01 or SPED09, report the earliest of the IEP end date and Evaluation Exit Date.
  - 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.
Otherwise, report blank.

Notes:

Whatever end date is sending (minimum of plan end, exit eval or enrollment end date), if it is not an instructional date, take the most previous instructional date and send that.
When there are multiple enrollments that all start before the IEP starts, use the following logic to determine which enrollment to use to calculate the end date:
- If the SPED Funded School is populated, then always use the enrollment tied to the SPED Funded School for the enrollment start date.
- Else, report from the most recent enrollment with a Service Type of 'P: Primary'.
- If the student has no 'P: Primary' enrollment, report from the most recent 'T: AOI' enrollment.
- If the student has no 'P: Primary' or 'T: AOI' enrollment, report from the most recent 'A: Ancillary' enrollment.
- If the student has no 'P: Primary', 'T: AOI', or 'A: Ancillary' enrollment, report from the most recent 'O: Program Only' enrollment.
If there are enrollments with an end status of ZZZ and a subsequent enrollment with a start status of ZZZ, combine the enrollments and report the latest end date (where the end status is NOT ZZZ) for the enrollment end date.
- Note, the enrollments must be in the same school, grade, and local service type. Also, the enrollment start date must be the next instructional day after the ZZZ end status, or be before or equal to the ZZZ end status.

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

lastEvaluation
Date

The date of the last special education
evaluation.

This is optional, does not report.

medically
Fragile

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.

multiply
Disabled

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.

reasonExited
Descriptor

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

If an IEP exists starting immediately after an existing plan or starts the very next instructional day, report SPED09.
If the most recent Exit Evaluation has an Exit reason of SPED01 or SPED09, report the Ed-Fi code from the Exit Reason selected.
If the IEP end date ends prior to the last instructional day of the school year, report SPED01.
If Enrollment End Date is NOT null,
- 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.
Otherwise, report blank.

Descriptor	Business Rule
SPED02	Reports when a student has an end status of W7, W14, W15, W17-W20, D2, G. If end status is NULL, but "Graduation (Year End Status) = 'G', also reports.
SPED03	Reports when a student 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 end status of W8.
SPED05	Reports when a student has an end status of: W10 W9, W21, W22 Grade Level is not mapped to 'PS'. W1 There is not another consecutive enrollment in the same school year, in the same school, that starts the very next instructional day.
SPED07	Reports when a student has an end status of: W3, W4, W5, W11, W12, W13, W41, W51 W2 Grade Level is not mapped to 'PS'.
SPED09	Reports when: An IEP exists starting immediately after an existing plan (or starts the very next instructional day) and IEP end date is before enrollment end date. A student has an end status of: WK, WD, WP W1 There is another consecutive enrollment in the same school year, in the same school, that starts the very next instructional day.
SPED10	Reports when a student has and end status of: 'W6 Is in state mapped grades 'PS', 'K', or 'UE'.
SPED13	Reports when the enrollment end date is equal to the last instructional day of the year and the IEP is active as of the last instructional day of the year.
SPED14	Reports when a student has an end status of W9, W21, W22, or W2 and the enrollment Grade Level is mapped to the state grade level of 'PS'.
SPED01	Reports when no other conditions above are met. 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

schoolHours
PerWeek

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

This is optional, does not report.

servedOutsideOf
RegularSession

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

This is optional, does not report.

serviceProviders

An unordered collection of studentSpecialEducationProgram

Association ServiceProviders. The staff providing Special Education services to the student.

This is optional, does not report.

specialEducation
HoursPerWeek

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

This is optional, does not report.

specialEducation
ProgramServices

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.

specialEducation
SettingDescriptor

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

MainSPED
School (R)

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

Report "False" if SPED Concurrency Type is = Secondary.
Otherwise, report 'True'.

Plan > Enrollment Status >SPED Concurrency Type

plan.
spedConcurrencyType

Arrays

Data Element Label

Business Requirement

Logic

M,C, or O

Data Source GUI Path

Database Field

assessmentCategory
Descriptor

This descriptor holds the category of an assessment based on format and content.

Report the corresponding Ed-Fi code based on the Assessment Category 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 blank if the field is null.

Ed-Fi Code	Business Rule
SPSC01	Report when drop down value is "Positive social-emotional skills (including social relationships)".
SPSC02	Report when drop down value is "Acquisition and use of knowledge and skills (including early language/ communication and early literacy)".
SPSC03	Report when drop down value is "Use of appropriate behaviors to meet their needs".

Student Information > SPED > General > Documents > Evaluation > Assessment Category

Evaluation.assessmentCategory

assessmentPeriod
Descriptor

This descriptor holds the period of time window in which an assessment is supposed to be administered (e.g., Beginning of Year, Middle of Year, End of Year).

If the Evaluation Type is 'Entry', report "SPSE01".
If the Evaluation Type is 'Exit', report "SPSE02".

Student Information > SPED > General > Documents > Evaluation > Evaluation Type

assessmentOutcomes
SummaryDescriptor

This descriptor holds the outcome of an Assessment based on the Assessment Category.

Report the corresponding Ed-Fi code based on the Assessment Outcomes Summary 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 blank if the field is null.

Ed-Fi Code	Business Rule
SPSOC01	Report when drop down value is "Overall not age appropriate: Does not yet show functioning expected in any situation, does not show immediate foundational skills in any situation."
SPSOC02	Report when drop down value is "Overall not age appropriate: Occasionally uses immediate foundational skills across settings and situations".
SPSOC03	Report when drop down value is "Overall not age appropriate: Uses immediate foundational skills most or all of the time across settings and situation."
SPSOC04	Report when drop down value is "Overall not age appropriate: Shows occasional age-appropriate functioning across settings and situations."
SPSOC05	Report when drop down value is "Overall not age appropriate: Shows functioning expected for his or her age some of the time and/or in some settings and situations."
SPSOC06	Report when drop down value is "Age appropriate: Functioning generally is considered appropriate for his or her age, but there are some significant concerns about the child’s functioning in this outcome area."
SPSOC07	Report when drop down value is "Age appropriate: Shows functioning expected for his or her age in all or almost all everyday situations that are part of the child’s life."

Student Information > SPED > General > Documents > Evaluation > Assessment Outcomes Summary

Evaluation.assessmentOutcome

Type/Descriptor

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

Arizona Ed-Fi Data v3.5 - Student Special Education Program Associations

Object Triggering Logic

School Exclude, Calendar Exclude, Resource Toggle and Resync Logic

Natural Key Changes, Cascading Updates, and Deletes Logic

Scope Year Logic

Resource Preferences

Identity Mapping Object Key

Event Queue Detail

Object Data Elements

Arrays

Type/Descriptor

Special Education Setting Descriptor

Related Articles