Querying the Attendance Percentage by Period (APBP) using a date range created in Attendance Percentage Date Setting (APDS) 

  • Non Flex Schools



NOTE: The Attendance Percentage by Period (APBP) table is a Query Expansion Table for querying Period Attendance, and may be used in conjunction with the Attendance Percentage Date Setting (APDS) table to query by date range. The table does 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 must be changed by query, example:
    • CHANGE APDS SWH TO  09/01/2025
    • CHANGE APDS TWH TO  09/23/2025


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


APBP - Attendance Percentage by Period

  • LIST STU APBP STU.NM STU.ID STU.GR STU.CU STU.TP APBP.DS APBP.DE APBP.SE APBP.SM APBP.PD APBP.CO APBP.TE APBP.DY APBP.S1 APBP.DC APBP.EIC APBP.DAB APBP.DTY APBP.TNE APBP.PRS APBP.PNC 

Queries from APBP 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 Flex Schools, please view Querying the APFP/APFS Table using a Date Range