Late and missing assignments: where is the data in CD2 Postgres db?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-04-2023
09:07 AM
Does anyone know which Canvas Data 2 database table(s) have assignment submission late / missing / excused flags?
I'm querying CD2 Postgres database for students who have late or missing assignment submissions. In the Canvas UI instructors can mark a submission late, missing or excused, or apply a late policy. In the Canvas Submissions API there are Boolean fields in the return object for late, missing and excused, but I do not see these fields in submissions table in CD2. Where is the submission status data in CD2? Thank you