Student Enrollment
This category carries information about student school enrollments and withdrawal information and includes the following data views and resources:
Student School
This data view represents a detailed list of Student Schools successfully published to the ODS. The published view layout provides the School Name, Student Number, Student Name, WISER ID, School ID, Grade Level, Entry Date, Entry Code, Exit Code, Last Publish Date, Publishing ID, and Resource ID.
studentSchoolAssociations
This association represents the school in which a student is enrolled.
Primary PowerSchool Source Data
- [Students]
- [ReEnrollments]
- [S_WY_STU_X]
- [S_WY_STU_ConcurrentEnroll_C]
Selection Criteria
Records are published if the following criteria are met:
- The student must not be excluded from state reporting.
- The student’s school of enrollment must not be excluded from state reporting.
- The studentUniqueID must be populated in PowerSchool.
- 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.
- Concurrent Enrollments: the student has a current year enrollment where the following conditions are met:
- Exit Date is greater than Entry Date.
- The school must be a different school than the primary school for the date range.
- The concurrent enrollment may overlap multiple primary school enrollments (and vice versa).
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.
- A separate studentSchoolAssociation record is published for each concurrent enrollment record meeting the required criteria.
- The studentSchoolAssociation resource is dependent on the prior publishing of the following: students.
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 | [Table]Data Type | Stored in [Table]Field | Req’d |
---|---|---|---|---|
graduationPlanReference A reference to the related graduationPlan resource. | O | |||
/typeDescriptor | The graduation plan associated with the student enrolled in the school. | Descriptor | If [S_WY_STU_X]VocConcen = Y: 'CTE' If [GradPlan]PlanType =
| R |
/educationOrganizationId | The school associated with the graduation plan. | Integer | SchoolID downloaded from the state Derived from: [Schools]School_Number | R |
/graduationSchoolYear | The graduation school year associated with the graduation plan. | Integer | [Students]Graduation_Year, if populated Otherwise: [Students]ClassOf | R |
schoolReference A reference to the related school resource | ||||
/schoolId | The school enrolling the student. | Integer | SchoolID downloaded from the state Derived from: [Students]SchoolID [ReEnrollments]SchoolID [S_WY_STU_ConcurrentEnroll_C]ConSchoolID | R |
classOfSchoolYearTypeReference A reference to the related schoolYearType resource. | O | |||
/schoolYear | The projected High School graduation year. | Integer | [Students]Graduation_Year, if populated Otherwise: [Students]ClassOf | R |
schoolYearTypeReference A reference to the related schoolYearType resource. | O | |||
/schoolYear | The school year associated with the student's enrollment. | Integer | [Terms]YearID | R |
studentReference A reference to the related student resource | R | |||
/studentUniqueId | The 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 school. | Date | Populates the most recent date from: [Students]EntryDate [ReEnrollments]EntryDate (historical) [S_WY_STU_ConcurrentEnroll_C]SchoolEntryDate (concurrent enrollments) 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. | Descriptor | [Students]Grade_Level [ReEnrollments]Grade_Level (historical) Concurrent Enrollments: If [S_WY_STU_ConcurrentEnroll_C]SchoolEntryDate is between [Students]EntryDate and [Students]ExitDate: [Students]Grade_Level Otherwise: If [ReEnrollments]StudentID is not blank, and [S_WY_STU_ConcurrentEnroll_C] SchoolEntryDate is between [ReEnrollments]EntryDate and [ReEnrollments]ExitDate: the most recent [ReEnrollments]Grade_Level is published | R |
entryTypeDescriptor | The process by which a student enters a school during a given academic session. Note: Local entry codes must be mapped for values to publish. For more information on mapping codes, refer to the Code Set Mappings section in the PowerSchool Data Exchange documentation. | String | [Students]EntryCode [ReEnrollments]EntryCode (historical) [S_WY_STU_ConcurrentEnroll_C] SchoolEntryCode (concurrent enrollments) | O |
exitWithdrawDate | The month, day, and year of the first day after the date of an individual's last attendance at a school (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) [S_WY_STU_ConcurrentEnroll_C]SchoolExitDate (concurrent enrollments) | O |
exitWithdrawTypeDescriptor | Describes the circumstances which a student exited from membership in an educational institution. Note: Local exit codes must be mapped for values to publish. For more information on mapping codes, refer to the Code Set Mappings section in the PowerSchool Data Exchange documentation. | Descriptor | [Students]ExitCode [ReEnrollments]ExitCode (historical) [S_WY_STU_ConcurrentEnroll_C]SchoolExitCode (concurrent enrollments) | O |