This association indicates the course sections to which a student is assigned.

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 will report for each Section record that is reported based on the Sections logic. When roster start date is after the term end date, do not report a record for the prior term. Only send 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. Do not send records when the Calendar Exclude checkbox is checked. Do not send records when the School Exclude checkbox is checked. Do not send records when the Course is marked as Inactive. Do not send a record when the State Reporting Exclude checkbox is selected on the course.
Post	Send a new record when a student's roster start date is changed.
Put	When section information is updated for a student or section. Update when the course or section's homeroom field is changed.
Delete	When a student is deleted from a course section.
Delete	Delete 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	Delete 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 will remain in the ODS but no new data will send.
Resync	When 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	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 will be deleted from the ODS.
Resync	When 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: The natural key logic from Sections and Students will update this resource when they change. When the student's Begin Date changes.
Delete/Post	When the natural key changes all dependent data will 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 student's Begin Date changes.

Delete/Post

When the natural key changes all dependent data will 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 will only send for years that have valid configuration.

Logic

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

Data will only send 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	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. When blank, default is the start date of the first grading period'	Report the roster start date for the term record in which the start date occurs. For any records in the future terms for that course, use the earliest term start date. When Start Date is NULL, report the earliest term start date associated with the term descriptor selected for this section based on section schedule placement.	M	Schedule > Roster Start Date OR Calendar Information > Term Setup	roster.startdate or terms.startdate
section Reference	A reference to the related Section resource.	Reports the fields that are part of the Natural Key for the Section resource. For sessionName: When the Session Name Override checkbox is checked in the Session resource preferences, then report the 'District Id - Term Descriptor of the term being reported'. Otherwise, report the Term Descriptor of the term being reported.	M
student Reference	A reference to the related Student resource.	Reports the fields that are part of the Natural Key for the Student resource. Note: The Ed-Fi ID reports from the Student State ID field.	M
attemptStatus Descriptor	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.	Report the Roster End Date for the student, when it exists. When a roster end date is entered, delete any records for future terms for that section. When the Roster End Date is NULL, only report a value when: When the resource is triggered to send, the current date is on or after the Section > Term end date for the last term of the section, and The student is in grades 9-12. The value reported should be the section's terms.endDate Otherwise, do not report.	O	Schedule > Roster End Date OR Calendar Information > Terms	roster.endDate or terms.endDate
homeroom Indicator	Indicator that the class is the student''s designated homeroom used for daily attendance reporting.	This is optional, does not report.	O
CourseEntry Descriptor	The way the student entered this course section, either as a new enrollee or as a transfer from another section at the same school.	Report 'T' when the student transferred into a different section of the same course in the same school year. Student's roster start date is after the earliest term start date based on section schedule placement. Student must have been scheduled into the same course in a different section prior to the roster start date of the section being reported. The sections must have the same section schedule placement in order to be considered. Report 'R' when the student left a section, then later returned to that same section. Else, report 'N'.	M
CourseExit Descriptor	The type of exit the student had from this course section.	A Course Exit Descriptor is sent when the roster record has en end date and is on/before the term end date OR the current date is on/after the section end date and the grade is 9-12 AND a student meets one of the conditions below, reports with the following logic: When the Transcript > Credits Earned = Credits Attempted, reports CF. When Transcript > Credits Earned is less than Credits Attempted bu greater than zero (0), reports CP. When Transcript > Credits Earned is zero (0), reports CN. This only reports for the last term type based on the section schedule placement and the roster end date. Conditions: Students receives a posted grade to the Transcript for this course. This triggers when the Transcript records are posted via the Post to Transcripts too. Manual entries do now trigger since they lack a section ID to trace back to the student's course record. The student has a resident district of 090835000 or 070801000 AND the course number of the scheduled course matches a Transcript record in any school within the configuration year. A Course Exit Descriptor is sent when a Roster End Date is entered and saved for a student. When the Student Roster End Date is before the highest Term End Date based on the section schedule placement for that term type/section combination and the Enrollment End Date is null or after the Roster End Date, reports SC. When a student's Roster End Date is before the highest Term End Date based on the section schedule placement for that term type/section combination and is equal to the student's latest Enrollment End Date, reports LS. Otherwise, reports blank.	C	Transcript > Credits Earned Transcript > Credits Attempted	transcriptDetal.creditsEarned transcriptDetal.creditsAttempted
DualCredit	A flag indicating when this student is earning Dual Credit in a Dual Credit Course.	Report 'True' when Dual Credit check box is selected on the Course editor. Report 'True' when Dual Credit check box is selected on the Section editor. Report 'True' when Dual Credit check box is selected on the Roster Batch Edit editor. Else report 'False'.	M	Course Information > Dual Credit Section Information > Dual Credit Section Batch Edit > Dual Credit	course.dualCredit section.dualCredit
Concurrent Enrollment	A Flag indicating When this student is concurrently enrolled in a course that offers concurrent enrollment.	Report 'True' when the Post Secondary check box is checked on the course. Else, report 'False'.	M	Course Information > Post Secondary	course.postSecondary
repeatIdentifier Type	An indication as to whether a student has previously taken a given course.	Does not report, this data is not collected in Campus.	O
teacherStudent DataLink Exclusion	Indicates that the student-section combination is excluded from calculation of value-added or growth attribution calculations used for a particular teacher evaluation.	Does not report, this data is not collected in Campus.	O
etag	A unique system-generated value that identifies the version of the resource.		O

Course Entry Descriptor

Code Value	Short Description	Description
N	New enrollment
R	Re-entry
T	Transfer

Arizona Ed-Fi Data v3.5 - Student Section Association