SIF v2.7 - StaffAssignment | Infinite Campus Test

Classic View: System Administration > Data Utilities > SIF

Search Term: SIF

This object defines information related to a staff member's assignment(s); commonly, this will be a school assignment.

SIF_Events are reported for this object.

Object Triggering

Event Type	Requirement
Add	A new District Assignment is added for staff member.
	A staff's District Assignment exclude checkbox is unchecked and the Exclude is checked in District Assignment in Zone Option.
Change	A District Assignment is modified for staff member.
Delete	A District Assignment is deleted for staff member.
	A staff's District Assignment exclude checkbox is checked and the Exclude is checked in District Assignment in Zone Option.

Object Population and Business Rules

Requirement
Report one object per assignment.
Report only 1 record per staff per school per school year when multiple District Assignment records exist with the same JobFunction/OtherCodeList/OtherCode (Title standard code). If Primary District Assignment is unchecked for all assignments with the same Title standard code with a null End Date or an End Date that falls after the current date, report from the District Assignment record with the highest FTE of Assignment. If FTE of Assignment is the same, report from the record where Assignment Code = 001, 002. Otherwise, report from the most recent record.
Report Staff even if District Assignment End Date or Staff History>End Date is on or before the current date. Do not report Staff if District Assignment End Date is After District Assignment Start Date AND before the selected calendar Start Date
Do not report Staff that have a Job Classification code (District Assignment>Title (StandardCode)) of NULL
Always report Staff from Schools that have Staff Assignment Type of 02.
Records where District Employment exclude is checked will not report.

Core Object Data Elements (SIF 2.7)

