Querying the Attendance Percentage by Flex Period (APFP) and Attendance Percentage by Flex Summary (APFS) tables using a Date Range



NOTE: The Attendance Percentage by Flex Period (APFP) and Attendance Percentage by Flex Summary (APFS) tables are Query Expansion Tables for querying Flex Period Attendance, and may be used in conjunction with the Attendance Percentage Date Setting (APDS) table to query by date range. 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 Attendance Percentage Date Setting (APDS) table contains the Date Range information. How to change the Start and End dates in the APDS table:

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


Now the APFP and APFS tables may be queried for the date range that was just applied. Example Queries:


APFS - Attendance Percentage by Flex Summary

  • LIST STU APFS STU.ID STU.NM APFS.ENR APFS.DP APFS.PRC  


APFP - Attendance Percentage by Flex Period

  • LIST STU APFP STU.ID APFP.SE APFP.CN APFP.CO APFP.SWH APFP.TWH APFP.STI APFP.ENR APFP.DA APFP.DP APFP.PRC 



These queries tend to run long as an Aeries Query, so sending it to Excel is best. In the event that it produces nothing, it is likely that it exceeded the allowed time. Adding a filter for a particular grade level, a particular course, or section, can allow it to complete from Aeries Query to Excel.


For NON Flex Schools, please view Querying the APDR Table using a Date Range