SIF v2.7 - StudentAttendanceSummary

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 TypeRequirement
Add/Change/DeleteN/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 LabelDescriptionBusiness RulesData Source GUI PathDatabase FieldM, C or O
@RefIdA 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
@StudentPersonalRefIdThe Id (GUID) of the student for whom this attendance information is being reported.

attendance.personIdM
@SchoolInfoRefIdThe Id (GUID) of the school for which this attendance information is being reported.

calendar.schoolIdM
@SchoolYearSchool year for which the information is applicable.

calendar.endYearM
StartDateThe 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.dateM
StartDayNumber of the first school day to which this object instance applies.The instructional day number the student first attended.
day.dateM
EndDateThe 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.dateM
EndDayNumber of the last school day to which this object instance applies.The instructional day number the student last attended.
day.dateM
ResidentAn 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.residentDistrictM
FTEFull 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
DaysAttendedThe 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
ExcusedAbsencesThe 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"
Excuse of "E"
Does not include days where the student has marked enrollment No Show.

For each period,

  1. Get the number of minutes the student was absent.
  2. Get GradeLevel standard day if it exists from the Grade Level that the student is enrolled in for this attendance record; otherwise get the calendar student day.
  3. Get the Period minutes minus passing minutes.
  4. If (2) does not equal (3) then get (3) multiply by the no. of non instructional period in the period schedule. Otherwise if (2) and (3) are both 0, use 360. Otherwise use (2). 

attendanceExcuse.status
OR attendance.status

attendanceExcuse.excuse OR
attendance.excuse
M
UnexcusedAbsencesThe 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
DaysTardyThe 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
DaysInMembershipThe 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.dateM
StudentSchoolEnrollmentRefIdRefId (GUID) of the StudentSchoolEnrollment object instance that corresponds to this object instance.

enrollment.enrollmentIdO