Arizona Ed-Fi Data v3.1 - Student Program Associations

Last Modified on 03/19/2024 8:03 am CDT

Classic View: System Administration > Ed-Fi

Search Terms: Ed-Fi

This educational entity represents the organization of subject matter and related learning experiences provided for the instruction of students on a regular or systematic basis.

Object Triggering Logic

This tables below describe the logic for triggering syncing of this object.

Flags

Click here to expand...
ActionTrigger
Post

Report a record based on the students enrollment record:  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 the student has multiple overlapping enrollments within the same school, but no 'P: Primary' enrollment, report the most recent 'T: AOI' enrollment.
  • If the 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 the 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.

  • 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 records if the Grade Level Exclude check box is checked in the grade level record tied to the calendar the student is enrolled in.
  • If there are multiple eligible enrollments, and a 21st CCLC (codes 42-47) Flag record is saved, look to see if any of the enrollments have a Service Type of 'S', and if so, send the Student Program Association record with that EdOrgId. If there are no Service Type of 'S' records, send for the enrollment with a Service Type of 'P: Primary'.
  • Do not trigger a Flags record for records tied to State Code 21: "21st Century program".
Post

When a Flag is created and saved for a student that is mapped to a state program code.

  • Flag start date must be on or after enrollment start date.
Post

When a new enrollment is created for a student that has an active Flag mapped to a state program code.

  • Enrollment start date must be after Flag start date.
  • Flag end date must be NULL or after enrollment start date.
  • If the enrollment overlaps an existing enrollment within the same school, follow the post requirements based on the student's enrollment record, otherwise post a new record.
Put

When a Program is changed on an existing Flag for a student mapped to a state program code other than code '21'.

  • If the state program code is changed from one mapped code to another, post the updated code.
Delete/PostWhen a start or end date is entered or changed for an existing record.
Delete/PostWhen an enrollment end date is entered for a student with a valid enrollment end status:  W1-W13.
DeleteDelete the existing record if a Program is changed on an existing flag.
Delete

Flag is deleted for a student.

  • If the student has two flags with the same Program Name and Start Date, do not delete this record unless all programs or needs associated with the record are deleted.
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.

Title 1

Click here to expand...
ActionTrigger
Post

Report a record based on a Title 1 record being saved and overlapping the students enrollment record.

  • Send for each unique overlap between any enrollment records and any Title 1 records, where both are tied to the same calendar.
  • 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!
Post

When Title 1 record overlaps the student's Enrollment record for that school.

  • Title 1 record start date is on or after enrollment start date.

  • Title 1 record start date is before enrollment start date, and the Title 1 record end date is either null or after the enrollment start date.
PostWhen a new enrollment for the same school indicated in a pre-existing Title 1 record is created for a student, which had not previously had an eligible enrollment record (either didn't have one in that school, didn't have one that overlapped, or didn't have one that wasn't excluded).
Delete/PostWhen a start or end date is entered or changed on an existing Title 1 record.
Delete/PostWhen an enrollment end date is entered for a student with a valid enrollment end status:  W1-W13.
Delete/PostWhen the Title 1 service is changed on an existing record.
Delete/PostWhen the enrollment tied to the Title 1 record is deleted or made ineligible, and there is another eligible enrollment in the student's record (another overlapping one with perhaps a lower ranked Status value, non-excluded).
Delete

Title 1 record is deleted.

  • If the student has two or more Title 1 records with the same Title 1 program value and Start Date, do not delete the record unless all programs or needs associated with the primary keys are deleted.
DeleteTitle 1 record's start date or end date is changed, such that it no longer overlaps an eligible enrollment.
DeleteWhen there is a delete/edit to the eligible enrollment reporting is based on, such that there are no longer any eligible enrollments.

EL

Click here to expand...
ActionTrigger
Post

Report a record based on the students enrollment record: 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 the student has multiple overlapping enrollments within the same school, but no 'P: Primary' enrollment, report the most recent 'T: AOI' enrollment.
  • If the 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 the 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.
  • 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!.
PostWhen a LEP Service is created and saved for a student that is mapped to a state program code.
PostWhen a Service is changed on an existing Service for a student with a state program code.
Post