Data Element Label	Description	Business Rules	Data Source GUI Path	Database Field	M, C or O
@RefId	The GUID that uniquely identifies a particular staff assignment.			District.district GUID Employment Assignment. assignmentID	M
@SchoolInfoRefId	The Id (GUID) that identifies the school where the staff member is assigned.			Calendar.schoolID	M
@SchoolYear	School year for which the information is applicable, expressed as the four-digit year in which the school year ends (e.g., 2007 for the 2006-07 school year).			Calendar.endYear	M
@StaffPersonalRefId	Id (GUID) of this staff member, as represented in the StaffPersonal object.			Employment Assignment. personID	M
Description	Short assignment description		Census > People > District Assignments	Employee Assignment. title	O
PrimaryAssignment	Is this the staff member's primary assignment? Note: There must be one and only one instance of the object with a Yes value in this element per school year.	1. Get the minimum EmploymentAssignment.assignmentID of the maximum EmploymentAssignment.fte where employmentAssignment.endDate is after current date. 2. If the StaffAssignment that is reporting is the same as the EmploymentAssignment.assignmentID calculated above, then ‘Yes’ ELSE ‘No’.		Employment Assignment. primary	M
JobStartDate	This is the date from which the staff assignment is valid (inclusive).	Report the Start Date of the staff assignment	Census > People > District Assignments	Employment Assignment. startDate	O
JobEndDate	This is the date through which the staff assignment is valid (inclusive).	Report the End Date of the staff assignment.	Census > People > District Assignments	Employment Assignment. endDate	O
JobFTE	Full-time job equivalent ratio for this assignment. (Format is x.xx; an employee who is full-time and who is 50% of their time on this assignment would be represented as 0.50)	Report the value that's there if it is <=1, but report the value/100 if it is greater than 1	Census > People > District Assignments	employment Assignment. fte	O
JobFunction	The purpose of the activities as related to students				O
JobFunction/Code	Code representing the type of job function.	If Employment Assignment Info > "Title" contains the string "Principal" (case sensitive), JobFunction/Code = 2410 If the "Teacher" checkbox = Checked, JobFunction/Code = 1000 If the "Health" checkbox = Checked, JobFunction/Code = 2130 If none of the above are true, JobFunction/Code = 9999	Census > People > District Assignments > Assignments > Employment Assignment Info > "Title"	jobFunction Code	M
JobFunction/ OtherCodeList		Optional. Do note Report			O
JobFunction/ OtherCodeList/ OtherCode	A state/province code, local code, other code or a text string that crosswalks to or serves as a translation of an associated Code element.				MR
JobFunction/ OtherCodeList/ @Codeset	Describes the OtherCode element content as either a state/province code, a local code, other code, or text string.				M
TeachingAssignment	The teacher field taught by the individual				O
TeachingAssignment/ Code	Code representing the type of teaching assignment.	Report the Standard Code from Primary Teaching Area (Census > People > District Assignment > Employment Assignment Information). If teacher but no record exists, then report '9999'	Census > People > District Assignment > Employment Assignment Information	Employment Assignment. primaryTeaching Area	M
TeachingAssignment/ OtherCodeList					O
TeachingAssignment/ OtherCodeList/ OtherCode	A state/province code, local code, other code or a text string that crosswalks to or serves as a translation of an associated Code element.	When Codeset = StateProvince	Census > People > District Assignments	employment Assignment. assignmentCode	MR
TeachingAssignment/ OtherCodeList/ OtherCode/ @Codeset	Describes the OtherCode element content as either a state/province code, a local code, other code, or text string.	Must = StateProvince			M
GradeLevels	An indication of the grade level(s) the individual is assigned	Do NOT report the GradeLevels element when the following is True: (Census>People>District Assignments>Assignments>Employment Assignment Info>Teacher) = NOT Checked for this District Assignment. Also in any case where a prior value (above) is not reported (this is our ELSE value).			O
GradeLevels/ GradeLevel		When staff has (Census>People>District Assignments>Assignments>Employment Assignment Info>Teacher) = Checked: Report an instance of the Grade Level element for each unique grade level that is associated with any student rostered from across all sections where the staff is either a 'Teacher' or a 'Primary Teacher' where staff history Start Date <= the current date or is Null (Scheduling>Courses>Course>Section>Staff History>Staff History) only in the school associated with this District Assignment (and within the SIF School, Year, and Calendar selected (System Admin>Data Interchange>Zones>Zone List>Zone Info>School, Year, Calendar)). The Staff must have (Section>Staff History>Staff History Detail>District Assignment) = NOT Null in order to accurately report the section's associated grade level(s). Not every State has a non-Null dictionary in this field (Iowa, for example). When the District Assignment dropList on Staff History = Null, or when the District Assignment field has a Null dictionary, the section will report for any/all of the Staff's district assignments in the calendar matching the section, and that were active during the time the Staff was assigned to the section. A grade level must only be included when the student was actively enrolled (not dropped) in the section when the teacher was actively teaching the section. Students enrolled in the course must be active on or between the staff history teaching dates for the staff. Note: An existing UI validation exists that forces the staff history Start Date to be <= today. If this is ever removed, our SIF logic should remain in place.			MR
GradeLevels/ GradeLevel/ Code	Code representing the grade level.	The user-entered Code in (System Admin>Calendar>Calendar>Grade Levels>Standard Code (SIF code)) must report to GradeLevel/Code. Follow the student's roster grade back via the mapped State Grade Level Code. GradeLevel/Code = Other, and the OtherCodeList must NOT be reported WHEN: Teacher = Checked on the District Assignment, AND staff history Start Date <= the current date, AND: When there is no student assigned across all sections that the teacher is assigned as a 'Teacher' or 'Primary Teacher' in this District Assignment's school. OR When the teacher is NOT assigned to a section in the district assignment as a 'Teacher' or 'Primary Teacher'.	System Administration > Resources > Grade Level Definitions	StateGrade LevelDefinition. code, GradeLevel. name	M
GradeLevels/ GradeLevel/ OtherCodeList		Report (System Admin>Calendar>Calendar>Grade Levels>State Grade Level Code) mapped to the student's enrollment (roster) grade. (The Roster Grade is updated to the student's most recent enrollment grade)			O
ItinerantTeacher	Is this staff itinerant for this assignment?	If the teacher checkbox is checked in District Assignment, If the person has district assignments marked Teacher in multiple schools, where the Start date is on or after July 1st of the Zone Year and the End Date is null Or after today's date, then Report Yes. If the person does not have district assignments in multiple schools as specified above, then Report No. If the teacher checkbox is not checked in District Assignment, then report NA		Calculated value	O
InstructionalLevel	An indication of the general nature of instruction provided throughout a course.	This is Optional. Does not Report.			O
EmployeePersonal RefId	A GUID referencing an EmployeePersonal object to be able to establish a link between HR employee objects and SIS staff objects.	This is Optional. Does not Report.

SIF v2.7 - StaffAssignment

Object Triggering

Object Population and Business Rules

Core Object Data Elements (SIF 2.7)

Related Articles