Staff Cohort Associations (Core v3.X)

Tool Search: Ed-Fi

This association indicates the Staff associated with a cohort of students.

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. The Cohort can only be created from Program Admin> Programs> Programs tab. The Staff member must have an Ed-Fi ID to report.
Put	The end date is updated on the Program Sessions tab.
Delete/Post	If any part of the Natural Key changes: Instructor Start Date
Delete	If the Program Session is deleted.
Delete	Staff is removed from the "Instructor" field.

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.

This table describes the Natural Key Changes/Cascading Updates and Deletes logic of this object.

Action	Trigger
Post/Delete	Natural Key changes: If the Ed-Fi ID changes, a delete/post will occur with the cascading deletes from the Ed-Fi ID Change triggers. If the start date of the Program Session changes. If the Instructor is changed on the Program Sessions record.
Delete	Cascading Deletes: N/A - there are no dependent resources.

Action

Trigger

Post/Delete

Natural Key changes:

If the Ed-Fi ID changes, a delete/post will occur with the cascading deletes from the Ed-Fi ID Change triggers.
If the start date of the Program Session changes.
If the Instructor is changed on the Program Sessions record.

Delete

Cascading Deletes: N/A - there are no dependent resources.

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. Data will only send for years that have valid configuration.

Logic

The record will send to the scope year for the school year the program record is associated with.

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.

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 staff is assigned to the Program Session.	O	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.	O	Programs Admin> Programs> Program Sessions> End Date	programSession.enddate
studentRecord Access	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