This association represents the school in which a student is enrolled.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	When a new enrollment is saved for a student. A record will report for each distinct enrollment in a School and Enrollment Start Date. When a student has two enrollments in the same School, Calendar and Schedule Structure with the same start date, report from the enrollment service type in the following order: P: Primary Enrollment S: Partial/Ancillary N: Special Ed Services When an enrollment with a higher priority is deleted, the enrollment with lower priority will post a new record. Do not send records if the Calendar Exclude checkbox is checked in the calendar the student is enrolled. Do not send records if the School Exclude checkbox is checked in the calendar the student is enrolled. Do not send a record if the No Show checkbox is checked. Do not send a record if the Enrollment State Exclude check box is checked. Do not send records if the Calendar Grade Level "Exclude from State Reporting" checkbox is selected for the grade level that the student's enrollment is tied to. If one calendar is mapped to another calendar in the Calendars Override Mapping , and any grade levels are shared between the two calendars, the "mapped-to" calendar governs the "Exclude from State Reporting" status. When a new Transportation record is saved for a student, and the Transportation Start Date is after the Enrollment Start Date (but still takes place before the SSA exitWithdrawalDate), an additional SSA record will be created with a Start Date equal to the Transportation record Start Date. When a Transportation record is updated so that the Transportation End Date takes place after the Enrollment Start Date (but before the SSA exitWithdrawalDate), an additional SSA record will be created with a Start Date equal to the day after the Transportation End Date. A new SSA is ONLY created from the transportation record if the transportation record end date is prior to the transportation calendar's last instructional day.
Post	When the start date for an enrollment is changed. When an enrollment with a lower priority is changed, data will not send.
Post	when the State Aid Category on the enrollment = 98 and when the enrollment record start date is in the scope year and is on or after 7/1/xxx and when the enrollment record has an end date within the scope year for the following data elements report default values: Attendance = '0' Membership = '0' Percent Enrolled = '100' Transporting District = Submitting District / District of Enrollment (Resident District) Transportation Category = '00: Walkers' NOTE: This logic does not require the enrollment to overlap any instructional days.
Put	When an enrollment is updated for a student. When a student's start status is changed. When a student's end status is changed. When a student's grade level is changed. When a student's End Action is changed. When a student's School Choice checkbox is checked or unchecked. When a student's Resident District or Service District fields are changed. When a students Service Type is changed. When the Calendar reference is changed due to a Natural Key update on the Calendars resource. When a Transportation record Start Date is changed, if the Transportation record is responsible for the exitWithdrawlDate of the preceding SSA record, it will update the exitWithdrawalDate of the preceding SSA record. When a Transportation record End Date is changed, if the Transportation record is responsible for the entryDate of the following SSA record, it will update the entryDate of the following SSA record.
Delete	When an enrollment is deleted. When a student has two enrollments in the same school for the same start date, records with lower priority will not trigger a delete. When the start date of an enrollment is changed. When the No Show checkbox is checked. When a transportation record's start or end date is updated so that it no longer overlaps an enrollment record, and the transportation record was responsible for a stand-alone SSA record, the associated SSA record will be deleted.

Resource Toggle and Resync Logic

This table describes the Resource Toggle and Trigger logic of this object.

Action	Business Rule
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.
Put	If the natural key of the Calendar Reference is changed, a put will be done to update the Calendar Reference even if the Student School Association resource is turned 'OFF'.
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	Business Rule
Post/Delete	Natural Key changes: If the School Number/Ed-Fi School Number changes, a delete/post will occur with the cascading deletes from the School ID Change triggers. If an Ed-Fi ID changes, this will happen with the cascading deletes from the Ed-Fi ID Change trigger. If the enrollment start date changes, all dependent resources will be deleted and re-posted. If a dependent resource is turned off, all dependent resources will be deleted and not re-posted.
Delete	Cascading Deletes: If the Student School Association is deleted, all dependent resources will be deleted. Student Parent Associations, Student Education Organization Associations, Student Section Associations, Graduation Plans, Student Program Associations, Student CTE Program Associations, Student Special Education Program Associations, Student Title 1 Part A Program Associations, Student Academic Records, Course Transcripts, Grades, Student Discipline Incident Associations, Discipline Actions, Student Cohort Associations, Student School Attendance Events, Student Section Attendance Events

