SIF v2.7 - StaffSectionAssignment

Last Modified on 10/22/2022 10:09 am CDT

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
Report an object instance for each staff who has a Staff History record on the section with a Start Date = Null or <= the current date. Report an object for each of these staff records assigned to the course.
The Staff must have a StaffPersonal Record.
Do NOT report a record if any one of the following scenarios are true: If the record is being triggered from a District Assignment record and the School is marked as Exclude. If Exclude checkbox is checked in Zone Option, exclude StaffPersonal whose District Assignments are Excluded.
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	Report Start Date under Staff History. If it is null, then report start date of the Calendar instead. If both dates come before the Term Start Date, then report the Term Start Date Report from EmploymentAssignment.startDate if after the term start date of a section and should be inclusive of the state and end date of the section coming from TermInfo If the Exclude District Assignments are checked in Zone Options, only include District Assignments that are not excluded	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	Report End Date under Staff History If it is null, then report end date of the Calendar instead. If both dates come before the Term End Date, then report the Term End Date Report from EmploymentAssignment.endDate if the district assignment has ended and is before the term end date of a section If the Exclude District Assignments are checked in Zone Options, only include District Assignments that are not excluded	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.	When this staff is the active Primary Teacher as of the current date (or was on the last day of the section when current date > course term end date) from (Scheduling > Courses > Course > Section > Staff History > Staff History Detail), report "Yes". Otherwise, report "No".		SectionStaffHistory.staffType	M
Roles	List of one or more Roles.				M
Roles/Role	One of a set of possible enumerated Role values.	When (Scheduling>Courses>Course>Section>Staff History> saved as = "New Primary Teacher", report "LeadTeacher". When "New Teacher", report "TeamTeacher". When "New Section Staff", report "ContributingProfessional". 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.

Was this helpful?

Copyright ©️ 2010-2023 Infinite Campus, Inc. All rights reserved. | Terms of Use | Privacy Policy | infinitecampus.com