Arizona Ed-Fi Data v3.1 - Sections | Infinite Campus Test

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.

Action	Trigger
Post	When a section is created and saved. Section Placement is required in order for the section to send. 1 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. Do not send if the School Exclude check box is checked. Do not send a record if the State Reporting Exclude checkbox is selected on the course.
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 local course name or 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	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: 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/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 Setting	Educational Environment Types
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
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

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	Business Rules	M, C or O	Data Source GUI Path	Database Field
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
courseOfferingReference	A reference to the related CourseOffering 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. classroomIdentificationCode schoolId	Reports the fields that are part of the Natural Key for the Locations resource.	O	System Administration > Resources > Resources > Rooms System Administration> Resources> School> Entity ID	room.name school.EntityId
locationSchoolReference	A reference to the related School resource.	This is optional, does not report.	O
siteLocationSchoolReference	The identifier assigned to a school. This is used when a course is taught at a different school. schoolId	If the Section Location Override <> NULL, report that value. If the Section Location Override is NULL, but the Course Location Override <> NULL, report that value. If both course.provider and section.provider is NULL, report out the School entityID.	M	Course > Section > Location Override Course > Section > Location Override System Administration > Resources > School > entityID	course.provider section.provider school.entityID
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	Course> Grading Tasks> Credit	gradingTaskCredit.Credit
availableCreditTypeDescriptor	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	An unordered collection of courseLevelCharacteristics. The type of specific program or designation with which the course is associated (e.g., AP, IB, Dual Credit, CTE).	Reports when the following are added: CTE check box is checked on the course or section. Report if Dual Credit checkbox is checked on the course or section. Report from Level drop list if selected on course. See Array section below for data logic for each field.
educationalEnvironmentDescriptor	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. If NULL, do not report.	O	Course > Section > Instructional Setting	section.instructionalSetting
instructionLanguageDescriptor	The primary language of instruction, if omitted English is assumed.	This is optional, does not report.	O
mediumOfInstructionDescriptor	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.	Reports the lowest and the highest grade level of students scheduled in the course section. All students are considered regardless of rosters start or end date. If a student changes grade levels either by updating grade on enrollment or creating a new enrollment this will not trigger a change on section. A resync would need to be done on section to update this field. If a grade level is marked as State Exclude in the Calendar > Grade Levels tab, those grade levels are excluded from consideration/inclusion in of this endpoint. Report the Ed-Fi Code value from the mapped Grade Level Name selected on the course section being reported.	M
populationServedDescriptor	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. If the course has only onle part, the value of this section attribute should be 1	Report the value selected in the SCED Sequence "Part n" field. If NULL, report '1'.	M
etag	A 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
classPeriodReference	Reports the natural key of the Class Periods resource.		M

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source

GUI Path

Database Field

classPeriodReference

Reports the natural key of the Class Periods resource.

Course Level Characteristics

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
courseLevelCharacteristics	An unordered collection of courseLevelCharacteristics.The type of specific program or designation with which the course is associated (e.g., AP, IB, Dual Credit, CTE).	Report all courseLevelCharacterisitics that apply, based on the reporting chart listed below in the Course Level Characteristic Descriptor table.	O	Various - See Course Level Characteristic Descriptors list below.	Various - See Course Level Characteristic Descriptors list below.

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source

GUI Path

Database Field

courseLevelCharacteristics

An unordered collection of courseLevelCharacteristics.The type of specific program or designation with which the course is associated (e.g., AP, IB, Dual Credit, CTE).

Report all courseLevelCharacterisitics that apply, based on the reporting chart listed below in the Course Level Characteristic Descriptor table.

Various - See Course Level Characteristic Descriptors list below.

Type/Descriptor

Educational Environment Descriptors

Code Value	Description	Short Description
Computer Based or Self Placed Course	Computer Based or Self Placed Course	Computer Based or Self Placed Course
Self Study	Self Study	Self Study
Classroom	Classroom	Classroom
Resource Room	Resource Room	Resource Room
Self-contained (Special Education)	Self-contained (Special Education)	Self-contained (Special Education)
Structured English Immersion	Structured English Immersion	Structured English Immersion
Virtual	Virtual	Virtual

Course Level Characteristic Descriptors

CodeValue	ShortDescription	Data Source GUI Path	IC Attribute	IC Code Value	Logic
Gifted and Talented	Gifted and Talented	Scheduling > Course > Level	Course.level	GT	Report from Level drop list if selected.
Untracked	Untracked	Scheduling > Course > Level	Course.level	UN	Report from Level drop list if selected.
Pre-AP	Pre-AP	Scheduling > Course > Level	Course.level	PA	Report from Level drop list if selected.
Graduation Credit	Graduation Credit	Scheduling > Course > Level	Course.level	GC	Report from Level drop list if selected.
Dual Credit	Dual Credit	Scheduling > Course > Dual Credit Section > Dual Credit	course.dualCredit section.localDualCredit		Report if Dual Credit checkbox is checked.
General	General	Scheduling > Course > Level	Course.level	GN	Report from Level drop list if selected.
English Language Learner	English Language Learner	Scheduling > Course > Level	Course.level	EL	Report from Level drop list if selected.
Advanced	Advanced	Scheduling > Course > Level	Course.level	AD	Report from Level drop list if selected.
Advanced Placement	Advanced Placement	Scheduling > Course > Level	Course.level	AP	Report from Level drop list if selected.
Basic	Basic	Scheduling > Course > Level	Course.level	BA	Report from Level drop list if selected.
Career and Technical Education	Career and Technical Education	Scheduling > Course > CTE Scheduling > Course > Section > CTE			Report if CTE checkbox is checked on the course or section.
Other	Other	Scheduling > Course > Level	Course.level	OT	Report from Level drop list if selected.
Students with disabilities	Students with disabilities	Scheduling > Course > Level	Course.level	SE	Report from Level drop list if selected.

Arizona Ed-Fi Data v3.1 - Sections