Student Cohort Associations (Nebraska v3.5)

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.

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

  • The Cohort can only be created from Program Admin> Programs> Programs tab.
Put

The end date is updated on the Student's Program tab.

Delete/Post

If any part of the Natural Key changes:

  • Begin Date
Delete/PostWhen the student has two of the same flags with the same start date and 1 record is deleted, the remaining records data will post.
DeleteIf 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.

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 Participation record changes.
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.

Identity Mapping Object Key

This table describes the Event Queue Detail of this object.

campusObjectTypeObject Key Data Source
ProgramParticipationparticipationID


Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus TableEd-Fi ActionFields
programParticipationPostThe 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.

Reports the Start Date the student is assigned to the Cohort.

MStudent Information> Program Participation> Programs> Start Dateprogramparticipation.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.

  1. Reports the End Date the student is ended from the Cohort.
  2. If NULL, do not report.
CStudent Information> Program Participation> Programs> End Dateprogramparticipation.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