StudentAttendanceSummary
The StudentAttendanceSummary SIF Object is a record of each student's enrollment for each school in the zone. StudentAttendanceSummary requires that Attendance Code, Attendance Conversions, and Attendance Tracking and Notification has been setup correctly for each school. Also, each student's entry date must be on or after the first day of school. If the entry date is before, the PowerSchool attendance will not be calculated correctly.
Events
Events are not supported for StudentAttendanceSummary.
Element Mappings for StudentAttendanceSummary
PS Field Mapping | SIF Element/Attribute | Req. | IA Field | Business Rules |
@StudentPersonalRefId | M | Auto Generated. | ||
@SchoolInfoRefId | M | Auto Generated. | ||
@SchoolYear | M | Auto Generated. | ||
Students.EntryDate | StartDate | M | MTSS | If the student's EntryDate is before the first day of school, then the agent will get the First Day of school and use that as the start date, otherwise, the EntryDate will be used. If a students entry date is before the first day of school, there will be issues with the calcuations. |
Calendar_Day.InSession | StartDay | M | MTSS | Total number of InSession Days between the Start of School and the StartDate. |
Students.ExitDate ReEnrollments.ExitDate | EndDate | M | MTSS | If the requested date is before today, then this will be the requested date. If the student has exited, then this will be the exit date of the student. Otherwise, this will be the current date. |
Calendar_Day.InSession | EndDay | M | MTSS | Total number of InSession Days between the Start of School and the EndDate. |
Resident | M | MTSS | Based on District Of Residence. If the value is null or equals the same value as the District Number, then Yes is published. Otherwise, No is published. | |
PS_AdaAdm_Defaults_All.AttendanceValue | DaysAttended | M | D0510 | This is the sum of attendance days that are > 0 in Attendance. If the attendance value is > .5, then attendance will be 1. If the attendance is between 0 and .5, then attendance will be .5. Otherwise, attendance will be 0. |
ExcusedAbsences | M | MTSS | Excused Absencs are the difference between the total Membership, the Unexcused Absences and the number of days Attended. | |
Based on ATN Unexcused Setup. | UnexcusedAbsences | M | MTSS | This is the sum of records in the UnexcusedHistorical table that have a RecType of 'TA' and a category of Unexcused. This comes from Attendance Tracking and Notification. |
PS_AdaAdm_Defaults_All.MembershipValue | DaysInMembership | M | D0500 | Total number of potential attendance days between the StartDate and EndDate. |
StudentSchoolEnrollmentRefId | M | MTSS | Auto Generated. |