Minnesota Ed-Fi Data v3.1 - Student Section Associations

Classic View: System Administration > Ed-Fi 

Search Terms: 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

When a student is scheduled into a course section.

  • A record will report for each Section record that is reported based on the Sections logic.
  • If roster start date is after the term end date, do not report a record for the prior term.
  • Only send records if the student has a enrollment in the schedule structure where the student is scheduled and is not marked as No Show or State Exclude.

  • Do not send records if the Calendar Exclude check box is checked.
  • Do not send records if the School Exclude check box is checked.
  • Do  not send records if the Course is marked as Inactive or Exclude.
PostSend a new record if a student's roster start date is changed.
Put

When section information is updated for a student or section.

  • Update when the course or section's homeroom field is changed.
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 the future terms for that course, use the earliest term start date.
  2. If Start Date is NULL, 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

roster.

startdate

or

terms.

startdate


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


M

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


M

attemptStatus
Descriptor

An indication of the student’s 

attempt status for the section.

  1. This is optional, does not report.
O

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

homeroom
Indicator 
Indicator that the class is the 
student''s designated homeroom 
used for daily attendance 
reporting.
  1. Report "True" if the check box is checked on either the Section or the Course to which the section is assigned.
  2. Else, report False.
O

Scheduling> Course

> Homeroom


or


Scheduling> Course> 

Section> Homeroom

course.

homeroom

or

section.

homeroom

repeatIdentifier
Type
An indication as to whether a 
student has previously taken a 
given course. NEDM: Repeat
Identifier Repeated, counted in 
grade point average Repeated, 
not counted in grade point 
average Not repeated Other. 
  1. Does not report, this data is not collected in Campus.
O

teacherStudent
DataLink
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

section
Enrollment
Type
Descriptor
The Section enrollment type.Report the mapped value.
  1. If no value exists, or is not mapped, do not report
CCourse > Section
Enrollment Type

collegeCourse
Reference

courseCode: A unique alphanumeric 

code assigned to a course.


educationOrganizationId: The identifier 

assigned to an education organization.

courseCode: 

  1. Report the value.

educationOrganizationId:

  1. Report the Ed-Fi School ID.
  2. If Ed-Fi School ID is NULL, report:
    • ttddddsssmmm

      where:

      • tt = district type
      • dddd = district number, left zero filled
      • sss = school number, left zero filled
      • mmm = 000 for all organizations reported in Ed-Fi
M

courseCode: 

Course > Number


educationOrganizationId:

System Administration > Resources > School > 

school record > Ed-Fi 

School ID


tt: System Administration > Resources > District 

Information > district record

> Type


dddd: System Administration > Resources > District 

Information > district record > State District Number


SSS: System Administration > Resources > School > 

school record > State 

School Number

courseCode: 

  • Course.number

educationOrganizationId:

  • School.entityID
  • District.type
  • District.number
  • School.number
instructional
Approaches
An unordered collection of
student Section Association
Instructional Approaches.
Instructional approach as
implemented for the student
section association. General
purpose but intially implemented
for Early Education.


instructionalApproachDescriptor: 

Instructional approach.


implementationStatusDescriptor: 

Status of implementation of the 

instructional approach.


Report the mapped value.
  1. If no value exists, or is not mapped, do not report.
M
C

instructionalApproach

Descriptor:

Course > Inst. Approach 

and Implementation


implementationStatus

Descriptor:

Course > Inst. Approach 

and Implementation 

instructionalApproach

Descriptor:

Course.eeInstApproach

AndImp / CustomCourse.

value


implementationStatus

Descriptor: 

Course.eeInstApproach

AndImp / CustomCourse.

value

siteBased
Initiatives
An unordered collection of student Section Association SiteBased Initiatives. Site-based initiative as implemented for the student section association. General purpose but intially implemented for Early Education.

siteBasedInitiativeDescriptor: Site-based initiative.


implementationStatusDescriptor: Status of 

implementation of the site-based initiative.

Report the mapped value.
  1. If no value exists, or is not mapped, do not report.
M
C

siteBasedInitiative

Descriptor:

Course > Site-Based

 Initiative and Impl.


implementationStatus

Descriptor:

Course > Inst. Approach and Implementation 

siteBasedInitiative

Descriptor:

 Course.eeSiteBased

InitAndImp / CustomCourse.value


implementationStatus

Descriptor: 

Course.eeInstApproach

AndImp / CustomCourse.value

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


Types/Descriptors

section Enrollment Type Descriptor : 

Campus Attribute CodeCampus Attribute NameEd-Fi Descriptor codeEd-Fi Descriptor description
AIALC Independent StudyAIALC_IND_STUDY
DPPSEO Direct PayDPDIRECT_PAY_PSEO
OPPSEO OffsiteOPOFFSITE_PSEO
PBProject BasedPBPROJECT_BASED
SCScheduledSCSCHEDULED


instructional Approach Descriptor : Course.eeInstApproachAndImp "Inst. Approach and Implementation"

Campus Attribute CodeEd-Fi Descriptor codeEd-Fi Descriptor description
All codes that begin with 'ABA...'ABAApplied Behavior Analysis
All codes that begin with 'DR...'DRDialogic Reading
All codes that begin with 'NONE...'NONENo organized instructional approach used.
All codes that begin with 'OTHER...'OTHERUse OTHER when the EE Inst. Approach is not listed.
All codes that begin with 'ISB...'ISBInteractive Shared Book Reading
All codes that begin with 'TD...'TDTransdisciplinary Approach (Only used with Program = Special Ed)
All codes that begin with 'PAT...'PATPhonological Awareness Training
All codes that begin with 'R...'RRTI
All codes that begin with 'TE...'TETeach
All codes that begin with 'LI...'LILetter Identification
All codes that begin with 'PSP...'PSPPrimary Service Provider
All codes that begin with 'SBR...'SBRShared Book Reading
All codes that begin with 'L...'LLeap


implementation Status Descriptor : Course.eeInstApproachAndImp

Campus Attribute CodeEd-Fi Descriptor codeEd-Fi Descriptor description
All codes that end with '...CBEG'CBEGBeginning - Centers of Excellence ONLY
All codes that end with '...CEXP'CEXPExpanding - Centers of Excellence ONLY
All codes that end with '...CMNT'CMNTMaintaining - Centers of Excellence ONLY
All codes that end with '...FULL'FULLFull Implementation
All codes that end with '...X'XDoes not apply
All codes that end with '...YR1'YR1Initial Implementation Year 1
All codes that end with '...YR2'YRSInitial Implementation Year 2


site Based Initiative Descriptors : Course.eeSiteBasedInitAndImp "Site-Based Initiative and Impl."

Campus Attribute CodeEd-Fi Descriptor codeEd-Fi Descriptor description
All codes that begin with 'CLASS...'CLASSThe Classroom Assessment Scoring System
All codes that begin with 'FGRBI...'FGRBIFamily Guided Routines Based Intervention
All codes that begin with 'MMC...'MMCMinnesota Math Corp
All codes that begin with 'MRC...'MRCMinnesota Reading Corp
All codes that begin with 'NONE...'NONENo site-base initiative used
All codes that begin with 'NW...'NWNumbers Work
All codes that begin with 'PBIS...'PBISPositive Behavior Intervention and Suppport
All codes that begin with 'PECC...'PECCParent Education Core Curriculum
All codes that begin with 'PYRAMID...'PYRAMIDPyramid Model
All codes that begin with 'RPPM...'RPPMrelationship-based Primary Provider Model