With Flex Scheduling, how can I query student Course Attendance Records (CAR) for a specific teacher for Census Day?
Find the Local Staff ID Number on the Staff Page and replace XX with the ID.
LIST STU CAR MST SSE STF STU.ID STU.NM CAR.SN CAR.CN CAR.SE CAR.DS CAR.DE STF.ID STF.LN STF.FN SSE.PR SSE.STR IF STF.ID = XX AND ( CAR.DS <= 10/xx/20xx AND ( CAR.DE = NULL OR CAR.DE >= 10/xx/20xx ) ) AND SSE.STR = 1
- CAR.DS and CAR.DE date of 10/xx/20xx is the Census Date for the current year