• Home
  • State Specific Information
  • Wisconsin
  • Wisconsin Ed-Fi
  • Wisconsin Ed-Fi v3.5 Resources (Current)

Wisconsin Ed-Fi Data v3.5 - 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.
  • 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.
  • Do not send if the Calendar is marked Summer School.
  • If Ed-Fi Configuration Profile = Choice + Private Opt In or Choice Only, do not send any records.
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 theSCED Seq Number is changed and saved on the Course editor.
  • When the Certified Learning Method is changed and saved on the Course Editor.
  • When the Non-Certificated Learning Method is changed and saved on the Course Editor.
  • When the Dual Enrollment is changed and saved on the Course Editor.
  • When the World Language is changed and saved on the Course Editor.
  • When the Medium of Instruction is changed and saved on the Course Editor or on a section.
  • When the Language of Instruction is changed and saved on the Course Editor or on a section.
Delete/PostWhen the State Course Number is changed
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.
DeleteIf Active is unchecked or Exclude from State Reporting is checked on the Course OR on the Course Master and pushed to the current scope year.


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

Data Element LabelMapping Needed
Medium of InstructionMedium of Instruction


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.

This field is optional and does not report.


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 field is optional and does not report.

O

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.

This field is optional and does not report.

O

courseLevelCharacteristicsThe 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

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 

This field is optional and does not report.

OCourse > Section > Instructional Settingsection.instructionalSetting
instructionLanguageDescriptorThe primary language of instruction, if omitted English is assumed.

Report when a course is taught in a language other than English:

  1. Report first from Language of Instruction on Section.
  2. If Section is NULL, report from Language of Instruction on Course.
  3. Otherwise, do not report.


C

Scheduling > Course > Section > Language of Instruction


Scheduling > Course > Language of Instruction



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 first from the Medium of Instruction field on Section.
  2. If section is NULL, report from Medium of Instruction on the Course.
O

Scheduling > Course > Section > Medium of Instruction


Scheduling > Course > Medium of Instruction

SectionInfo.mediumOf

Instruction


CourseInfo.mediumOf

Instruction



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.
  1. If World Language is populated on Section, report programReference for World Language from Section.
    • Otherwise, report the value selected on Course if populated.
  2. If the Dual Enrollment field is populated on Section, report the  programReference from the section. 
    • Otherwise, report from Course if populated.
  3. If Certified Learning Method is populated on Section, report the associated programReference
    • Otherwise, report value from the Course for the student if populated
  4. If Non-Certificated Learning Method is populated on Section, report the associated programReference
    • Otherwise, report value from the Course for the student if populated
  5. If multiple programs are tied to the same course, report each program.
  6. If the student drops from the class without receiving a final, state reported grade, do NOT send the program reference.
  7. If the student drops and then re-enrolls in the class, send the program reference if data exists.
  8. If student drops from the class and receives a final, state reported grade, send the program reference if data exists.
  9. See Appendix for logic and reporting values for programType and programName.

CScheduling > Courses > Section

Scheduling > Courses > Course
Courseinfo.WorldLanguage
Sectioninfo.WorldLanguage
Courseinfo.programtype
course.dualenrollment



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
  1. Report the value selected in the SCED Sequence "Part n" field.
    • If SCED sequence is 1 out of 1, do not report.
  2. If NULL, do not report.
CScheduling > Course > NCES Data > Sequence Number part ncourse.SCEDSequence Number
etagA unique system-generated value that identifies the version of the resource.

This is optional, does not report.

O

Type/Descriptors


Appendix