Course Offerings (Georgia 3.6.1)

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	Reports a record when a Section that is scheduled into a term/period has and the associated Course has a State Code entered OR when a section has a Section Student Detail record with a Course State Code Override. Do not report a record if the any of the following exclusions are present: Course is inactive (Active is unchecked) Course State Exclude Course State Code is NULL Calendar Exclude School Exclude One record will report for each unique Course State Code / Course State Code Override and Term Type combination. Course Offering records will exist for BOTH the original and override state code(s).
Delete/Post/Put	A DELETE/POST is performed if the data element being altered is part of the resource's natural key. A PUT is performed otherwise. When the following information is changed on Course: Course ID (New Course) State Code Course Name When the following information is changed on Section Student Detail: Course State Code Override
Delete	When the terms the section is offered in are changed or removed. When the section is deleted. When the Section Student Detail record that has a Course State Code Override is deleted. When the Course State Code Override on a Section Student Detail record is changed or removed.

Action

Trigger

Post

Reports a record when a Section that is scheduled into a term/period has and the associated Course has a State Code entered OR when a section has a Section Student Detail record with a Course State Code Override.

Do not report a record if the any of the following exclusions are present:
- Course is inactive (Active is unchecked)
- Course State Exclude
- Course State Code is NULL
- Calendar Exclude
- School Exclude
One record will report for each unique Course State Code / Course State Code Override and Term Type combination.
Course Offering records will exist for BOTH the original and override state code(s).

Delete/Post/Put

A DELETE/POST is performed if the data element being altered is part of the resource's natural key. A PUT is performed otherwise.

When the following information is changed on Course:
- Course ID (New Course)
- State Code
- Course Name
When the following information is changed on Section Student Detail:
- Course State Code Override

Delete

When the terms the section is offered in are changed or removed.
When the section is deleted.
When the Section Student Detail record that has a Course State Code Override is deleted.
When the Course State Code Override on a Section Student Detail record is changed or removed.

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.
Delete	If a resource is toggled to 'OFF" after data has sent and an action is performed that would trigger a delete, that data will remain in the ODS until a resync is done.
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	If any of the following changes in the Schools resource: School ID: If the Ed-Fi School Number changes. School ID: If the State School Number changes and the Ed-Fi School Number is NULL.
Delete/Post	If the Course Number changes.
Delete/Post	If the Session Name changes to which the Course Offering is aligned.
Delete/Post	If the natural key changes all dependent resources will delete/post.
Dependent Resources	Sections, Staff Section Associations, Student Section Associations, Student Section Attendance Events, Grades

Scope Year Logic

This table describes scope year logic of this object.

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

Identity Mapping Object Key

Campus Object Key	Object Key Data Source
Section	sectionID-termID

Event Queue Detail

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.

Object Data Elements

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

Data Element Label	Business Requirement and Business Rules	M, C or O	Data Source GUI Path	Database Field
localCourseCode	The local code assigned by the School that identifies the course offering provided for the instruction of students. Normal Logic: Reports the State Code from the Course Format is ##.####### The last two digits of the State Code will always report as "00". Override Logic: Report the Course State Code Override.	M	Course/Section > Course > Course Information > State Code	course.stateCode
courseReference	A reference to the related Course resource. Normal Logic: Reports the fields that are part of the Natural Key for the Course resource. The last two digits of the courseCode will always report as "00". Override Logic: Report the Course State Code Override.	M	Course/Section > Course > Course Information > State Code	course.stateCode
schoolReference	A reference to the related School resource. Reports the fields that are part of the Natural Key for the Schools resource. educationOrganizationId = Ed-Fi School ID	M	System Administration > Resources > School > Ed-Fi School ID	School.entityID
sessionReference	A reference to the related Session resource. Reports the fields that are part of the Natural Key for the Sessions resource.	M	N/A	N/A
localCourseTitle	The descriptive name given to a course of study offered in the school, if different from the Course Title. Reports the Course Name.	M	Scheduling > Course > Name	course.name