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.

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 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.
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 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/Post	When the State Course Number is changed
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.
Delete	If 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.

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

Data Element Label	Mapping Needed
Medium of Instruction	Medium of Instruction

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.	This field is optional and does not report.	O
locationSchoolReference	A reference to the related School resource.	Reports the fields that are part of the Natural Key for the School resource.	M
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.	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
courseLevelCharacteristics	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
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.	O	Course > Section > Instructional Setting	section.instructionalSetting
instructionLanguageDescriptor	The primary language of instruction, if omitted English is assumed.	Report when a course is taught in a language other than English: Report first from Language of Instruction on Section. If Section is NULL, report from Language of Instruction on Course. Otherwise, do not report.	C	Scheduling > Course > Section > Language of Instruction Scheduling > Course > Language of Instruction
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	Report first from the Medium of Instruction field on Section. 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
offeredGradeLevels	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.	This is optional, does not report.	O
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.	If World Language is populated on Section, report programReference for World Language from Section. Otherwise, report the value selected on Course if populated. If the Dual Enrollment field is populated on Section, report the programReference from the section. Otherwise, report from Course if populated. If Certified Learning Method is populated on Section, report the associated programReference Otherwise, report value from the Course for the student if populated If Non-Certificated Learning Method is populated on Section, report the associated programReference Otherwise, report value from the Course for the student if populated If multiple programs are tied to the same course, report each program. If the student drops from the class without receiving a final, state reported grade, do NOT send the program reference. If the student drops and then re-enrolls in the class, send the program reference if data exists. If student drops from the class and receives a final, state reported grade, send the program reference if data exists. See Appendix for logic and reporting values for programType and programName.	C	Scheduling > Courses > Section Scheduling > Courses > Course	Courseinfo.WorldLanguage Sectioninfo.WorldLanguage Courseinfo.programtype course.dualenrollment
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 SCED sequence is 1 out of 1, do not report. If NULL, do not report.	C	Scheduling > Course > NCES Data > Sequence Number part n	course.SCEDSequence Number
etag	A unique system-generated value that identifies the version of the resource.	This is optional, does not report.	O

Type/Descriptors

This table describes the Ed-Fi Value mapped and reported for Medium of Instruction Descriptors.

Code	Short Description	Descritpion
Center-based instruction	Center-based instruction	Centers are organized based on content or activity areas. One classroom may have separate centers for pretend play, reading, art, science and blocks.
Correspondence instruction	Correspondence instruction	Correspondence education is a formal educational process under which the institution provides instructional materials, by mail or electronic transmission, including examinations on the materials, to students who are separated from the instructor.
Distance Learning (other than online)	Distance Learning (other than online)	Participation by a student in a course where the educational materials are provided through cable television, satellite classes, videotapes, or correspondence courses.
Face-to-face instruction	Face-to-face instruction	Use this value to represent the traditional classroom. Face-to-face instruction is when the instructor and the students of an educational institution are in a place devoted to instruction and where the teaching and learning take place through in-person contact.
Independent study	Independent study	Sometimes referred to as Directed Study, this instruction type is a form of education offered by many high schools, colleges, and other educational institutions where a course is undertaken by an individual student with little to no supervision.
Internship	Internship	The position of a student who works in an organization, sometimes without pay, in order to gain work experience or to satisfy qualification requirements.
Other	Other	Use this instruction type only in the event that no other, more suitable instruction type describes the medium of instruction for the course.
Other technology-based instruction	Other technology-based instruction	Use this instruction type only in the event that no other, more suitable instruction type describes the medium of instruction for the course.
Technology-based instruction in classroom	Technology-based instruction in classroom	The use of technology in the classroom, including iPads, laptops, tablets, etc. Or, the use of on-line related curriculum versus a paper textbook and/or workbook.
Telepresence/video conference	Telepresence/video conference	This code refers to a set of technologies which allow students to feel as if they were present, to give the appearance of being present, or to have an effect of presence, via telerobotics, at a place other than their true location, e.g., connecting to a remote classroom using video technology.
Televised	Televised	The inclusion of televised documentaries, movies, etc. that relate to the curriculum and enhance a student's understanding.
Videotaped/prerecorded video	Videotaped/prerecorded video	Under what is known as the "fair use" rule, someone other than the copyright owner may make limited use of a copyrighted work without permission for purposes, such as teaching, research, scholarship, criticism, parody, and news reporting.
Virtual/On-line Distance learning	Virtual/On-line Distance learning	Courses taught entirely online, where physical distance between teacher and student is immaterial.
Blended Learning	Blended Learning	Courses taught online and in-person.

Appendix

Program Reference

Note the following:

For certified programs, do not report if codes NONE, COOP, EMP or BUS are select:

