Querying the Attendance Percentage by Date Range (APDR) table using a Date Range - 

NON Flex Schools



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



The APDS table contains the Date information for the 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/2024 
    • CHANGE APDS TWH TO  09/23/2024 


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 ID NM GR APDR SWH TWH APR  


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