Student Teacher Sections
This category captures section teachers and student section enrollments. The Student Teacher Sections category includes the following data views and resources:
Note: Student Teacher Sections resources are only published for public schools.
Staff Sections
This data view represents the class sections to which a teacher is assigned and is required for all teachers. The published view layout includes the School Name, Teacher Number, Staff Name, Course Number, Course Name, Term, Section Number, Last Publish Date, and Publishing ID.
staffSectionAssociations
Primary PowerSchool Source Data
- [Period]
- [Sections]
- [Courses]
- [Terms]
Selection Criteria
Records are published if the following criteria are met:
- The teacher's school must not be excluded from state reporting.
- The teacher's school must have an Ed-Fi State School number.
- The teacher's school must have a WISEdata Reporting option.
- The staffUniqueId must be populated in PowerSchool.
- The teacher must not be excluded from state reporting.
- The teacher's section must not be excluded from state reporting.
Resource Output
- A separate staffSectionAssociations record is published for each course section in which the teacher is scheduled based on the year and the Term selected in the PowerSchool UI.
- A teacher with classes at multiple schools will have a record for each section at each school.
- The staffSectionAssociations resource is dependent on the prior publishing of the following resources: 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 | [Table]Data Type | Stored in [Table]Field | Req’d |
|---|---|---|---|---|
sectionReference A reference to the related section resource. | R | |||
/schoolID | The school associated with the session. | Integer | SchoolId downloaded from State Derived from: [S_WI_SCH_X]EdFi_StateSchoolNumber, or if this field is blank then [Schools]Alternate_School_Number] if greater than 0 Otherwise, [Schools]School_Number | 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, First semester, Second semester, Year long, Summer school; must match Term in corresponding CourseOffering. | String | Derived from: [Terms]Portion [Terms]Abbreviation | R |
/schoolYear | The identifier for the school year, recorded as the later calendar year of the school year. For example, 2017-2018 school year is recorded as 2018. | Integer | [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; State SchoolID + "-" + [Sections]DCID | R |
/sequenceOfCourse | When a section is part of a sequence of parts for a course, the number of the sequence. If the course has only one part, the value of this Section attribute is 1. | Integer | '1' | R |
| staffReference A reference to the related Staff resource. | R | |||
/staffUniqueId | The staff associated with the section. | String | [S_WI_USR_X]WISEIDStaff | 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. | String | [S_WI_STC_X]Classroom_Position if not blank Otherwise: Derived from Valid derived values:
| R |
| beginDate | The month, day, and year of the first day of a teacher's assignment to the Section. | Date | [SectionTeacher]Start_Date | O |
| endDate | The month, day, and year of the last day of a teacher's assignment to the Section. | Date | [SectionTeacher]End_Date | O |
Student Sections
This data view represents the course sections to which a student is assigned. The published view layout provides the School Name, Student Number, Student Name, Grade Level, Course Number, Course Name, Section Number, Term, State Student Number, Last Publish Date, and Publishing ID.
studentSectionAssociations
Primary PowerSchool Source Data
- [Period]
- [Sections]
- [Courses]
- [Terms]
- [Calendar_Day]
Selection Criteria
Records are published if the following criteria are met:
- The student's school of enrollment must not be excluded from state reporting.
- The student's school of enrollment must have an Ed-Fi State School number.
- The student's school of enrollment must have a WISEdata Reporting option.
- The student must not be excluded from state reporting.
- The section must not be excluded from state reporting.
- The section must be taught during the Term selected in the PowerSchool UI.
- The student must have corresponding school enrollment for the section enrollment.
Resource Output
- A separate studentSectionAssociations 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 studentSectionAssociations resource is dependent on the prior publishing of the following resources: sections.
- StudentSectionAssociations for sections taken at a different school from the primary enrolled school are not published at this time.
- 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 | [Table]Data Type | Stored in [Table]Field | Req’d |
|---|---|---|---|---|
sectionReference A reference to the related section resource. | R | |||
/schoolID | The school for which the section is defined. | Integer | SchoolId downloaded from State Derived from: [S_WI_SCH_X]EdFi_StateSchoolNumber, or if this field is blank then [Schools]Alternate_School_Number] if greater than 0 Otherwise, [Schools]School_Number | 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, First semester, Second semester, Year long, Summer school; must match Term in corresponding CourseOffering. | String | Derived from: [Terms]Portion [Terms]Abbreviation | R |
/schoolYear | The identifier for the school year, recorded as the later calendar year of the school year. For example, 2017-2018 school year is recorded as 2018. | Integer | [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; State SchoolID + "-" + [Sections]DCID | R |
/sequenceOfCourse | When a section is part of a sequence of parts for a course, the number of the sequence. If the course has only one part, the value of this section attribute should be 1. | Integer | '1' | R |
| studentReference A reference to the related Student resource. | R | |||
/studentUniqueID | The student enrolled in the section. | String | [Students]State_StudentNumber | R |
| beginDate | The month, day, and year of the student's entry or assignment to the section. | Date | Minimum [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 | The 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 | Maximum [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 |
| studentSchoolAssociationReference | R | |||
/studentUniqueID | The student associated with the school. | String | [Students]State_StudentNumber | R |
/schoolID | The school for which the section is defined. | Integer | SchoolId downloaded from State Derived from: [S_WI_SCH_X]EdFi_StateSchoolNumber, or if this field is blank then [Schools]Alternate_School_Number] if greater than 0 Otherwise, [Schools]School_Number | R |
/entryDate | The month, day, and year of the student's entry or assignment to the section. | Date | [Students]EntryDate if [CC]DateEnrolled is between [Students]EntyDate and [Students]ExitDate and [Students]SchoolID (or [Students]Enrollment_SchoolID) = [Sections]SchoolID Otherwise [ReEnrollments]EntryDate if [CC]DateEnrolled is between [ReEnrollments]EntryDate and [ReEnrollments]ExitDate and [ReEnrollments]SchoolID = [Sections]SchoolID | R |