For 2019-20 and 2020-, only report the following descriptors:
- Youth Apprenticeship
- State Co-op Ed. Skill Standards - DPI Occupational
- State Co-op Ed. Skill Standards - DPI Youth Leadership
- State Co-op Ed. Skill Standards - DPI Employability Skills
- IRC State Approved WTCS- Embedded Technical Diploma
- IRC State Approved WTCS- Technical Diploma
- IRC State Approved WTCS- Associates
- IRC State Approved Business & Industry
For 2021-22, report the following descriptors:
- State Co-op Ed. Skill Standards - DPI Occupational
- State Co-op Ed. Skill Standards - DPI Employability Skills
- IRC State Approved WTCS- Embedded Technical Diploma
- IRC State Approved WTCS- Technical Diploma
- IRC State Approved WTCS- Associates
- IRC State Approved Business & Industry
- IRC - Not State Approved
- Youth Apprenticeship
- State Co-op Youth Leadership Skills

For non-certified programs, do not report if codes NONE or OTH are selected:

For 2019-20 and 2021-21, only report the following descriptors:
- Local Co-op
- Internship
- Simulation
- Supervised occupational experience
- School-based Enterprise
For 2021-22, only report the following descriptors:
- Internship/Local co-op
- Simulated Worksite
- Entrepreneurial Student Business
- School-based Enterprise
- Supervised Agricultural Experience

