Classic View: System Administration > Data Utilities > SIF
Search Term: SIF
This object contains information about a teacher's assignment in a section.
SIF_Events are reported for this object.
Object Triggering
| Action | Requirement |
|---|---|
| Add | Staff is assigned to a section with an existing roster. |
| Add | When Course active checked. |
| Change | A change is made to the Start Date and End Date fields in Scheduling>Courses>Course>Section>Staff History>Staff History Detail. |
| Change | When District Assignment is added/deleted . |
| Change | When District Assignment Start/End dates are changed. |
| Delete | Staff is removed from a section. |
| Delete | When Course active unchecked. |
| Delete | When a section is removed. |
| Delete | When all the rosters are removed. |
| Add | If the Exclude box is unchecked in the Assignment record and the Exclude is checked in District Assignment in Zone Option. |
| Delete | If the Exclude box is checked in the Assignment record and the Exclude is checked in District Assignment in Zone Option. |
Object Population and Business Rules
| Requirement |
|---|
|
| The Staff must have a StaffPersonal Record. |
Do NOT report a record if any one of the following scenarios are true:
|
The staff must be assigned to the section as a Primary Teacher OR a Teacher OR a Section Staff. |
| Note: if no students are rostered into the course, staff section assignment will not pull . |
| The associated course must have Active = Checked. |
| The section must have a section placement. |
Object Data Elements
| Data Element Label | Description | Business Rule | Data Source GUI Path | Database Location | M, C, or O |
|---|---|---|---|---|---|
| @RefId | The Id (GUID) that uniquely identifies this StaffSectionAssignment entity. | SectionStaffHistory.historyID, District.districtGUID | M | ||
| StaffPersonalRefId | The Id (GUID) of the teacher or educational staff to whom the assignment information applies. | SectionStaffHistory.personID | M | ||
| SectionInfoRefId | The Id (GUID) of the section in which this staff (teacher) is assigned. | SectionStaffHistory.sectionID | M | ||
| AssignmentStart Date | Date span from when this section assignment is effective |
| Scheduling > Courses > Course > Section > Staff History > Staff History Detail > Start Date Sys Admin > Calendar > Calendar > Start Date Sys Admin > Calendar > Calendar > Terms > Start Date Census > People > District Assignments | SectionStaffHistory.startDate Calendar.startDate Term.startDate EmploymentAssignment.startDate | O |
| AssignmentEndDate | Date when this section assignment comes to an end |
| Scheduling > Courses > Course > Section > Staff History > Staff History Detail > End Date System Admin > Calendar > Calendar > End Date System Admin > Calendar > Calendar > Terms > End Date Census > People > District Assignments | SectionStaffHistory.endDate Calendar.startDate Term.startDate EmploymentAssignment.endDate | O |
| TeacherOfRecord | Indicates if the staff is the Teacher of Record during this assignment. |
| SectionStaffHistory.staffType | M | |
| Roles | List of one or more Roles. | M | |||
| Roles/Role | One of a set of possible enumerated Role values. |
Note: Database code for reference New Primary Teacher" -> "P", "New Teacher" -> "T", "New Section Staff" -> "SS | Scheduling>Courses>Course> Section>Staff History | SectionStaffHistory.staffType | MR |
| PercentResponsible | Percentage of Responsibility of the Teacher of Record. | Optional. Do Not Report. |
