MN v3.3 - Sections

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.
  • 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 or State Exclude.
  • Do not send if the School Exclude check box is checked.
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 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.
DeleteWhen a section is deleted.
DeleteWhen Section Placement is changed or removed and saved on a section.
DeleteWhen 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.

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.

Resource Preferences

This table describes the Resource Preferences of this object.

Data Element LabelMapping Needed
Instructional SettingEducational Environment Types

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 Scheduling & Courses > Courses > Section Informationsection.sectionID
courseOffering
Reference
A 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.

This is optional, does not report.


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  
availableCreditsCredits or units of value awarded for the completion of a course.

This is optional, does not report.

OScheduling & Courses > Courses Course Information > Course Grading Tasks > CreditgradingTaskCredit.
Credit
availableCredit
TypeDescriptor
The type of credits or units of value awarded for the completion of a course.

This is optional, does not report.

O  
characteristics

Reflects important characteristics of the Section, such as whether the Section is graded. 

  1. Report 'MA' (markingIndicator) if a grading task exists on the course that is mapped to an Ed-Fi Grade Descriptor of 'FG: Final Grade'
    1. Do not report if Course Level = 'P' or 'N'
    2. Otherwise do NOT report the indicator
  2. Report 'FP' (fixed period) if the section is scheduled into a period in Section Schedule Placement
    1. Do not report if Section Enrollment Type != SC
  3. Report 'VI' (virtual indicator) if "Online Learning (Override)" on Section is not GD and not null
    1. Report 'VI' (virtual indicator) if "Online Learning" on Course is not GD and not null
    2. Do not report if Section Enrollment Type != SC
M

Scheduling & Courses > Courses Course Information > Course Grading Tasks > Score Group > State Score


Scheduling & Courses > Courses Course Information > Online Learning


 Scheduling & Courses > Courses > Section Information > Online Learning (Override)


string

classPeriods The class period during which the Section meets.

classPeriodname:

  1. Report the Period Schedule Name + Period Name + Schedule Structure ID
    1. Report a space between each value

schoolId:

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

Do not report if Section Enrollment Type != SC

M

classPeriodname:

System Administration> Calendar> Calendar> Periods


schoolId:

System Administration> Calendar> Calendar> Schedule Structure


System Administration > Resources > School > State School Number

 periodschedule.name

period.name

schedulestructure.structureID

school.number

courseLevel
Characteristics
The 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

classPeriods

An unordered collection of sectionClassPeriods. The class period during which the Section meets.


classPeriodReference

  • classPeriodName
  • schoolId

classPeriodname:

  1. Report the Period Schedule Name + Period Name + Schedule Structure ID.
    • Report a space between each value.

schoolId:

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

M

classPeriodname:

Scheduling & Courses > Calendar Setup > Period Setup


schoolId:

Scheduling & Courses > Calendar Setup > Calendar Information > Schedule Structure


School & District Settings > Schools > School Information > State School Number


periodschedule.

name


period.name

schedulestructure.

structureID


school.number


educational
Environment
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.

This is optional, does not report.

OScheduling & Courses > Courses > Section Information > Instructional Settingsection.
instructional
Setting
instruction
Language
Descriptor
 The primary language of instruction, if omitted English is assumed.Report the Language from the Instruction Language saved on the Course record.
  1. Look for a mapping saved to the Language Descriptor Override section in preferences. If there is a mapped value, report that mapping.
  2. If an override is not there, look to see if the language standard code matches an Ed-Fi code, if yes report that value
  3. Report default value if saved on the Attribute and the standard code matches an Ed-Fi code
  4. Else, report NULL
CScheduling & Courses > Courses > Course Information > Instruction LanguageCourse.instruction
Language / CustomCourse.
value
mediumOf
Instruction
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.
  1. Report the mapped value, if it exists.
  2. Otherwise do not report.
MScheduling & Courses > Courses > Course Information > Instruction Method / EE Location Course.teaching
Method
instructional
DeliveryMode
Descriptor
The delivery mode of instruction. E.g, On-ground, Online, etc.
  1. If Section > "Online Learning" <> NULL, Report the mapped value, if it exists.
  2. If Section > "Online Learning" is either NULL or unmapped, check to see if  Course > "Online Learning" <> NULL, and if so, report the mapped value if it exists .
    • Otherwise do not report.