Action

Business Rule

Post/Delete

Natural Key changes:

If the School Number/Ed-Fi School Number changes, a delete/post will occur with the cascading deletes from the School ID Change triggers.
If an Ed-Fi ID changes, this will happen with the cascading deletes from the Ed-Fi ID Change trigger.
If the enrollment start date changes, all dependent resources will be deleted and re-posted. If a dependent resource is turned off, all dependent resources will be deleted and not re-posted.

Delete

Cascading Deletes: If the Student School Association is deleted, all dependent resources will be deleted.

Student Parent Associations, Student Education Organization Associations, Student Section Associations, Graduation Plans, Student Program Associations, Student CTE Program Associations, Student Special Education Program Associations, Student Title 1 Part A Program Associations, Student Academic Records, Course Transcripts, Grades, Student Discipline Incident Associations, Discipline Actions, Student Cohort Associations, Student School Attendance Events, Student Section Attendance Events

Scope Year Logic

This table describes scope year logic of this object.

Logic
The record will send to the scope year for the school year the enrollment is associated with.
Data will only send for the years that have valid configuration.

Resource Preferences

This table describes the Resource Preferences of this object.

Data Element Label	Mapping Needed
Entry Type Descriptors	Enrollment Start Status
Exit Withdraw Type Descriptors	Enrollment End Status

Identity Mapping Object Key

This table describes the Identity Mapping Object Key of this object.

campusObjectType	Object Key Data Source
Enrollment	enrollmentID

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus Table	Ed-Fi Action	Fields
enrollment	Post/Put/Delete	The primary table used for sending data for this resource.
person	Post/Delete	Student ID in Student Reference
graduation	Put	Class of School Year Type Reference
programs	Put	Graduation Plan Reference
programparticipation	Put	Graduation Plan Reference

Object Data Elements

This table describes data elements sent within the Student School Association resource.

