Canvas Data Release Notes (2018-01-08)
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
| Name | Type | Description |
|---|---|---|
| score_id | bigint | Unique surrogate identifier for the score. |
| canvas_id | bigint | Primary key for the score |
| account_id | bigint | Foreign key to the Account group table. |
| course_id | bigint | Foreign key to the Course group table. |
| assignment_group_id | double precision | Foreign key to the Assignment group table. |
| enrollment_id | bigint | Foreign key to the Enrollment table. |
| current_score | double precision | Current score |
| final_score | double precision | Final score |
muted_current_score | double precision | Current Score that might not yet be public. Or is muted |
muted_final_score | double precision | Final score that might not yet be public. Or is muted |
course_score_fact
Table containing measures for overall course scores within Canvas grade book
| Name | Type | Description |
|---|---|---|
| score_id | bigint | Unique surrogate identifier for the score |
| canvas_id | bigint | Primary key for the score |
| account_id | bigint | Foreign key to the Account group table |
| course_id | bigint | Foreign key to the Course group table |
| enrollment_id | bigint | Foreign key to the Enrollment table |
| current_score | double precision | Current score |
| final_score | double precision | Final score |
| muted_current_score | double precision | Current Score that might not yet be public, or is muted |
| muted_final_score | double precision | Final 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
| Name | Type | Description |
|---|---|---|
| score_id | bigint | Unique surrogate identifier for the score |
| canvas_id | bigint | Primary key for the score |
| account_id | bigint | Foreign key to the Account group table |
| course_id | bigint | Foreign key to the Course group table |
| enrollment_id | bigint | Foreign key to the Enrollment table |
| grading_period_id | bigint | Foreign key to the grading period group table |
| grading_period_group_id | bigint | Foreign key to the grading period group table |
| grading_period_group_account_id | bigint | One hop ID to the Account table for the grading period group table |
| current_score | double precision | Current score |
| final_score | double precision | Final score |
| muted_current_score | double precision | Current Score that might not yet be public, or is muted |
| muted_final_score | double precision | Final 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
| Name | Type | Description |
|---|---|---|
| id | bigint | Unique surrogate identifier for the score |
| canvas_id | bigint | Primary key for the score |
| assignment_group_id | bigint | Foreign key to the assignment group table |
| enrollment_id | bigint | Foreign key to the Enrollment table |
| created_at | timestamp | Timestamp when record was created |
| updated_at | timestamp | Timestamp when record was last updated |
| workflow_state | varchar | workflow 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.
| Name | Type | Description |
|---|---|---|
| id | bigint | Unique surrogate identifier for the score |
| canvas_id | bigint | Primary key for the score |
| enrollment_id | bigint | Foreign key to the Enrollment table |
| created_at | timestamp | Timestamp when record was created |
| updated_at | timestamp | Timestamp when record was last updated |
| workflow_state | varchar | workflow 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.
| Name | Type | Description |
|---|---|---|
| id | bigint | Unique surrogate identifier for the score |
| canvas_id | bigint | Primary key for the score |
| enrollment_id | bigint | Foreign key to the Enrollment table |
| grading_period_id | bigint | Foreign key to the grading period group table |
| created_at | timestamp | Timestamp when record was created |
| updated_at | timestamp | Timestamp when record was last updated |
| workflow_state | varchar | workflow 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.
