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 and saved. Section Placement is required in order for the section to send. One record reports for each Section and Term Type combination. Does not send records when the Calendar Exclude checkbox is marked. Does not send records when the course is marked inactive. Does not send when the School Exclude checkbox is marked.
Post	When Section Placement is changed and saved on a section.
Post	When the Local Course Number or Term type Override is changed.
Put	When any fields listed below are changed: When the SCED Seq Number is changed and saved on the Course editor. When the Instructional Setting is changed and saved on a section. When the Credit field is changed and saved on a Grading Task assigned to the course.
Delete	When a section is deleted.
Delete	When Section Placement is changed or removed and saved on a section.
Delete	When the Local Course Number or Term type Override is changed.

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 is needed 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: When the School ID changes, all data remains under the old number and a resync is needed to be completed to populate data under the new number. The delete tool would need to be used to remove all data from the old School ID.
Post/Delete	When any of the following changes in the Course Offerings resource: Local Course Code Session Name
Post/Delete	When the natural key changes all dependent data is deleted/posted.
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 report to the configured year to which they are aligned.
Data only sends for years that have valid configuration.

Resource Preferences

This table describes the Resource Preferences of this object.

Data Element Label	Mapping Needed
Educational Environment Descriptor	Section Instructional Setting
Course Level Characteristic Descriptor	Course Level

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus Table	Ed-Fi Action	Fields
sectionPlacement	Post/Put/Delete	The primary table used for sending data for this resource.
course	Put	Sequence of Course
section	Put	Educational Environment Descriptor
gradingTaskCredit	Put	Available Credits

Object Data Elements

This table describes data elements sent within the Sections resource.

Data Element Label	Business Requirement and Rules	Mandatory, Conditional, or Operational	Location
sectionIdentifier	The local identifier assigned to a section. Reports the section ID of the section being reported.	M	Courses > Section Information Section.sectionID
id	The unique identifier of the resource.	M
courseOfferingReference	A reference to the related Course Offering resource. Reports the fields that are part of the Natural Key for the Course Offering resource.	M
locationReference	A reference to the related Location resource. Reports the fields that are part of the Natural Key for the Locations resource.	O	Settings > Rooms > Name Room.name School Information > Entity ID School.EntityId
locationSchoolReference	A reference to the related School resource. Reports the fields that are part of the Natural Key for the School resource. This is optional, does not report.	O
availableCreditConversion	Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units. This is optional, does not report.	O
availableCredits	Credits or units of value awarded for the completion of a course. Sum the total number of credits from the Grading Tasks on the course. Divide by the number of terms the course section occurs.	O	Grading Tasks > Credit gradingTaskCredit.Credit
availableCreditType Descriptor	The type of credits or units of value awarded for the completion of a course. This is optional, does not report.	O
characteristics	This descriptor defines characteristics of a section, such as whether attendance is taken and the section is graded. This is optional, does not report.	O
classPeriods	The class period during which the Section meets. See array section for logic.	O
courseLevel Characteristics	The type of specific program or designation with which the course 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 Offering level. This is optional, does not report.
educationalEnvironment Descriptor	The setting in which a child receives education and related services; for example: Center-based instruction Home-based instruction Hospital class Mainstream Residential care and treatment facility. Reports the Ed-Fi Code value from the mapped Instructional Setting selected on the course section being reported. When NULL, does not report.	O	Section Information > Instructional Setting section.instructionalSetting
instructionLanguage Descriptor	The primary language of instruction, if omitted English is assumed. This is optional, does not report.	O
mediumOfInstruction Descriptor	The media through which teachers provide instruction to students and students and teachers communicate about instructional matters; for example: Technology-based instruction in classroom Correspondence instruction Face-to-face instruction Virtual/On-line Distance learning Center-based instruction. This is optional, does not report.	O
offeredGradeLevels	The ID of the GradeLevel Descriptor. This is optional, does not report.	M
officialAttendancePeriod	Indicator of whether this section is used for official daily attendance. Alternatively, official daily attendance may be tied to a class period. Reports True when Attendance checkbox is marked on the Course. Reports False when Attendance checkbox is NOT marked on the Course.	M	Scheduling & Courses > Course Information > Section > Course Attendance
populationServed Descriptor	The population for which the course was designed; for example: Bilingual students Remedial education students Gifted and talented students Career and Technical Education students Special education students. This is optional, does not report.	O
programs	An unordered collection of sectionPrograms. 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. This is optional, does not report.	O
sequenceOfCourse	When a section is part of a sequence of parts for a course, the number if the sequence. When the course has only one part, the value of this section attribute should be one. Reports the value selected in the SCED Sequence Part N field. When blank, reports a value of 1.	M	Courses > SCED Sequence Course.scedSequenceNumber
etag	A unique system-generated value that identifies the version of the resource	O

Arrays

Click here to expand...

Class Periods

Data Element Label	Business Requirement	Mandatory, Conditional or Optional	Location
classPeriodReference	Reports the natural key of the Class Periods resource.	M

Type/Descriptor