Teacher Sections
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]
[SCHOOLSTAFF]
[SECTIONTEACHER]
[S_NM_SEC_X]
[TERMS]
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 not be excluded from state reporting.
The course must have a valid state course code.
Note about 777777777 & 888888888 staff - These generic Unique ID values must be entered in the SSN field in the PowerSchool staff record in order to successfully publish Teacher Section (staffSectionAssociation) data.
These staff do not need Staff, Staff Employment (staffEducationOrganizationEmploymentAssociation), or Staff Assignment (staffEducationOrganizationAssignmentAssociation) records to publish from PowerSchool for the Teacher Section records to publish.
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).
Data Element | Description | Data Type | Stored in [Table]Field | Req'd |
|---|---|---|---|---|
SectionReference | R | |||
/schoolId | The school associated with this session. 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 school year associated with the calendar recorded as the trailing calendar year of the school year. For example, the 2019-2020 school year is published as 2020. | Number | [Terms]YearID +1991 | R |
/localCourseCode | The local code assigned by the LEA that identifies the organization of subject matter and related learning experiences provided for the instruction of students. | String | [Courses]Course_Number CoursesCoreFields.Alt_Course_Number Note: The field the logic pulls from depends on how the State Course Code Field is set on the District Info page. The localCourseCode will come from the field that is not selected in the State Course Code field. | R |
/sectionIdentifier | Unique identifier of a section. FORMAT: [sec]schoolid - [crs]course_number - [sec]section_number - [sec].dcid | String | Composed of the following: [SECTIONS]schoolid, course_number, section_number, dcid | R |
/sessionName | The identifier for the calendar for the academic session. | String | Composed of the following: [TERMS]schoolid, [TERMS]abbreviation, [TERMS]dcid | |
staffReferenceID | ||||
/staffUniqueId | ||||
/beginDate | As part of a course section details, the following teacher details are available: Teacher - Section Lead The start and end dates of the teacher's assignment to the Section are published. If blank, defaults to the first day of the first grading period for the Section. The endDate will publish only if it is less than the current date. Teacher/Staff - Additional The start and end dates of the additional teachers listed are published. The endDate will publish only if it is less than the current date. Team Teacher Information The dates of the term assigned to the section are published as the start and end dates of the teachers. The endDate will publish only if it is less than the current date. | String | Co-Teachers: [SECTIONTEACHER]Begin_Date Team Teachers: [TERMS]FirstDay | |
/classroomPositionDescriptor | The type of position the staff member holds in the specific class/section. Classroom Position Descriptor Set | Descriptor | Lead Teacher: [SECTIONS]Teacher Teacher/Staff - Additional: Derived from the Alt Code 1 value of the Co-Teaching role identified in the [SECTIONTEACHER]RoleID field. Team Teacher Information: [S_NM_SEC_X]TeamTeacher1ID [S_NM_SEC_X]TeamTeacher2ID | R |
/endDate | Month, day, and year of the last day of a staff member's assignment to the Section. | String | Co-Teachers: [SECTIONTEACHER]End_Date Team Teachers: [TERMS]LastDay | |
Additional record publishing information and classroomPositionDescriptor information & setup:
Staff tied to a section in the manners listed below can and will be published:
This includes the following:
Staff listed under Teacher - Section Lead
Staff listed under Teacher/Staff - Additional*
staff will be published if the setup outlined below is completed.
Staff listed under Team Teacher Information
For any staff listed under Teacher/Staff - Additional, in order for the classroomPositionDescriptor to publish correctly, the following setup must be done for the Co-Teaching Roles that are being used.
Path:
Classic UI: Start Page> System> Roles Administration> Co-Teaching
Enhanced UI: Start Page> System Management> Security> User Roles> Co-Teaching
For each Co-Teaching role (other than the Lead Teacher role), the Alt Code 1 field must be populated with one of the following descriptor values in order for the teacher staff record to publish:
Assistant Teacher
Support Teacher
Substitute Teacher
Teacher of Record
Note: Staff with the Lead Teacher role will always, automatically publish as the Teacher of Record. This value does not need to be entered into the Alt Code 1 field of the Lead Teacher role.
Team Teacher Information:
Staff entered in the Team Teacher 1 Name and Team Teacher 2 Name fields will always publish with the Assistant Teacher classroomPositionDescriptor value.