To Query students that are present in a specific period on a specific date:

In a school using Negative Attendance, a blank attendance field is associated to not absent (present by default).  Blank attendance fields cannot be queried because there is no code associated with a blank. Additionally, the CAT.DT field remains blank when a student is not marked absent for a given period. 

1. Run a SKIP query to skip students that were absent in the specific Flex Period on the specific date

• SKIP STU SEC MST CAT FTF IF FTF.STI = 'P1' AND ( CAT.SE = MST.SE ) AND CAT.DT = 07/25/2025
  • In this query, P1 represents the specific Flex Period Short Title that is being queried. It will need to be replaced with the district's Short Title for the specific Flex Period being queried
  • The date will need to be changed to the specific date being queried

2. Run a LIST query to view the list of students remaining after the SKIP query. These are students that were not marked absent in the specific Flex Period

• Example:  LIST STU ID NM GR