Tennessee Ed-Fi Data v3.1 - Sections

Classic View: System Administration > Ed-Fi

Search Terms: 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.

ActionTrigger
Post

When a section is created and saved.

  • Section Placement is required in order for the section to send.
  • One record will report for each Section and Term Type combination.
  • Do not send records if the Calendar Exclude check box is checked.

  • Do not send records if the course is marked inactive or State Exclude.
  • Do not send if the School Exclude check box is checked.
  • Section must be tied to a course that has State Code = NOT NULL.
PostWhen Section Placement is changed and saved on a section.
PostWhen the Local Course Number or Term type Override is changed.
Put

When any fields listed below are changed:

  • When the Type Override, Teaching Method Override or Advanced Academics  is changed and saved on a section.
  • When the Type, Teaching Method or Advanced Academics  is changed and saved on a course.
  • When the instruction checkbox on a day is changed.
  • When a section term assignment is changed.
DeleteWhen a section is deleted.
DeleteWhen Section Placement is changed or removed and saved on a section.
DeleteWhen the Local Course Number 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.

ActionTrigger
NoneIf a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
DeleteIf 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.
ResyncIf 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.
ResyncIf 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.
ResyncIf 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.

ActionTrigger
Post/Delete

Natural Key Changes:

  • If the School ID changes, all data will remain under the old number and a resync will need 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

If any of the following changes in the Course Offerings resource:

  • Local Course Code
  • Session Name
Post/DeleteIf the natural key changes all dependent data will delete/post.
Dependent ResourcesStaff 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.


Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus TableEd-Fi ActionFields
sectionPost/Put/DeleteThe primary table used for sending data for this resource.
coursePut

Educational Environment Descriptor

Sequence of Course

gradingTaskCreditPutAvailable Credits


Object Data Elements

This table describes data elements sent within the Sections resource.

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source GUI Path

Database Field

idThe unique identifier of the resource.

 

M  
sectionIdentifier

The local identifier assigned to a section.

Reports the section ID of the section being reported.

M Course > Sectionsection.sectionID
courseOfferingReferenceA reference to the related CourseOffering resource.

Reports the fields that are part of the Natural Key for the Course Offering resource.


M  
locationReferenceA reference to the related Location resource.

Reports the fields that are part of the Natural Key for the Locations resource.


O  
locationSchoolReferenceA reference to the related School resource.

Reports the fields that are part of the Natural Key for the School resource.


M  
availableCreditConversionConversion factor that when multiplied by the number of credits is equivalent to Carnegie units.

This is optional, does not report.

O  
availableCreditsCredits or units of value awarded for the completion of a course.

This is optional, does not report.

OCourse> Grading Tasks> CreditgradingTaskCredit.Credit
availableCreditTypeDescriptorThe 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  
courseLevelCharacteristicshe type of specific program or designation with which the section 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.

O

educationalEnvironmentDescriptorThe 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.
  1. Report mapped Ed-Fi Code of Type Override.
  2. If NULL, report Type.
  3. If both NULL, do not report field.
O

Course > Type


Course > Section > Type Override



instructionLanguageDescriptor The primary language of instruction, if omitted English is assumed.

This is optional, does not report.

O  
mediumOfInstructionDescriptorThe 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.
  1. Report mapped Ed-Fi Code of Teaching Method Override from section.
  2. If NULL, report Teaching Method from course.
  3. If both NULL, do not report field.
O Course > Teaching Method


Course > Section > Teaching Method Override

 
offeredGradeLevelsThe grade levels in which the section is offered. This collection should only be populated if it differs from the Offered Grade Levels identified at the Course Offering level.

This is optional, does not report.

O

populationServedDescriptorThe 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  
programsAn 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  
courseLevelCharacteristics / courseLevelCharactersticsDesriptorThe type of specific program or designation with which the section 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.
  1. Report mapped Ed-Fi Code of Advanced Academics from section.
  2. If NULL, report Advanced Academics from course.
  3. If both NULL, do not report field.

O

Course > Advanced Academics


Course > Section > Advanced Academics



sectionMeetingDatesThis list should contain the actual complete meeting schedule for this section.
This list should be dynamic and trigger updates due to changes in daily scheduling and calendar as the school year progresses. This list will allow us to accomplish a more accurate assessment of instructional minutes spent in class, which classes are actually impacted by school absences, which classes are actually impacted by section absences, and the actual total number of section meeting times for statistical analysis.  The calendar Reference allows cross validation against the instructional days on the associated calendar.
Report all days marked as Instruction within the terms assigned for the section.M

