Support

9/28/2022 UPDATE:  The ISAC submission has been extended  to October 7 per the CDE.

ISSUE 2 - FIXED with the 9/28/2022 Update 

Note:  These fixes could impact the ISAC submission.  To ensure STAS totals are correct, this Aeries update needs to be applied and the Aeries California - P-EBT Submission process will need to be run again to ensure the correct Attendance History totals are submitted in the CALPADS STAS file.

Revision Note:  Attendance History Configuration - Calculated period attendance data was not populated for some students in the Attendance History Summary (AHS) table when the process was run with a specified date range, fixed.

Note:  The following School Configurations were effected by this change:

• When a school was configured in the following way

  • The Education Type was set to Alternative Education in School Options

    • LOC.TY = 1

  • Attendance Reporting was set to Positive in School Options

    • LOC.B = 1

OR

• When the Calculate Attendance Totals Based on Period Attendance option is enabled

  • All Schools using Period attendance.

  • The Calculate Attendance Totals Based on Period Attendance option is defined within the School Options (OPT) Table:

    • OPT.NM = "Calc AttTotOnPA" and OPT.CD = 'True'

For more information please see our knowledge base article pertaining to Alternative Education with Positive Attendance.

CALPADS Extracts - STAS file extracts were omitting students because the data created with the Attendance History Configuration process was miscalculated, fixed.

ISSUE 1 - FIXED with the 9/26/2022 Update

Revision Notes:   Attendance History Configuration - For Flex schools with negative period attendance, the counts for periods present and unexcused absences were incorrect, fixed. 

Attendance History Totals (AHS) were incorrect for schools with the following configuration: Flex, Period, Negative Attendance using the School Setting of “Calculate Attendance Totals Based on Period Attendance” option.

To find out if this issue impacts your district, The following Aeries Query can be run in your 2021/2022 database:

LIST OPT NM SC CD IF NM =  'Calc AttTotOnPA' AND OPT.CD = 'TRUE' 

AND 

Verify School Options settings:

Self-Hosted Districts: 

If the BOTH conditions above produce a school that was reported in the ISAC submission, the Aeries update that ships today needs to be applied and the Aeries California - P-EBT Submission process will need to be run again to ensure the correct Attendance History totals are submitted in the CALPADS STAS file. 

Hosted Districts;

If the BOTH conditions above produce a school that was reported in the ISAC submission, the Aeries California - P-EBT Submission process will need to be run again on the latest update available 9/27/2022 to ensure the correct Attendance History totals are submitted in the CALPADS STAS file. 

The following SQL query can be run in your 2021/2022 database to find out if this issue impacts your district: 

SELECT LOC.CD, LOC.NM, LOC.E, LOC.B, LOC.A, OPT.*

FROM LOC INNER JOIN OPT ON LOC.CD = OPT.SC

WHERE LOC.DEL = 0 AND OPT.DEL = 0

AND LOC.E = '3'

AND LOC.B = '0'

AND LOC.A = '1'

AND OPT.NM = 'Calc AttTotOnPA'

AND OPT.CD = 'TRUE'

ISSUE 3

Negative numbers have been reported when submitting to the ISAC system.  Please confirm that the Absence Codes for Independent Study have been configured correctly.

Please refer to this document.  

https://support.aeries.com/support/solutions/articles/14000070596-independent-study-absence-and-code-configurations

Hi Maritza,

As of right now, the update only has the fix for the first issue:  Flex, Period, Negative Attendance using the School Setting of “Calculate Attendance Totals Based on Period Attendance” option.

Programming is looking into the second issue now that impacts Secondary, Period, Positive schools.  This issue is that not all the students are extracting in the STAS extract for the Attendance History date ranges.

We will update when we know more.

Yes Denise, that is correct.  The SQL query should be run on the 2021/2022 database. 

Hi Dana,

Negative attendance schools that don't use the Calculate Attendance Totals Based on Period Attendance option are OK.