Classic View: System Administration > Data Utilities > SIF
Search Term: SIF
This object contains information about a student's enrollment in a section of a course.
SIF_Events are reported for this object.
Object Triggering
| Event Type | Requirement |
|---|---|
| Add | When a student is scheduled into a course section. |
| Add | Checking course.active. Or Unchecking State report Exclude on Course. |
| Add | If roster start date is after the term end date, do not report a record for the prior term. |
| Add | Only send records if the student has a enrollment in the schedule structure where the student is scheduled and is not marked as No Show. |
| Add | Do not send records for Excludes in Object Population. |
| Add | Do not send records if the Course is marked as Inactive. |
| Change | Any change made to the roster:
|
| Change | When section information is updated for a student or section |
| Change | Any delete made to the roster Start or End Date as the earliest or latest term dates will be utilized respectively |
| Delete | Unchecking course.active Or Checking State report Exclude on Course |
| Delete | When a student is deleted from a course section. |
| Roster End Date must be before Term Start date of future records. | |
| Delete | Enrollment status is changed or deleted so that the student no longer meets the Object Population. |
Object Population and Business Rules
| Requirement |
|---|
|
|
|
|
| Course cannot have "State Exclude" checked to report. |
Object Data Elements (SIF 2.7)
| Data Element Label | Description | Business Rules | Data Source GUI Path | Database Field | M, C or O |
|---|---|---|---|---|---|
| @RefId | The Id (GUID) that uniquely identifies this StudentSectionEnrollment entity. | District.districtGUID, Roster.rosterID | M | ||
| @StudentPersonalRefId | The Id (GUID) of the student to whom the enrollment information applies. | roster.personId | M | ||
| @SectionInfoRefId | The Id (GUID) of the section in which this student is enrolled. | roster.sectionId | 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 | ||
| EntryDate | Date from when this course section enrollment is valid. | When Roster Start Date is null, reports the earliest term start date for the section. | Student Information > General > Schedule or System Administration > Calendar > Calendar > Term | Roster.startDate, When roster.startDate is term.startDate | O |
| ExitDate | The last school calendar day (membership day) the student was enrolled in the course section (inclusive). | When Roster End Date is null, reports the latest term end date for the section. | Student Information > General > Schedule or System Administration > Calendar > Calendar > Term | Roster.endDate, Term.endDate | O |
| ScheduleInfo OverrideList | A complete replacement of the standard SectionInfo/ScheduleInfoList for this student's course enrollment. | Optional Does not Report | O | ||
| ScheduleInfoOverrideList/ ScheduleInfoOverride | A complete replacement of the standard SectionInfo/ScheduleInfo for this student's course enrollment. If the student's schedule for this course is different than the standard schedule as defined in SectionInfo, a ScheduleInfoOverride must be provided for each term in which the course is offered, along with the appropriate value for Override. See the use cases for this object for scenario examples. | Optional Does not Report | MR | ||
| ScheduleInfoOverrideList/ ScheduleInfoOverride/ @Override | Designates whether or not scheduling information has been overridden with different values for this student. | Optional Does not Report | M | ||
| ScheduleInfoOverrideList/ ScheduleInfoOverride/ @TermInfoRefId | The Id (GUID) of the term to which this override information relates for this student. | Optional Does not Report | M | ||
| ScheduleInfoOverrideList/ ScheduleInfoOverride/ MeetingTimeList | Optional Does not Report | O | |||
| ScheduleInfoOverrideList/ ScheduleInfoOverride/ MeetingTimeList/ MeetingTime | Time(s) this section meets for this student; this should be a subset of the meeting times for the section. | Optional Does not Report | MR | ||
| CreditsAttempted | Number of credits the student is attempting to earn. If present, this element's value overrides the credits in SchoolCourseInfo and SectionInfo. | Optional Does not Report | O | ||
| CreditsAttempted/ @Type | The type of credit. | Optional Does not Report | M | ||
| DualCredit | Indicates whether this course is applicable in having dual credits. This value overrides the SchoolCourseInfo DualCredit value at the student section level.. | Optional Does not Report | O | ||
| CTEConcentrator | Indicates whether this is a CTE concentrator for this course. This value overrides the SchoolCourseInfo CTEConcentrator value at the student section level.. | Optional Does not Report |
