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

Last Modified on 11/18/2024 10:43 am CST

Reports the Special Education data for a student.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

Report one record for each Primary/Secondary SPED Services School with a student having a new IEP created and saved for a student and locked in a given scope year.

  • When a student has multiple overlapping enrollments within the primary/secondary school, report from the enrollment with a Local Service Type of 'P: Primary'.
  • When a student has multiple overlapping enrollments within the primary/secondary school, but no 'P: Primary' enrollment, report the 'T: AOI' enrollment.
  • When a student has multiple overlapping enrollments within the primary/secondary school, but no 'P: Primary' or 'T: AOI' enrollment, report the most recent 'A: Ancillary' enrollment.
  • When a student has multiple overlapping enrollments within the primary/secondary school, but no 'P: Primary', 'T: AOI', or 'A: Ancillary' enrollment, report the most recent 'O: Program Only' enrollment.

  • When Primary/Secondary Services dropdowns are not populated, report from the enrollment that overlaps the IEP dates that has a IC Service Type of 'P: Primary'.

  • IEP start date must be on or after enrollment start date and on or before enrollment end date.

  • Does not send a record for an enrollment that is marked as State Exclude or No Show.

  • Does not send a record when the enrollment is in a calendar marked as State Exclude.

  • Does not send a record when the enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY!.

PostWhen 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.
  • When the student has more than one 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.

  • When the resource was posted from the IEP, updates when the start date was changed.
  • When the resource was posted from the Enrollment, updates when the start date was changed.
Put

When a end date is entered or changed for an existing record.

  • When the resource was posted from the IEP, updates when the start date was changed.
  • When the resource was posted from Enrollment, updates when start date was changed.
Delete/PostWhen the student has two locked IEPs with the same start date and 1 record is deleted or unlocked, the remaining IEP will post.
Delete/PostWhen an enrollment end date is entered for a student with a valid enrollment end status: W1-W13.
Delete/PostWhen an Exit Eval is entered for a student, update the end date of the active IEP.
DeleteIEP is deleted for a student.
DeleteWhen a student's enrollment Start Status is changed from a valid code to E: NON-SAIS DISTRICT USE ONLY! and saved.
DeleteWhen an existing enrollment is marked as State Exclude or No Show.
DeleteWhen 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 when one was created.
DeleteWhen 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.

ActionTrigger
NoneWhen a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
ResyncWhen 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.
ResyncWhen 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.
ResyncWhen 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: when 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 Setting
Reason Exited DescriptorsEnrollment Special Ed Exit Reason

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 identwhenier of the resource.
M

beginDateThe month, day, and year on which the student first received services. 
  1. Reports the plan start date from the IEP when:
    • IEP Start Date is after enrollment Start Date.
    • Enrollment End Date must be NULL or after IEP start date.
  2. Also reports the start date from the Amended IEP when the original plan has been amended, or the 2nd consecutive plan, but reports it with the second Student Special Education Program Association record.
  3. Reports the Enrollment Start Date when:
    • Enrollment Start Date is after the IEP Start Date.
    • IEP End Date is after the Enrollment Start Date.

Notes:

  1. When there are enrollments with an end status of ZZZ and a subsequent enrollment with a start status of ZZZ, the enrollments are combined and the earliest start date (where the start status is NOT ZZZ) reports 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.
  2. The enrollment that is tied to the primary/secondary services school when populated is used; otherwise, the enrollment that has Service Type of P: Primary is used.
M

Documents > IEP Start Date

OR

Enrollments > Start Date


plan.startDate


enrollment.

startdate

education
Organization
Reference		The education organization where the student is participating in or receiving the program services.
  1. When the Primary SPED Services School is populated on the locked IEP, reports the School Entity ID from the school selected.
  2. When the Secondary SPED Services School is populated on the locked IEP, reports the School Entity ID from the school selected.
  3. Reports the School Entity ID.
M

Document > AZ locked Plan > Enrollment Status > Primary SPED Services School


Documents > AZ locked Plan > Enrollment Status > Secondary SPED Services School


School Information  > school record > Entity ID

School.entityID

program
Reference		A reference to the Program
Resource.

