Michigan Ed-Fi Data v3.1 - Student School Association [.2144 - .2227]

Classic View: System Administration > Ed-Fi

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

ActionTrigger
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:
    1. P: Primary Enrollment
    2. S: Partial/Ancillary
    3. 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 the No Show check box is checked.
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.

DeleteWhen the No Show check box is checked.

Resource Toggle and Resync Logic

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

Action

Business Rule

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

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 DescriptorsEnrollment Start Status
Exit Withdraw Type DescriptorsEnrollment End Status
District Residency Status DescriptorsEnrollment Student Residency

Identity Mapping Object Key

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

campusObjectType

Object Key Data Source

EnrollmentenrollmentID

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.

personPost/DeleteStudent ID in Student Reference
graduationPutClass of School Year Type Reference
programsPutGraduation Plan Reference
programparticipationPutGraduation Plan Reference

Object Data Elements

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

Data Element
Label
Business RequirementBusiness RulesM, 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.

MStudent Information> General> Enrollments> Start Dateenrollment.
startdate
calendar
Reference
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

classOfSchool
YearType
Reference  
 The year the student is expected to graduate. Report the year selected in Student Info > General > Graduation > NCLB Cohort End Year.
  1. If NCLB Cohort End Year = Null, do not report.
CStudent 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. 
  1. Report the Ed-Fi Code from the Grade Level mapping for the grade selected on the student's enrollment.
  2. If a mapping is not available, the record will error.
MStudent 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. 
  1. Report the Ed-Fi Code Value mapped to the Start Status selected.
  2. If blank, do not report.
OStudent Information> General> Enrollments> Start Statusenrollment.
startstatus
exitWithdraw
Date 
 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. 

Report the enrollment end date.

OStudent Information> General> Enrollments> End Dateenrollment.
enddate
exitWithdraw
TypeDescriptor 
 A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. 
  1. Report the Ed-Fi Code Value from the End Status selected.
  2. If blank, do not report.
OStudent Information> General> Enrollments> End Statusenrollment.
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.

OStudent Information> General> Enrollments> Service Typeenrollment.
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.

OStudent Information> General> Enrollments> End Actionenrollment.
endAction
 esidencyStatus
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.

servingdistrict

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.

OStudent Information> General> Enrollments> School Choiceenrollment. schoolChoice
Program
districtEntry
Date
The date the student was first enrolled in the District.
  1. Report District Start Date.
  2. 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

OStudent Information > General > Enrollments > State Reportingenrollment.
districtDate
districtResidency
StatusDescriptor
To indicate 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.Report Ed-Fi Code from Student Residency.OStudent Information > General > Enrollments > State Reporting > Student Residency
districtResidency
StatusAsOfDate
To indicate the date of the last change to district residency status.Reports Enrollment Start Date.
  1. Only reports if districtResidencyStatusDesctiptor is reported.

OStudent Information > General > Enrollmentsenrollment.
startDate
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.


OStudent Information > General > Enrollments > State Reporting > FTE in General Education
exitWithdraw
DateAsOfDate
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.OStudent Information > General > Enrollments > State Reportingenrollment.
s2e2
endOfTerm
Status
Descriptor
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




Type/Descriptor

Entry Grade Level Descriptors

Code ValueDescriptionName SpaceShort Description
Adult EducationAdult Educationuri://ed-fi.org/GradeLevelDescriptorAdult Education
Early EducationEarly Educationuri://ed-fi.org/GradeLevelDescriptorEarly Education
Eighth gradeEighth gradeuri://ed-fi.org/GradeLevelDescriptorEighth grade
Eleventh gradeEleventh gradeuri://ed-fi.org/GradeLevelDescriptorEleventh grade
Fifth gradeFifth gradeuri://ed-fi.org/GradeLevelDescriptorFifth grade
First gradeFirst gradeuri://ed-fi.org/GradeLevelDescriptorFirst grade
Fourth gradeFourth gradeuri://ed-fi.org/GradeLevelDescriptorFourth grade
Grade 13Grade 13uri://ed-fi.org/GradeLevelDescriptorGrade 13
Infant/toddlerInfant/toddleruri://ed-fi.org/GradeLevelDescriptorInfant/toddler
KindergartenKindergartenuri://ed-fi.org/GradeLevelDescriptorKindergarten
Ninth gradeNinth gradeuri://ed-fi.org/GradeLevelDescriptorNinth grade
No grade levelNo grade leveluri://ed-fi.org/GradeLevelDescriptorNo grade level
OtherOtheruri://ed-fi.org/GradeLevelDescriptorOther
PostsecondaryPostsecondaryuri://ed-fi.org/GradeLevelDescriptorPostsecondary
Preschool/PrekindergartenPreschool/Prekindergartenuri://ed-fi.org/GradeLevelDescriptorPreschool/Prekindergarten
Second gradeSecond gradeuri://ed-fi.org/GradeLevelDescriptorSecond grade
Seventh gradeSeventh gradeuri://ed-fi.org/GradeLevelDescriptorSeventh grade
Sixth gradeSixth gradeuri://ed-fi.org/GradeLevelDescriptorSixth grade
Tenth gradeTenth gradeuri://ed-fi.org/GradeLevelDescriptorTenth grade
Third gradeThird gradeuri://ed-fi.org/GradeLevelDescriptorThird grade
Twelfth gradeTwelfth gradeuri://ed-fi.org/GradeLevelDescriptorTwelfth grade
UngradedUngradeduri://ed-fi.org/GradeLevelDescriptorUngraded

