SIF v2.7 - StaffAssignment

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.

DeleteA 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.
  1. 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).
    1. 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.
      1. If FTE of Assignment is the same, report from the record where Assignment Code = 001, 002.
      2. 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.
  1. 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 LabelDescriptionBusiness RulesData Source GUI PathDatabase FieldM, C or O
@RefIdThe GUID that uniquely identifies a particular staff assignment.

District.district
GUID Employment
Assignment.
assignmentID
M
@SchoolInfoRefIdThe Id (GUID) that identifies the school where the staff member is assigned.

Calendar.schoolIDM
@SchoolYearSchool 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.endYearM
@StaffPersonalRefIdId (GUID) of this staff member, as represented in the StaffPersonal object. 

Employment
Assignment.
personID
M
DescriptionShort assignment description
Census > People > District AssignmentsEmployee
Assignment.
title
O
PrimaryAssignmentIs 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
JobStartDateThis is the date from which the staff assignment is valid (inclusive).Report the Start Date of the staff assignmentCensus > People > District AssignmentsEmployment
Assignment.
startDate
O
JobEndDateThis is the date through which the staff assignment is valid (inclusive).Report the End Date of the staff assignment.Census > People > District AssignmentsEmployment
Assignment.
endDate
O
JobFTEFull-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 Assignmentsemployment
Assignment.
fte
O
JobFunctionThe purpose of the activities as related to students


O
JobFunction/CodeCode representing the type of job function.
  1. If Employment Assignment Info > "Title" contains the string "Principal" (case sensitive), JobFunction/Code = 2410
  2. If the "Teacher" checkbox = Checked, JobFunction/Code = 1000
  3. If the "Health" checkbox = Checked, JobFunction/Code = 2130
  4. 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
TeachingAssignmentThe 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 InformationEmployment
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 = StateProvinceCensus > People > District Assignmentsemployment
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
GradeLevelsAn indication of the grade level(s) the individual is assignedDo NOT report the GradeLevels element when the following is True:
  1. (Census>People>District Assignments>Assignments>Employment Assignment Info>Teacher) = NOT Checked for this District Assignment.
  2. 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:
  1. 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)).
    1. 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).
    2. 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.
    3. 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.
    4. 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.
  1. The user-entered Code in (System Admin>Calendar>Calendar>Grade Levels>Standard Code (SIF code)) must report to GradeLevel/Code.
  2. Follow the student's roster grade back via the mapped State Grade Level Code.
  3. 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:
      1. 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.
      2. OR
      3. When the teacher is NOT assigned to a section in the district assignment as a 'Teacher' or 'Primary Teacher'.
System Administration > Resources > Grade Level DefinitionsStateGrade
LevelDefinition.
code, GradeLevel.
name 
M
GradeLevels/
GradeLevel/
OtherCodeList

  1. 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
ItinerantTeacherIs 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 valueO
InstructionalLevelAn 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.