Arizona Ed-FI Data v3.5 - Student Education Organization Responsibility Associations

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:

ActionTrigger
PostReport one record for the Primary 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 school, report from the enrollment with a Local Service Type of 'P: Primary'.
  • When a student has multiple overlapping enrollments within the primary school, but no 'P: Primary' enrollment, report the 'T: AOI' enrollment.
  • When a student has multiple overlapping enrollments within the primary 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 school, but no 'P: Primary', 'T: AOI', or 'A: Ancillary' enrollment, report the most recent 'O: Program Only' enrollment.
  • When the Primary Services dropdown is 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.
  • Do not send a record for an enrollment that is marked as State Exclude or No Show.
  • Do not send a record when enrollment is in a calendar marked as State Exclude.
  • Do 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 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.
  • When Responsibility was posted from IEP, update when start date was changed.
  • When Responsibility was posted from Enrollment, update when start date was changed
PutWhen a end date is entered or changed for an existing record.
  • When Responsibility was posted from IEP, update when start date was changed.
  • When Responsibility was posted from Enrollment, update when 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.
Delete/PostWhen an Exit Eval is entered for a student, update the end date of the active IEP .
DeleteWhen an IEP 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 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.

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.  When 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 when:
    • 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 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, 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.
  2. Use the enrollment that is tied to the primary services school when populated, otherwise use the enrollment that has an IC Service Type of P: Primary.
M

Documetns > AZ locked Plan>Education Plan>IEP Start Date


OR

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. When the Resident School field is populated on the Enrollment, report the School Entity ID from the school selected.
  2. When the Primary SPED Services School is populated on the locked IEP, report the School Entity ID from the school selected
  3. Report the School Entity ID.


M

Documents > AZ locked Plan > Enrollment Status > SPED Funded School


Enrollments > Resident School


School Information > Entity ID

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

Report the student reference.

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

M



endDateThe date the educational organization is no longer responsible for the student.
  1. When Enrollment End Date is NOT null:
    • Report 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, report 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, report the last instructional day that occurs right before the start date of the new IEP.
  3. Otherwise, report blank.

Notes:

  1. Whatever end date is sending (minimum of plan end, exit eval or enrollment end date),  when it is not an instructional date, take the most previous instructional date and send that.
  2. 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:
    • When reporting from the Primary SPED Services School, then always use the enrollment tied to the Primary SPED Services School for the enrollment start date.
    • Otherwise, report from the enrollment that has an IC Service Type of P: Primary.
  3. When 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.
C

Documents > AZ locked Evaluation>Exit Evaluation> Exit Date


OR

Enrollments> End Date

Evaluation.

exitDate
OR
enrollment.

enddate

_etag

O