sectionMeetingDaysThis list replaces the 031 records for EIS and would contain the days of the week, the number of instructional minutes on that day, and the period on which the class meets (if more than one, the first occurring). In the case when the actual schedule varies from week to week, this will contain a synthetic weekly schedule that takes the average values of a rotating schedule.Reports Monday, Tuesday, Wednesday, Thursday, and Friday.
  • Do NOT report Saturday or Sunday.

M

_ext.tdoe.submittedFor
SchoolYearTypeReference.
schoolYear
Indicates the school year for which the record is reporting.Using the End Date tied to the calendar, report the year.M

_ext.tdoe.submittedBy
EducationOrganization
Reference.education
OrgnizationID
The identifier assigned to an education organization.Populate State District Number + State School Number.M

_ext.tdoe.postSecondary
InstitutionReference.post
SecondaryInstitutionId
For Statewide Dual Credit, Local Dual Credit, or Dual Enrollment.Report Post Secondary Instituition ID from Section  If NULL, do not report this field.OScheduling > Course > Section > Post Secondary Instituition ID
ext.tdoe.eisLocalClassNumberThe Local Class Number value that is being sent to EIS, used only for cross database validation.Reports Course Number + Section NumberOScheduling > Course > Section
sequenceOfCourseWhen a section is part of a sequence of parts for a course, the number if the sequence. If the course has only onle part, the value of this section attribute should be 1.This is optional, does not report.O

etagA unique system-generated value that identifies the version of the resource.

This is optional, does not report.

O  

Arrays

Class Periods

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source

GUI Path

Database Field

classPeriodReferenceReports the natural key of the Class Periods resource.
M


Section Meeting Dates

Data Element LabelBusiness RequirementBusiness RulesM, C or O

Data Source

GUI Path

Database Field
calendarReference


IC FieldJSON FieldLogic
Instructional Program NumbercalendarCode

If Instructional Program Number equals null or blank, populate “99”

Else

Populate Instructional Program Number

Format: 2 character left zero padded integer.

State School Number / State District NumberschoolId

District Number + School Number.

End YearschoolYearPopulate the End Year of the school year tied to the configured year.


M

meetingDateActual date on which class has met/will meet.Reports date of instruction.M

totalInstructionalMinutesNumber of instructional minutes the class meets on this date. If the class meets more than one period, the total of all periods that the class meets on that date.

Reports total period time section meets on this instructional day. SUMs periods assigned to the section for the period schedule on that day.

M

classPeriodsReferenceThe class period(s) the section meets on this dateReports reference key to the associated class period(s).M


Section Meeting Days

Data Element LabelBusiness RequirementBusiness RulesM, C or O

Data Source

GUI Path

Database Field
weekdayDescriptor
Reports Ed-Fi Code value of weekdayDescriptor.M

instructionalMinutes

Report (Aggregated Scheduled Period Time / # of period schedules). Round for whole number.


This duration calculation exists in the 031 report.

M

Course > Section > Section Schedule Placement

System Administration > Calendar > Periods > Start Time, End Time


assignedPeriod

Using the calendar tied to the Section that is being reported, complete the following logic:

Report sequence number of period assigned to the section.

If assigned to more than one period, report period mostly assigned for the term.

MSystem Administration > Calendar > Periods > Sequence


Type/Descriptor

Educational Environment Descriptors

Code ValueDdescriptionNamespaceShort Description
Hospital classHospital classuri://ed-fi.org/EducationalEnvironmentDescriptorHospital class
LaboratoryLaboratoryuri://ed-fi.org/EducationalEnvironmentDescriptorLaboratory
Pull-out classPull-out classuri://ed-fi.org/EducationalEnvironmentDescriptorPull-out class
Self-contained (Special Education)Self-contained (Special Education)uri://ed-fi.org/EducationalEnvironmentDescriptorSelf-contained (Special Education)
Off-school centerOff-school centeruri://ed-fi.org/EducationalEnvironmentDescriptorOff-school center
ShopShopuri://ed-fi.org/EducationalEnvironmentDescriptorShop
Resource roomResource roomuri://ed-fi.org/EducationalEnvironmentDescriptorResource room
Self-studySelf-studyuri://ed-fi.org/EducationalEnvironmentDescriptorSelf-study
HomeboundHomebounduri://ed-fi.org/EducationalEnvironmentDescriptorHomebound
Single sex classroomSingle sex classroomuri://ed-fi.org/EducationalEnvironmentDescriptorSingle sex classroom
ClassroomClassroomuri://ed-fi.org/EducationalEnvironmentDescriptorClassroom
Mainstream (Special Education)Mainstream (Special Education)uri://ed-fi.org/EducationalEnvironmentDescriptorMainstream (Special Education)
In-school suspensionIn-school suspensionuri://ed-fi.org/EducationalEnvironmentDescriptorIn-school suspension