This entity represents any type of list of designated students for tracking, analysis, or intervention.
Object Triggering Logic
This table describes logic for triggering syncing of this object.
| Action | Trigger |
|---|---|
| Post | When a Student is assigned to an Instruction Mode program that is reported as a Cohort in the configured year and they have a valid Student School Association in the current scoped year. |
| Put | The end date is updated on the Student's Program tab. |
| Delete/Post | If any part of the Natural Key changes:
|
| Delete/Post | 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. |
| Delete | If the Program Participation record is Deleted. |
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.
| Action | Trigger |
|---|---|
| None | If a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send. |
| Resync | If 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. |
| Resync | If 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. |
| Resync | If 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.
| Action | Trigger |
|---|---|
| Post | When an Instruction Mode record is added to a student with Instruction Mode = 01, 02, or 03 and Start Date within Scope Year. |
| Put | A change made to End Date. |
| Delete/Post | A change made to: Instruction Mode, Start Date. |
| Delete | If Instruction Mode record is deleted. |
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 record is associated with.
|
Identity Mapping Object Key
This table describes the Event Queue Detail of this object.
| campusObjectType | Object Key Data Source |
|---|---|
| ProgramParticipation | participationID |
Event Queue Detail
This table describes the Event Queue Detail of this object.
| Campus Table | Ed-Fi Action | Fields |
|---|---|---|
| programParticipation | Post | The 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.
| 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 | |||
| beginDate | The month, day, and year on which the Student was first identified as part of the Cohort. |
| M | Student Information> Program Participation> State Programs > Instruction Mode | |
| cohortReference | A reference to the related Cohort resource. |
| M | ||
| studentReference | A reference to the related Student resource. |
| M | ||
| endDate | The month, day, and year on which the Student was removed as part of the Cohort. |
| C | Student Information> Program Participation> State Programs> Instruction Mode | |
| sections | The Cohort representing the subdivision of students within one or more sections. For example, a group of students may be given additional instruction and tracked as a cohort. |
| O | ||
| etag | O |
