This association indicates the Staff associated with a cohort of students.
NDE will be collecting programs in Cohort for the 2021-22 school year. In order to assign a staff member to a Cohort Program, a Program Session needs to be created in Program Admin > Programs > Program Sessions.
Object Triggering Logic
This table describes logic for triggering syncing of this object.
| Action | Trigger |
|---|---|
| Post | When a Staff is assigned as "Instructor" to a Program Session that is reported as a Cohort in the Scoped Year.
|
| Put | The end date is updated on the Program Sessions tab. |
| Delete/Post | If any part of the Natural Key changes:
|
| Delete | If the Program Session is deleted. |
| Delete | Staff is removed from the "Instructor" field. |
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.
|
Event Queue Detail
This table describes the Event Queue Detail of this object.
| Campus Table | Ed-Fi Action | Fields |
|---|---|---|
| programSession | 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 | 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 staff is assigned to the Program Session. | M | Programs Admin > Programs > Program Sessions > Start Date programSession.startdate |
| cohortReference | A reference to the related Cohort resource. Reports the Natural Key of the Cohort resource. | M | |
| staffreference | A reference to the related Staff resource. Reports the Natural Key of the Staff resource. | M | |
| endDate | The month, day, and year on which the Student was removed as part of the Cohort. Reports the End Date the staff is ended from the Program Session. If NULL, do not report. | C | Programs Admin> Programs> Program Sessions> End Date programSession.endDate |
| studentRecordAccess | Indicator of whether the staff has access to the student records of the cohort per district interpretation of FERPA and other privacy laws, regulations, and policies. This is optional, does not report. | O | |
| etag | O |