Data Element Label	Business Requirement	Business Rules	M, C or O	Location
id	The unique identifier of the resource.		M
entryDate	The month, day, and year on which an individual enters and begins to receive instructional services in a campus.	If the SSA record is based on the student's enrollment, and there is either no transportation record, or an overlapping transportation record does exist, but begins prior to the start of the enrollment record, report the enrollment Start Date. If the SSA record is based on a transportation record that overlaps the student's enrollment, and the transportation record begins after the enrollment start date, report the transportation Start Date. If the SSA record is based on the student's enrollment, and there is a transportation record that overlaps the student's enrollment but ends prior to the last instructional day of the calendar or the enrollment end date, report the date following the transportation end date.	M	Student Information > General > Enrollments > Start Date Student Information > General > Transportation> Start Date Student Information > General > Transportation > End Date enrollment. startDate
calendarReference	A reference related to the Calendar resource.	This is optional, does not report.	O
classOfSchoolYear TypeReference	The year the student is expected to graduate.	This is optional, does not report.	O
graduationPlan Reference	A reference to the related GraduationPlan resource.	This is optional, does not report.	O
entryTypeDescriptor	The process by which a student enters a school during a given academic session.	If State Aid Category on the enrollment record = '46', then report '0'. If the SSA record is based on the student's enrollment, and there is a transportation record that overlaps the student's enrollment and that starts after the start of the student's enrollment but before the last instructional day in the calendar, report entryTypeDescriptor= 24. If the SSA record is based on the student's enrollment, and there is either no transportation record, or an overlapping transportation record does exist, but ends after the end of the enrollment record, report 40. f the SSA record is based on the student's enrollment, and there is either no transportation record, or an overlapping transportation record does exist, but ends after the end of the enrollment record, report entryTypeDescriptor = 00. Otherwise reports EdFi Code from the State Start Status value saved in the enrollment record.	M	Student Information > General > Enrollments > Enrollments > State Aid Category Student Information > General > Enrollments > Enrollments > Start Status enrollment.stateAid enrollment.startStatus
exitWithdrawDate	The month, day, and year of the first day after the date of an individual's last attendance at a school (if known), the day on which an individual graduated, or the date on which it becomes known officially that an individual left school.	If the SSA record is based on the student's enrollment, and there is either no transportation record, or an overlapping transportation record does exist, but ends after the end of the enrollment record, report the enrollment End Date. If the SSA record is based on the student's enrollment, and there is either no transportation record, or an overlapping transportation record does exist, but ends after the end of the associated calendar, and there is no enrollment end date, report the last instructional date of the calendar If the SSA record is based on a transportation record that overlaps the student's enrollment, and the transportation record ends before the enrollment end date, report the transportation End Date. If the SSA record is based on the student's enrollment, and there is a transportation record that overlaps the student's enrollment but starts after the start of the student's enrollment, report the date prior to the transportation Start Date.	M	Student Information > General > Enrollments > End Date Student Information > General > Transportation> Start Date Student Information > General > Transportation > End Date Scheduling & Courses > Calendar Setup > Calendar Information > Days enrollment.endDate
exitWithdrawTypeDescriptor	A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.	Report the Ed-Fi Code mapped to the enrollment End Status. If value is NULL and calendar End Code Override has a value set, the override value will be reported. If the SSA record is based on a transportation record that overlaps the student's enrollment, and the transportation record ends before the enrollment end date, report = 99 If the SSA record is based on the student's enrollment,and there is a transportation record that overlaps the student's enrollment but starts after the start of the student's enrollment, report = 99 If the SSA record is based on the student's enrollment, and there is either no transportation record, or an overlapping transportation record does exist, but ends after the end of the enrollment record, report 40.	M	Student Information > General > Enrollments > End Status OR Scheduling & Courses > Calendar Setup > Calendar Information > End Code Override
primarySchool	Indicates if a given enrollment record should be considered the primary record for a student. If omitted, the default is true.	This is optional, does not report.	O
repeatGrade Indicator	An indicator of whether the student is enrolling to repeat a grade level, either by failure or an agreement to hold the student back.	This is optional, does not report.	O
residencyStatus Descriptor	An indication of the location of a persons legal residence relative to (within or outside of) the boundaries of the public school attended and its administrative unit.	This is optional, does not report.	O
schoolChoice Transfer	An indication of whether students transferred in or out of the school did so during the school year under the provisions for public school choice in accordance with Title I, Part A, Section 1116.	This is optional, does not report.	O
specialEducation Evaluation StatusDescriptor	An indicator of the students’ need for and participation in special education programs during this enrollment period.	Report Special Ed Status code. If NULL, report '1'.	M	Student Information > General > Enrollments > Special Ed Fields > Special Ed Status Enrollment. specialEdStatus
stateAidCategory Descriptor	State Aid Category.	Report State Aid Category. If NULL, report '00'.	M	Student Information > General > Enrollments > State Reporting Fields > State Aid Category Enrollment. stateAid
homeboundService Indicator	The Homebound Service Indicator is used to validate Membership Days for students who have no Attendance Days. It is an indication of whether students were medically confined to their home and received instruction in the home during the enrollment period.	If Homebound = 'Y', report 'true'. If Homebound = 'N', report 'false'. If Homebound = NULL, report 'false'.	M	Student Information > General > Enrollments > State Reporting Fields > Homebound Enrollment. homebound
specialPupilIndicator	An indicator representing a Student who qualifies as a Special Pupil for Care and Treatment at some time during the school year.	If Special Pupils for Care/Treatment is 'Y', report 'true'. If Special Pupils for Care/Treatment is 'N', report 'false'. If Special Pupils for Care/Treatment is NULL, report 'false'.	M	Student Information > General > Enrollments > State Reporting Fields > Special Pupils for Care/Treatment EnrollmentMN. specialCare
residentLocal Education AgencyReference	localEducationAgencyId The identifier assigned to a local education agency.	Look to see if the Resident District <> NULL. If so, report the Resident District number. If not, report from the district.type + district.number values (ttdddd) Where: tt = district type dddd = district number, left zero filled An Error message specific to the resident district ID is generated for the SSA in the Ed-Fi Error Log if the resident district value is invalid.	M	Student Information > General > Enrollments > Resident District School & District Settings > District > District Information > Type School & District Settings > District > District Information > State District Number Enrollment. residentDistrict District.type District.number
membership Attendance UnitDescriptor	Days or Hours.	Report based on Membership/Attendance Type: If '01: Days' is selected, report 'Days'. If '02: Hours' is selected, report 'Hours'.	M	Student Information > General > Enrollments > State Reporting Fields > Attendance Type Enrollment. attendanceType
attendance	The total number of Instructional Days or Hours during which students attended school during the current school year.	Report the value entered into Attendance Override when <> NULL Else, if Attendance Override is NULL, calculate attendance based on membership first and then subtract qualifying absence amounts, if they exist in order to determine the reported value for 'attendance' When SAC = 46 always report '0' (zero) When Homebound Indicator =Y, report 0, else report the value entered into Enrollment Membership Override When school site category = 41: ALC or 42: ALP, the value reported for attendance can exceed the value for (possible) membership. Else, the attendance value cannot exceed the value that reports for membership. Percent enrolled '100' reports attendance and membership as a daily value. It counts the number of instructional days between the calculated start and end date. The total calculated value for membership cannot exceed the total instructional days override for a grade level, if a value exists. Percent enrolled 999/998 reports attendance and membership as an hourly value. It converts attendance minutes into hours and uses membership/attendance type '01: Days'. It counts all period minutes from the student's roster where course attendance = 1. In order to calculate the attendance value, Enrollment 'Percent Enrolled' cannot be NULL the student must be rostered into at least one course that: Is marked as Attendance Is scheduled in an Instructional period the absent value recorded for the day is equal to the total rostered instructional minutes OR is equal to the value in the calendar field "Whole Day Absence (minutes)" (1.0) or "Half Day Absence (minutes)" (0.5). The calculation method is determined by the value entered in enrollment field 'percent enrolled' and should match MARSS B calculation for determining value for flat file field named 'Attendance Days'.	M	Student Information > General > Enrollments > State Reporting Fields > Attendance Override Course > Attendance Scheduling & Courses > Calendar Setup > Calendar Information > Period Scheduling & Courses > Calendar Setup > Calendar Information > Grade Levels > Grade Level Editor > Grade Level Detail > Maximum Membership Days and Whole Day Absence (minutes)/ Half Day Absence (minutes) Scheduling & Courses > Calendar Setup > Calendar Information > Whole Day Absence (minutes) / Half Day Absence (minutes) Enrollment. adaOverride
membership	The total number of Instructional Days or Hours during which students were enrolled in the school during the current school year.	Report the value entered into Enrollment Membership Override when <> NULL If Enrollment Membership Override is NULL, calculate the total number of days between entryDate and exitWithdrawDate for which the student was enrolled, where the calendar days are marked as School Day, Instructional and Attendance When SAC = 46 always report '0' (zero) When Homebound Indicator =Y, report 0, else report the value entered into Enrollment Membership Override Else, when when SAC is NOT 46 and percent enrolled = 999/998 always report membershipAttendanceUnitDescriptor = 'Hours', if the Calendar Grade Level associated with the reported enrollment meets the reporting criteria and where 'Instructional Days Override' = NULL, convert the calculated value into Hours and report that value if the Calendar Grade Level associated with the reported enrollment meets the reporting criteria and where 'Instructional Days Override' = NOT NULL, use that value and convert into hours. Else, when SAC is NOT 46 and percent enrolled IS NOT = 999/998 always report membershipAttendanceUnitDescriptor = 'Days', if the Calendar Grade Level associated with the reported enrollment meets the reporting criteria and where 'Instructional Days Override' = NULL, report the calculated value of membership days for the duration of the enrollment record If the Calendar Grade Level associated with the reported enrollment meets the reporting criteria and where 'Instructional Days Override' = NOT NULL, use that value in the calculation when school site category IS 41: ALC or 42: ALP, report the calculated value for the enrollment record else, do not report a value that exceeds the total number of days between entryDate and exitWithdrawDate of the enrollment. The calculation method is determined by the value entered in enrollment field 'percent enrolled' and should match MARSS B calculation for the value reported for the flat file field named 'Membership Days'. Round the reported value to a whole number if it contains a decimal. Apply logic when value is calculated OR when override value is reported from Enrollment.admOverride - Membership Override field on the enrollment. Round down when decimal is 0.1-0.4. Round up when decimal is 0.5-0.9	M	Student Information > General > Enrollments > State Reporting Fields > Membership Override Scheduling & Courses > Calendar Setup > Calendar Information > Days > Instruction/Attendance Scheduling & Courses > Calendar Setup > Calendar Information > Grade Levels > Grade Level Editor > Grade Level Detail > Maximum Membership Days Enrollment. admOverride Day.instruction Day.attendance Gradelevel.maxMembershipDays
percentEnrolled	Percent Enrolled	Report Percent Enrolled. calculate value as percentEnrolled/100 If NULL, report '100'.	M	Student Information > General > Enrollments > State Reporting Fields > Percent Enrolled Enrollment. percentEnrolled
transportation Category Descriptor	Student’s to and from Transportation Category for the regular school term.	Report the EdFi Code mapped to the Transportation Category value selected from the latest transportation record that overlaps the enrollment record. If the mapping is NULL, or there is no transportation record that overlaps the enrollment record, report '00'.	M	Student Information > General > Transportation > Transportation Category Transportation. transportation Code
transportingLocal EducationAgency Reference	localEducationAgencyId The identifier assigned to a local education agency.	Report the value saved in Transporting District If Transporting District is NULL, or no Transportation record exists, report the District Number from the EdFi Configuration If District Number from the EdFi config is NULL, report the Ed-Fi District Number from the District record If the Ed-Fi District Number is NULL, report from the district.type + district.number values (ttdddd) Where: tt = district type dddd = district number, left zero filled	C	Student Information > General > Transportation > Transporting District Ed-Fi > Ed-Fi Configuration > configuration record > Connection > District Number School & District Settings > District > District Information > district record > Ed-Fi District Number School & District Settings > District > District Information > Type School & District Settings > District > District Information > State District Number Transportation. transporting District Enrollment. residentDistrict District.type District.number

