Student Enrollments
This category carries information about student school enrollments, withdrawal, and District Of Residence (DOR) information and includes the following data views and resources:
This view captures student enrollments in schools in the current year as published in the studentSchoolAssociation resource in the Student Enrollments category. The layout includes the School Name, Student Number, Student Name, State Identifier, School ID, Grade Level, Entry Date, Entry Code, Exit Date, Last Publish Date, Publishing ID, and Resource ID.
studentSchoolAssociation
This association represents the school in which a student is enrolled.
Primary PowerSchool Source Data
- Students
- ReEnrollments
- S_REN_EdFI_X
Selection Criteria
Records are published if the following criteria are met:
- The student must not be excluded from state reporting.
- The school must not be excluded from state reporting.
- The studentUniqueID must be populated in PowerSchool (Students.State_StudentNumber).
- The student must have at least one school enrollment with an Entry Date that falls on or after July 1, and on or before last day defined for the school year (Terms.LastDay) 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: students and schools.
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 |
|---|---|---|---|---|
graduationPlanReference A reference to the related graduationPlan resource. | R | |||
/typeDescriptor | The graduation plan associated with the student enrolled in the school. | String | if GradPlan.PlanType is empty then blank if GradPlan.PlanType = 1: Published Value = 'Standard' Otherwise: Published Value = 'Career and Technical Education' | R |
/educationOrganizationId | The school associated with the graduation plan. | Integer | Derived from: Schools.School_Number | R |
/graduationSchoolYear | The graduation school year associated with the graduation plan. | Integer | Students.ClassOf | R |
schoolReference A reference to the related schools resource. | R | |||
/schoolID | School enrolling the student. | Integer | Derived from: Students.SchoolID ReEnrollments.SchoolID (historical) | R |
| classOfSchoolYearTypeReference | O | |||
/schoolYear | The projected High School graduation year. This element is required if applicable; otherwise it is excluded from publishing. | Integer | Students.ClassOf | R |
schoolYearTypeReference A reference to the related schoolYearType resource. | R | |||
/schoolYear | The school year associated with the student's enrollment. | Integer | Derived from: YearId for term selected in the PowerSchool UI | R |
studentReference A reference to the related students resource. | R | |||
/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 | Populates the most recent date from: Students.EntryDate ReEnrollments.EntryDate or the first day of the school year | 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. | String | Students.Grade_Level ReEnrollments.Grade_Level (historical) | R |
| entryTypeDescriptor | The process by which a student enters a school during a given academic session. | String | Students.EntryCode ReEnrollments.EntryCode (historical) | 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. | Date | The last in-session date prior to Students.ExitDate ReEnrollments.ExitDate (historical) | O |
| exitWithdrawTypeDescriptor | Describes the circumstances which a student exited from membership in an educational institution. | String | Derived from: Students.ExitCode ReEnrollments.ExitCode (historical) | O |
| repeatGradeIndicator | An indicator of whether the student is enrolling to repeat a grade level, either by failure or an agreement to hold the student back.. | Boolean | S_REN_EdFI_X.RepeatGradeIndicator | O |
| residencyStatusDescriptor | 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. | String | S_REN_EdFI_X.ResidencyStatus | O |
| schoolChoiceTransfer | 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. | Boolean | if S_REN_EdFI_X.SchoolChoiceTransfer = 1: Published Value = '1' Otherwise: Published Value = '0' | O |
This view captures a detailed list of student District of Residence (DOR) records as published in the studentEducationOrganizationAssociations resource in the Student Enrollments category. The layout includes the School Name, Student Number, Student Name, State Identifier, School ID, Grade Level, DOR, DOR Entry Date, Last Publish Date, Publishing ID, and Resource ID.
studentEducationOrganizationAssociations
This association indicates any relationship between a student and an education organization other than how the state views enrollment. Enrollment relationship semantics are covered by StudentSchoolAssociation.
Primary PowerSchool Source Data
- Students
- ReEnrollments
Selection Criteria
Records are published if the following criteria are met:
- The student must not be excluded from state reporting.
- The school must not be excluded from state reporting.
- The studentUniqueID must be populated in PowerSchool (Students.State_StudentNumber).
- The student must have a District of Residence specified.
- The student must have at least one school enrollment with an Entry Date that falls on or after July 1, and on or before last day defined for the school year (Terms.LastDay) 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.
Data Element | Description | Data Type | Stored in Table.Field | Req’d |
|---|---|---|---|---|
educationOrganizationReference A reference to the related educationOrganization resource. | R | |||
/educationOrganizationId | The school associated with the Education Organization. | Integer | Derived from: Schools.School_Number | R |
studentReference A reference to the related students resource. | R | |||
/studentUniqueID | Student enrolled in the school. | String | Students.State_StudentNumber | R |
| responsibilityDescriptor | Indications of an education organization's responsibility for a student, such as accountability, attendance, funding, etc. | String | Published Value = 'Funding' | R |