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.

Action	Trigger
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. Do not send records when reportable enrollment is marked as State Exclude.
Post	Send 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.
Delete	When 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/Post	Delete the record if a student's roster start date is changed. If State Exclude is checked/unchecked, trigger DELETE/POST as appropriate.

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

Action

Trigger

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.

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 Table	Ed-Fi Action	Fields
roster	Post/Put/Delete	The primary table used for sending data for this resource.
roster	Put	End date
terms	Put	End date
course	Put	homeroom
section	Put	homeroom

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
id	The unique identifier of the resource.		M
beginDate	Month, 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.	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. 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 Scheduling & Courses > Calendar Setup > Calendar Information > Terms	roster. startdate or terms. startdate
section Reference	A reference to the related Section resource.	Reports the fields that are part of the Natural Key for the Section resource.	M
student Reference	A reference to the related Student resource.	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.	This is optional, does not report.	O
endDate	Month, day, and year of the withdrawal or exit of the student from the section.	Report the roster end date for the student. If a roster end date is entered, delete any records for future terms for that section. 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 Scheduling & Courses > Calendar Setup > Calendar Information > Calendar > Terms	roster. endDate or terms. endDate
homeroom Indicator	Indicator that the class is the student''s designated homeroom used for daily attendance reporting.	Report "True" if the check box is checked on either the Section or the Course to which the section is assigned. Else, report False.	O	Scheduling & Courses > Courses > Course Information > Homeroom or Scheduling & Courses > Courses > Section Information > 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.	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.	Does not report, this data is not collected in Campus.	O
section Enrollment Type Descriptor	The Section enrollment type.	Report the mapped value. If no value exists, or is not mapped, do not report	C	Scheduling & Courses > Courses > Course Information > Section Enrollment Type
collegeCourse Reference	courseCode: A unique alphanumeric code assigned to a course. educationOrganizationId: The identifier assigned to an education organization.	courseCode: Report the value. educationOrganizationId: Report the Ed-Fi School ID. 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: School & District Settings > Schools > School Information > school record > Ed-Fi School ID tt: School & District Settings > District > District Information > district record > Type dddd: School & District Settings > District > District Information > district record > State District Number SSS: School & District Settings > Schools > School Information > 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. If no value exists, or is not mapped, do not report.	M C	instructionalApproach Descriptor: Scheduling & Courses > Courses > Course Information > Inst. Approach and Implementation implementationStatus Descriptor: Scheduling & Courses > Courses > Course Information > 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. If no value exists, or is not mapped, do not report.	M C	siteBasedInitiative Descriptor: Scheduling & Courses > Courses > Course Information > Site-Based Initiative and Impl. implementationStatus Descriptor: Scheduling & Courses > Courses > Course Information > Inst. Approach and Implementation	siteBasedInitiative Descriptor: Course.eeSiteBased InitAndImp / CustomCourse.value implementationStatus Descriptor: Course.eeInstApproach AndImp / CustomCourse.value
etag	A unique system-generated value that identifies the version of the resource.		O

Types/Descriptors

Click here to expand...

section Enrollment Type Descriptor :

Campus Attribute Code	Campus Attribute Name	Ed-Fi Descriptor code	Ed-Fi Descriptor description
AI	ALC Independent Study	AI	ALC_IND_STUDY
DP	PSEO Direct Pay	DP	DIRECT_PAY_PSEO
OP	PSEO Offsite	OP	OFFSITE_PSEO
PB	Project Based	PB	PROJECT_BASED
SC	Scheduled	SC	SCHEDULED

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

Campus Attribute Code	Ed-Fi Descriptor code	Ed-Fi Descriptor description
All codes that begin with 'ABA...'	ABA	Applied Behavior Analysis
All codes that begin with 'DR...'	DR	Dialogic Reading
All codes that begin with 'NONE...'	NONE	No organized instructional approach used.
All codes that begin with 'OTHER...'	OTHER	Use OTHER when the EE Inst. Approach is not listed.
All codes that begin with 'ISB...'	ISB	Interactive Shared Book Reading
All codes that begin with 'TD...'	TD	Transdisciplinary Approach (Only used with Program = Special Ed)
All codes that begin with 'PAT...'	PAT	Phonological Awareness Training
All codes that begin with 'R...'	R	RTI
All codes that begin with 'TE...'	TE	Teach
All codes that begin with 'LI...'	LI	Letter Identification
All codes that begin with 'PSP...'	PSP	Primary Service Provider
All codes that begin with 'SBR...'	SBR	Shared Book Reading
All codes that begin with 'L...'	L	Leap

