There is a new option in Aeries that allows a school to calculate attendance totals based on period attendance. This option was added due to changes in attendance due to COVID. The option allows for period calculations to display in various areas such as the student profile and attendance history summary. This option will impact the CALPADS STAS extract by converting the period data (hourly) attendance/absence into Days that will be used when submitting STAS data to Calpads.
The option to enable this feature is available from the School Settings page within the school site that will be enabled. When this option is turned on, a 'true' value will be stored in the OPT table labeled Calc AttTotOnPA for the currently logged in school site.
Make sure you are logged into the school you are enabling, not the district database. This setting must be enabled on a school-by-school basis and can not be turned on districtwide via the District database. Upon logging into the school, go to the Navigation bar and select School Settings under Pages.
In the School Settings, check the box "Calculate Attendance Totals Based on Period Attendance".
The other location that can be used to enable this feature is under Attendance History Configuration. Once the option is enabled in either page, the setting will be actively enabled in the school and a check box will display in both pages.
To enable these settings from the Attendance History Configuration page, check the box "Calculate Attendance Totals Based on Period Attendance?" and select Save. Once the option is enabled in either page, the setting will be actively enabled in the school and a check box will display in both pages.
Next, select Update Attendance History - "Update All schools Now" button. This is necessary in order for the calculations to be updated in the Attendance History table (AHS). The process is a Long Running Process and will take some time to complete. An email will be sent to the user once the process has finished.
Once Attendance History has been calculated based on Period Attendance totals, various areas in Aeries will reflect the newly calculated information.
On the profile page, the Periods Present will display based on the period attendance totals.
Attendance History Summary
Additional information will display on this page to reflect the calculated period totals. For example, Periods Attended, Periods Absent Excused, Periods Absent Unexcused, etc.
Display Layout by Card:
Display Layout by Grid:
The Attendance Page will display minimal information for the student: Days Enrolled, Days with Truancies and Days Suspended.
Calpads STAS Extract
The Calpads STAS Extract will include period (hourly) attendance/absence converted into Days. The formula used to calculate this information are outlined in the following document.
The following fields in the Attendance History (AHS) table are used for the Period Attendance calculations:
PE Periods Expected to Attend
PA Periods Attended
POS Periods Absent, Out of School Suspension
PIS Periods Present, In-School Suspension
PAX Periods Absent, Excused
PAU Periods Absent, Unexcused
PIC Periods Complete Independent Study
PIN Periods Incomplete Independent Study
Below is an example of the period calculations for a student.
Student has enrollment for 1 week (5 days):
Student has a total of 25 periods where they are expected to attend (5 days * 5 periods)
Student has 3 periods marked as absent
Attendance History Query:
- EN = Days Enrolled
- PE = Periods Expected to Attend
- PA = Periods Attended
- PAU = Periods Absent Unexcused
Below is the calculation from the CALPADS Data Guide:
Days Attended PA/PE * EN 22/25 * 5 = 4.4
Days Absent Unexcused PAU/PE * EN 3/25 * 5 = .60
Below is a sample STAS Record for the example student: