Student Attendance Summary records are published for each student who is reported with a Student Personal record. Student Attendance Summary is calculated on each request, and the sum of each day of attendance, membership, and absences is calculated, depending on the request. To fulfill the 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 Unexcused Absences (truancies), the agent uses Attendance Tracking and Notification (ATN) in PowerSchool. To configure ATN, please contact PowerSchool Support.
This object provides a summary of a student's daily attendance and membership information for a given school during the time period between the StartDate and End Date, inclusive. There may be multiple instances of this object for a student in a school during the school year or reporting period.
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, 2025 for the 2025-2026 year and the Start Date must be the same as the students Entry Date into the school.
Selection Criteria
TBD
Dependency
StudentAttendanceSummary is specifically dependent on StudentPersonal.
Element Mappings for Student Attendance Summary
|
SIF Element/Attribute |
Description |
Req. |
PS Field Mapping: [Table]Column |
MA Field |
Business Rules |
|---|---|---|---|---|---|
|
@RefId |
A GUID that identifies an instance of this object. This RefId is a “transient” value. It must 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 |
|
|
|
|
@SchoolInfoRefId |
The Id (GUID) of the school for which this attendance information is being reported. |
M |
|
|
|
|
@SchoolYear |
The school year for which the information is applicable. |
M |
|
|
|
|
@StudentPersonalRefId |
The Id (GUID) of the student for whom this attendance information is being reported |
M |
|
|
|
|
StartDate |
The starting date on which the information in this object instance is applicable. |
M |
[Students] EntryDate or
|
|
|
|
StartDay |
The number of the first school day to which this object instance applies. |
M |
Calculated or [StudentAttendanceSummary] StartDay |
|
A calculated field based on the number of InSession days between the beginning of school and the StartDate. |
|
EndDate |
The ending date on which the information in this object instance is applicable. |
M |
Requested by the state or [Students] ExitDate or[StudentAttendanceSummary] EndDate |
|
If the request from the state comes through with an EndDate, that is what is used here. |
|
EndDay |
The number of the last school day to which this object instance applies. |
M |
Calculated or [StudentAttendanceSummary] EndDay |
|
A calculated field based on the number of InSession days between the beginning of school and the EndDay. |
|
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. |
M |
[Students] MA_SAS_Resident or [StudentAttendanceSummary] Resident |
|
If this value does not exist, the agent will send Yes. |
|
DaysAttended |
The number of days the student attended school when the school was in session between the StartDate and EndDate inclusive. |
M |
Calculated or [StudentAttendanceSummary] DaysAttended |
DOE017 |
Calculated from the StartDate to the EndDate. |
|
DaysInMembership |
The number of days the student was present plus the number of days the student was absent when the school was in session during the period between the StartDate and EndDate inclusive. |
M |
Calculated or [StudentAttendanceSummary] Membershipvalue |
DOE018 |
Calculated from the StartDate until the EndDate. The agent sums the number of InSession days between the two dates. |
|
ExcusedAbsences |
The number of days the student was absent from the school with a valid excuse when the school was in session between the StartDate and EndDate inclusive. |
M |
Calculated or [StudentAttendanceSummary] ExcusedAbsences |
|
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. |
|
UnexcusedAbsences |
The number of days the student was absent from the school without a valid excuse when the school was in session between the StartDate and EndDate inclusive. |
M |
Calculated or [StudentAttendanceSummary] UnexcusedAbsences |
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. |
|
StudentSchoolEnrollmentRefId |
RefId (GUID) of the StudentSchoolEnrollment object instance that corresponds to this object instance. |
O |
|
|
|
|
SIF_ExtendedElements |
|
O |
|
|
|
|
DaysAttendedRemote |
The number of days the student was in attendance in a remote instruction mode. |
M |
Calculated or [S_MA_SAS_X] RemoteAttendance |
|
RemoteAttendance |
|
DaysAbsentRemote |
The number of days the student was absent in a remote instruction mode. |
M |
Calculated or [S_MA_SAS_X] RemoteAbsent |
|
RemoteAbsent |