Brightspace Data Sets for Rubrics

Brightspace Data Sets for Rubrics include:

These data sets 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

To show the relationships between entities used to create Brightspace Data Sets for Rubrics, click the following thumbnail image:

Entity Relationship Diagram for Rubrics

 

Brightspace Data Set: Rubric Assessment Criteria

About

Returns details for all rubric criteria in rubrics.

Data Set Availability

This data set is available as:

  • Full CSV, produced on a weekly basis, containing all of the data.
  • Differential CSV, produced on a daily basis or hourly basis as a paid add-on, containing the differences (diffs) of the data that was updated or inserted since the last successful differential which is typically the previous day or hour, respectively.

Returned Fields

Version History

Field

Description

Type

Column Size

Key

2.5/3.0 - Removed FK

AssessmentId

Unique assessment ID

BigInteger

8

PK

1.0

UserId

Unique user identifier

Integer

4

FK

4.9 / 5.3 - Corrected PK

RubricId

Unique rubric ID

BigInteger

8

PK

4.8 / 5.2 - Updated column size

Score

Rubric score the user achieved on a criterion. Field can be null

Numeric

19, 9

 

1.0

LevelAchieved

Rubric level if criterion was achieved

nvarchar

512

 

1.0

Feedback

Feedback for that criterion

nvarchar

Truncated to 1000 characters. To change the default value, contact D2L.

 

1.0

IsScoreOverridden

Is score overridden by instructor

Boolean

1

 

4.9 / 5.3 - Updated PK CriterionId Unique criterion identifier BigInteger 8 PK
5.5 - Added LevelAchievedId Unique rubric level achieved identifier. Field can be null. BigInteger 8  

 

Brightspace Data Set: Rubric Assessment

About

Returns rubric outcomes that are associated with a competency. Includes incomplete rubric assessments, which have a null LevelAchieved value.

Data Set Availability

This data set is available as:

  • Full CSV, produced on a weekly basis, containing all of the data.
  • Differential CSV, produced on a daily basis or hourly basis as a paid add-on, containing the differences (diffs) of the data that was updated or inserted since the last successful differential which is typically the previous day or hour, respectively.

Returned Fields

Version History

Field

Description

Type

Column Size

Key
1.0

RubricId

Unique rubric identifier

BigInteger

8

FK

1.0

OrgUnitId

Unique org unit identifier

Integer

4

FK

1.0

UserId

Unique user identifier

Integer

4

FK

1.0

RubricName

Rubric name

nvarchar

512

 

4.8 / 5.2 - Updated column size

Score

Rubric score. Field can be null.

Numeric

19, 9

 

4.10 / 5.4 - Updated description

LevelAchieved

Rubric level achieved. Field can be null.

nvarchar

512

 

1.0

AssessedByUserId

Rubric assessed by. Field can be null.

Integer

4

FK

1.0

AssessmentDate

Date the rubric was assessed (UTC).

DateTime

8

 

1.0

IsCompleted

Is rubric assessment complete.

Boolean

1

 

1.0

ActivityType

Activity type associated with the rubric. Field can be null.

nvarchar

100

 

1.0

ActivityName

Activity name associated with the rubric. Field can be null.

nvarchar

2000

 

1.0

ActivityObjectId

Identifier of the activity associated with the rubric.

BigInteger

8

FK

1.0

DateCreated

Date rubric was created (UTC).

DateTime

8

 

1.0

AssessmentId

Unique assessment ID.

BigInteger

8

PK

5.5 - Added LevelAchievedId Unique rubric level achieved identifier. Field can be null. BigInteger 8  

 

Brightspace Data Set: Rubric Objects

About

The Rubric Objects data set returns information about the rubric properties.

Data Set Availability

This data set is available as:

  • Full CSV, produced on a weekly basis, containing all of the data.
  • Differential CSV, produced on a daily basis or hourly basis as a paid add-on, containing the differences (diffs) of the data that was updated or inserted since the last successful differential which is typically the previous day or hour, respectively.

Returned Fields

Version History

Field

Description

Type

Column Size

Key

1.7

RubricId

Unique rubric Identifier

BigInteger

8

PK

1.7

Name

Name of the rubric

nvarchar

512

 

1.7

RubricStatus

Status of the rubric

nvarchar

512

 

1.7

Description

Description of the rubric object. Field can be null

nvarchar

Truncated to 1000 characters. To change the default value, contact D2L.

 

1.7

RubricType

