PowerSchool SIS Iowa

Student Attendance Summary

Events

Add, Change, and Delete events are supported.

Dependencies

Requires StudentPersonal, SchoolInfo, and StudentSchoolEnrollment records.

Element Mappings

Element Name or @Attribute

Submission

Definition

Code Set, if applicable

[Table]Field Mapping

Business Rules

RefId

Required

Unique attendance-summary identifier.


[CST_PUBPUBLISHED_TMP]SIFREFID


StudentPersonalRefId

Required

Student reference.


Attendance-summary staging value


SchoolInfoRefId

Required

School reference.


Attendance-summary staging value


SchoolYear

Required

Academic school year.


Attendance-summary staging value


StartDate

Required

Start date of the attendance period.


Attendance-summary staging value


StartDay

Required

Starting day number.


Attendance-summary staging value


EndDate

Required

End date of the attendance period.


Attendance-summary staging value


EndDay

Required

Ending day number.


Attendance-summary staging value


Resident/value

Required

Resident indicator.

Yes, No

Attendance-summary staging value


DaysAttended

Required

Number of days attended.


Attendance aggregation


ExcusedAbsences

Required

Number of excused absences.


Attendance aggregation


UnexcusedAbsences

Required

Number of unexcused absences.


Attendance aggregation


DaysInMembership

Required

Number of membership days.


Enrollment and attendance aggregation


StudentSchoolEnrollmentRefId

Optional

Related school-enrollment reference.


StudentSchoolEnrollment RefId