• Home
  • State Specific Information
  • Indiana
  • Indiana Ed-Fi Resources - v2.4/3.1

Indiana Ed-Fi Data v2.4/3.1 - Student Program Associations

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 table describes logic for triggering syncing of this object.

ActionTrigger
PostWhen a Program is created and the record overlaps the configured year.
PutWhen the student is given an End Date on a reported Program:
  • Parent in Military: A Military Connections record exists for a Guardian of the student or the student themselves, Start/End Dates are changed so the record no longer overlaps configured year, the Guardian checkbox is checked/unchecked, the record is deleted
  • Foster Care: When a Foster Care record exists for the student, Start/End Dates are changed so the record no longer overlaps configured year, the record is deleted
  • Homeless, Unaccompanied Youth:  A student has a Homeless record that overlaps the configure year, Start/End Dates are changed so the record no longer overlaps configured year,  the record is deleted, the Unaccompanied Youth field is changed, the Runaway checkbox is checked or unchecked.
  • Foreign Exchange: A student has the Foreign Exchange check box checked on enrollment that overlaps configure year, enrollment Start/End Dates are changed so the record no longer overlaps configured year and there is no start of a new enrollment with the Foreign Exchange check box checked that overlaps the configured year.
  • High Ability: A student has a High Ability record selected on enrollment that overlaps configure year, enrollment Start/End Dates are changed so the record no longer overlaps configured year and there is no start of a new enrollment with the High Ability value selected check box that overlaps the configured year, current enrollment has a change made on the High Ability field.
  • Migrant Education: A student has the Migrant check box checked on enrollment that overlaps configure year, enrollment Start/End Dates are changed so zthe record no longer overlaps configured year and there is no start of a new enrollment with the Migrant check box checked that overlaps the configured year.
  • School Food Service: A student has a FRAM record of FREE or REDUCED that overlaps the configure year, Start/End Date are changed so the record no longer overlaps the configure year, eligibility changes from Free or Reduced.
  • Section 504: A student has a Section 504 program that overlaps the configure year, Start/End Date are changed so the record no longer overlaps the configure year.
  • Virtual Education: A student has an enrollment with a value in 'Virtual Student' that overlaps the configuration year, Start/End Dates are changed so the record no longer overlaps the configure year, the enrollment is updated to change the value in 'Virtual Student'. 
  • Refugee:  A student has a Refugee state program that overlaps the configuration year - start/end dates are changed, reason exited is added or removed.
  • Multilingual Learners: A student has an Active EL record that overlaps the config year with services. The start/end dates change, the services change, the EL record Program Status changes from EL to Exited, services end, or parent declines services after the original record has sent. 
  • Homebound: A student has a Homebound program that overlaps the configurations year, start/end dates change, reason exited is added or removed.
  • Immigrant Education: A student has a Birth Country other than 'USA' and the Birth country changes to 'USA'.
Delete/Post

When part of the records Natural Key changes:

  • When the student has two of the same Programs with the same start date and 1 record is deleted, the remaining records data will post.
Delete
  • Immigrant Education: A student has a Birth Country other than 'USA' and the Birth country changes to 'USA'.
  • When a Flag is deleted or when the record no longer overlaps the configured year.

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:

  • LEA Reference - District Numbers cannot change after data has been sent.  If a district number changes, we would expect an Ed-Fi error and this change would not be supported.
  • If an Ed-Fi ID changes, a delete/post will occur with the cascading deletes from the Ed-Fi ID Change triggers.
  • If the Program Name or Program Type Descriptor mapping changes and a resync is completed.
  • If the Flag Start Date or Flag Name changes, all Student Program Associations will be deleted and then reposted
DeleteCascading Deletes:  N/A no resources exists 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.

Error Log

ErrorPossible Cause/How to Fix
Error code return from Ed-Fi. 409: [message:The value supplied for the related 'program' resource does not exist.].This error is likely the result of either the Programs Resource was not sent or the state has not updated the logic to accept this program as it is not actually available until October 2021.
No data sending for Homebound/Hospitalized when the program has been ended

This is due to the Exit Reason.  If the list of exit reasons is not a state list, the data will not send as there is nothing to match the reason to. 

Index> Sys Admin> Custom> Attribute/Dictionary> Program Participation> Exit Reason: Add the state list provided below 'Reason Exited Descriptor'.

Object Data Elements

This table describes data elements sent within the Student Program Association resource. Data Element Labels in bold are part of the Natural Key and are required data elements for Data to send to Ed-Fi.

Data Element Label

Business Requirement

Business Rules

M, C or O

Location

id  

The unique identifier of the resource.

 

M

 

educationOrganization

Reference 

A reference to the related EducationOrganization resource.

Reports the District State Number.

  • 10+districtID+SchoolID

M

System Administration > Resources > District Information > State District Number

programReference 

A reference to the related Program resource.

  1. Reports Program reference.
    • See the Program Reference below.
  2. FRAM Program Reference
    • If a student has two records in a school year; one has a start date within the previous school year and an end date in the current school year; and, the student has a new record in the current school year, report the student's new record.

M


studentReference

A reference to the related Student resource.

Reports the Student Reference.

M

 

beginDate

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

Report the Start Date in the program.

  • See Program Type info below.

M

Student Information > General > Program Participation > Start Date


program

participation. startdate

endDate

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

Report the End Date in the program.

  • See Program Type info below.

O

Student Information > General > Program Participation > End Date


program

participation. enddate

reasonExitedDescriptor

A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

Standard Logic:

Report the reason the student exited from the program.


Multilingual Learners Program Logic:

  • Report '99' if End Date has a value.
  • Otherwise, do not report.

C

 

servedOutsideOf

RegularSession

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

Optional, do not report.

O

 

enrollmentStatus

 

Optional, do not report.

O

 

services

An unordered collection of studentProgramAssociationServices. Indicates the services being provided to the student by the program.

Optional, do not report.

O

 

InstructionalDaysA total of days the student received instruction while in the program.Optional, do not report.O
InstructionalMinutesA total of minutes the student received instruction while in the program.Optional, do not report.O

Program Reference

Data Element LabelBusiness RequirementBusiness RulesM,C, or O
ProgramTypeIDReport the type of Program the student is in.Reports the type in the programReference.
  • There are several types from several areas of Campus, see Type list below for logic.
C
ProgramNameReports the name of the program the student is in.Reports the name in the programreference.
  • See logic below.
C
ProgramEdOrgIDReports the education organization ID the supporting the program.Reports the edOrgID that is supporting this program.
  • See Logic below.
C


Types/Descriptors

Click here to expand...