Tool Search: Ed-Fi

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 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 an enrollment in the schedule structure where the student is scheduled. Does not send records when No Show or State Exclude is marked on the Enrollment. Does not send records when Calendar Exclude is marked. Does not send records when School Exclude is marked. Does not send records when the Course is Inactive (Active checkbox not marked). Does not send records when the Course is marked as Exclude from State Reporting.
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	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	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 is sent.
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 is need 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 updates this resource when they change.
Delete/Post	When the natural key changes all dependent data is deletes/posted. Student Section Attendance Events, Grades

Action

Trigger

Delete/Post

Natural Key change:

The natural key logic from Sections and Students updates this resource when they change.

Delete/Post

When the natural key changes all dependent data is deletes/posted.

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 and Rules

Mandatory, Conditional or Optional

Location

beginDate

Month, day and year of the student's entry or assignment to the section. When blank, the 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 is used.
When the Start Date is NULL, reports the earliest term start date associated with the term descriptor selected for this section based on section schedule placement.

Schedule > Roster Start Date

roster.startDate

Terms Setup > Start Date

terms.startDate

sectionReference

A reference to the related Section resource

Reports the fields that are part of the Natural Key for the Section resource

sessionName = KS specific sessionName for the mapped Ed-Fi code value:

Kansas specific sessionName translation table


Q1	SchoolYear.endYear + ' Quarter 1'
Q2	SchoolYear.endYear + ' Quarter 2'
Q3	SchoolYear.endYear + ' Quarter 3'
Q4	SchoolYear.endYear + ' Quarter 4'
S1	SchoolYear.endYear + ' First Semester'
S2	SchoolYear.endYear +' Second Semester'
SM	'Summer'
T1	SchoolYear.endYear + ' Trimester 1'
T2	SchoolYear.endYear + ' Trimester 2'
T3	SchoolYear.endYear + ' Trimester 3'
YR	SchoolYear.endYear +' School Year'

studentReference

A reference to the related Student resource

Reports the fields that are part of the Natural Key for the Student resource

studentUniqueId = Student State ID

attemptStatusDescriptor

An indication of the student’s attempt status for the section.

This is optional and does not report.

endDate

Month, day, and year of the withdrawal or exit of the student from the section.

Reports the roster end date for the student.

When a roster end date is entered, deletes any records for future terms for that section.
When NULL, reports the latest term end date associated with the term descriptor selected for this section based on section schedule placement.

Schedule > Roster End Date

roster.endDate

Terms Setup > End Date

terms.endDate

homeroomindicator

Indicator that the class is the student's designated homeroom used for daily attendance reporting.

Reports True when the Homeroom checkbox is marked on either the Section or the Course the section is assigned to,
Reports False when the Homeroom checkbox is not marked.

Course Information > Homeroom

course.Homeroom

Section Information > Homeroom

section.Homeroom

repeatIdentifierType

An indication as to whether a student has previously taken a given course.

NEDM: Repeat Identifier Repeated, counted in grade point average Repeated, not counted in grade point average Not repeated Other .

This data is not collected in Campus.

teacherStudentDataLinkExclusion

Indicates that the student-section combination is excluded from calculation of value-added or growth attribution calculations used for a particular teacher evaluation.

This data is not collected in Campus

courseStatusDescriptor

Indication of the student's status in the course

Always sends 'Enrolled' as the courseStatusDescriptor (see Type/Descriptors table below).

Type and Descriptors

Click here to expand...

Course Status Descriptors

Code Value	Description	Namespace	Short Description
Certificate Earned	Certificate Earned	uri://ksde.org/CourseStatusDescriptor	Certificate Earned
Completed (Fail)	Completed (Fail)	uri://ksde.org/CourseStatusDescriptor	Completed (Fail)
Completed (Pass)	Completed (Pass)	uri://ksde.org/CourseStatusDescriptor	Completed (Pass)
Enrolled	Enrolled	uri://ksde.org/CourseStatusDescriptor	Enrolled
Enrolled (Migrant only)	Enrolled (Migrant only)	uri://ksde.org/CourseStatusDescriptor	Enrolled (Migrant only)
Exited before course completion (Migrant only)	Exited before course completion (Migrant only)	uri://ksde.org/CourseStatusDescriptor	Exited before course completion (Migrant only)
Received Services (Summer Migrant only)	Received Services (Summer Migrant only)	uri://ksde.org/CourseStatusDescriptor	Received Services (Summer Migrant only)
Record Submitted in Error	Record Submitted in Error	uri://ksde.org/CourseStatusDescriptor	Record Submitted in Error

Student Section Associations (Kansas v3.6)