Wisconsin Ed-Fi Data v3.5 - Student Section Associations

Tool Search: Ed-Fi

This association indicates the course sections to which a student is assigned.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

Report a record based on the student enrollment.

  • When a student is scheduled into a course section.
    Note:  Report for state grade levels 6-12, unless specified differently.
  • A record will report for each Section record that is reported based on the Sections logic.
  • Report only if a Grading Task marked State Reported and Exclude from Ed-Fi is unchecked with an Ed-Fi Grade Type of Final exists for the course/section or if a Standard marked 'State Reported' and 'Final' exists for the course/section.
    • Note: Report a record based on the Term Mask of the state reported Grading Task.
  • If Roster End Date is null, use the term mask to determine the term to report.
  • If Roster End Date is not null, use the term the endDate falls within to report.
  • Report from any enrollment determining a record. If the student has multiple qualifying enrollments in the same school, report a record for each unique start date.
  • Do not send a record based on an enrollment that is marked as State Exclude, No Show, or WISE Exclude.

  • Do not send a record based on an enrollment is in a calendar marked as State Exclude or Summer School.
  • Report records only if the student's State Enrollment Type = Primary or Coursework Only.
  • Do not send records if the Course is marked as Inactive or Exclude.
  • Do not send if there is a School Override value populated on enrollment that is different from the school for the enrollment record.
PostSend a new record if a student's roster start date is changed.
PostWhen a grade is added, changed, or deleted for a student.
Put

When section information is updated for a student or section.

  • Update when the course or section's homeroom field is changed.
  • Update when a grade is added for a grading task mapped to an Ed-Fi Grade
DeleteWhen a student is deleted from a course section.
Delete

Delete any future records if the student is given a roster end date for the course.

  • Roster End Date must be before Term Start date of future records
Delete/PostDelete the record if a student's roster start date 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.
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
Delete/Post

Natural Key change:

  • The natural key logic from Sections and Students will update this resource if they change.

  • If the students Begin Date changes.
Delete/Post

If the natural key changes all dependent data will delete/post.

  • Student Section Attendance Events, Grades


Scope Year Logic

This table describes scope year logic of this object.

Logic

Reports records in the scope year in which the course/section's calendar is aligned.

  • Data will only send for years that have valid configuration.


Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus TableEd-Fi ActionFields
rosterPost/Put/DeleteThe primary table used for sending data for this resource.
rosterPutEnd date
termsPutEnd date
coursePuthomeroom
sectionPuthomeroom


Object Data Elements

This table describes data elements sent within the Student Section Association 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

beginDateMonth, day and year of the student''s entry or assignment to the section. If blank, default is the start date of the first grading period.
  1. Report the roster start date for the term record in which the start date occurs.
    • For any records in future terms for that course, use the earliest term start date.
  2. If Roster Start Date is NULL:
    • If the enrollment start date is after the earliest term start date associated with the term descriptor selected for the section, report the enrollment start date.
    • Otherwise, report the earliest term start date associated with the term descriptor selected for this section based on section schedule placement.
M

Student Information> General> Schedule> Roster Start Date


OR


System Administration> Calendar> Calendar> Terms


OR


Student Information > General > Enrollments > Enrollment Start Date


roster.startdate

or

terms.startdate

or

enrollment.startdate


sectionReferenceA reference to the related Section resource.
  1. Reports the fields that are part of the Natural Key for the Section resource.


M

studentReference A reference to the related Student resource.
  1. Reports the fields that are part of the Natural Key for the Student resource.


M

programReferenceAn 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 Student Detail, report the associated programReference.
    • If it is only populated on Section, report the associated programReference.
    • Otherwise, report value from Course for the student, if populated.
  2. If the Dual Enrollment field is populated on the Section Student Detail, report the associated programReference.
    • If the Dual Enrollment field is is only populated on the Section, report from the Section for the student.
    • Otherwise, report the value selected on 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.
      1. Do not report if codes NONE, COOP, EMP or BUS are selected.
      2. 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 
  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
      1. Do not report if codes NONE or BOTH are selected.
      2. For 2021-22, only report the following descriptors:
        • Internship/Local co-op
        • Simulated Worksite
        • Entrepreneurial Student Business
        • School-based Enterprise
        • Supervised Agricultural Experience
  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.  
    • If the student drops and then re-enrolls in the class, send the program reference, if data exists.
  7. If student drops from the class and receives a final, state reported grade, send the program reference, if data exists.