implementation Status Descriptor : Course.eeInstApproachAndImp

Campus Attribute Code	Ed-Fi Descriptor code	Ed-Fi Descriptor description
All codes that end with '...CBEG'	CBEG	Beginning - Centers of Excellence ONLY
All codes that end with '...CEXP'	CEXP	Expanding - Centers of Excellence ONLY
All codes that end with '...CMNT'	CMNT	Maintaining - Centers of Excellence ONLY
All codes that end with '...FULL'	FULL	Full Implementation
All codes that end with '...X'	X	Does not apply
All codes that end with '...YR1'	YR1	Initial Implementation Year 1
All codes that end with '...YR2'	YRS	Initial Implementation Year 2

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

Campus Attribute Code	Ed-Fi Descriptor code	Ed-Fi Descriptor description
All codes that begin with 'CLASS...'	CLASS	The Classroom Assessment Scoring System
All codes that begin with 'FGRBI...'	FGRBI	Family Guided Routines Based Intervention
All codes that begin with 'MMC...'	MMC	Minnesota Math Corp
All codes that begin with 'MRC...'	MRC	Minnesota Reading Corp
All codes that begin with 'NONE...'	NONE	No site-base initiative used
All codes that begin with 'NW...'	NW	Numbers Work
All codes that begin with 'PBIS...'	PBIS	Positive Behavior Intervention and Suppport
All codes that begin with 'PECC...'	PECC	Parent Education Core Curriculum
All codes that begin with 'PYRAMID...'	PYRAMID	Pyramid Model
All codes that begin with 'RPPM...'	RPPM	relationship-based Primary Provider Model

Resource Preferences

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

The following describes how to enable the Student Section Association resource for Ed-Fi reporting. If the Configure or Edit buttons do not display, then the resource does not need to be mapped and the toggle button can be used to turn the resource on or off.

If a mapping is changed, a resync must be performed on the resource in order for the new mappings to send correctly.

Select the appropriate Ed-Fi Code for the Implementation Status Descriptors. To view a full list of the Descriptors, please see the Student Section Associations Data Resource article.

Any item not mapped will not report to Ed-Fi.

Course Inst. Approach and Implementation
Attribute Dictionary	System Settings > Custom Data and Links > Core Attribute Dictionary > Course > Curriculum and Implementation
UI Location	Scheduling & Courses > Courses > Course Information > Inst. Approach and Implementation Scheduling & Courses > Courses > Course Information > Site-Based Initiative and Implementation

Course Inst. Approach and Implementation

Attribute Dictionary

System Settings > Custom Data and Links > Core Attribute Dictionary > Course > Curriculum and Implementation

UI Location

Scheduling & Courses > Courses > Course Information > Inst. Approach and Implementation

Scheduling & Courses > Courses > Course Information > Site-Based Initiative and Implementation

Select the appropriate Ed-Fi Code for the Instructional Approach Descriptors. To view a full list of the Descriptors, please see the Student Section Associations Data Resource article.

Course Inst. Approach and Implementation
Attribute Dictionary	System Settings > Custom Data and Links > Core Attribute Dictionary > Course > Inst. Approach and Implementation
UI Location	Scheduling & Courses > Courses > Course Information > Inst. Approach and Implementation

Select the appropriate Ed-Fi Code for the Section Enrollment Type Descriptors. To view a full list of the Descriptors, please see the Student Section Associations Data Resource article.

Section Enrollment Type
Attribute Dictionary	System Settings > Custom Data and Links > Core Attribute Dictionary > Course > Section Enrollment Type
UI Location	Scheduling & Courses > Courses > Section Information > Section > Enrollment Type

Select the appropriate Ed-Fi Code for the Site Based initiative Descriptors. To view a full list of the Descriptors, please see the Student Section Associations Data Resource article.

Course Site Based Initiative and Impl
Attribute Dictionary	System Settings > Custom Data and Links > Core Attribute Dictionary > Course > Site-Based Initiative and Impl.
UI Location	Scheduling & Courses > Courses > Course Information > Site-Based Initiative and Impl.

MN v3.3 - Student Section Associations