educationOrganizationId:

  1. Reports the entityID value from 'Funded SPED Service DOR' when it is populated.
  2. When it is not filled in, reports from customdistrict.attributeid.

programName:

Reports the value.


programTypeDescriptor:

Reports 'Special Education'.

M

education
OrganizationId:

District Information > Entity ID


OR


Documents > > Enrollment Status >

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.

M

disabilitiesThe disability condition(s) that best
describesan individual’s impairment,
as related to special education
services received.

This is optional, does not report.

O

endDateThe month, day, and year on which the student exited the program or stopped receiving services.
  1. When the Enrollment End Date is NOT null:
    • Reports the earliest of the following dates:
      • Exit Date from the most recent Evaluation of the type 'Exit'.

      • Enrollment End Date

      • IEP End Date 
  2. When Enrollment End Date IS null:
    • When 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, reports the earliest of the IEP end date and Evaluation Exit Date.
      • When an IEP does not have an end date and a new IEP is created, reports the last instructional day that occurs right before the start date of the new IEP.
  3. Otherwise, reports blank.

Notes:

  1. Whichever end date is sending (minimum of plan end, exit evaluation or enrollment end date), when it is not an instructional date, the most previous instructional date is sent.
  2. When there are multiple enrollments that all start before the IEP starts, the following logic is used to determine which enrollment to use to calculate the end date:
    • When reporting from the Primary SPED Services School, the enrollment tied to the Primary SPED Services School is always used for the enrollment start date.
    •  When reporting from the Secondary SPED Services School, the enrollment tied to the Secondary SPED Services School is always used for the enrollment start date
    • Otherwise, reports from the enrollment that has a Service Type of P: Primary.
  3. When here are enrollments with an end status of ZZZ and a subsequent enrollment with a start status of ZZZ, the enrollments are combined and the latest end date (where the end status is NOT ZZZ) for the enrollment end date reports.
    • 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.
C

Documents > Exit Evaluation > Exit Date


OR

Enrollment > End Date


OR


IEP End Date


OR


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.

O


iepBeginDateThe effective date of the most recent IEP.

This is optional, does not report.

O

iepEndDate

The end date of the most recent IEP.

This is optional, does not report.

O

iepReviewDate

The date of the last IEP review.

This is optional, does not report.

O

lastEvaluation
Date 		The date of the last special education
evaluation.

This is optional, does not report.

O

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.

O

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.

O

reasonExited
Descriptor		The reason the child left the Program within a school or district.
  1. When an Enrollment End Date is null:
    • When an IEP exists starting immediately after an existing plan or starts the very next instructional day, reports SPED09.
    • When the most recent Exit Evaluation has an Exit reason of SPED01 or SPED09, reports the Ed-Fi code from the Exit Reason selected.
    • When the IEP end date ends prior to the last instructional day of the school year, reports SPED01.
  2. When an Enrollment End Date is not null:
    • When the IEP End Date is before Enrollment End Date
      • And an IEP exists starting immediately after an existing plan or starts the very next instructional day, reports SPED09.
      • Otherwise, reports SPED01.
    • Reports 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.
    • Reports based on the table below, when a student's enrollment is ended with the following End Status:
  3. Otherwise, report blank.
DescriptorBusiness Rule
SPED02Reports when a student has an end status of W7, W14, W15, W17-W20, D2, G.


When end status is NULL, but Graduation (Year End Status) = G, also reports.

SPED03Reports 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.
SPED04Reports when a student has an end status of W8.
SPED05

Reports when a student has an end status of:

  1. W10
  2. W9, W21, W22 - Grade Level is not mapped to PS.
  3. 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:

  1. W3, W4, W5, W11, W12, W13, W41, W51
  2. W2 - Grade Level is not mapped to PS.
SPED09

Reports when:

  1. 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.
  2. 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.

SPED13Reports 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.
SPED14Reports 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.


When a new IEP is added within the same school year, this should be changed based on the information in the new IEP.


C

Documents > Exit Evaluation > Exit Reason


OR

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.

O

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

This is optional, does not report.

O

serviceProviders

An unordered collection of studentSpecialEducationProgram

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

This is optional, does not report.

O

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

This is optional, does not report.

O

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.

