Querying the Attendance Percentage by Date Range (APDR) table using an Attendance Percentage Date Settings to create a date range: 


NOTE: The APDS and APDR tables are Query Expansion Tables for querying All Day Attendance Percentages. These tables do not exist in Aeries until they are created as referenced in this article: Aeries Query Expansion through SQL views and Custom Tables.



The Attendance Percentage Date Settings (APDS) table contains the date range information for the Attendance Percentage by Date Range (APDR) table. 


How to change the Start and End dates in the APDS table:

  • Start Date = APDS.SWH  
  • End date = APDS.TWH 
  • The date range must be changed by query, example:
    • CHANGE APDS SWH TO  09/01/2025
    • CHANGE APDS TWH TO  09/23/2025


Note: If no date settings are created, the results in APDR are year-to-date.


Now the APDR table may be queried for the date range that was just applied. Example Queries:


APDR 

Attendance Percentage by Date Range:

  • LIST STU APDR STU.ID STU.NM STU.GR APDR.SWH APDR.TWH APDR.APR  

Attendance Days Enrolled, Days Present, Days Absent, Attendance Percentage:


  • LIST STU APDR STU.ID STU.NM STU.GR APDR.SWH APDR.TWH APDR.DE APDR.DP APDR.DA APDR.APR 
These queries take awhile to render. Wait several minutes before the results will start to populate.



For Flex Schools, please view Querying the APFP and APFS Tables Using a Date Range