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 Schools

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

studentSchoolAssociation

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

Primary PowerSchool Source Data

[Students]
[ReEnrollments]
[S_GA_STU_X]
[S_GA_REN_X]

Selection Criteria

Records are published if the following criteria are met:

The school must not be excluded from state reporting.
The school must have an Ed-Fi State School number.
The student must not be excluded from state reporting.
A student record has been published for the student.
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 exit date is greater than the entry date.

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 resources: student.

Note: After a student record is uploaded, it cannot be modified until a studentSchoolAssociation record has 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).

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

Automatic Publishing

Whenever the related fields in the UI are updated, this resource will automatically generate the necessary DCF events to publish the resource with the updated values.

Data Element	Description	[Table]Data Type	Stored in [Table]Field	Req’d
schoolReference A reference to the related school resource.				R
schoolID	The school enrolling the student.	Integer	[StudentSpecialEducationAssociationEvents]SchoolOrgID	R
schoolYearTypeReference	The school year associated with the student’s enrollment, recorded as the later calendar year of the school year. For example, 2017-2018 school year is recorded as 2018.	String	[Terms]YearID	R
/schoolYear	The identifier for the school year.	Number	[CourseTranscripts]SchoolYear	R
studentReference A reference to the related student resource.				R
/studentUniqueId	The student enrolled in the school.	Integer	[Students]State_StudentNumber	R
entryDate	The month, day, and year on which an individual enters and begins to receive instructional services in a campus. Note: If a student's entry and exit dates fall outside the session period, and no exit date is provided, the entry date is published as the exit date. This logic applies to no show students (students who were enrolled but did not attend).	Date	[StudentTbl]EntryDate	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	[studentAcademicRecords]GradeLevel	R
entryTypeDescriptor		String	[StudentSchoolAssociations]EntryType_DX
giftedServedDescriptor	Valid values: [Blank] – N/A Yes, Received Gifted Services No, Dual Enrollment No, Gifted Services suspended services at the request of the parent/student No, local continuation policy criteria were not met No, Gifted Courses not offered No, the student became eligible in the spring of the school year, but gifted services commence the following school year. No, the gifted documentation for the transferring student has not been received.	String
ccaNonTraditional	Indicates whether a student is part of a non-traditional CCA program. Valid values: N - No (Default) Y - Yes	String	[S_GA_STU_X]CCANonTraditional
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. Note: The exit dates are not sent for actively enrolled students, preventing them from being flagged as withdrawn. In addition, withdrawal codes are always sent when a withdrawal date is present.	Date	[StudentTbl]ExitDate	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.	String	[studentSchoolAssociations]ExitType_DX	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. Note: This element is only published for public schools. *repeatGradeIndicator is required if [S_WI_STU_X]CompletedSchoolTerm = Y.	Boolean	[StudentExtTbl]RepeatGradeIndicator	O*
residencyStatusDescriptor	Indicates the residency status descriptor Note: When publishing Student School Association, the Enrollment Type Descriptor will be publishing value 'M' if the Pupil Count Resident Reduction or Non-Resident Reduction field value is updated as R-OUTSIDEAGE. Also, the Receiving Services element will be populating new values M-3FS & M-2FJ and Residency Status will be publishing the Pupil Count Resident Reduction or Non-Resident Reduction field value. If the Pupil Count Resident Reduction or Non-Resident Reduction field value is blank, then the default value 'R' will be published for Residency Status.	String	[studentSchoolAssociations]ResidencyStatus_DX
dateEntered9thGrade		DateTime	studentSchoolAssociations]DateEntered9thGrade	R
priorTenDays		Boolean	studentSchoolAssociations]PriorTenDays
summerImmigrantProgramParticipation		Boolean	studentSchoolAssociations]SummerImmigrantPart
summerTitleIIIServed		Boolean	studentSchoolAssociations]SummerTitleIII
asvabScore		Number	studentSchoolAssociations]AsvabScore
esolSegments		Number	studentSchoolAssociations]EsolSegments
FTE Segments
segmentNumber		Number	[FteSegments]SegmentNumber
fteProgramCodeDescriptor		String	[FteSegments]ProgramCode_DX
inclusionPersonnelDescriptor		String	[FteSegments]InclusionCode_DX
itinerantTeacherSpecialEducationServices		Boolean	[FteSegments]ItinerantTchFlag
receivedSupplementalSpeechServices		Boolean	[FteSegments]SupplSpeechFlag
transportedForSection		Boolean	[FteSegments]TransportedFlag
enrollmentLocationDescriptor		String	[FteSegments]LocationEnrollment_DX