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
| Action | Trigger |
|---|---|
| Post | When a section with Section Placement is created and saved.
|
| Delete/Post | When the Local Course Number is changed. |
| Delete/Post | If 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.
|
| Delete | When a section is deleted. |
| Delete | 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 will post with the remaining records data. |
School Exclude, Calendar Exclude, Resource Toggle and Resync Logic
| Action | Trigger |
|---|---|
| None | If a resource is toggled to 'OFF' after data has sent, all sent data remains in the ODS but no new data sends. |
| Delete | If 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 | 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 is deleted from the ODS. |
| Resync | If 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
| 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 to which the Course Offering is aligned changes. |
| 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
| Logic |
|---|
| Course Offerings will report to the configured year to which they are aligned. |
| Data only sends for years that have valid configuration. |
Identity Mapping Object Key
| Campus Object Key | Object Key Data Source |
|---|---|
| Section | sectionID-termID |
Event Queue Detail
| 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
Data Element Label | Business Requirement | Logic | M, C or O | 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 > Number course.number |
| courseReference | A reference to the state provided course. |
| M | Course > State Code |
| schoolReference | A reference to the related School resource. | Reports the fields that are part of the Natural Key for the School resource. | M | |
| sessionReference | 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 specific type of 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 | |
| curriculumUsed | An unordered collection of courseOffering CurriculumUseds. 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 | |
| instructionalTime Planned | 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 | |
| localCourseTitle | The descriptive name given to a course of study offered in the school, if different from the Course Title. | Does not report. | O | |
| offeredGradeLevels | 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 | |
| etag | A unique system-generated value that identifies the version of the resource. | This is optional, does not report. | O |
