Sections (Texas v4.0)

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

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. Do not send records if the: Calendar Exclude checkbox is marked. Course is marked inactive or State Exclude. 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: Local course name or SCED Seq Number. Instructional Setting on a section. Credit field 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/Post	When the Local Course Number or Term type Override is changed.

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 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

Action	Trigger
Post/Delete	Natural Key Changes: If the School ID changes, all data remains under the old number and a resync needs 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/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

Logic
Sections report to the configured year to which they are aligned.
Data only sends for years that have valid configuration.

Resource Preferences

Data Element Label	Mapping Needed
Instructional Setting	Educational Environment Descriptors

Identity Mapping Object Key

Campus Object Key	Object Key Data Source
SectionPlacement	sectionID-termID

Event Queue Detail

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. Required data elements are listed in bold.

Data Element Label	Business Requirement	Logic	M, C or O	Location
id	The 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 > Section section.sectionID
courseOffering Reference	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
locationSchool Reference	A reference to the related School resource.	Reports the fields that are part of the Natural Key for the School resource.	M
availableCredit Conversion	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	Course > 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
courseLevelCharacteristics	The specific type of 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
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.	Report the Ed-Fi Code value from the mapped Instructional Setting selected on the course section being reported. Does not report if null.	O	Course > Section > 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 / 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 grade levels in which the section is offered. This collection only populates if it differs from the Offered Grade Levels identified at the Course Offering level.	This is optional, does not report.	O
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	Course > Population Served Course > Section > Population Served
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	The number of the sequence when a section is part of a sequence of parts for a course. If the course has only one part, the value of this section attribute is 1.	This is optional, does not report.	O
sets		See array section for logic.	O
etag	A unique system-generated value that identifies the version of the resource.	This is optional, does not report.	O

Arrays

Click here to expand...

Class Periods

Data Element Label	Business Requirement	Logic	M, C or O	Location
classPeriodReference	Reports the natural key of the Class Periods resource.		M

Section Sets

Data Element Label	Business Requirement	Logic	M, C, or O	Location
populationServedDescriptor	Identifies the student population for which a student has been designed or is intended. It does not necessarily identify the program eligibility of the students who receive the service.	Reports mapped Ed-Fi Code of Population Served from Course. If NULL, reports mapped Ed-Fi Code of Population Served from Section.	O	Course > Population Served Course > Section > Population Served
gradeLevelDescriptor		Reports grade level of section roster. Reports from highest roster count if more than one grade level is found.	O	Course > Section
courseSequenceDescriptor	Identifies the unique part(s) of a course when a course is taught during a single grading period or semester or across multiple grading periods or semesters.	Reports mapped Ed-Fi Code of Course Sequence.	O	Course > Course Sequence
nonCampusBasedInstruction Descriptor	Indicates that a course was offered for class credit or student achievement, but was: not taught by a school district/charter school employee or a contracted teacher, or taught by a school district/charter school employee or a contracted teacher at a facility other than the campus where the student is enrolled. Examples include but are not limited to college based instruction, non-district teacher, non-campus teacher, internet based instruction, and Texas Virtual School Network (TxVSN).	Reports mapped Ed-Fi Code of Non Campus Based Instruction Code from Section. Reports mapped Ed-Fi Code of Non Campus Based Instruction Code from Course if null.	O	Course > Non Campus Based Instruction Code Course > Section > Non Campus Based Instruction Code
pkCurriculaDescriptor	Indicates curricula used in the district’s prekindergarten program serving eligible four-year-old students per TEC §29.1532(c)(7).	Reports mapped Ed-Fi Code of PK Curricula.	O	Course > Section > PK Curricula
highQualityPKProgram	Indicates campus /course / section participation in the High-Quality Prekindergarten Program consistent with requirements in TEC §29.167-29.171	Reports true if HQ PK Program Indicator is selected.	O	Course > Section > HQ PK Program Indicator
pkStudentInstructionDescriptor	Indicates the prekindergarten student type of instruction.	Reports mapped Ed-Fi Code of Student Instruction Type.	O	Course > Section > Student Instruction Type
pkSchoolTypeDescriptor	Indicates the type of prekindergarten program that is offered.	Reports mapped Ed-Fi Code of PK School Type.	O	Course > Section > PK School Type
classTypeDescriptor	Identifies the type of class providing instruction to students in particular class settings.	Reports 1 if Instructional Setting is NULL. Reports 2 if Instructional Setting is NOT NULL.	O	Course > Instructional Setting Course > Section > Instructional Setting
CTEHours	Indicate the number of contact hours assigned to a particular section of a course.	Does not exist in Campus- Does not report.	O
beginDate		Reports Term Start Date based on checkbox selections of section schedule placement.	M	Course > Section > Section Schedule Placement
endDate		Reports Term End Date based on checkbox selections of section schedule placement.	M	Course > Section > Section Schedule Placement
childCareOperationNumber	Identifies the childcare facility operation number assigned by the Child Care Regulation (CCR) department. The facility serves students who are dually enrolled in the Local Education Agency’s public prekindergarten course section and childcare program.	This is optional, does not report.	O

Type/Descriptor