Student Enrollments

This category carries information about student school enrollments and withdrawal information. The Student Enrollments category includes the following data views and resources:

Student School

This view captures student enrollments in schools in the current year as published in the StudentSchoolAssociation resource in Student Enrollments. The layout includes the School Name, School ID, Student Number, Student Name, Grade Level, Entry Date, Exit Date, and State Student Number.

studentSchoolAssociations

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

Primary PowerSchool Source Data

• [Students]
• [S_MI_STU_GC_X]
• [ReEnrollments]

Selection Criteria

Records are published if the following criteria are met:

• A Student record has been published for the student.
• StudentUniqueId (Michigan Student Number) must be populated in PowerSchool.
• The student must not be excluded from state reporting.
• The school must not be excluded from state reporting.
• The student must have at least one school enrollment with an Entry Date that falls on or within the date range defined by [Terms]FirstDay and [Terms]LastDay of the year for the Term selected in the PowerSchool UI.
• The enrollment ExitDate is greater than the EntryDate.

Resource Output

• A separate StudentSchoolAssociation record is published for each student and school enrollment reflected in the [Students] and [Reenrollments] tables based on the year for the Term selected in the PowerSchool UI.
  • If the student is or was enrolled in a single school, one record is published.
  • If the student was enrolled in a single school, withdrew, and later re-enrolled in the same school, two records are published.
  • If the student was enrolled in multiple schools, a record is published for each enrollment.
• The StudentSchoolAssociation resource is dependent on the prior publishing of the following: Student.
  Note: After a Student record is uploaded, it cannot be modified until a StudentSchoolAssociation record has also been uploaded for the same student.

• • This establishes a relationship between the school, the associated LEA, and the student.
  • The LEA then has permission to modify the previously uploaded Student record.
• LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real time or on-demand ("Run Now" button).

Note: Click Export to export the data collection results to an Excel spreadsheet.

Data Element	Description	Data Type	Stored in [Table]Field	Req'd
schoolId	School enrolling the student.	Integer	Derived from: [Schools]School_Number [ReEnrollments]SchoolID (historical)	R
classOfSchoolYear	A reference to the related SchoolYearType resource.	Integer	Derived from [Students]ClassOf	O
schoolYear	The school year associated with the student's enrollment.	String	[Terms]YearID	O
studentUniqueId	Student enrolled in the school.	String	[Students]State_StudentNumber	R
entryDate	The month, day, and year on which an individual enters and begins to receive instructional services in a campus.	Date	[Students]EntryDate (current) [ReEnrollments]EntryDate (historical)	R
entryGradeLevelDescriptor	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.	Descriptor	[Students]Grade_Level (current) [ReEnrollments]Grade_Level (historical) If value is less than 0: '30' (Preschool) Other grade levels: the student's grade level in PowerSchool	R
entryTypeDescriptor	The process by which a student enters a school during a given academic session.	Descriptor	[Students]EntryCode	O
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. This element is required if applicable; otherwise, it is excluded from publishing.	Date	[Students]ExitDate (current) [ReEnrollments]ExitDate (historical)	O*
exitWithdrawTypeDescriptor	Describes the circumstances which a student exited from membership in an educational institution. This element is required if applicable; otherwise, it is excluded from publishing.	Descriptor	[Students]ExitCode (current) [ReEnrollments]ExitCode (historical)	O*
districtResidencyStatusDescriptor	An indication of the location of a person's legal residence relative to (within or outside of) the boundaries of the public school attended and its administrative unit.	Descriptor	[S_MI_STU_GC_X]ResidencyMembership	O
readingDeficiencyIdentified	Whether a reading deficiency is identified at any time during the current school year.	String	[S_MI_STU_GC_X]readDefIndentified
readingDeficiencyContinuation	Whether reading deficiency exists at the end of the current school year.	String	[S_MI_STU_GC_X]readDefContinue
readingDeficiencyActivities	Additional instructional time grant-related activities delivered to the student.	String	[S_MI_STU_GC_X]readDefActivities
enrollmentPercent	The full-time equivalency (FTE) that the student spends in the school Applies to Attendance FTE.	Number	[Students]MembershipShare [ReEnrollments]MembershipShare	O

Back to top

Student DOR

This view captures a detailed list of students' District of Residence (DOR). The layout includes the School Name, School ID, Student Number, Student Name, Grade Level, DOR, Entry Date, Entry Code, Exit Date, Exit Code, DOR Exit Date, and State Student Number.

studentEducationOrganizationAssociations

This association indicates any relationship between a student and an education organization other than how the state views enrollment. The enrollment relationship semantics are covered by StudentSchoolAssociation.

Primary PowerSchool Source Data

• [Students]
• [ReEnrollments]

Selection Criteria

Records are published if the following criteria are met:

• A Student record has been published for the student.
• StudentUniqueId (Michigan Student Number) must be populated in PowerSchool.
• The student must not be excluded from state reporting.
• The school must not be excluded from state reporting.
• The student must have a District of Residence specified. The school must not be excluded from state reporting.
• The student must have at least one school enrollment with an Entry Date that falls on or within the date range defined by [Terms]FirstDay and [Terms]LastDay of the year for the Term selected in the PowerSchool UI.
• The enrollment ExitDate is greater than the EntryDate.

Resource Output

• The StudentEducationOrganizationAssociation resource is dependent on the prior publishing of the following: Student and StudentSchoolAssociation.
• LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real time or on-demand ("Run Now" button).

Note: Click Export to export the data collection results to an Excel spreadsheet.