Tool Search: Ed-Fi

This educational entity represents a setting in which organized instruction of course content is provided to one or more students for a given period of time. A course may be offered to more than one class/section. Instruction, provided by one or more teachers or other staff members, may be delivered in person or via a different medium.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	When a section is created and saved. Section Placement is required in order for the section to send. One record reports for each Section and Term Type combination. Does not send records when the Calendar Exclude checkbox is marked. Does not post a record when the course's State Reporting Exclude checkbox is marked.
Post	When Section Placement is changed and saved on a section. When the Local Course Number or Term type Override is changed.
Delete	When a section is deleted. When Section Placement is changed or removed and saved on a section.
Delete/Post	When the Local Course Number or Term type Override 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.
Delete	When a resource is toggled to off after data has sent and an action is performed that would trigger a delete, that data remains in the ODS until a resync is done.
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
Post/Delete	Natural Key Changes: When the School ID changes, all data remains under the old number and a resync needs to be completed to populate data under the new number. The delete tool needs to be used to remove all data from the old School ID.
Post/Delete	When any of the following changes in the Course Offerings resource: Local Course Code Session Name
Post/Delete	When the natural key changes all dependent data deletes/posts.
Dependent Resources	Staff Section Associations, Student Section Associations, Student Section Attendance Events, Grades.

Scope Year Logic

This table describes scope year logic of this object.

Logic
Sections report to the configured year to which they are aligned.
Data only send for years that have valid configuration.

Resource Preferences

This table describes the Resource Preferences of this object.

Data Element Label	Mapping Needed
Instructional Setting	Educational Environment Types

Identity Mapping Object Key

This table describes the Resource Preferences of this object.

Campus Object Key	Object Key Data Source
SectionPlacement	sectionID-termID

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus Table	Ed-Fi Action	Fields
section	Post/Put/Delete	The primary table used for sending data for this resource.
course	Put	Educational Environment Descriptor Sequence of Course
gradingTaskCredit	Put	Available Credits

Campus Table

Ed-Fi Action

Fields

section

Post/Put/Delete

The primary table used for sending data for this resource.

course

Put

Educational Environment Descriptor

Sequence of Course

gradingTaskCredit

Put

Available Credits

Object Data Elements

This table describes data elements sent within the Sections resource.

Data Element Label	Business Requirements and Rules	M, C or O	Data Source GUI Path Database Field
id	The unique identifier of the resource.	M
sectionIdentifier	The local identifier assigned to a section. Reports the Section ID number.	M	Course > Section section.sectionID
courseOfferingReference	A reference to the related CourseOffering resource. Reports the fields that are part of the Natural Key for the Course Offering resource. The School ID is the reporting District ID number. The Local Course Code is the Course Number. The School Year is the end year of the reported calendar. The sessions name is the Term Descriptor.	M
offeredGradeLevels	An unordered collection of sectionOfferedGradeLevels. The grade levels in which the section is offered. This collection should only be populated if it differs from the Offered Grade Levels identified at the Course Offering level. See the Arrays section below.	O

Arrays

Click here to expand...

Data Element	Business Requirements and Rules	M, C, or O	Database Field
gradeLevelDescriptor	Grade level at which curriculum for the specific course is designed to be taught. Grade level should reflect the grade at which the course curriculum is meant to be offered; not necessarily describe the students in the classroom. Reports the grade level.	M	Course > Course Editor > Grade

Type/Descriptor