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 still takes place before the SSA exitWithdrawalDate), an additional SSA record will be created with a Start Date equal to the day after the Transportation End Date.
Post	When the start date for an enrollment is changed. When an enrollment with a lower priority is changed, data will not send.
Put	When an enrollment is updated for a student. When a change is made to the Graduation > NCLB Cohort End Year field. When a student is assigned to a Graduation or CTE Program or the start and/or end dates are modified. 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 change, 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.
Delete	When the start date of an enrollment is changed.
Delete	When the No Show checkbox is checked.
Delete	When a Transportation record is deleted, and it was responsible for a stand-alone SSA record, the associated SSA record will be deleted.
Delete	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
Special Education Evaluation Status Descriptors	Enrollment Special Ed Status
State Aid Category Descriptors	Enrollment State-Aid Category
Transportation Category Descriptors	Transportation Category

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 enrollment/calendar 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
school Reference	A reference to the related School resource.	Reports the fields that are part of the Natural Key for the School resource.	M
schoolYearType Reference	The school year the student is being reported in.	Reports the end year of the calendar.	O
studentReference	A reference to the related Student resource.	Reports the reference for the student being reported.	M
educationPlans	An unordered collection of student School Association Education Plans. This association represents the school in which a student is enrolled.	This is optional, does not report.	O
employedWhile Enrolled	An individual who is a paid employee or works in his or her own business, profession, or farm and at the same time is enrolled in secondary, postsecondary, or adult education.	This is optional, does not report.	O
entryGradeLevel Descriptor	The grade level or primary instructional level at which a student enters and receives services in a school or an educational institution during a given academic session.	Reports the Ed-Fi Code from the Grade Level mapping for the grade selected on the student's enrollment. If a mapping is not available, the record will error.	M	Student Information > General > Enrollments > Grade activeEnrollment. grade
entryGradeLevel ReasonDescriptor	A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.	This is optional, does not report.	O
entryType Descriptor	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'. Otherwise reports Ed-Fi Code from the State Start Status value saved in the enrollment record.	O	Student Information > General > Enrollments > State Aid Category Student Information > General > Enrollments > Start Status enrollment. stateAid enrollment. startStatus
exitWithdraw Date	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. When an enrollment is ended using a date that is marked as non-instructional on the Calendar, the date of the last instructional day is reported as the enrollment end date. This applies to Ed-Fi resources dependent upon Student School Association and related transportation records.	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 enrollment. endDate
exitWithdraw TypeDescriptor	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 NULL, report '40'.	M	Student Information > General > Enrollments > End Status OR System Administration > calendar > End Code Override enrollment. endstatus
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	M	Student Information > General > Enrollments > Resident District System Administration > Resources > District Information > Type System Administration > Resources > 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 in the Attendance Override when the field is not NULL. If Attendance Override is NULL, report the total number of Instructional Days between entryDate and exitWithdrawDate when: The student was rostered into at least one course that: Is marked as Attendance. Is scheduled in an Instructional period. Report a value no higher than the value entered into Maximum Membership Days. The total absence minutes for the student on that date is equal to or greater than the value entered into the calendar's "Whole Day Absence (minutes)" field. If the field is NULL, absence minutes must equal total rostered instructional minutes.	M	Student Information > General > Enrollments > State Reporting Fields > Attendance Override Course > Attendance System Administration > Calendar > Calendar > Period System Administration > Calendar > Calendar > Grade Levels > Grade Level Editor > Grade Level Detail > Maximum Membership Days 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 Membership Override when <> NULL. If Membership Override is NULL, report the total number of days between entryDate and exitWithdrawDate for which the student was enrolled, where the calendar days are marked as both Instructional and Attendance. Report a value no higher than the value entered into Maximum Membership Days.	M	Student Information > General > Enrollments > State Reporting Fields > Membership Override Course > Attendance System Administration > Calendar > Calendar > Period System Administration > Calendar > Calendar > Grade Levels > Grade Level Editor > Grade Level Detail > Maximum Membership Days Enrollment. admOverride
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 Resident District number. If Resident District 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 Student Information > General > Enrollments > Resident District System Administration > Resources > District Information > Type System Administration > Resources > District Information > State District Number Transportation. transporting District Enrollment. residentDistrict District.type District.number
etag

Minnesota Ed-Fi Data v3.1 - Student School Association