Ed-Fi Data v3.X - Student Program Associations

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

ActionTrigger
PostWhen a Flag is created and it is mapped to an Ed-Fi Program Type and the record overlaps the configured year.
PutWhen the student is given an End Date on a reported Flag.
Delete/Post

When part of the records Natural Key changes:

  • When the student has two of the same flags with the same start date and 1 record is deleted, the remaining records data will post.
DeleteWhen 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:

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


Object Data Elements

This table describes data elements sent within the Student Program Association resource.

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source GUI Path

Database Field

id  

The unique identifier of the resource.

 

M

 

 

educationOrganizationReference 

A reference to the related EducationOrganization resource.

Reports the District State Number.

M



 

programReference 

A reference to the related Program resource.

Reports Program reference.

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 when reporting from Flags.

M

Student Information> General> Flags> Start Date

programparticipation. startdate

endDate

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

Report the End Date when reporting from Flags.

O

Student Information> General> Flags> End Date

programparticipation. enddate

reasonExitedDescriptor

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

Optional, do not report.

O

 

 

servedOutsideOfRegularSession

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