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 OR When a Section Student Detail record is created with a Course State Code Override that is different than the associated course's State Code.
|
| 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 otherwise performed.
|
| Delete |
|
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 |
|---|---|
| Post/Delete | Natural Key Changes:
|
| Post/Delete | If any of the following changes in the Course Offerings resource:
|
| Post/Delete | If the natural key changes all dependent data will delete/post. |
| 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 will report to the configured year to which they are aligned. |
| Data will 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 Languages Descriptor | Alternative Instruction Language |
| Educational Environment Descriptors | Section Distance Learning Provider |
| Medium of Instruction Descriptors | Section Course Delivery Model Code |
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 |
Object Data Elements
This table describes data elements sent within the Sections resource.
Data Element Label | Business Requirement and Business Rules | M, C or O | Data Source GUI Path | Database Field |
|---|---|---|---|---|
| sectionIdentifier | The local identifier assigned to a section. Reports the section ID. | 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. | M | N/A | N/A |
| characteristics | This descriptor defines characteristics of a section, such as whether attendance is taken and the section is graded. Reports the below data elements in an array:
| C | Course > Online Learning, State Code Section > Online Learning (Override) | Course.distanceCode Section.distanceCode |
| availableCredits | Report the result of the following calculation:
| C | Course > Grading Tasks > Credit | GradingTaskCredit.Credit |
| classPeriods | The class period during which the Section meets. For all class periods the course is offered in the reporting term, reports the fields that are part of the Natural Key for the Class Periods resource in an array. | M | N/A | N/A |
| instructionLanguageDescriptor | The primary language of instruction, if omitted English is assumed.
| C | Section > Immersion Language | Section.immersionLanguage |
| alternateEducationOrganizationId | Indicates Concurrent enrollment system
| C | Course > Alt School Code, Alt System Code Section > Alt School Code, Alt System Code | Course.altStateCode Section.altSchoolCode |
| sectionName | Report the Section Number
| M | Section > Number | section.number |
| taughtByESOLTeacher | Indicates the section is taught by an ESOL teacher
| C | Course > Section > Staff History > Role | SectionStaffHistory.role |
