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.

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

DeleteWhen 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

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 LabelBusiness 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
calendarReferenceA 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.
  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
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. 
  1. If End Status NOT = NULL or 19, report End Date + 1 day.
  2. 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. 
  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
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.

OStudent Information> General> Enrollments> School Choiceenrollment.
school
Choice
Program
districtEntryDateThe 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
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.OStudent 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.

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


OStudent 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.OStudent Information > General > Enrollments > State Reportingenrollment.
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.OStudent Information > Program Participation > State Programs > Third Grade RetentionthirdGrade
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.OStudent Information > Program Participation > State Programs > Third Grade RetentionthirdGrade
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 ReportingEnrollment.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 to attend the public school.

  1. Tuition Funded Enrollment = selected, reports 1
  2. Tuition Funded Enrollment = deselected, reports 0


Student Information > General > Enrollments > State Reporting

Arrays

Click here to expand...

Personal Curriculums

Data Element LabelBusiness Rules
Namespace
M,C, or OData Source GUI Path
curriculumDescriptorReports mapped Ed-Fi Code for the subject area curriculum
  1. If more than one subject area has the same curriculum modification, report single curriculum with associated subject areas included in the modifications array.
uri://midatahub.org/CurriculumDescriptor
MState Programs > Personal Curriculum
creditModificationAsOfDate

Optional, does not report.


O
creditModifications

Modifications array


M
creditModificationDescriptor

Reports mapped Ed-Fi Code from the related subject droplist

uri://midatahub.org/CreditModificationDescriptor
MState Programs > Personal Curriculum

Early Reading Intervention

Data Element LabelBusiness RequirementLogicM,C, or OData Source GUI PathDatabase Field
readingDeficiencyIdentified

A reading deficiency was identified during the current school year.

  1. If = 1: Yes, report true.
  2. If = 0: No, report false

MStudent Information > Program Participation > Early Reading DeficiencyReadingDeficiency.Identified
readingDeficiencyContinuation

A reading deficiency still exists at the end of the school year.

  1. If = 1: Yes, report true.
  2. If = 0: No, report false

OStudent Information > Program Participation > Early Reading DeficiencyReadingDeficiency.readingDeficiencyContinuation
readingDeficiencyActivities

Indicates the type of additional instructional time related activities delivered to the student.

Reports Reading Deficiency Activities in readingDeficiencyActivitiesDesriptor
  1. More than one code can be reported
OStudent Information > Program Participation > Early Reading DeficiencyReadingDeficiency.readingDeficiencyActivities

Type/Descriptor

Click here to expand...

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


Previous Versions

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