Tool Search: SIF
The current version of SIF is v2.7.
This object provides information about the section—the specific time period a session of the course meets.
SIF_Events are reported for this object.
Object Triggering
| Event Type | Requirement |
| Add | A new section is created. |
| Add | If section schedule placement is added for a section that had none, an Add event will be generated. |
| Add/Delete | Checking/Unchecking course.active Or Unchecking State Report Exclude on Course/ Or Checking State Report Exclude on Course. |
| Change | A change is made to any of these fields: Section number, Room, Instructional Setting and Medium of Instruction on the Section Editor and saved. |
| Change | Section schedule placement is updated. |
| Delete | A section is deleted. |
| Delete | If all of the section schedule placement is deleted for a section, a Delete event will be generated. |
| Add/Change/Delete | If a add, change or delete is made to a section, a record should also be triggered for SectionMarkInfo and StudentSectionEnrollment (if students are assigned). |
Object Population and Business Rules
| Requirement |
| The associated course must have Active = Checked. |
| The associated course must not be state report Excluded. |
| The associated calendar must not be SIF Exchange Exlcuded. |
| The section must have a section placement. |
Object Data Elements
| Data Element Label | Description | Business Rules | Data Source GUI Path | Database Field | M, C or O |
|---|---|---|---|---|---|
| @RefId | The Id (GUID) that uniquely identifies this section entity. | Calculated | Section.sectionID | M | |
| @SchoolCourseInfo RefId | The Id (GUID) that identifies the course being taught in this section. | Calculated | Section.courseID | M | |
| @SchoolYear | School year for which the information is applicable, expressed as the four-digit year in which the school year ends | Calendar.endYear | M | ||
| LocalId | The locally-assigned identifier for this course section. | Scheduling>Courses>Section> Section Info>Section Number | Section.number | M | |
| Description | Description of the course section | Optional do not report. | O | ||
| ScheduleInfoList | System Administration > Calendar > Calendar > Terms | sectionPlacement. termId | M | ||
| ScheduleInfoList/ ScheduleInfo | The schedule-related information for a section repeating for each term in which the section is scheduled. The TermInfoRefId attribute value should repeat as necessary to show the appropriate relationship between meeting times, teachers and rooms. | MR | |||
| ScheduleInfoList/ ScheduleInfo/ @TermInfoRefId | The Id (GUID) of the term to which this schedule information relates. | System Administration > Calendar > Calendar > Terms | sectionPlacement. termId | M | |
| ScheduleInfoList/ ScheduleInfo/ TeacherList | Repeatable teacher list. This parent and child elements only report when the section Staff History.personId exists. When no person exists on Staff History, this element is not reported. | O | |||
ScheduleInfoList/ ScheduleInfo/ TeacherList/ StaffPersonalRefId | The Id (GUID) of the teacher. | Census > People > Demographics | sectionStaffHistory. personId | MR | |
| ScheduleInfoList/ ScheduleInfo/ SectionRoomList | Will report when Section.roomId has a value. Otherwise, this element will not be reported. | O | |||
ScheduleInfoList/ ScheduleInfo/ SectionRoomList/ RoomInfoRefId | The Id (GUID) of the room in which this section is taught. | System Administration > Resources > Resources > Rooms | Section.roomId | MR | |
| ScheduleInfoList/ ScheduleInfo/ MeetingTimeList | Always reports. | O | |||
ScheduleInfoList/ ScheduleInfo/ MeetingTimeList/ MeetingTime | Time(s) this section meets. | MR | |||
ScheduleInfoList/ ScheduleInfo/ MeetingTimeList/ MeetingTime/ TimetableDay | Locally defined rotation cycle day code when the section meets (e.g., in a two day schedule, valid values would be "A" and "B," or "1" and "2"). | (Note: No triggers for this Element) | System Administration > Calendar > Calendar > Periods > Period Schedule Info > Name | periodSchedule.name | O |
ScheduleInfoList/ ScheduleInfo/ MeetingTimeList/ MeetingTime/ TimetablePeriod | The period within the day when this section takes place (e.g., "0" through "7"). | (Note: No triggers for this Element) | System Administration > Calendar > Calendar > Period Info > Name | period.name | O |
| MediumOfInstruction | Medium through which the student receives instructional communication from the teacher. | Element and child elements will only report when Medium Of Instruction NOT = Null. | Scheduling>Courses>Course> Section>Medium Of Instruction | section.mediumOf Instruction | O |
| MediumOfInstruction/ Code | Code representing the medium of instruction. | Reports the mapped SIF code. When code doesn't have dictionary mapping, reports 9999. | Scheduling > Course > Section > Medium Of Instruction | Section.mediumOf Instruction | M |
| MediumOfInstruction/ OtherCodeList | O | ||||
| MediumOfInstruction/ 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. | Reports the Code selected in the Medium Of Instruction field. | Scheduling > Course > Section > Medium Of Instruction | section.mediumOf Instruction | MR |
MediumOfInstruction/ OtherCodeList/ OtherCode/ @Codeset | Describes the OtherCode element content as either a state/province code, a local code, other code, or text string. | Codeset = StateProvince | M | ||
| LanguageOfInstruction | Language in which the section in taught | This is Optional. Does not Report. | O | ||
| LocationOfInstruction | Description of the location in which the section is taught. | Element and child elements will only report when Instructional Setting NOT = Null. | Scheduling > Course > Section> Instructional Setting | section.instructional Setting | O |
| LocationOfInstruction/ Code | Code representing the location of instruction. | Reports the mapped SIF code. When code doesn't have dictionary mapping, reports 9999. | Scheduling > Course > Section | section.instructiona Setting | M |
| LocationOfInstruction/ OtherCodeList | O | ||||
| LocationOfInstruction/ 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. | Reports the Code selected in the Instructional Setting field. | Scheduling > Course > Section | section.instructional Setting | MR |
LocationOfInstruction/ OtherCodeList/ OtherCode/@Codeset | Describes the OtherCode element content as either a state/province code, a local code, other code, or text string. | Codeset = StateProvince | M | ||
| SummerSchool | Is this a summer school assignment? | Reports "Yes" when "Summer School" = Checked on the calendar. Otherwise, "No". (Note: No triggers for this Object Element) | System Administration > Calendar > Calendar > Summer School | calendar.summerSchool | O |
| SchoolCourseInfo Override | Optional overrides of the course information for this section | This is Optional. Does not Report. | O | ||
| CourseSection Code | A section code that is linked to a course. This should be a unique identifier within the school year and course (i.e. the class instance number for a course). For example, Algebra I: Section 23 is different from English II: Section 23. | This is Optional. Does not Report. | O | ||
| SectionCode | A unique identifier of the section for the school year and across courses | Reports the course number + "-" + the section number. | Scheduling>Courses> Course>Number Scheduling>Courses> Section>Number | course.number-section.number | O |
| CountForAttendance | Indicates if attendance in this section is collected and used in attendance calculations. | This is Optional. Does not Report. | O | ||
| BellScheduleRefId | The GUID of the bell schedule used by this section. | This is Optional. Does not Report. |
