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.

ActionTrigger
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
DeleteIf the Program Session is deleted.
DeleteStaff 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.

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

  • Data will only send for years that have valid configuration.


Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus TableEd-Fi ActionFields
programSessionPostThe 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 LabelBusiness RequirementBusiness RulesM, 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.

  1. Reports the Start Date the staff is assigned to the Program Session.
OPrograms Admin> Programs> Program Sessions> Start DateprogramSession.startdate
cohortReference

A reference to the related Cohort resource.
  1. Reports the Natural Key of the Cohort resource.
M

staffReference

A reference to the related Staff resource.

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

  1. Reports the End Date the staff is ended from the Program Session.
  2. If NULL, do not report.
OPrograms Admin> Programs> Program Sessions> End DateprogramSession.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.

  1. This is optional, does not report.
O

etag

O