In a Flex Scheduling School, the CAT (Class Attendance) table is used to list and total period attendance. It’s designed to store attendance codes entered for each period, which are saved by section number. This allows for a more granular tracking of student attendance per period rather than just all-day attendance.



NOTE: When querying for period attendance, it’s important to note that joining the CAT (Class Attendance) table with the ATT (Attendance Data) table will result in only including records where an all-day attendance code is present, due to the way the ATT.AL field is populated. Therefore, including the ATT table in a list or total period attendance without all-day codes, should be avoided for accuracy.




A Student Period Attendance

  • LIST STU SEC MST FTF CAT STU.ID STU.LN STU.FN CAT.SCL CAT.DT CAT.AC FTF.STI BY STU.LN CAT.DT FTF.STI IF CAT.SE = SEC.SE AND STU.ID = XXXXXX
  • TOTAL STU SEC MST FTF CAT STU.ID STU.LN STU.FN CAT.AC FTF.STI BY STU.LN STU.FN FTF.STI CAT.AC STU.ID IF  CAT.SE = SEC.SE AND STU.ID = XXXXXX 


All Students Period Attendance

  • TOTAL STU SEC MST FTF CAT STU.ID STU.LN STU.FN CAT.AC FTF.STI BY STU.LN STU.FN FTF.STI CAT.AC STU.ID IF  CAT.SE = SEC.SE


All Period Attendance by Period

  • TOTAL STU SEC MST FTF CAT STU.ID STU.LN STU.FN CAT.AC FTF.STI BY STU.LN STU.FN FTF.STI CAT.AC STU.ID IF  CAT.SE = SEC.SE