Classic View: System Administration > Data Utilities > SIF
Search Term: SIF
This object provides a summary of a student's daily attendance and membership information for a given school during the time period between the Start Date and End Date, inclusive. As such, there may be multiple instances of this object for a student in a school over the course of a school year or reporting period.
Object Triggering
| Event Type | Requirement |
|---|---|
| Add/Change/Delete | N/A for this object at this time since SIF_Events are NOT reported for this object. |
Object Population and Business Rules
| Requirement |
|---|
| Report for each occurrence of StudentPersonal object for a student. |
We ignore non-primary enrollments if the SIF option 'excludeSecondaryEnrollments' is checked. Otherwise we look at all enrollments. |
| Calendar exclude must not be checked. |
| Student must not be grade level excluded. |
| Student must not be enrollment State Exclude or enrollment No Show when the Zone Options excludes these enrollments. |
Object Data Elements
| Data Element Label | Description | Business Rules | Data Source GUI Path | Database Field | M, C or O |
| @RefId | A GUID that identifies an instance of this object. This RefId is a “transient” value; that is, it should be generated by the provider at the time the object is provided in a Response message. This value MUST NOT be used in a later Request for the object. | M | |||
| @StudentPersonalRefId | The Id (GUID) of the student for whom this attendance information is being reported. | attendance.personId | M | ||
| @SchoolInfoRefId | The Id (GUID) of the school for which this attendance information is being reported. | calendar.schoolId | M | ||
| @SchoolYear | School year for which the information is applicable. | calendar.endYear | M | ||
| StartDate | The starting date on which the information in this object instance is applicable. | The student's earliest date of instruction up to the current date. | day.date | M | |
| StartDay | Number of the first school day to which this object instance applies. | The instructional day number the student first attended. | day.date | M | |
| EndDate | The ending date on which the information in this object instance is applicable. | The student's latest date of instruction up to the current date. | day.date | M | |
| EndDay | Number of the last school day to which this object instance applies. | The instructional day number the student last attended. | day.date | M | |
| Resident | An indication as to whether or not the student's legal residence was within the boundaries of the school during the time between the StartDate and EndDate, inclusive. Note: No SIF_Query SIF_Condition support is required for this element. | When the enrollment Resident District is the same as the enrollment district, reports "Yes". When the enrollment Resident District is not the same as the enrollment district, reports "No". When the enrollment Resident District is null, reports "Unknown". | enrollment.residentDistrict | M | |
| FTE | Full time equivalent numeric value of the student's course load during the time between the StartDate and EndDate, inclusive. Expressed in decimal form, where 1.00 represents a full time enrollment. Deprecated in favor of using the StudentSchoolEnrollmentRefId element below. | Optional. Do not Report. | O | ||
| DaysAttended | The number of days the student attended school when school was in session between the StartDate and EndDate, inclusive. Note: No SIF_Query SIF_Condition support is required for this element. | The number of days attended MINUS excused and unexcused absences. Reports only for those days where the student is not marked No Show. | M | ||
| ExcusedAbsences | The number of days the student was absent from school with a valid excuse when school was in session between the StartDate and EndDate, inclusive. Note: No SIF_Query SIF_Condition support is required for this element. | Status of "A" For each period,
| attendanceExcuse.status OR attendance.status attendanceExcuse.excuse OR attendance.excuse | M | |
| UnexcusedAbsences | The number of days the student was absent from school without a valid excuse when school was in session between the StartDate and EndDate, inclusive. Note: No SIF_Query SIF_Condition support is required for this element. | Status of "A" Excuse of "U" or null Does not include days where the student has marked enrollment No Show. | attendanceExcuse.status OR attendance.status attendanceExcuse.excuse OR attendance.excuse | M | |
| DaysTardy | The number of days the student was tardy when school was in session between the StartDate and EndDate, inclusive. | Status of "T" Does not include days where the student has marked enrollment No Show. | attendanceExcuse.status OR attendance.status | O | |
| DaysInMembership | The number of days the student was present plus the number of days the student was absent when school was in session during the period between the StartDate and EndDate, inclusive. Note: No SIF_Query SIF_Condition support is required for this element. | Count of the number of instructional days the student was enrolled. (DaysAttended PLUS ExcusedAbsences and UnexcusedAbsences) | day.date | M | |
| StudentSchoolEnrollmentRefId | RefId (GUID) of the StudentSchoolEnrollment object instance that corresponds to this object instance. | enrollment.enrollmentId | O |
