Skip to main content
Skip table of contents

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, Staff Name, State Identifier, Course Number, Course Name, Section Number, Term, Last Publish Date, Publishing ID, and Resource ID.

staffSectionAssociation

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]
  • [Terms]
  • [Period]

Selection Criteria

Records are published if the following criteria are met:

  • The teacher must not be excluded from state reporting.
  • The teacher must not be excluded from Ed-Fi reporting.
  • The teacher’s school must not be excluded from state reporting.
  • The teacher’s section must not be excluded from state reporting.
  • The staffUniqueId must be populated in PowerSchool.

If your District wants to report a section’s Additional Teacher as the responsible teacher and not report the section’s Lead Teacher, perform the following:

  1. Exclude the Lead Teacher from either Ed-Fi or State reporting.

  2. Set the section’s Class Instruction value to 1 - This class is taught by two or more teachers.

  3. Enter the Additional Teacher’s information in the First Secondary Teacher field and specify a Special Education Classroom Settings (defaults to 'Not a Special Ed Teacher').

If the Lead Teacher is excluded and only one Secondary Teacher is specified, the additional teacher is the only teacher reported.

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: staffs 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

A reference to the related sections resource.

R

/schoolID

The school associated with the section.

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

Derived from:

[Period]Abbreviation

[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

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.

String

[Courses]Course_Number

R

/termDescriptor

The name of the term in which the section is offered, for example, Fall Semester, Spring Semester.

Descriptor

Derived from

[Terms]Portion

[Terms]Abbreviation

R

/schoolYearType

The identifier for the school year.

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

Derived from:

[Sections]schoolid

[Courses]Course_Number

[Sections]section_number

[Sections]dcid

Format: [Sections]schoolid - [Courses]Course_Number - [Sections]section_number - [Sections]dcid

R

/sequenceOfCourse

When a section is part of a sequence of parts for a course, the number in the sequence.If the course has only one part, the value of this Section attribute should be 1.

Integer

'1'

R

staffReference

A reference to the related staffs resource.

R

/staffUniqueID

The staff associated with the section.

String

[Users]DCID

R

classroomPositionDescriptorA unique number or alphanumeric code assigned to a room by a school, school system, state, or other agency or entity.String

[Sections]Teacher = [SectionTeacher]TeacherID: 'Teacher of Record'

[RoleDef]Name = 'Lead Teacher': 'Teacher of Record'

[RoleDef]Name in 'Co-teacher', 'Job Share Teacher': 'Assistant Teacher'

[SchoolStaff]StaffStatus = 4: 'Substitute Teacher'

Otherwise: '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 if populated

Otherwise: [Terms]FirstDay of selected school year

O

endDate

Month, day, and year of the last day of a teacher's assignment to the section.

Date

[SectionTeacher]End_Date if populated

Otherwise: [Terms]LastDay of selected school year

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 / 100

O

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, Student Name. STN Number, Grade Level, Course Number, Course Name, Section Number, Term, Last Publish Date, Publishing ID, and Resource ID.

studentSectionAssociation

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

Primary PowerSchool Source Data

  • [CC]
  • [Sections]
  • [Students]
  • [Terms]
  • [Period]

Selection Criteria

Records are published if the following criteria are met:

  • The school must not be excluded from state reporting.
  • The section must not be excluded from state reporting.
  • The studentUniqueID (Vermont Student Number) must be populated in PowerSchool ([Students]State_StudentNumber).
  • The enrollment ExitDate is greater than the EntryDate.

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: studentSchoolAssociations 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

A reference to the related sections resource.

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

Derived from:

[Period]Abbreviation

[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

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.

String

[Courses]Course_Number

R

/termDescriptor

The name of the term in which the section is offered, for example, Fall Semester, Spring Semester.

Descriptor

Derived from

[Terms]Portion

[Terms]Abbreviation

R

/schoolYear

The identifier for the school year.

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

Derived from:

[Sections]schoolid

[Courses]Course_Number

[Sections]section_number

[Sections]dcid

Format: [Sections]schoolid - [Courses]Course_Number - [Sections]section_number - [Sections]dcid

R

/sequenceOfCourse

When a Section is part of a sequence of parts for a course, the number if the sequence.

Integer

'1'

R

studentReference

A reference to the related students resource.

R

/studentUniqueID

The student enrolled in the section.

String

[Student]State_StudentNumber

R

beginDate

Month, day, and year of the student's entry or assignment to the section. If blank, default is the start date of the first grading period.

Date

[Calendar_Day]Date_Value

Where [Calendar_Day]InSession = 1
and [Calendar_Day]Date_Value is between the first and last day of the term
and [Calendar_Day]Date_Value is greater than or equal to [CC]DateEnrolled

Format: 'YYYY-MM-DD'

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.

Date

[Calendar_Day]Date_Value

Where [Calendar_Day]InSession = 1
and [Calendar_Day]Date_Value is between the first and last day of the term
and [Calendar_Day]Date_Value is less than [CC]DateLeft

Format: 'YYYY-MM-DD'

O

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.