Canvas Data Release Notes (2018-01-08)

Document created by Sydney McCann Employee on Jan 8, 2018Last modified by Sydney McCann Employee on Jan 9, 2018
Version 3Show Document
  • View in full screen mode

In this production release of Canvas Data, we have bumped to schema version 1.18.0 and have added a new set of score tables. The new schema has been attached to this post to help accommodate change. This change version will go live in January 23rd's data dump. New tables have been added to the Canvas Data Schema to help clarify scores that belong to an assignment group, course, or grading period.

 

The score_fact and score_dim tables are also being deprecated in order to accommodate the new score tables for more accurate reporting.

 

 

  Added Tables

 

assignment_group_score_fact

Table containing measures for Assignment Group scores within Canvas grade book

NameTypeDescription
score_idbigintUnique surrogate identifier for the score.
canvas_idbigintPrimary key for the score
account_idbigintForeign key to the Account group table.
course_idbigintForeign key to the Course group table.
assignment_group_iddouble precisionForeign key to the Assignment group table.
enrollment_idbigintForeign key to the Enrollment table.
current_scoredouble precisionCurrent score
final_scoredouble precisionFinal score

muted_current_score

double precisionCurrent Score that might not yet be public. Or is muted

muted_final_score

double precisionFinal score that might not yet be public. Or is muted

 

course_score_fact

Table containing measures for overall course scores within Canvas grade book

NameTypeDescription
score_idbigintUnique surrogate identifier for the score
canvas_idbigintPrimary key for the score
account_idbigintForeign key to the Account group table
course_idbigintForeign key to the Course group table
enrollment_idbigintForeign key to the Enrollment table
current_scoredouble precisionCurrent score
final_scoredouble precisionFinal score
muted_current_scoredouble precisionCurrent Score that might not yet be public, or is muted
muted_final_scoredouble precisionFinal score that might not yet be public, or is muted

 

grading_period_score_fact

Table containing measures for Grading Period scores within Canvas grade book

NameTypeDescription
score_idbigintUnique surrogate identifier for the score
canvas_idbigintPrimary key for the score
account_idbigintForeign key to the Account group table
course_idbigintForeign key to the Course group table
enrollment_idbigintForeign key to the Enrollment table
grading_period_idbigintForeign key to the grading period group table
grading_period_group_idbigintForeign key to the grading period group table
grading_period_group_account_idbigintOne hop ID to the Account table for the grading period group table
current_scoredouble precisionCurrent score
final_scoredouble precisionFinal score
muted_current_scoredouble precisionCurrent Score that might not yet be public, or is muted
muted_final_scoredouble precisionFinal score that might not yet be public, or is muted

 

assignment_group_score_dim

Attributes for Assignment Group scores. You can think of a score as synonymous with a cell inside the gradebook

NameTypeDescription
idbigintUnique surrogate identifier for the score
canvas_idbigintPrimary key for the score
assignment_group_idbigintForeign key to the assignment group table
enrollment_idbigintForeign key to the Enrollment table
created_attimestampTimestamp when record was created
updated_attimestamp

Timestamp when record was last updated

workflow_statevarcharworkflow state for the score. Possible values are 'active', 'deleted'

 

course_score_dim

Attributes for course scores. You can think of a score as synonymous with a cell inside the gradebook.

NameTypeDescription
idbigintUnique surrogate identifier for the  score
canvas_idbigintPrimary key for the score
enrollment_idbigintForeign key to the Enrollment table
created_attimestampTimestamp when record was created
updated_attimestampTimestamp when record was last updated
workflow_statevarcharworkflow state for the score.  Possible values are 'active', 'deleted'

 

grading_period_score_dim

Attributes for Grading Period scores. You can think of a score as synonymous with a cell inside the gradebook.

NameTypeDescription
idbigintUnique surrogate identifier for the  score
canvas_idbigintPrimary key for the score
enrollment_idbigintForeign key to the Enrollment table
grading_period_idbigintForeign key to the grading period group table
created_attimestampTimestamp when record was created
updated_attimestampTimestamp when record was last updated
workflow_statevarcharworkflow state for the score.  Possibe values are 'active', 'deleted'

 

 

  Changed Tables

Score_fact

This table is no longer populated in Canvas, and as such is no longer populating current data. This will be removed in a future version of Canvas Data, and all consumers should move off of this.

Score_dim

This table is no longer populated in Canvas, and as such is no longer populating current data. This will be removed in a future version of Canvas Data, and all consumers should move off of this.

3 people found this helpful

Attachments

Outcomes