This object provides a summary of a student’s attendance and membership information for a given school during the time period between the Start Date and End Date, inclusive. As such, there may be multiple instances of this object for a student in a school over the course of a school year.
This object can be published daily, and the data is certified twice in the school year. The first will be upon completion of the first nine-week reporting period; the second will be upon completion of the school year.
There will be one Student Attendance Summary per Enrollment record with corresponding Start and End Dates.
Selection Criteria:
-
Includes students with enrollment records in the current school year.
-
Honors the
state_excludefromreportingflag for both student and school. -
Includes Basis of Admission where
ALT_REPORT_CODE != 1from theps_common_codetable.-
Currently, excludes Pre-ISP, PK3, LTSS, and STSS Basis of Admission.
-
-
Aggregates attendance by enrollment period and calculates Days In Membership, Days Attended, Excused Absences, Unexcused Absences, and Days Transported Eligible State Aid.
-
For the first quarter: If today’s date is before January 1 of the current school year, use the First Day of the term and aggregate attendance through the Quarter 1 End Date (in S_OK_SCH_X table).
-
For the remainder of the year: If today’s date is on or after January 1 of the current school year, use the First Day of the term and aggregate attendance through the term’s Last Day.
-
Time Between Periods
This object is updated to correctly process the Time Between Periods feature to ensure accurate attendance calculation in the following scenarios:
-
When there is a record in the Attendance table, the student is marked present or absent.
-
When there is no record in the Attendance table, the student is present by default.
The update ensures passing time is included in attendance values, preventing miscounted absences.
The following table lists the elements that are published for this object:
|
Element Name or @Attribute |
Submission |
Definition |
Code Set, if applicable |
[Table]Field Mapping |
Business Rules |
|---|---|---|---|---|---|
|
@RefId |
Yes |
The Id (GUID) of this record. |
|
Derived |
|
|
@StudentPersonalRefId |
Yes |
The ID (GUID) of the student for whom this attendance information is being reported. |
|
Derived based on [Students]DCID |
|
|
@SchoolInfoRefId |
Yes |
The ID (GUID) of the school for which this attendance information is being reported. |
|
Derived based on [Schools]DCID |
The RefId for the School associated with this StudentAttendanceSummary. The state expects multiple StudentAttendanceSummary objects for a single student if multiple Enrollments exist for that student during the reporting period. The RefId must contain hyphens. Example: F4AABF042-EAD4-781A-9AA2-0BF64C4EDAC |
|
@SchoolYear |
Yes |
School year for which the information is applicable. |
|
Current School Year |
|
|
StartDate |
Yes |
The starting date on which the information in this object instance is applicable. |
|
[Terms]FirstDay [Calendar_Day]Date_Value [Students]EntryDate |
|
|
StartDay |
Yes |
Number of the first school day to which this object instance applies. |
|
[Calendar_Day]InSession [Calendar_Day]Date_Value [Terms]FirstDay |
The number of the school day will reflect actual instructional days and exclude professional days and holidays. |
|
EndDate |
Yes |
The ending date on which the information in this object instance is applicable. |
|
[Terms]LastDay [Calendar_Day]Date_Value [Students]ExitDate |
|
|
EndDay |
Yes |
Number of the last school day to which this object instance applies. |
|
[Calendar_Day]InSession [Calendar_Day]Date_Value [Terms]LastDay |
The number of the school day will reflect actual instructional days and exclude professional days and holidays. |
|
Resident |
Yes |
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. |
|
Students Reenrollments |
Default value is Yes
|
|
DaysAttended |
Yes |
The number of days the student attended school when school was in session between the StartDate and EndDate, inclusive. |
|
Calculated |
|
|
ExcusedAbsences |
Yes |
The number of days the student was absent from school with a valid excuse when school was in session between the StartDate and EndDate, inclusive. |
|
Calculated |
|
|
UnexcusedAbsences |
Yes |
The number of days the student was absent from school without a valid excuse when school was in session between the StartDate and EndDate, inclusive. |
|
Calculated |
|
|
DaysInMembership |
Yes |
The number of days the student was present plus the number of days the student was absent when school was in session during the period between the StartDate and EndDate, inclusive. |
|
Calculated |
|
|
StudentSchoolEnrollmentRefId |
Yes |
RefId (GUID) of the StudentSchoolEnrollment object instance that corresponds to this object instance. |
|
Derived |
The RefId for the StudentSchoolEnrollment associated with this StudentAttendanceSummary. The state expects multiple StudentAttendanceSummary objects for a single student if multiple StudentSchoolEnrollment objects exist for that student during the time period requested. The RefId must contain hyphens. Example: F4AABF042-EAD4-781A-9AA2-0BF64C4EDAC |
|
SIF_ExtendedElements/SIF_ExtendedElementName |
|
|
|
|
|
|
SIF_ExtendedElements/ SIF_ExtendedElementName= “DaysTransportedEligibleStateAid” |
Yes |
Total should be for the reporting period between the StartDate and EndDate inclusive. |
|
Calculated |
|
|
SIF_ExtendedElements/ SIF_ExtendedElementName= ”CalendarSummaryRefId” |
Yes |
The RefId for the CalendarSummary object associated with this enrollment. |
|
Derived |
The RefId must contain hyphens. Example: F4AABF042-EAD4-781A-9AA2-0BF64C4EDAC |