This entity represents any type of list of designated students for tracking, analysis, or intervention.
NDE will be collecting programs in Cohort for the 2021-22 school year. Batch assign Cohort sessions using the Batch Assignment tool in Program Admin > Batch Assignment tool. Select "Program Sessions' as the Type to view the Cohort programs that can be assigned. The Search Filter option allows users to to mass assign Cohort sessions using Grade Levels, Ad Hoc or Scheduling Groups. The Batch Add option allows users to search for students and select them directly.
Object Triggering Logic
This table describes logic for triggering syncing of this object.
| Action | Trigger |
|---|---|
| Post | When a Student is assigned to a 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/Delete | Natural Key changes:
|
| Delete | Cascading Deletes: N/A - there are no dependent resources. |
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. | Reports the Start Date the student is assigned to the Cohort. | M | Student Information> Program Participation> Programs> Start Date | programparticipation.startdate |
| cohortReference | A reference to the related Cohort resource. | Reports the Natural Key of the Cohort resource. | M | ||
| studentreference | A reference to the related Student resource. | Reports the Natural Key of the 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> Programs> End Date | programparticipation.enddate |
| 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. | This is optional, does not report. | O | ||
| etag | O |