C

Scheduling & Courses > Courses > Course Information > Online Learning



Scheduling & Courses > Courses > Section Information > Online Learning


Course.distance
Code/Section.
distanceCode
offeredGrade
Levels
The 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.
  1. This is optional, does not report.
O

population
Served
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.
  1. 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.
  1. This is optional, does not report.
O  
sequenceOf
Course
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.
  1. If value for Section Enrollment = SC or NULL:
    1. Report the value selected in the SCED Sequence "Part n" field.
    2. If NULL, report '1'.
  2. Otherwise, do not report
M  
instruction
Minutes
PerTerm
Instruction minutes per term.
  1. If the Section's "Period Minutes Override" field is <> NULL, multiply that value by the total number of days the section is scheduled in the term and report that value.
  2. If the Section's "Period Minutes Override" field is NULL, but the Course's "Period Minutes" field <> NULL, multiply that value by the total number of days the section is scheduled in the term and report that value.
  3. If the Course's "Period Minutes" field is NULL, sum and report the number of instructional minutes (minus lunch minutes if within any applicable period) for each period this course/section is scheduled for, for all the days it is scheduled in the term and report that value.
C

Scheduling & Courses > Courses > > Section Information >  Section > Period Minutes Override


Scheduling & Courses > Courses > > Course Information >  Period Minutes


Scheduling & Courses > Courses >   Section Information > Section Schedule Placement


Course.periodMinutes / CustomCourse.value


Section.periodMinutesOverride / CustomSection.value



etagA unique system-generated value that identifies the version of the resource.
  1. This is optional, does not report.
O  

Type/Descriptor

Click here to expand...

Medium Of Instruction Descriptor: Course.teachingMethod

Campus Attribute CodeCampus Attribute NameEdFi Descriptor codeEdFi Descriptor description
BHBlended/HybridBHBlended/Hybrid
CCClassroom CollaborativeCCClassroom Collaborative
CLClassroom LoopedCLClassroom Looped
COCompletely OnlineCOCompletely Online
CPComputer ProgramCPComputer Program
CRClassroomCRClassroom
CSClassroom Self-ContainedCSClassroom Self-Contained
CTClassroom TeamCTClassroom Team
DLDistance LearningDLDistance Learning (other than online)
EEEarly EducationEEEarly Education
GGuidedGGuided
ITVRITV ReceivingITVRITV Sending
OOtherOOther


Instructional Delivery Mode Descriptor : Course.distanceCode

Campus Attribute CodeEdFi Descriptor codeEdFi Descriptor description

GD

GD

The delivery and learning occur with the instructor and students in the same place and time.

OA

OA

The delivery of instruction is completely online. The delivery and learning would not occur in same time and place.

OS

OS

The delivery of instruction is completely online. The delivery and learning would not be in the same place but will occur at the same time.

HB

HB

A mix of any on ground, asynchronous and synchronous.

Resource Preferences Continued

The Ed-Fi Configuration tool is used to establish Ed-Fi data resources.

The following describes how to set the resource preferences for the Sections resource.

 If a mapping is changed, a resync must be performed on the resource in order for the new mappings to send correctly.
  1. Select the appropriate Ed-Fi Code for the Instructional Delivery Mode Descriptors. The Show Inactive button can be used to show Instructional Delivery Mode Descriptors that are not active.

     Any item not mapped will not report to Ed-Fi.
    Course Online Learning
    Attribute DictionarySystem Settings > Custom Data and Links > Core Attribute/Dictionary > Course > Online Learning
    UI LocationScheduling & Courses > Courses > Course Information > Online Learning

  2. Select a Instructional Language Override if necessary.

    The Instructional Language Override mapping only needs to be populated if the code does not match a code that is in the Ed-Fi Code list.
    Instructional Language Overrides
    UI LocationScheduling & Courses > Courses > Course Information > Instruction Language

  3. Select the appropriate Ed-Fi Code for the Medium of Instruction Descriptors. The Show Inactive button can be used to show Medium of Instruction Descriptors that are not active.

    Course Instruction Method / EE Location
    Attribute Dictionary
    System Settings > Custom Data and Links > Core Attribute/Dictionary > Course > Instruction Method
    UI Location
    Scheduling & Courses > Courses > Course Information > Instruction Method / EE Location


  4. Click Save.