This idea is being reposted from an idea that was closed and archived to Cold Storage. It had 8 votes and was created on July 18, 2018. Canvas Data Submissions - Include Historical Submissions
I'm proposing new tables: submission_historical_dim and submission_historical fact.
We need to be able to see each time a student submits an assignment - much like quizzes has the quiz_submission_historical tables, we need to be able to see ALL submissions from students. Some background is here..
But it is imperative to be able to back up student claims regarding assignments and each submission for various reasons - activity, attendance, plagiarism claims, etc.