Discrepancy Between Course and Grading Standards

[JimEgan]

In the CD2 data I'm working with I have noticed that a course in the Courses table has a NULL value for the Grading_Standard_ID column.  However, in the Grading_Standards table there is a row where the Context_ID column has the ID of the course.

Is this something that a user could have messed up?  Or is Canvas not keeping the two tables in sync?

To provide some context, I have 4,072 courses where the above situation is present.  This is out of a total population of 92,000 rows in the Courses table.

I also found one example where the course has a NULL value for Grading_Standard_ID and there are two rows in the Grading_Standards table that reference the course.

[amcdona · Accepted solution]

The checkbox on the course settings will toggle the value between null and the GRADING_STANDARD_ID

The not currently associated rows in GRADING_STANDARDS are available to be selected (workflow_state = active) but are not in use at the moment.

[JimEgan]

If the grading standard row is no longer "assigned" then it would seem logical to me that the Context_ID column would be set to NULL.  Except that it's a NOT NULL column, so it's left "hanging" there.

Anyhow, thank you for the screenshot that shows the application perspective.