Brightspace Data Sets for Rubrics have a dependency on Rubrics. If you turn this tool on and off during the data set query period, there may be unexpected or missing content in your data sets.
Entity Relationship Diagram
The following diagram shows the relationships between entities used to create Brightspace Data Sets for Rubrics. To enlarge the diagram, right-click on the image and select Open image in a new tab.
Rubric Assessment
The Rubric Assessment Brightspace Data Set returns rubric outcomes that are associated with a competency. Includes incomplete rubric assessments, which have a null LevelAchieved value.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 1.0 |
RubricId
|
Unique rubric identifier
|
bigint
|
8
|
FK
|
| 1.0 |
OrgUnitId
|
Unique org unit identifier
|
int
|
4
|
FK
|
| 6.8 - Updated key |
UserId
|
Unique user identifier
|
int
|
4
|
PK, FK
|
| 5.7 / 6.0 - Changed Column Size |
Score
|
Rubric score.
Field can be null.
|
decimal
|
36, 2
|
|
| 1.0 |
AssessedByUserId
|
Rubric assessed by.
Field can be null.
|
int
|
4
|
FK
|
| 1.0 |
AssessmentDate
|
Date the rubric was assessed (UTC).
|
datetime2
|
8
|
|
| 1.0 |
IsCompleted
|
Is rubric assessment complete.
|
bit
|
1
|
|
| 5.7 / 6.0 - Changed Column Size |
ActivityType
|
Activity type associated with the rubric.
Field can be null.
|
nvarchar
|
50
|
|
| 1.0 |
ActivityObjectId
|
Identifier of the activity associated with the rubric.
Field can be null.
|
bigint
|
8
|
FK
|
| 1.0 |
DateCreated
|
Date rubric was created (UTC).
|
datetime2
|
8
|
|
| 1.0 |
AssessmentId
|
Unique assessment ID.
|
bigint
|
8
|
PK
|
| 5.5 |
LevelAchievedId |
Unique rubric level achieved identifier.
Field can be null.
|
bigint |
8 |
|
Rubric Assessment Criteria
The Rubric Assessment Criteria Brightspace Data Set returns details for all rubric criteria in rubrics.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 1.0 |
AssessmentId
|
Unique assessment ID
|
bigint
|
8
|
PK, FK
|
| 5.6 - Updated PK |
UserId
|
Unique user identifier
|
int
|
4
|
PK, FK
|
| 5.6 - Updated FK |
RubricId
|
Unique rubric ID
|
bigint
|
8
|
FK
|
| 4.8 / 5.2 - Updated column size |
Score
|
Rubric score the user achieved on a criterion.
Field can be null.
|
decimal
|
19, 9
|
|
| 1.0 |
Feedback
|
Feedback for that criterion.
Field can be null.
|
nvarchar
|
1000
|
|
| 1.0 |
IsScoreOverridden
|
Is score overridden by instructor
|
bit
|
1
|
|
| 4.9 / 5.3 - Updated PK |
CriterionId |
Unique criterion identifier |
bigint |
8 |
PK, FK |
| 5.5 |
LevelAchievedId |
Unique rubric level achieved identifier.
Field can be null.
|
bigint |
8 |
|
| 5.7 / 6.0 |
Version |
Indicates the version of the row. This information is used to determine which table row occurred first, similar to the way time stamps function in other data sets. |
bigint |
8 |
|
Rubric Criteria Levels
The Rubric Criteria Levels Brightspace Data Set returns the details for all rubric criteria and associated levels where they exist.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 4.9 / 5.3 - Corrected PK |
RubricId
|
Unique rubric identifier
|
bigint
|
8
|
PK
|
| 4.9 / 5.3 - Corrected PK |
CriterionId
|
Identifier for the criterion associated with the rubric levels
|
bigint
|
8
|
PK
|
| 2.0 |
Description |
Description of the criterion.
Field can be null.
|
nvarchar |
1000 |
|
| 2.0 |
Feedback |
Automated feedback provided by the rubric for the rubric criterion.
Field can be null.
|
nvarchar |
1000 |
|
| 2.0 |
Value |
Value assigned to the criterion in the rubric. This is populated based on the rubric type and the scoring method.
Field can be null
|
decimal |
19, 9 |
|
| 2.0 |
LevelId |
Identifier of the level associated with the criterion |
bigint |
8 |
PK |
| 2.0 |
IsDeleted
|
Set to true if the criterion has been deleted
|
bit
|
1
|
|
Rubric Objects
The Rubric Objects Brightspace Data Set returns information about the rubric properties.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 1.7 |
RubricId
|
Unique rubric Identifier
|
bigint
|
8
|
PK
|
| 5.7 / 6.0 - Changed Column Size |
Name
|
Name of the rubric
|
nvarchar
|
256
|
|
| 5.7 / 6.0 - Changed Column Size |
RubricStatus
|
Status of the rubric.
Field can be null.
|
nvarchar
|
256
|
|
| 1.7 |
Description
|
Description of the rubric object.
Field can be null.
|
nvarchar
|
1000
|
|
| 5.7 / 6.0 - Changed Column Size |
RubricType
|
Type of rubric used.
Field can be null.
|
nvarchar
|
256
|
|
| 5.7 / 6.0 - Changed Column Size |
ScoringMethods
|
Type of scoring methods used.
Field can be null.
|
nvarchar
|
256
|
|
| 1.7 |
IsScoreVisible
|
Is the rubric score visible
|
bit
|
1
|
|
| 1.7 |
OrgUnitID
|
Org unit identifier associated with the rubric
|
int
|
4
|
FK
|
| 1.7 |
IsShared
|
Set to true if the Rubric object is shared
|
bit
|
1
|
|
| 1.7 |
IsDeleted
|
Set to true if the rubric object is deleted
|
bit
|
1
|
|
Rubric Object Criteria
The Rubric Object Criteria Brightspace Data Set returns information about the rubric criteria within a rubric.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 1.7 |
RubricId
|
Unique rubric identifier
|
bigint
|
8
|
FK
|
| 1.7 |
CriterionId
|
Identifier for the criterion associated with the rubric levels
|
bigint
|
8
|
PK
|
| 9.12 - Size updated |
Name
|
Name of the criterion.
|
nvarchar
|
500
|
|
| 1.7 |
SortOrder
|
Sort order by which the criteria is listed
|
int
|
4
|
|
| 2.0 - field name updated |
CriteriaGroupId
|
Identifier for the criterion group to which the criterion belongs
|
bigint
|
8
|
|
| 2.0 - field name updated |
GroupName |
Name of the criterion group. |
nvarchar |
256 |
|
| 2.0 - field name updated |
GroupSortOrder |
Sort order assigned to the criterion group |
int |
4 |
|
| 1.7 |
LevelSetId
|
Identifier of the Level Set to which the level belongs
|
bigint
|
8
|
FK
|
| 1.7 |
IsDeleted
|
Set to true if the Level Set, Criterion Group or Criterion has been deleted
|
bit
|
1
|
|
Rubric Object Levels
The Rubric Object Levels Brightspace Data Set returns information about the rubric levels in a rubric criteria.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 1.7 |
RubricId
|
Unique rubric Identifier
|
bigint
|
8
|
FK
|
| 1.7 |
LevelId
|
Identifier for the level associated with the rubric
|
bigint
|
8
|
PK
|
| 5.7 / 6.0 - Changed Column Size |
Name |
Name of the level |
nvarchar
|
256 |
|
| 1.7 |
Description |
Description of the level.
Field can be null.
|
nvarchar |
1000 |
|
| 1.7 |
Feedback |
Automated feedback provided by the rubric for the corresponding level.
Field can be null.
|
nvarchar
|
1000 |
|
|
4.8 / 5.2 - Updated column size
|
Value |
Value assigned to the level. This is populated based on the rubric type and scoring method.
Field can be null.
|
decimal |
19, 9 |
|
|
4.8 / 5.2 - Updated column size
|
RangeStartValue |
Level range start value which is populated based on the rubric type and scoring method.
Field can be null.
|
decimal |
19, 9 |
|
| 1.7 |
SortOrder |
Sort order for the levels |
int |
4 |
|
| 1.7 |
LevelSetId |
Identifier for the level set to which the level belongs |
bigint |
8 |
FK |
| 1.7 |
IsDeleted
|
Set to true when Level Set or Level have been deleted.
Field can be null.
|
bit
|
1
|
|
Rubrics Edit
In the Rubrics Edit Brightspace Data Set, each row represents one element of a rubric that was changed by a permissioned user. If multiple elements are changed in the same rubric, multiple data rows will appear in the data set.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 7.12 |
AuditLogId
|
Unique identifier
|
uniqueidentifier
|
16
|
PK
|
| 7.12 |
RubricId
|
Unique rubric identifier
|
bigint
|
8
|
FK
|
| 7.12 |
CriterionId |
Identifier for the criterion row of the rubric.
Field can be null.
|
bigint
|
8 |
FK |
| 7.12 |
LevelId |
Identifier for the evaluation level of the rubric.
Field can be null.
|
bigint |
8 |
FK
|
| 7.12 |
ModifiedBy |
ID of the user who last modified this item
|
int
|
4 |
|
| 7.13 - Updated field name |
ModifiedObjectType |
Rubric element that has been edited. Refer to Modified Object Type Lookup for details. |
int |
4 |
|
| 7.12 |
CriteriaGroupId |
Identifier for the criterion group to which the criterion belongs.
Field can be null.
|
bigint |
8 |
|
| 7.12 |
ModifiedDate |
The date when this item was modified (UTC) |
datetime2 |
8 |
|
| 7.13 - Updated column size |
PreviousValue |
The value of the object prior to the modification.
|
nvarchar |
4000 |
|
| 7.13 - Updated column size |
ModifiedValue
|
The value of the object after the modification.
|
nvarchar
|
4000
|
|
| 7.12 |
IsLocked |
The locked status of the rubric at the time of the modification |
bit |
1 |
|
| 8.7 |
Version |
Incrementing sequence number to keep track of edits that were made during the same session. |
int |
4 |
|
Modified Object Type Lookup
The following table contains all possible ModifiedObjectType values and their corresponding rubric element:
ModifiedObjectType
|
Rubric Element |
|---|
| 1 |
Level Name
|
| 2 |
Criterion Name
|
| 3 |
Criterion Group Name
|
| 4 |
Criteria Level Description |
| 5 |
Criteria Level Initial Feedback |
| 6 |
Overall Level Name |
| 7 |
Overall Level Initial Feedback |