Tool Search: SIF
The current version of SIF is v2.7.
This object provides a summary of a school's calendar information for a given school year. A school may have more than one calendar per school year (e.g., one calendar for Kindergarten students, one for special education students, one for seniors, or one for each calendar track), and each may have different days in session, start and end dates, minutes per day, instructional minutes, etc.
SIF_Events are reported for this object.
Object Triggering
| Event Type | Requirement |
|---|---|
| Add | When the calendar is added in the Zone Scope and Year, and does not have "Exclude From SIF Reporting" = Checked on the Calendar Note: CalendarSummary object reports per calendar. |
| Add | When a new Calendar is created and saved via the Calendar Wizard. |
| Change | When a non-SIF-excluded calendar is modified on (System Adminisstration > Resources > Calendar > Calendar) with below changes:
|
| Delete | When a non-SIF-excluded calendar in the Zone Scope and Year is deleted. |
Object Population and Business Rules
| Requirement |
|---|
| Rights to the object, in the Zone year and calendar. |
| Does not have "Exclude From SIF Reporting" = Checked on the Calendar. |
| No triggers on Exclude from SIF Exchange checkbox. |
Object Data Elements
| Data Element Label | Description | Business Rules | Data Source GUI Path | Database Field | M, C, or O |
|---|---|---|---|---|---|
| @RefId | The ID (GUID) of the calendar to which this information relates. | calendar.calendarID | M | ||
| @SchoolInfoRefId | The ID (GUID) of the school for which this calendar information is being reported. | 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). |
| System Administration > Calendar > School Years > End Year | calendar.endYear | M |
| LocalId | The locally assigned identifier for this calendar. | System Administration> Calendar> Calendar | calendar.calendarId | M | |
| Description | Textual description of the school calendar. |
| System Admin>Calendar>Calendar>Calendar Info>Name | Calendar.name | O |
| DaysInSession | The total number of days that the school was or is anticipated to be in session during the school year. Also included are days on which the education institution facility is closed and the student body as a whole is engaged in planned activities off-campus under the guidance and direction of staff members. | Total number of days marked ‘School Day’ in the calendar. | System Admin>Calendar>Calendar>Days | Count of day.Date | M |
| StartDate | The first calendar date, whether or not instruction was provided. If both CalendarSummary and CalendarDate objects are supported, StartDate must be the date of the first chronological instance of CalendarDate for the school's calendar. | Reports the first day in the calendar with one or more of the following:
| System Administration> Calendar> Calendar> Days> | calendar.startDate | O |
| EndDate | The last calendar date, whether or not instruction was provided. If both CalendarSummary and CalendarDate objects are supported, EndDate must be the last chronological instance of CalendarDate for the school's calendar. | Reports the last day in the calendar with one or more of the following:
| System Administration> Calendar> Calendar> Days> | calendar.endDate | O |
| FirstInstructionDate | The first day of student instruction. | First instructional day in day.date in the calendar. | System Administration > Calendar > Calendar > Days > date record > Instructional | day.date | O |
| LastInstructionDate | The last day of student instruction (including days or times that students are present for purposes of testing and/or evaluation, but not including whole or part-days whose sole purposes is for distribution of report cards). | Last instructional day in day.date in the calendar. | System Administration > Calendar > Calendar > Days > date record > Instructional | day.date | O |
| GraduationDate | Date of graduation ceremony | This is Optional. Does not Report. | |||
| InstructionalMinutes | The total number of instructional minutes for this calendar for the school year. | When Calendar.studentDay NOT = Null, report the Calendar.studentDay minutes multiplied by the number of unique instructional days in the calendar:
| System Administration > Calendar | Calendar.studentDay day.duration | O |
| MinutesPerDay | The number of minutes in the day in which the school is normally in session. |
| System Administration > Calendar | calendar.studentDay | O |
| GradeLevels | Collection of grade levels applicable to this school calendar. | O | |||
| GradeLevels/GradeLevel | Grade or academic level. | MR | |||
| GradeLevels/GradeLevel/Code | Code representing the grade level. | When gradelevel.standardCode is any of 01 - 12, PK, KG, PG, or UN, report the code. Otherwise, reports 'Unknown'. Excludes grade levels from reporting that have (System Admin>Calendar>Calendar>Grade Levels>Grade Level Detail>Exclude from SIF reporting) = Checked. Does NOT exclude grade levels from reporting that have (System Admin>Calendar>Calendar>Grade Levels>Grade Level Detail>Exclude from State Reporting) = Checked | System Administration > Calendar > Grade Levels | gradelevel.standardCode | M |
