Tool Search: Ed-Fi

This entity represents an offering of a course by school during a session, representing the course catalog of available courses.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	When a section with Section Placement is created and saved. One record reports per Course and Term Type combination. Does not send when course is marked as Inactive. Does not post a record when the course's State Reporting Exclude checkbox is marked.
Delete/Post	When the Local Course Number is changed. When the Term Descriptor changes either via section placement or mapping override and a course offering already exists with non-matching Term Descriptors.
Put	When Course information is changed and saved. Course Name
Delete	When a section is deleted. When a section schedule placement is removed and saved.
Delete/Post	When there are two Sections with the same natural key and one is deleted, the other record posts with the remaining record's data.

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.

This table describes the Natural Key Changes/Cascading Updates and Deletes logic of this object.

Action	Trigger
Delete/Post	When any of the following changes in the Schools resource: School ID: When the Ed-Fi School Number changes. School ID: When the State School Number changes and the Ed-Fi School Number is null.
Delete/Post	When the Course Number changes.
Delete/Post	When the Session Name changes to which the Course Offering is aligned.
Delete/Post	When the natural key changes all dependent resources delete/post.
Dependent Resources	Sections, Staff Section Associations, Student Section Associations, Student Section Attendance Events, Grades

This table describes scope year logic of this object.

Logic
Course Offerings reports to the configured year to which they are aligned.
Data only sends for years that have valid configuration.

Campus Object Key	Object Key Data Source
Section	sectionID-termID

This table describes the Event Queue Detail of this object.

Campus Table	Ed-Fi Action	Fields
course	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.

This table describes data elements sent within the Course Offerings resource.

Data Element Label	Business Requirements and Rules	M, C or O	Data Source GUI Path Database Location
id	The unique identifier of the resource.	M
localCourseCode	The local code assigned by the LEA or Campus that identifies the organization of subject matter and related learning experiences provided for the instruction of students. Reports the Course Number from the Course.	M	Scheduling > Course > Course Number course.number
courseReference	A reference to the related Course resource. Reports the fields that are part of the Natural Key for the Course resource. The Course Code is the Course State Code and the educationOrganizationID is 1.	M
schoolReference	A reference to the related School resource. Reports the fields that are part of the Natural Key for the School resource where the School ID is the Reporting School Code.	M
sessionReference	A reference to the related Session resource. Reports the fields that are part of the Natural Key for the Session resource. The School ID is the reporting School Code. The School Year is the end year of the reported Calendar. The Session Name is the Term Name.	M
localCourseTitle	The descriptive name given to a course of study offered in the school, when different from the Course Title. Reports the Course Name.	O	Scheduling > Course > Name course.name