CScheduling > Course > Section > Section Student Detail

Scheduling > Courses > Section

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

An indication of the student’s attempt status for the section.

Descriptors :

Use InSufficient when students stays enrolled but withdraws from course in a specified term OR when students exits enrollment so exits section. Performance grade is not expected as student did not stay long enough in the section.

Use sufficient when students enrollment stays long enough in the section with in a specified term and performance grade is expected for this course.

  1. If the student is NOT in grade 9-12, report blank.
    • Otherwise, if student is in grade 9-12, continue to determine value.
  2. If Attempt Status Override is populated on the Section Student Detail, report the value selected.
    • Otherwise, if reported on Roster Batch Edit for the student, report the value selected.
  3. If the student exits the section and re-enrolls:
    • Report "Insufficient" on the earlier student section association with an End Date if the student does not have a grade for a Grading Task mapped to an Ed-Fi Grade Type.
    • Report "Sufficient" for the latest student section association record if the student has a grade for a Grading Task mapped to an Ed-Fi Grade Type or is expected to.
    • Note: In the case of multiple roster records for the student (exit, re-enroll, exit, etc), always report "I" for the first record.
  4. If the student exits the section prior to the section end date
    • AND there is a Grading Task mapped to an Ed-Fi Grade, but the student does NOT have a grade for that Grading Task on the section, report "Insufficient".
  5. If the student exits the section prior to the section end date
    • AND the student has a Grade for the Ed-Fi Mapped Grading task on the section
      • AND the Score for the student is mapped to an Ed-Fi Grade Type, report "Sufficient"
    • Otherwise, if the Score is NOT mapped to an Ed-Fi Grade Type, report "Insufficient"
  6. If the student is on the roster through the section end date, report "Sufficient".
C

Grading & Standards > Grading Tasks

Score Groups & Rubrics > Ed-Fi Grade Type


Scheduling > Course > Section > Section Student Detail


Scheduling > Course > Roster


endDate Month, day, and year of the withdrawal or exit of the student from the section.
  1. Report the roster end date for the student .
    • If a roster end date is entered, delete any records for future terms for that section.
  2. If NULL, report the latest term start date associated with the term descriptor selected for this section based on section schedule placement.
O

Student Information> General> Schedule> Roster End Date


OR


System Administration> Calendar> Calendar> Terms

roster.endDate

or

terms.endDate

homeroomIndicator Indicator that the class is the student''s designated homeroom used for daily attendance reporting.
  1. This is optional, does not report.
O

repeatIdentifierTypeAn indication as to whether a student has previously taken a given course. 
  1. Does not report, this data is not collected in Campus.
O

teacherStudentDataLink
Exclusion
Indicates that the student-section combination is excluded from calculation of value-added or growth attribution calculations used for a particular teacher evaluation.
  1. Does not report, this data is not collected in Campus.
O

etagA unique system-generated value that identifies the version of the resource.
O

Program Reference

Click here to expand...

Program TypeProgram NameLogic
uri://dpi.wi.gov/ProgramTypeDescriptor#WLForeign 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#WLForeign 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#WLImmersion 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#WLWorld 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#WLExploratory 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#WLElementary 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#WLContent-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#WLTwo-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#WLDual 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#WLSecondary 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#WLHeritage Learner World Language Program(HLWL)

Report this program type and program name if World Language is mapped to the Ed-Fi Code: Heritage Learner World Language Program(HLWL) for SY 2022-23 and later.

uri://dpi.wi.gov/ProgramTypeDescriptor#WLAmerican 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#WLFacilitated 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#WLOne-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#DualCollege 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#DualCollege 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#DualCollege 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#DualCollege 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#DualHigh 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#DualHigh 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#DualHigh 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#DualHigh 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#CertifiedIRC 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#CertifiedIRC 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#CertifiedIRC 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#CertifiedState 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#CertifiedState 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#CertifiedState 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#CertifiedYouth 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 CertifiedInternship

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

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 CertifiedSupervised occupational experience

Report this program type and program name if Non-Certificated Learning Method is mapped to the Ed-Fi Code: Supervised occupational experience.