Canvas Data Submissions - Include FIRST assignment submission timestamp

Idea created by Joni Miller Expert on Feb 26, 2018
    Open for Voting
    • Amy Stuart
    • Joni Miller
    • Rob Ditto
    • Linda J. Lee
    • Michelle Franz
    • Margaret Taylor
    • Robert Sparrow

    I’m working on getting the assignment submission information into Starfish Early Alert system using Canvas Data.  I'm working with submission_dim and submission_fact trying to generate some data based on student submissions.  I see in the schema that submission_dim and submission_fact both have only information about the LATEST submission.  


    If there are multiple submisisons for an assignment/student/course:  


    I see the number of attempts but I can't find the first attempt date or timestamp.  There seems to be no way to see past submission information for assignments in canvas data - it only keeps the most recent submission's data.   I was advised by canvasdatahelp to submit this as a feature idea. 


    Could submissions_dim have a field added that includes the FIRST ATTEMPT DATE for the assignment?