Grades and assessment

Rubrics Edit data set: columns, keys and joins

Primary key: AuditLogId 12 columns

Checked against D2L on October 31, 2026

Back to the map

Columns

Column	Type	Size	Key
`AuditLogId`	`uniqueidentifier`	`16`	PK
`RubricId`	`bigint`	`8`	FK
`CriterionId`	`bigint`	`8`	FK
`LevelId`	`bigint`	`8`	FK
`ModifiedBy`	`int`	`4`
`ModifiedObjectType`	`int`	`4`
`CriteriaGroupId`	`bigint`	`8`
`ModifiedDate`	`datetime2`	`8`
`PreviousValue`	`nvarchar`	`4000`
`ModifiedValue`	`nvarchar`	`4000`
`IsLocked`	`bit`	`1`
`Version`	`int`	`4`

Joins to (3)

Rubric Object CriteriaCriterionId → CriterionId
Rubric Object LevelsLevelId → LevelId
Rubric ObjectsRubricId → RubricId

Joined from (0)

None

Edit history links

None

Source

Source: Rubrics data sets on the D2L Brightspace Community