When a new enrollment is created for a student that has an active Service.

  • Enrollment start date must be after Service start date.
  • Service end date must be NULL or after enrollment start date.
  • If the enrollment overlaps an existing enrollment within the same school, follow the post requirements based on the student's enrollment record, otherwise post a new record.
Put

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

  • When an enrollment end date is entered for a student with a valid enrollment end status:  W1-W13.
  • When an EL Service Type is updated.
DeleteDelete the existing Service if the Service is changed.
Delete

A Service is Deleted.

  • If the student has two services with the same start date, do not delete this record unless all services with the same start date are deleted.
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.


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
NoneIf a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
ResyncIf 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.
ResyncIf 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.
ResyncIf 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/Delete

Natural Key changes:

  • If the Flag Start Date or Flag Name changes, all Student Program Associations will be deleted and then re-posted. 
DeleteCascading Deletes: N/A - No resources exist under this resource.


Scope Year Logic

This table describes scope year logic of this object.

Logic
The record will send to the scope year for the school year the program association record is associated with.
Data will only send for the years that have valid configuration.

Identity Mapping Object Key

This table describes the Identity Mapping Object Key of this object.

campusObjectTypeObject Key Data Source
ProgramParticipationparticipationID


Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus TableEd-Fi ActionFields
programsPutThe primary table used for sending data for this resource.
programparticipationPutThe primary table used for sending data for this resource.


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.

Flags

Click here to expand...

Data Element Label

Business Requirement

Business Rules

M,C, or O

Data Source GUI Path

Database Field

educationOrganizationReference

The identifier assigned to an education organization.

Report the School Entity ID.MSystem Administration > Resources > School editor > Entity IDschool.entityid
programReference

The identifier assigned to an education organization.

  1. Program Type: 
    • Report 'Support Program' when the Ed-Fi Code of the mapped dictionary value is any of the following (program ID =60): 
      1. 22,
      2. 27,
      3. 28,
      4. 29,
      5. 30,
      6. 31,
      7. 32,
      8. 33,
      9. 34,
      10. 35,
      11. 36,
      12. 38,
      13. 40,
      14. 41,
      15. IM,
      16. 21st Century Community Learning Centers Cont-Yr2,
      17. 21st Century Community Learning Centers Cont-Yr3,
      18. 21st Century Community Learning Centers Cont-Yr4,
      19. 21st Century Community Learning Centers Cont-Yr5,
      20. 21st Century Community Learning Centers Cycle 14
      21. 21st Century Community Learning Centers Cycle 15
    • Report 'Grand Canyon Diploma' when the Ed-Fi code of the mapped dictionary value is 'Grand Canyon Diploma'.
      • Program Type ID = 60
    • Report 'Dropout Recovery Program' when the Ed-FI code of the mapped dictionary value is = Dropout Recovery Program.
      • Program Type ID = 61
  2. Program Education Organization Id:  Report the District Entity ID from the School Editor if populated.
    • If NULL, report the District Entity ID.
  3. Program Name:  Reports the Program Code + Program Name.
M

Programs > Flags > State Program Code


System Administration > Resources > Resources > School Editor > District Entity ID


OR


System Administration > Resources > Resources > District Information > Entity ID

program.code

customschool.districtentityid

or

customdistrict.entityid

beginDate

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

  1. Report the start date from the Flag if:
    • Flag Start Date must be after enrollment Start Date.
    • Enrollment End Date must be NULL or after Flag start date.
    • The Flag record is tied to any of the '21st Century Community Learning Centers...' codes (codes 42-47).
  2. Report the Enrollment Start Date if:
    • Enrollment Start Date is after the Flag Start Date.
    • Flag End Date is NULL or after Enrollment Start Date.
M

Student Information > General > Flags > Start Date


OR


Enrollment Start Date

programparticipation.StartDate
endDate

The month, day, and year on which the Student exited the Program or stopped receiving services.

  1. Report the end date from Flag if populated.
    • Flag End Date must be before Enrollment End Date or before last instructional day of the calendar.

  2. Report Enrollment End Date if populated.

    • Enrollment End date must be after Flag Start Date and before Flag End Date and before last instructional day.

  3. Else, report the last instructional date from the calendar where the student is enrolled.
