Michigan Ed-Fi Data v3.1 - Student Cohort Associations

Classic View: System Administration > Ed-Fi

Search Terms: Ed-Fi

This entity represents any type of list of designated students for tracking, analysis, or intervention.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a Student is assigned to an Instruction Mode 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:

  • 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

When an Instruction Mode record is added to a student with Instruction Mode = 01, 02, or 03 and Start Date within Scope Year.

Put
A change made to End Date.
Delete/Post
A change made to: Instruction Mode, Start Date.
DeleteIf Instruction Mode record is deleted.


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.

  1. Reports the Start Date.
M
Student Information> Program Participation> State Programs > Instruction Mode

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

studentReference

A reference to the related Student resource.

  1. 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.
  2. If NULL, do not report.
C
Student Information> Program Participation> State Programs> Instruction Mode

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.

  1. This is optional, does not report.
O

etag

O