O

specialEducation
SettingDescriptor		Reports the Special Education setting for the student.
  1. Reports the Ed-Fi code for the value selected in Special Ed setting from the IEP or State Reporting Record being reported.
  2. When this field is blank or Ed-Fi Code is NULL, does not report.
O

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


enrollment.
specialEdSetting


OR


plan.
specialEdSetting


OR


specialedstate.
specialEdSetting

MainSPED
School (R)		This field tells (True or False) whether this is Primary school for SPED concurrency or not.
  1. When reporting from the Secondary SPED Services School, reports false.
  2. Otherwise, reports true.
M
plan.sped
Concurrency
Type
assessment
Outcomes		An unordered collection of Student Special Education Program Association Assessment Outcomes. This entity collection represents the SPED outcomes of students at an education organization.
  1. Only reports when a student has an entry or exit evaluation.
  2. See Array section below for data logic for each field.




Arrays

Click here to expand...

Assessment Outcomes

Data Element LabelBusiness RequirementLogicM,C, or O

Data Source GUI Path


Database Field
assessmentCategory
Descriptor		This descriptor holds the category of an assessment based on format and content.Reports 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.
  • Reports blank when the field is null.
Ed-Fi CodeBusiness Rule
SPSC01Reports when drop down value is Positive social-emotional skills (including social relationships).
SPSC02Reports when drop down value is Acquisition and use of knowledge and skills (including early language/ communication and early literacy).
SPSC03Reports when drop down value is Use of appropriate behaviors to meet their needs.

Documents > Evaluation > Assessment CategoryEvaluation.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).
  • When the Evaluation Type is Entry, reports SPSE01.
  • When the Evaluation Type is Exit, reports SPSE02.


Documents > Evaluation > Evaluation Type



assessmentOutcomes
SummaryDescriptor		This descriptor holds the outcome of an Assessment based on the Assessment Category.
  • Reports 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 iwhen the field is null.
Ed-Fi CodeBusiness Rule
SPSOC01Reports 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.
SPSOC02Reports when drop down value is Overall not age appropriate: Occasionally uses immediate foundational skills across settings and situations.
SPSOC03Reports when drop down value is Overall not age appropriate: Uses immediate foundational skills most or all of the time across settings and situation.
SPSOC04Reports when drop down value is Overall not age appropriate: Shows occasional age-appropriate functioning across settings and situations.
SPSOC05Reports 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.
SPSOC06Reports 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.
SPSOC07Reports 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.

Documents > Evaluation > Assessment Outcomes SummaryEvaluation.assessmentOutcome

Type/Descriptor

Click here to expand...

Special Education Setting Descriptor

Code ValueDescriptionNamespaceShort Description
Correctional FacilitiesCorrectional Facilitiesuri://ed-fi.or /SpecialEducationSettingDescriptorCorrectional Facilities
Homebound/HospitalHomebound/Hospitaluri://ed-fi.org/SpecialEducationSettingDescriptorHomebound/Hospital
Inside reg class between 40-79% of the dayInside regular class no more than 79% of day and no less than 40% of the dayuri://ed-fi.org/SpecialEducationSettingDescriptorInside reg class between 40-79% of the day
Inside regular class 80% or more of the dayInside regular class 80% or more of the dayuri://ed-fi.org/SpecialEducationSettingDescriptorInside regular class 80% or more of the day
Inside regular class less than 40% of the dayInside regular class less than 40% of the dayuri://ed-fi.org/SpecialEducationSettingDescriptorInside regular class less than 40% of the day
Parentally-placed in Private SchoolsParentally-placed in Private Schoolsuri://ed-fi.org/SpecialEducationSettingDescriptorParentally-placed in Private Schools
Residential FacilityResidential Facilityuri://ed-fi.org/SpecialEducationSettingDescriptorResidential Facility
Separate SchoolSeparate Schooluri://ed-fi.org/SpecialEducationSettingDescriptorSeparate School


Related Articles

Was this helpful?
Thank you for your feedback!
User Icon

Thank you!

Copyright ©️ 2010-2023 Infinite Campus, Inc. All rights reserved. | Terms of Use | Privacy Policy | infinitecampus.com