Student Teacher Sections

This category captures section teachers and student section enrollments, and includes the following data views and resources:

Staff Sections

This view captures the class sections to which a teacher is assigned as published in the StaffSectionAssociation resource within the Student Teacher Sections category. The layout includes the School Name, Teacher Number (PowerSchool ID), Staff Name, Course Number, Course Name, Term, and Section Number.

staffSectionAssociations

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

Primary PowerSchool Source Data

[Sections]
[SectionTeacher]
[S_MI_SSF_TSDL_X]
[S_MI_SEC_TSDL_X]
[Terms]
[Period]

Selection Criteria

Records are published if the following criteria are met:

The teacher was published in the preceding Staff resource.
The section was published in the Organization Schedules category
StaffUniqueId must be populated in PowerSchool.
The teacher must not be excluded from state reporting.
The teacher's school must not be excluded from state reporting.
The teacher's section must not be excluded from state reporting.
The course must have a valid state course code.

Resource Output

A separate StaffSectionAssociation record is published for each course section in which the Teacher is scheduled based on the year for the Term selected in the PowerSchool UI.
A teacher with classes at multiple schools will have a record for each section at each school.
A section with multiple teachers will have a record for each teacher associated with the section.
The StaffSectionAssociation resource is dependent on the prior publishing of the following resources: StaffSchoolAssociation and Sections.
LEAs and Schools may upload (publish) data to the Ed-Fi 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
SectionReference/SectionIdentity The section the staff member is assigned to.				R
/schoolId	The school for which the section is defined.	Integer	Derived from: [Sections]SchoolID	R
/classPeriodName	An indication of the portion of a typical daily session in which students receive instruction in a specified subject, for example, morning, sixth period, block period, or AB schedules.	String	[Period]Name If empty, then [Period]Period_Number	R
/classroomIdentificationCode	A unique number or alphanumeric code assigned to a room by a school, school system, state, or other agency or entity.	String	[Sections]Room If empty, then 'OPEN'	R
/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; must match LocalCourseCode in corresponding CourseOffering.	String	[Courses]Course_Number Internal spaces in the course number are replaced with an underscore, and leading /trailing spaces are removed.	R
/termDescriptor	The name of the term in which the section is offered, for example, First semester, Second semester, Year long, Summer school; must match Term in corresponding CourseOffering.	Descriptor	Derived from: [Terms]Portion [Terms]Abbreviation	R
/schoolYearType	SchoolYearType - The identifier for the school year, for example, 2010-2011; must match SchoolYear in corresponding CourseOffering.	Type	[Terms]YearID	R
/uniqueSectionCode	A unique identifier for the Section, that is defined by the classroom, the subjects taught, and the instructors that are assigned.	String	[Sections]SchoolID + "-" + [Sections]DCID	R
/sequenceOfCourse	When a Section is part of a sequence of parts for a course, the number if the sequence. If the course has only one part, the value of this Section attribute should be 1.	Integer	Default = '1'	R
staffUniqueId	The staff member recording the section attendance.	String	[S_MI_SSF_TSDL_X]repPIC	R
classroomPositionDescriptor	The type of position the staff member holds in the specific class/section, for example, Teacher of Record, Assistant Teacher, Support Teacher, Substitute Teacher, etc.	Descriptor	Derived from: [SectionTeacher]RoleID [S_MI_SSF_TSDL_X]teacherVirtual [S_MI_SEC_TSDL_X]coTeacher1 [S_MI_SEC_TSDL_X]coTeacher2 [S_MI_SEC_TSDL_X]mentorTeacher1 [S_MI_SEC_TSDL_X]mentorTeacher2 [S_MI_SEC_TSDL_X]mentorTeacher3 Default = 'Teacher of Record' Co-Teacher (1-2) = 'Assistant Teacher' Mentor Teacher (1-3) = 'Support Teacher'	R
beginDate	Month, day, and year of a teacher's assignment to the section. If blank, defaults to the first day of the first grading period for the section.	Date	[SectionTeacher]Start_Date Or, if empty [Terms]FirstDay	O
endDate	Month, day, and year of the last day of a teacher's assignment to the section.	Date	[SectionTeacher]End_Date Or, if blank [Terms]LastDay	O
teacherStudentDataLinkExclusion	Indicates that the entire section is excluded from calculation of value-added or growth attribution calculations used for a particular teacher evaluation.	Boolean	True if any of the follow exclude flags are checked: [S_MI_SSF_TSDL_X]excludeTSDL [S_MI_SEC_TSDL_X]excludeTSDL [S_MI_SCH_TSDL_X]excludeTSDL [S_MI_CRS_TSDL_X]excludeTSDL	O
percentageContribution	Indicates the percentage of the total scheduled course time, academic standards, and/or learning activities delivered in this section by this staff member. A Teacher of Record designation may be based solely or partially on this contribution percentage.	Number	[SectionTeacher]Allocation Or Blank	O

Back to top

Student Sections

This view captures the course sections to which a student is assigned as published in the StudentSectionAssociation resource within the Student Teacher Sections category. The layout includes the School Name, Student Number, Grade Level, Course Number, Course Name, Term, Section Number, and UIC.

studentSectionAssociations

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