Student Sections | PowerSchool SIS Compliance

This association indicates the course sections to which a student is assigned.

Selection Criteria   

The student is published in the Student category.
The section is published in the Organization Schedules category.
The student school is published in Enrollment Category.
The StudentUniqueId must be populated in PowerSchool.
The student must not be excluded from state reporting.
Excludes Pre-registered students
The school must not be excluded from state reporting.
The course must not be excluded from state reporting.
The course must have a valid state course code.
The section must not be excluded from state reporting.

Data Review

Field	Selection
Choose Dashboard	Student Sections
Choose Category	Sections info Summary  Sections info Published  Sections info Dependencies  Sections info Errors
Choose Data view	Statistical Summary Student Sections

Resource Output

LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Optional" button).
Publishes a record for each student and section (class).

Note:

Click Export to export the data collection results to an Excel spreadsheet.
See the Data Publishing > Published Resource > Resource Details to view the data elements that are not available in the Data View Column.

Ed-Fi Data Element	Description	Data View Column	Submission	[Table] Field Name	Business Rules
BeginDate	The date when a particular event or period starts, such as the start date of a course or school year.	Begin Date	Required	[CC]DateEnrolled	Not applicable.
EndDate	The date when a particular event or period ends, such as the end date of a course or school year.	End Date	Required	[CC]DateEnrolled	Not applicable.
LocalCourseCode	A unique identifier assigned by the local education agency to a course.	Local Course ID / Course Number	Required	[S_KS_CRS_X]LocalCourseId [Courses]Course_Number	Not applicable.
SchoolId	A unique identifier assigned to a school within the education system.	School Number	Required	[Schools]SIF_StatePRID Derived From [Sections]SchoolId	Format: ttbbbdddd If [Schools]SIF_StatePRID is blank, [Sections]School_Id is pulled. The [Schools]SIF_StatePRID or [Sections]School_Id must match with the Organization Catalog. Org Id is defaulted to D=14, if the district wants aOptionalther value to be published then the district must prepend the above alphabet in their district number.  The course is published based on sections created at the school and it uses the Section School Id
SchoolYear	The academic year for which the data is applicable, typically represented as a range (e.g., 2024-2025).	Year	Required	Calculated using [TERMS]YearID	If 2023-2024, then extract 2024
SectionIdentifier	A unique identifier for a specific section of a course.	Section Number	Required	Concatenated	SchoolID+[Courses]Course_Number + [Sections]Section_Number +TermdcidID Submit only valid Course Section values. Do not submit Course Section values for Certificate or MigrantServices
SessionName	The name of the session during which the course or event takes place (e.g., Fall 2024).	Session Name	Required	Concatenated [TERMS]YearID [Terms]Name	SessionName format: If 2023-2024, then extract 2024 Session name is a string that represents any of these time periods: ● Yearlong: 2024 School Year representing 2023-24 School Year ● Semester/Trimester: 2024 First Semester representing 2023-24 First Semester ● Quarter: 2024 Quarter 4 representing 2023-24 Fourth Quarter
StudentUniqueId	A unique identifier assigned to each student within the education system.	State Student Number	Required	[Students]State_StudentNumber	Not applicable.
studentSectionAssociationExtensions.ks_studentSectionAssociationExtension.CourseStatusDescriptor	A unique identifier assigned to each student within the education system.	Course Status	Optional	[S_KS_CC_X]Completion_Status	Not applicable.