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]
[ReEnrollments]
[S_NM_STU_X]
[S_NM_REN_X]
Selection Criteria
Records are published if the following criteria are met:
A Student record has been published for the student.
StudentUniqueId 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.
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 ODS in real time or on-demand ("Run Now" button).
Data Element | Description | Data Type | Stored in [Table]Field | Req'd |
|---|---|---|---|---|
/entryDate | The month, day, and year on which an individual enters and begins to receive instructional services in a campus. | Date | [Students]EntryDate | |
schoolReference A reference to the school | ||||
/schoolId | The school associated with this student. This is an eight-digit number comprising of: 35+[LEA Number - 3 digit]+[School Number - 3 digit] | String | LEA Number - [Prefs]Value [Prefs]Name where = districtnumber School Number - [Schools]Alternate_School_Number if the value greater is than zero else the [Schools]School_Number | R |
schoolYearTypeReference | ||||
/schoolYear | The school year associated with the student's enrollment. | Number | [Terms]YearID | R |
studentReference | ||||
/studentUniqueId | Student enrolled in the school. | String | [Students]State_StudentNumber | |
/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. Grade Level Descriptor Set The updated logic ensures that this element publishes as expected. | String | [Students]Grade_Level [ReEnrollment]Grade_Level | R |
/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 | [Students]ExitDate [ReEnrollments]ExitDate | C |
/exitWithdrawTypeDescriptor | Describes the circumstances which a student exited from membership in an educational institution.
Exit Withdraw Code Descriptor Set The updated logic ensures that this element publishes as expected. | String | [Students]ExitCode [ReEnrollments]ExitCode | C |
repeatGradeIndicator | An indicator of whether the student is enrolling to repeat a grade level, either by failure or by an agreement to hold the student back. This element is required if applicable; otherwise it is excluded from publishing. The logic is updated to match the logic in the Student and Student Snapshot templates. | Boolean | [S_NM_STU_X]Retained_YN [S_NM_REN_X]Retained_YN | C |
/entryTypeDescriptor | Describes the circumstances which a student exited from membership in an educational institution. Entry Code Descriptor Set | [Students]EntryDate [ReEnrollments]EntryDate | R | |
Student Demographics
This view captures a detailed list of students' demographic data. The layout includes the School Name, School ID, Student Number, Student Name, race & ethnicity, language, digital equity data, 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]
[S_NM_STU_X]
[ReEnrollments]
[S_NM_REN_X]
Selection Criteria
Records are published if the following criteria are met:
A Student record has been published for the student.
StudentUniqueId 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.
Resource Output
LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).
Data Element | Description | Data Type | Stored in [Table]Field | Req'd |
|---|---|---|---|---|
educationOrganizationReference A reference to the LEA of the student | ||||
/educationOrganizationId | The district associated with this program. This is an eight-digit number comprising of: 35+[LEA Number - 3 digit]+000 | String | LEA Number - [Prefs]Value [Prefs]Name where = districtnumber | R |
studentReference | ||||
/studentUniqueId | A unique alpha-numeric code assigned to a student. | Integer | [Students]State_StudentNumber | R |
addresses | ||||
/addressTypeDescriptor | The type of address being published. Address Type Descriptor Set. | String | Published as "Home" | R |
/streetNumberName | The street name and number. | String | [Students]Street | R |
/apartmentRoomSuiteNumber | The apartment or suite number. | String | [Students]Street | R |
/city | The city of home or mailing address. | String | [Students]City | R |
/stateAbbreviationDescriptor | The abbreviation of the state. State Abbreviation Type Descriptor Set | String | [Students]State | R |
/postalCode | The postal code of the home or mailing address. | [Students]ZIP | R | |
/hispanicLatinoEthnicity | Indicates the student is of Hispanic or Latino ethnicity. | Boolean | [Students]FedEthnicity | R |
languages A reference to the student's languages | ||||
/languageDescriptor | The student's native or home language. Language Descriptor Set | String | [S_NM_STU_X]langspokeninhome | R |
/languaeUseDescriptor | The type of use of the published language. Language Use Type Descriptor Set | String | Published as "Home language" | R |
/limitedEnglishProficiencyDescriptor | The student's ELL status. Limited English Proficiency Descriptor Set | String | [S_NM_STU_X]FEPClass | R |
races A reference to the student's race or races. | ||||
/raceDescriptor | The race(s) of the student. Race Type Descriptor Set | String | [StudentRace]RaceCD | R |
/sexDescriptor | The student's sex at birth. Sex Type Descriptor Set | String | [StudentCoreFields]PSCore_Legal_Gender [Students]Gender | R |
studentCharacteristics Characteristics of the student. | ||||
504 | Indicates the student is in the 504 program. | String | [S_NM_STU_X]PLAN504_YN | C |
/gifted | Indicates the student is in the Gifted & Talented program | String | [S_NM_STU_X]GiftedPartCode80_YN | C |
/giftedLevelOfIntegrationDescriptor | The student's gifted level of integration. Level Of Integration Descriptor Set | String | If [S_NM_STU_X]GiftedPartCode80_YN = Y, then: [S_NM_STU_X]SpEdPercentage | C |
/pregnant | Indicates the student is pregnant | String | [S_NM_STU_X]Expectingstudent | C |
/foreignExchange | Indicates the student is a foreign exchange student. | String | [S_NM_STU_X]Foreignexchange73_YN | C |
/form506 | Indicates the student is a Form 506 student. | String | [S_NM_STU_X]FederalForm506_YN | C |
/displacedHomemaker | Indicates the student is a displaced homemaker. | String | [S_NM_STU_X]Displaced_YN | C |
/homeSchooled | Indicates the student is home schooled. | String | [S_NM_STU_X]Location Code = 999 or [S_NM_STU_X]HomeSchooledClasses | C |
/singleParent | Indicates the student is a single parent. | [S_NM_STU_X]SingleParent_YN | C | |
/studentIdentificationSystemDescriptor | Published as "State" | R | ||
/assigningOrganizationIdentificationCode | Published as "1" | R | ||
/identificationCode | The student's local student number. | [Students]Student_Number | R | |
/grade09Entry | The student's grade 09 entry date. | Date | [S_NM_STU_X]Grade9EntryDate | C |
/militaryFamilyDescriptor | Indicator to identify the military status of the student's family. Military Family Descriptor Set | String | [S_NM_STU_X]MilitaryFamily | |
/dentalExaminationVerificationCodeDescriptor | This code for the dental examination performed. Dental Examination Verification Code Descriptor Set | String | [S_NM_STU_X]DentalExamWaiver | |
disabilities Disabilities of the student. | ||||
/disabilityDescriptor | The student's primary disability | String | [S_NM_STU_X]Disability | |
/orderOfDisability | Numeric value assigned to the disability | Integer | Always published as "1" | |
/disabilityDescriptor | The student's secondary disability (if applicable). | String | [S_NM_STU_X]OtherDisabilities1 | |
/orderOfDisability | Numeric value assigned to the disability | Integer | Always published as "2" | |
/disabilityDescriptor | The student's tertiary disability (if applicable). | String | [S_NM_STU_X]OtherDisabilities2 | |
/orderOfDisability | Numeric value assigned to the disability | Integer | Always published as "3" | |
/disabilityDescriptor | The student's quaternary disability (if applicable). | String | [S_NM_STU_X]OtherDisabilities3 | |
/orderOfDisability | Numeric value assigned to the disability | Integer | Always published as "4" | |
/internetAccessInResidence | An indication of whether the student is able to access the internet in their primary place of residence. | Boolean | [S__STU_X]InternetInResidence | |
/internetAccessTypeInResidenceDescriptor | The primary type of internet service used in the student s primary place of residence. Internet Access Type In Residence Descriptor Set | String | [S__STU_X]InternetAccess | |
/internetPerformanceInResidenceDescriptor | An indication of whether the student can complete the full range of learning activities, including video streaming and assignment upload, without interruptions caused by poor internet performance in their primary place of residence. Internet Performance In Residence Descriptor Set | String | [S__STU_X]InternetPerformance | |
/primaryLearningDeviceAccessDescriptor | An indication of whether the primary learning device is shared or not shared with another individual. Primary Learning Device Access Descriptor Set | String | [S__STU_X]DeviceAccess = 01 or 03 then NOT SHARED [S__STU_X]DeviceAccess = 02 or 04 then SHARED | |
/primaryLearningDeviceAwayFromSchoolDescriptor | The type of device the student uses most often to complete learning activities away from school. Primary Learning Device Away From School Descriptor Set | String | [S__STU_X]DeviceType | |
/primaryLearningDeviceProviderDescriptor | The provider of the primary learning device. Primary Learning Device Provider Descriptor Set | String | [S__STU_X]DeviceAccess = 01 or 02 then Personal [S__STU_X]DeviceAccess = 03 or 04 then School | |
tribalAffiliation The primary tribe the student is a part of. | ||||
/tribalAffiliationDescriptor | An American Indian tribe with which the student is affiliated as last reported to the education organization. Tribal Affiliation Descriptor Set | String | [S_NM_STU_X]Tribe | |