Good morning ,
I'm new to this position and I'm having a hard time running this query. How would this look as a query? At the moment all I'm getting back is "query does not produce any reports" Thank you for the help.
The query they provided is a SQL query so it has to be ran in a SQL environment. The query in Aeries is not SQL. If you are hosted, Aeries should be able to run this for you.
The second query results show our continuation school. This school is positive attendance. Do I need to wait for the update and resubmit? Thanks
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.
That SQL script should be run on the 21/22 database, correct? Since that's the year we pulled from?
Yes Denise, that is correct. The SQL query should be run on the 2021/2022 database.
Thanks! All clear here.
Following as I have a school that is found by "second issue" query.
How about those districts with negative attendance totals that don't use the Calculate Attendance Totals Based on Period Attendance option?
Negative attendance schools that don't use the Calculate Attendance Totals Based on Period Attendance option are OK.
I am currently having issues with negative schools that don't use the calculate attendance totals based on period attendance option. I have many students with negative attendance. This has been an issue for me since EOY reporting. I checked my ISP codes and they match the Aeries documentation with the exception of having check marks for showing on reports. I have ticket # 328577 in for this issue. I don't know what else to do.
I will check out your ticket.
Is the CDE going to allow us to submit our files after the deadline?
Since this is due Friday, what are we supposed to do about our positive hourly attendance schools that are found when running the 2nd query? All of these schools found in Issue 2 are showing little to no data when pulling the monthly files.
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
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'
Verify School Options settings:
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.
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'
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.
1 person likes this