This association indicates the course sections to which a student is assigned.
The Sessions, Course Offerings, and Sections resources all need to be present for the Student Section Associations resource to process and send.
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.
|
| Post | Send a new record if a student's roster start date is changed. |
| Put | When section information is updated for a student or section.
|
| Delete | When a student is deleted from a course section. |
| Delete | Delete any future records if the student is given a roster end date for the course.
|
| Delete/Post | Delete the record if 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 | 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. |
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:
|
| Delete/Post | If the natural key changes all dependent data will delete/post.
|
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.
|
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. |
| sectionPlacement | Post/Put/Delete | The primary table used for sending data for this resource. |
| term | Delete&Post | Begin date |
| term | 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 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 | Month, day and year of the student's entry or assignment to the section. If blank, default is the start date of the first grading period |
| M | Student Information > General > Schedule > Roster Start Date OR System Administration> 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.
| M |
| |
| studentReference | A reference to the related Student resource | Reports the fields that are part of the Natural Key for the Student resource. | M | ||
| attemptStatusDescriptor | An indication of the student’s attempt status for the section. | This is optional, does not report. | O | ||
| endDate | Month, day, and year of the withdrawal or exit of the student from the section. |
| O | Student Information > General > Schedule > Roster End Date or System Administration > Calendar > Calendar> Terms | roster.endDate or terms.endDate |
| homeroomIndicator | Indicator that the class is the student''s designated homeroom used for daily attendance reporting |
| O | Scheduling > Course > Homeroom or Scheduling > Course > Section> Homeroom | course.homeroom or section.homeroom |
| repeatIdentifierType | An indication as to whether a student has previously taken a given course. | Does not report, this data is not collected in Campus. | O | ||
| teacherStudentDataLink Exclusion | Indicates that the student-section combination is excluded from calculation of value-added or growth attribution calculations used for a particular teacher evaluation. |
| O | ||
| etag | A unique system-generated value that identifies the version of the resource | O |
