Indiana Ed-Fi Data v2.4/3.1 - Student Section Associations

Classic View: System Administration > Ed-Fi

Search Terms: Ed-Fi

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. A record will report for each Section record that is reported based on the Sections logic. If roster start date is after the term end date, do not report a record for the prior term. Only send records if the student has a enrollment in the schedule structure where the student is scheduled and is not marked as No Show. Do not send records if the Calendar Exclude check box is checked. Do not send records if the School Exclude check box is checked. Do not send records if the Course is marked as Inactive or Exclude.
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. 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 if 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 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: The natural key logic from Sections and Students will update this resource if they change. If the students Begin Date changes.
Delete/Post	If 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 if they change.
If the students Begin Date changes.

Delete/Post

If 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.
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	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. If 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	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. Report the following in this reference: schoolID 10+District+School classPeriodName Report the name of the period the student has this section. classroomIdentificationCode Reports Room Name. termDescriptor See Descriptor Logic for this. schoolYear Reports current end year of the School Year. YYYY (ex; 2022) uniqueSectionCode Reports the section ID of the section being reported. sequenceOfCourse Report as '1'.	M	SchoolID System Administration > Resources > School > School Number System Administration > Resources > District Information > District Number For Multiple Keys and Secrets, District Number reports from the connections page in System Administration > Ed-FI > Ed-Fi Configuration > Connection classPeriodName System Administration > Calendar > Calendar > Periods> Schedule Structure > Period Name classroomIdentificationCode System Administration > Resources> Resources> Rooms termDescriptor See Descriptor List (This is an actual descriptor.) schoolYear System Administration > Calendar > SchoolYear > End year of the school year uniqueSectionCode Scheduling > Courses > Section > Section Number sequenceOfCourse Report as '1'.
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.	Report the roster end date for the student If a roster end date is entered, delete any records for future terms for that section If NULL, report the latest term end date associated with the term descriptor selected for this section based on section schedule placement.	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	Report "True" if the check box is checked on either the Section or the Course the section is assigned to. Else, report False.	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.	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

Descriptors

Term Descriptors

Code	Description	Namespace	Short Descritpion
Fall Semester	Fall Semester	http://doe.in.gov/Descriptor/TermDescriptor.xml	Fall Semester
First Quarter	First Quarter	http://doe.in.gov/Descriptor/TermDescriptor.xml	First Quarter
First Trimester	First Trimester	http://doe.in.gov/Descriptor/TermDescriptor.xml	First Trimester
Fourth Quarter	Fourth Quarter	http://doe.in.gov/Descriptor/TermDescriptor.xml	Fourth Quarter
MiniTerm	MiniTerm	http://doe.in.gov/Descriptor/TermDescriptor.xml	MiniTerm
Other	Other	http://doe.in.gov/Descriptor/TermDescriptor.xml	Other
Second Quarter	Second Quarter	http://doe.in.gov/Descriptor/TermDescriptor.xml	Second Quarter
Second Trimester	Second Trimester	http://doe.in.gov/Descriptor/TermDescriptor.xml	Second Trimester
Spring Semester	Spring Semester	http://doe.in.gov/Descriptor/TermDescriptor.xml	Spring Semester
Summer Semester	Summer Semester	http://doe.in.gov/Descriptor/TermDescriptor.xml	Summer Semester
Third Quarter	Third Quarter	http://doe.in.gov/Descriptor/TermDescriptor.xml	Third Quarter
Third Trimester	Third Trimester	http://doe.in.gov/Descriptor/TermDescriptor.xml	Third Trimester
Year Round	Year Round	http://doe.in.gov/Descriptor/TermDescriptor.xml	Year Round