The StaffSectionAssociation indicates the class sections to which a staff member is assigned.
Selection Criteria
-
Sections must be published.
-
The staff member is active at any point during the selected school year.
-
The teacher's school must not be excluded from state reporting.
-
The teacher's section must not be excluded from state reporting.
-
The staff’s Unique Id must be populated in PowerSchool.
-
The sections are published to which a staff member is assigned.
-
Publish only Teacher - Section Lead as a Teacher of Record
-
Exclude Staff with State Teacher Number = Blank
Dependencies
-
Dependency on Sections
Data Review
|
Field |
Selection |
|
Choose Dashboard |
Staff Sections |
|
Choose Category
|
Staff Sections Info Summary Staff Sections Info Published Staff Sections Info Dependencies Staff Sections Info Errors |
|
Choose Data view |
Staff 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 staff 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 |
Description |
Data View Column |
Submission |
[Table] Field |
Business Rules |
|
BeginDate |
The date when a particular session, course, or enrollment begins. |
Begin Date |
Yes |
[SectionTeacher]Start_Date [TERM]FirstDay |
st.start_date, Else p_firsttermday Format: 'YYYY-MM-DD' Provide valid start date for student’s enrollment in course. |
|
LocalCourseCode |
A unique code assigned to a course by the local education agency. |
Local Course ID / Course Number |
Yes |
[S_KS_CRS_X]LocalCourseId [Courses]Course_Number |
If [S_KS_CRS_X]LocalCourseId is blank then extract from [Courses]Course_Number If [S_KS_CRS_X]LocalCourseId is blank then extract from [Courses]Course_Number |
|
SchoolId |
A unique identifier assigned to each school within the state. |
School Number |
Yes |
[Schools]SIF_StatePRID [Sections]SchoolId |
Derived From [Sections]schoolId Format: ttbbbdddd If [Schools]SIF_StatePRID is blank, [Sections]SchoolId is pulled. The [Schools]SIF_StatePRID or [Sections]SchoolId must match with the Organization Catalog. |
|
SchoolYear |
The academic year during which the session or course takes place. |
Year |
Yes |
Calculated using [TERMS]YearID |
If 2023-2024, then extract 2024 |
|
SectionIdentifier |
A unique identifier for a specific section of a course. |
Section Number |
Yes |
Concatenated |
SchoolID+[Courses]Course_Number + [Sections]Section_Number +TermdcidID |
|
SessionName |
The name of the session during which the course or section is offered. |
Session Name |
Yes |
Concatenated [TERMS]YearID [Terms]Name |
SessionName format: SchoolYear TermName 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 |
|
StaffUniqueId |
A unique identifier assigned to each staff member within the state |
State Teacher Number |
Yes |
[S_KS_USR_X]State_Teacher_Number
|
[S_KS_USR_X]State_Teacher_Number
|
|
ClassroomPositionDescriptor |
Describes the position or role of the staff member within the classroom (e.g., teacher, assistant, etc.). |
Classroom Position |
Yes |
Calculated Teacher of Record |
Teacher - Section Lead, Role: Value will be extracted as Teacher of Record for the assigned staff in the staff field. Lead Teacher = Teacher of Record Note: Publish only Teacher - Section Lead as a Teacher of Record |