Entry Type Descriptors

Code ValueDescriptionNamespaceShort Description
TransferTransferuri://ed-fi.org/EntryTypeDescriptorTransfer
New to education systemNew to education systemuri://ed-fi.org/EntryTypeDescriptorNew to education system
Next year schoolNext year schooluri://ed-fi.org/EntryTypeDescriptorNext year school
OtherOtheruri://ed-fi.org/EntryTypeDescriptorOther
Re-entryRe-entryuri://ed-fi.org/EntryTypeDescriptorRe-entry

Exit Withdraw Type Descriptors

Code ValueDescriptionNamespaceShort Description
CompletedCompleteduri://ed-fi.org/ExitWithdrawTypeDescriptorCompleted
Died or is permanently incapacitatedDied or is permanently incapacitateduri://ed-fi.org/ExitWithdrawTypeDescriptorDied or is permanently incapacitated
DropoutDropouturi://ed-fi.org/ExitWithdrawTypeDescriptorDropout
End of school yearEnd of school yearuri://ed-fi.org/ExitWithdrawTypeDescriptorEnd of school year
Enrolled in a high school diploma programEnrolled in a high school diploma programuri://ed-fi.org/ExitWithdrawTypeDescriptorEnrolled in a high school diploma program
ExpelledExpelleduri://ed-fi.org/ExitWithdrawTypeDescriptorExpelled
GraduatedGraduateduri://ed-fi.org/ExitWithdrawTypeDescriptorGraduated
IncarceratedIncarcerateduri://ed-fi.org/ExitWithdrawTypeDescriptorIncarcerated
Invalid enrollmentInvalid enrollmenturi://ed-fi.org/ExitWithdrawTypeDescriptorInvalid enrollment
Involuntarily RemovedInvoluntarily Removeduri://ed-fi.org/ExitWithdrawTypeDescriptorInvoluntarily Removed
No showNo showuri://ed-fi.org/ExitWithdrawTypeDescriptorNo show
OtherOtheruri://ed-fi.org/ExitWithdrawTypeDescriptorOther
Reached maximum ageReached maximum ageuri://ed-fi.org/ExitWithdrawTypeDescriptorReached maximum age
TransferredTransferreduri://ed-fi.org/ExitWithdrawTypeDescriptorTransferred
WithdrawnWithdrawnuri://ed-fi.org/ExitWithdrawTypeDescriptorWithdrawn

Residency Status Descriptors

Code ValueDescriptionNamespaceShort Description
Resident of admin unit and school areaResident of administrative unit and usual school attendance area.uri://ed-fi.org/ResidencyStatusDescriptorResident of administrative unit and usual school attendance area.
Resident of admin unit that crosses statesResident of an administrative unit that crosses state boundaries.uri://ed-fi.org/ResidencyStatusDescriptorResident of an administrative unit that crosses state boundaries.
Resident of admin unit, but other school areaResident of administrative unit, but of other school attendance area.uri://ed-fi.org/ResidencyStatusDescriptorResident of administrative unit, but of other school attendance area.
Resident of another stateResident of another state.uri://ed-fi.org/ResidencyStatusDescriptorResident of another state.
Resident of this state, but not of this admin unitResident of this state, but not of this administrative unit.uri://ed-fi.org/ResidencyStatusDescriptorResident of this state, but not of this administrative unit.