Program Type	Program Name	Logic
uri://dpi.wi.gov/ProgramTypeDescriptor#WL	Foreign Language Exploratory Programs (FLEX)	Report this program type and program name if World Language is mapped to the Ed-Fi Code: Foreign Language Exploratory Programs (FLEX) for SY 2021-22 and earlier
uri://dpi.wi.gov/ProgramTypeDescriptor#WL	Foreign Language in the Elementary School Programs (FLES)	Report this program type and program name if World Language is mapped to the Ed-Fi Code: Foreign Language in the Elementary School Programs (FLES) for SY 2021-22 and earlier
uri://dpi.wi.gov/ProgramTypeDescriptor#WL	Immersion Programs (IMMR)	Report this program type and program name if World Language is mapped to the Ed-Fi Code: Immersion Programs (IMMR) for SY 2021-22 and earlier
uri://dpi.wi.gov/ProgramTypeDescriptor#WL	World Language (WL)	Report this program type and program name if World Language is mapped to the Ed-Fi Code: World Language (WL) for SY 2021-22 and earlier
uri://dpi.wi.gov/ProgramTypeDescriptor#WL	Exploratory World Language Program (EXWL)	Report this program type and program name if World Language is mapped to the Ed-Fi Code: Exploratory World Language Program (EXWL) for SY 2022-23 and later
uri://dpi.wi.gov/ProgramTypeDescriptor#WL	Elementary School World Language Program (ESWL)	Report this program type and program name if World Language is mapped to the Ed-Fi Code: Elementary School World Language Program (ESWL) for SY 2022-23 and later
uri://dpi.wi.gov/ProgramTypeDescriptor#WL	Content-Based World Language Program (CBWL)	Report this program type and program name if World Language is mapped to the Ed-Fi Code: Content-Based World Language Program (CBWL) for SY 2022-23 and later
uri://dpi.wi.gov/ProgramTypeDescriptor#WL	Two-Way Dual Language Education Program (DLTW-WL)	Report this program type and program name if World Language is mapped to the Ed-Fi Code: Two-Way Dual Language Education Program (DLTW-WL) for SY 2022-23 and later
uri://dpi.wi.gov/ProgramTypeDescriptor#WL	Dual Language Education - Heritage learners (DLDB-HL)	Report this program type and program name if World Language is mapped to the Ed-Fi Code: Dual Language Education - Heritage learners (DLDB-HL) for SY 2022-23 and later
uri://dpi.wi.gov/ProgramTypeDescriptor#WL	Secondary Level World Language Program (SLWL)	Report this program type and program name if World Language is mapped to the Ed-Fi Code: Secondary Level World Language Program (SLWL) for SY 2022-23 and later
uri://dpi.wi.gov/ProgramTypeDescriptor#WL	Heritage Learner World Language Program (SLWL)	Report this program type and program name if World Language is mapped to the Ed-Fi Code: Heritage Learner World Language Program (SLWL) for SY 2022-23 and later
uri://dpi.wi.gov/ProgramTypeDescriptor#WL	American Indian Language Program (AIWL)	Report this program type and program name if World Language is mapped to the Ed-Fi Code: American Indian Language Program (AIWL) for SY 2022-23 and later
uri://dpi.wi.gov/ProgramTypeDescriptor#WL	Facilitated World Language Program (FWLS)	Report this program type and program name if World Language is mapped to the Ed-Fi Code: Facilitated World Language Program (FWLS) for SY 2022-23 and later
uri://dpi.wi.gov/ProgramTypeDescriptor#WL	One-Way Dual Language Education Program (OWDL)	Report this program type and program name if World Language is mapped to the Ed-Fi Code: One-Way Dual Language Education Program (OWDL) for SY 2022-23 and later
uri://dpi.wi.gov/ProgramTypeDescriptor#Dual	College Course with Private College	Report this program type and program name if Dual Enrollment is mapped to the Ed-Fi Code: College Course with Private College
uri://dpi.wi.gov/ProgramTypeDescriptor#Dual	College Course with Technical College	Report this program type and program name if Dual Enrollment is mapped to the Ed-Fi Code:College Course with Technical College
uri://dpi.wi.gov/ProgramTypeDescriptor#Dual	College Course with Tribal College	Report this program type and program name if Dual Enrollment is mapped to the Ed-Fi Code:College Course with Tribal College
uri://dpi.wi.gov/ProgramTypeDescriptor#Dual	College Course with UW System	Report this program type and program name if Dual Enrollment is mapped to the Ed-Fi Code:College Course with UW System
uri://dpi.wi.gov/ProgramTypeDescriptor#Dual	High School Course with Private College	Report this program type and program name if Dual Enrollment is mapped to the Ed-Fi Code:High School Course with Private College
uri://dpi.wi.gov/ProgramTypeDescriptor#Dual	High School Course with Technical College	Report this program type and program name if Dual Enrollment is mapped to the Ed-Fi Code:High School Course with Technical College
uri://dpi.wi.gov/ProgramTypeDescriptor#Dual	High School Course with Tribal College	Report this program type and program name if Dual Enrollment is mapped to the Ed-Fi Code:High School Course with Tribal College
uri://dpi.wi.gov/ProgramTypeDescriptor#Dual	High School Course with UW System	Report this program type and program name if Dual Enrollment is mapped to the Ed-Fi Code:High School Course with UW System
uri://dpi.wi.gov/ProgramTypeDescriptor#Certified	IRC - Not State Approved	Report this program type and program name if Certified Learning Method is mapped to the Ed-Fi Code: IRC - Not State Approved
uri://dpi.wi.gov/ProgramTypeDescriptor#Certified	IRC State Approved Business & Industry	Report this program type and program name if Certified Learning Method is mapped to the Ed-Fi Code: IRC State Approved Business & Industry
uri://dpi.wi.gov/ProgramTypeDescriptor#Certified	IRC State Approved WTCS- Associates	Report this program type and program name if Certified Learning Method is mapped to the Ed-Fi Code: IRC State Approved WTCS- Associates
uri://dpi.wi.gov/ProgramTypeDescriptor#Certified	IRC State Approved WTCS- Embedded Technical Diploma	Report this program type and program name if Certified Learning Method is mapped to the Ed-Fi Code: IRC State Approved WTCS- Embedded Technical Diploma
uri://dpi.wi.gov/ProgramTypeDescriptor#Certified	State Co-op Ed. Skill Standards - DPI Employability Skills	Report this program type and program name if Certified Learning Method is mapped to the Ed-Fi Code: State Co-op Ed. Skill Standards - DPI Employability Skills
uri://dpi.wi.gov/ProgramTypeDescriptor#Certified	State Co-op Ed. Skill Standards - DPI Occupational	Report this program type and program name if Certified Learning Method is mapped to the Ed-Fi Code: State Co-op Ed. Skill Standards - DPI Occupational
uri://dpi.wi.gov/ProgramTypeDescriptor#Certified	State Co-op Ed. Skill Standards - DPI Youth Leadership	Report this program type and program name if Certified Learning Method is mapped to the Ed-Fi Code: State Co-op Ed. Skill Standards - DPI Youth Leadership
uri://dpi.wi.gov/ProgramTypeDescriptor#Certified	Youth Apprenticeship	Report this program type and program name if Certified Learning Method is mapped to the Ed-Fi Code: Youth Apprenticeship
uri://dpi.wi.gov/ProgramTypeDescriptor#Non Certified	Internship	Report this program type and program name if Non-Certificated Learning Method is mapped to the Ed-Fi Code: Internship
uri://dpi.wi.gov/ProgramTypeDescriptor#Non Certified	Local Co-op	Report this program type and program name if Non-Certificated Learning Method is mapped to the Ed-Fi Code: Local Co-op
uri://dpi.wi.gov/ProgramTypeDescriptor#Non Certified	Simulation	Report this program type and program name if Non-Certificated Learning Method is mapped to the Ed-Fi Code: Simulation
uri://dpi.wi.gov/ProgramTypeDescriptor#Non Certified	Supervised occupational experience	Report this program type and program name if Non-Certificated Learning Method is mapped to the Ed-Fi Code: Supervised occupational experience