Student Sections

studentSectionAssociation

This view captures the section assignments for each student as published in the StudentSectionAssociation resource within the Student Enrollment category.

The layout includes the Course Code, Section Number, School Id, School Year, Student Id, begin date, and end date.

studentSectionAssociation

This association indicates the class sections to which a teacher is assigned. This resource is required for all teachers.

Primary PowerSchool Source Data

[CC]
[Sections]
[S_NM_SEC_X]

Selection Criteria

Records are published if the following criteria are met:

The student was published in the Student Parent category.
The section was published in the Master Schedule category.
StudentUniqueId must be populated in PowerSchool.
The school must not be excluded from state reporting.
The section must not be excluded from state reporting.
The course must have a valid state course code.
The enrollment ExitDate is greater than the EntryDate.

Note: The logic for the resource has been updated and student course enrollment records will no longer be published if the course or section is set to be excluded from state reporting.

Resource Output

A separate studentSectionAssociation record is published for each course section in each school in which a student is or was enrolled based on the year for the Term selected in the PowerSchool UI.
The studentSectionAssociation resource is dependent on the prior publishing of the following resources: student and section.
LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).

Note: staffSectionAssociation is not published for dual enrollment courses.

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.

Data Element	Description	Data Type	Stored in [Table]Field	Req'd
/beginDate	The date on which the student enrolled into the section.	Datetime	[CC]DateEnrolled	R
sectionReference A reference to the section of the enrollment.
/localCourseCode	The local code assigned by the LEA or Campus that identifies the organization of subject matter and related learning experiences provided for the instruction of students. This must match LocalCourseCode in the corresponding CourseOffering. Note: The localCourseCode logic (in the courseOfferings resource) has been updated and the localCourseNumber will now publish correctly for districts that are tracking the StateCourseCode in the Course Number field.	String	If the district [Prefs]State_Course_Code is set to Course Number: The first 4 digits in the [Courses]Alt_Course_Number field are published. Else, the first 4 digits in the [Courses]Course_Number field are published. If the district [Prefs]State_Course_Code is set to Alternate Course Number: The first 4 digits in the [Courses]Course_Number field are published. Else, the first 4 digits in the [Courses]Alt_Course_Number field are published. If the district [Prefs]State_Course_Code is blank, the first 4 digits in the [Courses]Course_Number field are published.	R
/schoolId	The school associated with this section. 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
/schoolYear	The identifier for the school year. For example, for 2021-2022, the school year will be 2022. This must match the SchoolYear in the corresponding CourseOffering resource.	Number	[Terms]YearID	R
/sectionIdentifier	This value is a combination of the course number, "-", and section number.	String	[Sections]Course_Number [Sections]Section_Number	R
/sessionName	The name of the session, comprised of the elements below: Format: [Schools]School_Number - [TERMS]abbreviation - [TERMS]dcid	String	[Schools]School_Number [TERMS]abbreviation [TERMS]dcid	R
studentReference A reference to the student
/studentUniqueId	The Id assigned to the student by the state.	String	[Students]State_StudentNumber	R
/endDate	Month, day, and year of the withdrawal or exit of the student from the section. This element is required if applicable; otherwise it is excluded from publishing.	Datetime	[CC]DateLeft	C