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

Student Information > General > Personal CurriculumStudent Information > General > Personal Curriculum

Tool Search: Ed-Fi

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 & 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 check box is checked in the calendar the student is enrolled. Do not send records if the School Exclude check box is checked in the calendar the student is enrolled. Do not send a record if enrollment is marked as No Show or State Exclude.
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 the Calendar reference is changed due to a Natural Key update on the Calendars resource. When Student Residency is changed. When FTE in General Education is changed. When S2E2 Code is changed. When District Start Date is changed.
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 or State Exclude check box is checked.

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 reposted. If a dependent resource is turned off, all dependent resources will be deleted and not reposted.
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 reposted. If a dependent resource is turned off, all dependent resources will be deleted and not reposted.

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
District Residency Status Descriptors	Enrollment Student Residency

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	Data Source GUI Path	Database Field
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.	Report the enrollment start date.	M	Student Information> General> Enrollments> Start Date	enrollment. startdate
calendarReference	A reference related to the Calendar resource.	Report the Calendar reference for the calendar in which the student is enrolled that is being reported.	O
classOfSchoolYear TypeReference	The year the student is expected to graduate.	Report the year selected in Student Info > General > Graduation > NCLB Cohort End Year. If NCLB Cohort End Year = Null, do not report.	C	Student Information > General > Graduation > NCLB Cohort End Year.
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 in which the student is being reported.	Reports the end year of the calendar.	O
student Reference	A reference to the related Student resource.	Report the reference for the student being reported.	M
educationPlans	An unordered collection of studentSchoolAssociationEducationPlans. 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.	Report 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
entryGradeLevel Reason Descriptor	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	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 Value mapped to the Start Status selected. If blank, do not report.	O	Student Information> General> Enrollments> Start Status	enrollment. startstatus
exitWithdrawDate	The month, day, and year of the first day after the date of an individual''s last attendance at a campus (if known), the day on which an individual graduated, or the date on which it becomes known officially that an individual left school.	If End Status NOT = NULL or 19, report End Date + 1 day. If End Status = NULL or 19, report End Date.	O	Student Information > General > Enrollments	enrollment. enddate
exitWithdrawType Descriptor	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 Value from the End Status selected. If blank, do not report.	O	Student Information> General> Enrollments> End Status	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	Student Information> General> Enrollments> Service Type	enrollment. type
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	Student Information> General> Enrollments> End Action	enrollment. endAction
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.		Student Information> General> Enrollments>	enrollment. resident district and/or enrollment. serving district
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	Student Information> General> Enrollments> School Choice	enrollment. school Choice Program
districtEntryDate	The date the student was first enrolled in the District.	Report District Start Date. If NULL, use the following calculation. Look back to the most recent enrollment with a End Status NOT = 19 or NULL. Then report the start date of the next following enrollment. (the calculation looks back until it finds a code, then moves forward to the next future enrollment and reports the Start Date) Calculation Exception If no code NOT = 19 or NULL is found, report the start date of the oldest enrollment on record for the student. Calculation Exception Please disregard the most recent enrollment in the calculation if the End Status NOT = ** or NULL. MSDS Logic: Component: Enrollment	O	Student Information > General > Enrollments > State Reporting	enrollment. districtDate
districtResidency StatusDescriptor	Indicates the student's residency related to the geographic boundaries of the district and/or residency requirements outlined in the Pupil Residency section of the MDE Pupil Accounting Manual.	Reports the Ed-Fi Code from the Student Residency.	O	Student Information > Program Participation > State Programs > Student Residency
districtResidency StatusAsOfDate	Indicates the date of the last change to district residency status.	Reports the Residency Start Date. If there is no Student Residency record, then report the Enrollment Start Date. Only reports if districtResidencyStatusDesctiptor is reported.	O	Student Information > Program Participation > State Programs > Student Residency or Student Information > General > Enrollments > Start Date
enrollment Percent	The pro rata share for which the student receives educational programs and/or services from the operating district.	Report FTE in General Education.	O	Student Information > General > Enrollments > State Reporting > FTE in General Education
exitWithdrawDate AsOfDate	To support state reporting: captures when ExitWithdrawDate changed.	This is optional, does not report.
s2E2Education Organization Reference	Reference to the Local Education Agency.	Report reference to the Local Education Agency that matches S2E2 Code.	O	Student Information > General > Enrollments > State Reporting	enrollment. s2e2
endOfTerm StatusDescriptor	The nature of the student’s progress at the end of a given school term.	If student has a 3rd Grade Reading Retention record with a Decision Date within the Scope Year, report End of Term Status.	O	Student Information > Program Participation > State Programs > Third Grade Retention	thirdGrade Retention. endStatus
promotion Reason Descriptor	The nature of the student’s promotion or progress at the end of the given school year.	If student has a 3rd Grade Reading Retention record with a Decision Date within the Scope Year, and End of Term Status = Promotion, report Promotion Reason.	O	Student Information > Program Participation > State Programs > Third Grade Retention	thirdGrade Retention. promotion Reason
etag
bldgOtherwiseAttend SchoolReference		Report reference to the School that matches School Override		Student Information > General > Enrollments > State Reporting
personalCurriculums		Reports if Personal Curriculum subject droplist is = NOT NULL		Student Information > General > Personal Curriculum
earlyReadingIntervention		Reports if student has an Early Reading Deficiency record within the identified Scope Year See array for field specific logic.		Student Information > Program Participation > State Programs > Early Reading Deficiency
bldgOtherwiseAttend		Reports Building Otherwise Attend		Student Information > General > Enrollments > State Reporting	Enrollment.facilityCode
tuitionFundedEnrollment	(MI EXT) NULL or 0 = No, 1 = Yes, Indicates if a charge or fee is required to be paid by the student s family in order to attend the public school.	Tuition Funded Enrollment = selected, reports 1 Tuition Funded Enrollment = deselected, reports 0		Student Information > General > Enrollments > State Reporting

Arrays

Click here to expand...

Personal Curriculums

Data Element Label

Business Requirement

Logic

M,C, or O

Data Source GUI Path

Database Field

curriculumDescriptor

Reports mapped Ed-Fi Code for the subject area

Student Information > General > Personal Curriculum

creditModificationAsOfDate

Optional, does not report.

creditModifications

Modifications array

creditModificationDescriptor

Reports mapped Ed-Fi Code from the related subject droplist

Early Reading Intervention

Data Element Label	Business Requirement	Logic	M,C, or O	Data Source GUI Path	Database Field
readingDeficiencyIdentified	A reading deficiency was identified during the current school year.	If = 1: Yes, report true. If = 0: No, report false	M	Student Information > Program Participation > Early Reading Deficiency	ReadingDeficiency.Identified
readingDeficiencyContinuation	A reading deficiency still exists at the end of the school year.	If = 1: Yes, report true. If = 0: No, report false	O	Student Information > Program Participation > Early Reading Deficiency	ReadingDeficiency.readingDeficiencyContinuation
readingDeficiencyActivities	Indicates the type of additional instructional time related activities delivered to the student.	Reports Reading Deficiency Activities in readingDeficiencyActivitiesDesriptor More than one code can be reported	O	Student Information > Program Participation > Early Reading Deficiency	ReadingDeficiency.readingDeficiencyActivities

Type/Descriptor