StudentAttendanceSummary
This object provides an inclusive summary of a student's daily attendance and membership information for a given school during the time period between the StartDate and EndDate. There may be multiple instances of this object for a student in a school over the school year. There will be one Student Attendance Summary per Enrollment record with corresponding Start and End Dates. The StudentAttendanceSummary is calculated using the same methods as the Statistical Summary report. Refer to the School Setup documentation to determine how to configure each school.
The Oklahoma SMP provides publishing capabilities for the following data object and its elements:
Element/@Attribute | Source | Table | Column | Business Rules |
|---|---|---|---|---|
@StudentPersonalRefId |
|
|
|
|
@SchoolInfoRefId |
|
|
|
|
@SchoolYear |
|
|
|
|
StartDate | Database | Students | EntryDate |
|
StartDay |
|
|
| Sum of the In Session days from the start of school to the StartDate. |
EndDate | Database | Students | ExitDate |
|
EndDay |
|
|
| Sum of the In Session days from the start of school to the EndDate. |
Resident |
|
|
| Hard coded to Yes. |
DaysAttended |
|
|
| The total number of days a student was in attendance. |
ExcusedAbsences |
|
|
| The total number of days a student was absent minus the number of Unexcused Absences.
|
UnexcusedAbsences |
|
|
| Unexcused Absences are based on Attendance Tracking and Notification. Refer to the School Setup documentation and PowerSchool Help to configure ATN. |
DaysInMembership |
|
|
| The total number of in session between the StartDate and EndDate. |
SIF_ExtendedElements/SIF_ExtendedElementName ["DaysTransportedEligibleStateAid"] | Database | S_OK_STU_X | TransportStatus | The sum total of days in attendance days if the TransportStatus equals 1 or 3. |
SIF_ExtendedElements/SIF_ExtendedElementName ["CalenderSummaryRefId"] |
|
|
|
|
SIF_ExtendedElements/SIF_ExtendedElementName ["StudentSchoolEnrollmentRefId"] |
|
|
|
|