Resource Preferences Continued

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

The following describes how to set the resource preferences for the Student School Association resource. 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. Any item not mapped will not report to Ed-Fi.

Select the appropriate Ed-Fi Codes for the Entry Type Descriptors.

Enrollment Start Status
Attribute Dictionary	System Settings > Custom Data and Links > Core Attribute/Dictionary > Enrollment > State Start Status
UI Location	Student Information > General > Enrollments > Start Status

Select the appropriate Ed-Fi Codes for the Exit Withdraw Type Descriptors.

Enrollment State Exit Type
Attribute Dictionary	System Settings > Custom Data and Links > Core Attribute/Dictionary > Enrollment > State ExitType
UI Location	Student Information > General > Enrollments > End Status

Select the appropriate Ed-Fi Codes for the Special Education Evaluation Status Descriptors Descriptors.

Enrollment Special Ed Status
Attribute Dictionary	System Settings > Custom Data and Links > Core Attribute/Dictionary > Enrollment > Special Ed Status
UI Location	Student Information > General > Enrollments > Special Ed Fields > Special Ed Status

Select the appropriate Ed-Fi Codes for the State Aid Category Descriptors.

Enrollment State Aid Category
Attribute Dictionary	System Settings > Custom Data and Links > Core Attribute/Dictionary > Enrollment > State Aid Category
UI Location	Student Information > General > Enrollments

Select the appropriate Ed-Fi Codes for the Transportation Category Descriptors.

Enrollment State Aid Category
Attribute Dictionary	System Settings > Custom Data and Links > Core Attribute/Dictionary > Transportation > Transportation Category
UI Location	Student Information > General > Transportation > Transportation Category

Click Save.

MN v3.3 - Student School Association