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



NOTE: The APDS, APFP and APFS 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 APFP and APFS tables. 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 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 


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