In the regular Submission API there are fields for "excused", "missing", and "late". Is the "late" field also in Canvas Data anywhere? submission_dim has "workflow_state" which can give me missing, and "excused" to give me excused, but I don't see a field for "missing". I don't see anything on any other table either so far.
At first, I thought to just compare the submission time to the due date, but that doesn't take into account teachers overriding the flags directly in the gradebook, which at this point with remote learning and our students in and out of quarantine happens very frequently. The regular API is pulling the correct late status flag, any thoughts on how to get it to work in Canvas Data?