Arizona Ed-FI Data v3.3 - Student Education Organization Responsibility Association

Classic View: System Administration > Ed-Fi 

Search Terms: Ed-Fi

Relationship Associations are reported from the Enrollment and locked IEPs. This is to identify any relationships a student may have with an organization outside the enrollment.

Object Triggering Logic

The tables below describe the logic for triggering syncing of this object. Expand one of the areas below to see full requirements:

Action
Trigger
PostReport 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, report from the most recent enrollment with a Service Type of 'P: Primary'.
  • If a student has multiple overlapping enrollments within the same school, but no 'P: Primary' enrollment, report the most recent 'T: AOI' enrollment.
  • If a student has multiple overlapping enrollments within the same school, but no 'P: Primary' or 'T: AOI' enrollment, report the most recent 'A: Ancillary' enrollment.
  • If a student has multiple overlapping enrollments within the same school, but no 'P: Primary', 'T: AOI', or 'A: Ancillary' enrollment, report the most recent 'O: Program Only' enrollment.
  • IEP start date must be on or after enrollment start 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 ONLY!
  • 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:
    1. District Information > State District Number.
    2. 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.
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.
  • If the student has more than 1 IEP started in previous schools years, only report the most recent IEP.
Delete/PostWhen 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
PutWhen 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/PostWhen an enrollment end date is entered for a student with a valid enrollment end status:  W1-W13.
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.
Delete

When an existing enrollment is marked as State Exclude or No Show.

DeleteWhen an Exit Evaluation is added for a student and a future record was already created.
  • The Exit Date on the Evaluation must be on or before the start date of the future record.
DeleteIf 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.
DeleteIf a plan is unlocked.

Scope Year

Business Rules
When a new IEP is created, the record will report in the Scope Year that the IEP Start Date overlaps with.
  • The start date must be on or before the School Year End Date.  If School Year End Date is NULL, 6/30/XXXX will be used as the default date.
  • Data will only send for the years that have valid configuration
When the record is triggered from enrollments, the record will send to the scope year for the school year the enrollment is associated with.
  • Data will only send for the years that have valid configuration.


Object Data Elements

Data Element Labels in bold are part of the Natural Key and are required data elements for Data to send to Ed-Fi. Expand one of the areas below to see full requirements:

Data Element LabelBusiness RequirementLocalized LogicM, C or O

Data Source GUI Path

Database Field
id The unique identifier of the resource.
M

beginDateThe date the educational organization was responsible for the student.
  1. Report the 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.
  2. Report the Enrollment Start Date if:
    • Enrollment Start Date is after the IEP Start Date.
    • IEP End Date is after the Enrollment Start Date.
M

AZ locked Plan>Education Plan>IEP Start Date

OR

Student Information> General> Enrollments> Start Date

Plan.startDate
OR
enrollment.

startdate

responsibilityDescriptorIndication of an education organization's responsibility for a student.Always report 'IEP'.


EducationOrganization
Reference 
A reference to the related EducationOrganization resource.
  1. Report the School Entity ID.


M

System Administration> Resources > School editor > Entity ID

school.entity id
studentReference A reference to the related Student resource.
  1. Report the student reference.


M



endDateThe date the educational organization is no longer responsible for the student.
  1. 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.
  2. 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.
  3. 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.
  4. 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.
C

AZ locked Evaluation>Exit Evaluation> Exit Date


OR


Student Information> General> Enrollments> End Date

Evaluation.

exitDate
OR
enrollment.

enddate

_etag

O