Student Sections

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.

Resource Input

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	Data View Column	Submission	PowerSchool Field	[Table] Field Name	Business Rules
BeginDate	Begin Date	Required	N/A	[CC]DateEnrolled	Not applicable.
LocalCourseCode	Local Course ID / Course Number	Required	Local Course code Start Page > School Setup > Courses	[S_KS_CRS_X]LocalCourseId [Courses]Course_Number	Not applicable.
SchoolId	School Number	Required	Start Page > School Setup	Derived From [Sections]SchoolId	Format: ttbbbdddd 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	Year	Required	Start Page > School Setup	Calculated using [TERMS]YearID	If 2023-2024, then extract 2024
SectionIdentifier	Section Number	Required	Start Page > School Setup > Calendar setup	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	Session Name	Required	Start Page > School Setup > Calendar setup	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	State Student Number	Required	Start Page > School Setup > Calendar setup	[Students]State_StudentNumber	Not applicable.
studentSectionAssociationExtensions.ks_studentSectionAssociationExtension.CourseStatusDescriptor	Course Status	Optional		[S_KS_CC_X]Completion_Status	Not applicable.