Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	When a student is scheduled into a course section. A record reports for each Section record that is reported based on the Sections logic. When the roster start date is after the term end date, does not report a record for the prior term. Only sends records when the student has a enrollment in the schedule structure where the student is scheduled and is not marked as No Show or State Exclude. Does not send records when the Calendar Exclude checkbox is marked. Does not send records when the School Exclude checkbox is marked. Does not send records when the Course is marked as Inactive or Exclude.
Post	Sends a new record when a student's roster start date is changed.
Put	When section information is updated for a student or section. Updates when the course or section's homeroom field is changed.
Delete	When a student is deleted from a course section.
Delete	Deletes any future records when the student is given a roster end date for the course. Roster End Date must be before Term Start date of future records.
Delete/Post	Deletes the record when a student's roster start date is changed.

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	When a resource is toggled to off after data has sent, all sent data remains in the ODS but no new data sends.
Resync	When a record is in the Ed-Fi Identity Mapping table and not in the ODS, it is deleted from the Ed-Fi Identity Mapping table.
Resync	When a record is in the ODS and it does not have a matching record in Campus or the Ed-Fi Identity Mapping table, it is deleted from the ODS.
Resync	When a mapping is changed in Resource Preferences, a resync needs 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
Delete/Post	Natural Key change: The natural key logic from Sections and Students will update this resource when they change. When the students Begin Date changes.
Delete/Post	When the natural key changes all dependent data delete/post. Student Section Attendance Events, Grades

Action

Trigger

Delete/Post

Natural Key change:

The natural key logic from Sections and Students will update this resource when they change.
When the students Begin Date changes.

Delete/Post

When the natural key changes all dependent data delete/post.

Student Section Attendance Events, Grades

Scope Year Logic

This table describes scope year logic of this object.

Logic
Reports records in the scope year in which the course/section's calendar is aligned. Data only sends for years that have valid configuration.

Logic

Reports records in the scope year in which the course/section's calendar is aligned.

Data only sends for years that have valid configuration.

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus Table	Ed-Fi Action	Fields
roster	Post/Put/Delete	The primary table used for sending data for this resource.
roster	Put	End date
terms	Put	End date
course	Put	homeroom
section	Put	homeroom

Object Data Elements

This table describes data elements sent within the Student Section Association resource.

Data Element Label	Description	M, C, or O	Database Location
id	The unique identifier of the resource.	M
beginDate	Month, day and year of the student's entry or assignment to the section. When blank, default is the start date of the first grading period. Reports the roster start date for the term record in which the start date occurs. For any records in the future terms for that course, the earliest term start date reports. When the Start Date is null, the earliest term start date associated with the term descriptor selected for this section based on section schedule placement reports.	M	Student Schedule > Roster Start Date OR Calendar > Calendar > Terms roster.startDate or terms.startDate
sectionReference	A reference to the related Section resource. Reports the fields that are part of the Natural Key for the Section resource. localCourseCode is the Course Id. schoolId is the Reporting School Code. schoolYear is the End Year. sectionIdentifier is the Assignment Number. sessionName is the Term Name.	M
studentReference	A reference to the related Student resource. Reports the fields that are part of the Natural Key for the Students resource where the studentUniqueId is the Student State ID.	M
creditEarned	The amount of credit earned by the student for the course in the unit of time specified in CourseTimeUnit. The student must be on the roster of a course. Calculates Credits Earned using credits assigned to the Course Master Grading Task. Aggregates the credit assigned to the state reported grading task. When the course has a Credit Level of HS: High School OR MS: Middle School, AND credit is assigned to a Course Master grading task where the Grading Task Detail State Reported checkbox is marked, ONLY IF a student’s Grade is posted to that grading task, AND the grade is mapped to a state score in Score Groups & Rubrics WHERE the Passing Score checkbox is marked.	O
creditTypeDescriptor	Does not report.	O
termDescriptor	Does not report.	O
creditScheduled	Does not report.	O
receivingInstitutionCode	Does not report.	O
dualCreditSites	Does not report.	O
reportComments	Does not report.	O

Student Section Association (Missouri v3.6)