Type of rubric used

nvarchar

512

 

1.7

ScoringMethods

Type of scoring methods used

nvarchar

512

 

1.7

IsScoreVisible

Is the rubric score visible

Boolean

1

 

1.7

OrgUnitID

Org unit identifier associated with the rubric

Integer

4

FK

1.7

IsShared

Set to true if the Rubric object is shared

Boolean

1

 

1.7

IsDeleted

Set to true if the rubric object is deleted

Boolean

1

 

 

Brightspace Data Set: Rubric Object Criteria

About

The Rubric Object Criteria data set returns information about the rubric criteria within a rubric.

Data Set Availability

This data set is available as:

  • Full CSV, produced on a weekly basis, containing all of the data.
  • Differential CSV, produced on a daily basis or hourly basis as a paid add-on, containing the differences (diffs) of the data that was updated or inserted since the last successful differential which is typically the previous day or hour, respectively.

Returned Fields

Version History

Field

Description

Type

Column Size

Key

1.7

RubricId

Unique rubric identifier

BigInteger

8

FK

1.7

CriterionId

Identifier for the criterion associated with the rubric levels

BigInteger

8

PK

2.0 - field name updated

Name

Name of the criterion. Field can be null

nvarchar

256

 

1.7

SortOrder

Sort order by which the criteria is listed

Integer

4

 

2.0 - field name updated

CriteriaGroupId

Identifier for the criterion group to which the criterion belongs

BigInteger

8

FK

2.0 - field name updated GroupName Name of the criterion group. Field can be null nvarchar 256  
2.0 - field name updated GroupSortOrder Sort order assigned to the criterion group Integer 4  
1.7

LevelSetId

Identifier of the Level Set to which the level belongs

BigInteger

8

FK

1.7

IsDeleted

Set to true if the Level Set, Criterion Group or Criterion has been deleted

Boolean

1

 

 

Brightspace Data Set: Rubric Criteria Levels

About

The Rubric Criteria Levels data set returns the details for all rubric criteria and associated levels where they exist.

Data Set Availability

This data set is available as:

  • Full CSV, produced on a weekly basis, containing all of the data.
  • Differential CSV, produced on a daily basis or hourly basis as a paid add-on, containing the differences (diffs) of the data that was updated or inserted since the last successful differential which is typically the previous day or hour, respectively.

Returned Fields

Version History

Field

Description

Type

Column Size

Key

4.9 / 5.3 - Corrected PK

RubricId

Unique rubric identifier

BigInteger

8

PK

4.9 / 5.3 - Corrected PK

CriterionId

Identifier for the criterion associated with the rubric levels

BigInteger

8

PK

2.0 Description Description of the criterion. Field can be null nvarchar Truncated to 1000 characters. To change the default value, contact D2L.  
2.0 Feedback Automated feedback provided by the rubric for the rubric criterion. Field can be null nvarchar Truncated to 1000 characters. To change the default value, contact D2L.  
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 Numeric 19, 9  
2.0 LevelId Identifier of the level associated with the criterion BigInteger 8 PK
2.0

IsDeleted

Set to true if the criterion has been deleted

Boolean

1

 

 

Brightspace Data Set: Rubric Object Levels

About

The Rubric Object Levels data set returns information about the rubric levels in a rubric criteria.

Data Set Availability

This data set is available as:

  • Full CSV, produced on a weekly basis, containing all of the data.
  • Differential CSV, produced on a daily basis or hourly basis as a paid add-on, containing the differences (diffs) of the data that was updated or inserted since the last successful differential which is typically the previous day or hour, respectively.

Returned Fields

Version History

Field

Description

Type

Column Size

Key

1.7

RubricId

Unique rubric Identifier

BigInteger

8

FK

1.7

LevelId

Identifier for the level associated with the rubric

BigInteger

8

PK

1.7 Name Name of the level

nvarchar

512  
1.7 Description Description of the level. Field can be null nvarchar Truncated to 1000 characters. To change the default value, contact D2L.

 

1.7 Feedback Automated feedback provided by the rubric for the corresponding level. Field can be null

nvarchar

1000Truncated to 1000 characters. To change the default value, contact D2L.  

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 Numeric 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 Numeric 19, 9  
1.7 SortOrder Sort order for the levels Integer 4  
1.7 LevelSetId Identifier for the level set to which the level belongs BigInteger 8 FK
1.7

IsDeleted

Set to true when Level Set or Level have been deleted

Boolean

1