Classic View: System Administration > Ed-Fi
Search Terms: 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.
|
| Delete/Post |
|
| Put | When Course information is changed and saved.
|
| Delete |
|
| Delete/Post | When there are two Sections with the same natural key and 1 is deleted, the other record will post with the remaining records 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 | 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:
|
| 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. |
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 Labels in bold are part of the Natural Key and are required elements for data to send to Ed-Fi.
Data Element Label | Business Requirement | Business Rules | M, C or O | Location |
|---|---|---|---|---|
| id | The unique identifier of the resource. | M | ||
| localCourse Code | 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 > Number course.number |
| course Reference | A reference to the related Course resource. | Reports the fields that are part of the Natural Key for the Course resource. | M | |
| school Reference | A reference to the related School resource. | Reports the fields that are part of the Natural Key for the School resource. | M | |
| session Reference | A reference to the related Session resource. | Reports the fields that are part of the Natural Key for the Session resource.
| M | |
| courseLevel Characteristics | The type of specific program or designation with which the course offering is associated (e.g., AP, IB, Dual Credit, CTE). This collection should only be populated if it differs from the Course Level Characteristics identified at the Course level. | This is optional, does not report. | O | |
| curriculum Used | An unordered collection of courseOfferingCurriculumUseds. This entity represents an offering of a course by school during a session, representing the course catalog of available courses. | This is optional, does not report. | O | |
| instructional TimePlanned | The planned total number of clock minutes of instruction for this course offering. Generally, this should be at least as many minutes as is required for completion by the related state- or district-defined Course., | This is optional, does not report. | O | |
| localCourse Title | The descriptive name given to a course of study offered in the school, if different from the Course Title. | Reports the Course Name. | O | Scheduling > Course > Name course.name |
| offeredGrade Levels | The grade levels in which the course is offered. This collection should only be populated if it differs from the Offered Grade Levels identified at the Course level. | This is optional, does not report. | O | |
| instruction Minutes PerTerm | Instruction minutes per term. |
| C | Course > Section > Period Minutes Override Course > Period Minutes Course > Section > Section Schedule Placement Course.periodMinutes / CustomCourse.value Section.periodMinutesOverride / CustomSection.value |
| instructional Approaches | An unordered collection of courseOfferingInstructionalApproaches. Instructional approach as implemented for the course offering. General purpose but initially implemented for Early Education. | See Array logic below. | ||
| siteBased Initiatives | An unordered collection of courseOfferingSiteBasedInitiatives. Site-based initiative as implemented for the course offering. General purpose but initially implemented for Early Education. | See Array logic below. | ||
| etag | A unique system-generated value that identifies the version of the resource. | This is optional, does not report. | O |
Arrays
Type/Descriptors
Resource Preferences
The Ed-Fi Configuration tool is used to establish Ed-Fi data resources.
The following describes how to enable the Course Offerings resource for Ed-Fi reporting
Select the appropriate Ed-Fi Code for the Implementation Status Descriptors.
Course Inst. Approach and Implementation Attribute Dictionary System Administration > Attribute/Dictionary > Course > Curriculum and Implementation
UI Location Course > Curriculum and Implementation 
Select the appropriate Ed-Fi Code for the Instructional Approach Descriptors.
Course Inst. Approach and Implmentation Attribute Dictionary System Administration > Attribute/Dictionary > Course > Inst. Approach and Implementation
UI Location Course > Inst. Approach and Implementation 
Select the appropriate Ed-Fi Code for the Site Based Initiative Descriptors Descriptors.
Course Site-Based Initiative and Impl Attribute Dictionary System Administration > Attribute/Dictionary > Course > Site-Based Initiative and Impl.
UI Location Course > Site-Based Initiative and Impl. 
4. Click Save.