C
programparticipation.EndDate

reasonExitedDescriptor

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

  1. Report from Flags > Exit Reason if <> NULL, and dictionary value is mapped in the Ed-Fi Resource Preferences area.
  2. Otherwise, do not report.

Programs > Flags > Exit Reason

Title 1

Click here to expand...

Data Element Label

Business Requirement

Business Rules

M,C, or O

Data Source GUI Path

Database Field

educationOrganizationReferenceThe identifier assigned to an education organization.Report the School Entity ID.MSystem Administration > Resources > School editor > Entity IDschool.entityid
programReference

The identifier assigned to an education organization.

  1. Program Type: 
    • Report 'Support Program' when the mapped Ed-Fi Code is one of the following:  28, 29, 30, 31, 32, 38, 39, 40, 41, IM.
      • Program Type ID  = 59
  2. Program Education Organization Id:  Report the District Entity ID from the School Editor if populated.
    • If NULL, report the District Entity ID.
  3. Program Name:  Reports the Program Code + Program Name 
M
  1. Programs Participation > Title 1 > Title 1 record > Title 1 Service
  2. System Administration > Resources > Resources > School Editor > District Entity ID
    OR
    System Administration > Resources > Resources > District Information > Entity ID

program.code

customschool.districtentityid

or

customdistrict.entityid

beginDate

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

Report the start date from the Title 1 record.MPrograms Participation > Title 1 > Title 1 record > Start Dateprogramparticipation.StartDate
endDate

The month, day, and year on which the Student exited the Program or stopped receiving services.

Report the end date from the Title 1 record if populated.CPrograms Participation > Title 1 > Title 1 record > End Dateprogramparticipation.EndDate
reasonExitedDescriptor

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

Do not report.


EL

Click here to expand...

Data Element Label

Business Requirement

Business Rules

M,C, or O

Data Source GUI Path

Database Field

educationOrganizationReference

The identifier assigned to an education organization.

Report the School Entity ID.MSystem Administration > Resources > School editor > Entity IDschool.entityid
programReference

The identifier assigned to an education organization.

  1. The Program Type = 'ELL'
  2. Program Type ID = 1
  3. Program Education Organization Id:  Report the District Entity ID from the School Editor if populated.
    • If NULL, report the District Entity ID.
  4. Program Name:  Reports the Program Code + Program Name



beginDate

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

  1. Report the start date from the EL Service if:
    • EL Service Start Date is after enrollment Start Date.
    • Enrollment End Date must be NULL or after EL Service start date.
  2. Report the Enrollment Start Date if:
    • Enrollment Start Date is after the EL Service Start Date.
    • EL Service End Date is after the Enrollment Start Date.
M

Student Information > General> Program Participation > EL > EL Services > Start Date


or


Student Information > General > Enrollments > Start Date

lepservice.StartDate

or

enrollment.startdate

endDate

The month, day, and year on which the Student exited the Program or stopped receiving services.

  1. Report the end date from EL Service if populated
    • EL Service End Date must be before Enrollment End Date or before last instructional day of the calendar.
  2. Report Enrollment End Date if populated.

    • Enrollment End date must be after EL Service Start Date and before EL Service End Date and before last instructional day.

  3. Else, report the last instructional date from the calendar where the student is enrolled.
C

Student Information > General > Program Participation > EL > EL Services > End Date


or


Student Information > General > Enrollments > End Date

lepservice.EndDate

or

enrollment.EndDate

reasonExitedDescriptor

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

  1. Report the mapped Ed-Fi Code from the Exit Reason selected on the EL Service if populated.
  2. Report ELL02 if Enrollment End Date is populated and End Status = W1-13.
    • Program End Date must be null or on or after the Enrollment End Date.
  3. Report ELL08 if Enrollment End Date is populated and End Status = WK.
    • Program End Date must be null or on or after the Enrollment End Date.
  4. Else, report ELL06.

Student Information > General > Program Participation > EL > EL Services > Exit Reason



Related Articles

  • None
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