StudentAttendanceSummary

StudentAttendanceSummary records are published for each student who is reported with a StudentPersonal record. StudentAttendanceSummary is calculated on each request and the sum of each day of attendance, membership, and absences is calculated, depending on the request. To fulfill t state requirements, the state may send a request with a specific end date, such as 10/1. The SIF Agent will calculate the data from the beginning of school until the date the state requests. For UnexcusedAbsences (truancies), the agent uses Attendance Tracking and Notification (ATN) in PowerSchool. To configure ATN, please contact PowerSchool Support.

Overriding

To override the automatic calculation of attendance, such as for Outplaced Students, a Student Attendance Summary record must exist for the student on the SAS tab of the State/Province page or the Student Attendance Summary report must be run. For the agent to use the manually created record, the School Year must be, for example, 2018 for the 2018-2019 year and the Start Date must be the same as the students Entry Date into the school.

Required Fields

StudentAttendanceSummary is specifically dependent on StudentPersonal.

Depends Upon

StudentPersonal

Events

This object does not support events. Data is pulled once a day by DESE at 2 AM.

Element Mappings for StudentAttendanceSummary

PS Field Mapping	SIF Element/Attribute	Req.	MA Field	Business Rules
	@RefId	M
	@SchoolInfoRefId	M
	@SchoolYear	M
	@StudentPersonalRefId	M
[Students] EntryDate or [StudentAttendanceSummary] StartDate	StartDate	M
Calculated or [StudentAttendanceSummary] StartDay	StartDay	M		A calculated field based on the number of InSession days between the beginning of school and the StartDate.
Requested by the state or [Students] ExitDate or[StudentAttendanceSummary] EndDate	EndDate	M		If the request from the state comes through with an EndDate, that is what is used here.
Calculated or [StudentAttendanceSummary] EndDay	EndDay	M		A calculated field based on the number of InSession days between the beginning of school and the EndDay.
[Students] MA_SAS_Resident or [StudentAttendanceSummary] Resident	Resident	M		If this value doesn't exist, the agent will send Yes.
Calculated or [StudentAttendanceSummary] DaysAttended	DaysAttended	M	DOE017	Calculated from the StartDate to the EndDate.
Calculated or [StudentAttendanceSummary] Membershipvalue	DaysInMembership	M	DOE018	Calculated from the StartDate until the EndDate. The agent sums the number of InSession days between the two dates.
Calculated or [StudentAttendanceSummary] ExcusedAbsences	ExcusedAbsences	M		Calculated from the StartDate until the EndDate. The agent sums the number of days that are marked as an absence and then subtracts the number of days that are marked as Unexcused Absences.
Calculated or [StudentAttendanceSummary] UnexcusedAbsences	UnexcusedAbsences	M	DOE052	Calculated from the StartDate until the EndDate. The agent sums the number of days that are marked as Unexcused Absences, based on the Attendance Tracking and Notification (ATN) setup.