Brightspace Data Sets for Competency

Brightspace Data Sets for Competency include:

These data sets have a dependency on Competencies. 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 Competency, click the following thumbnail image:

Entity Relationship Diagram for Competency

Brightspace Data Set: Competency Activities

About

Retrieves the data required to associate rubrics with competency activities. Using the returned data, clients can validate that they have configured the associations correctly.

Data Set Availability

This data set is available as:

  • Full CSV, produced on a daily 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

ActivityId

Unique identifier for the activity associated with the competency.

BigInt

8

PK

1.8

OrgUnitId

Identifier for the Org Unit associated with the competency.

Int

4

FK

1.8

ActivityName

The name of the activity.

nvarchar

256

 

1.8

ActivityTypeId

Identifier for the activity type

Int

4

 

1.8

AssessmentType

Rubric assessment type

nvarchar

7

 

1.8

ObjectLookupId

Lookup object id that is associated with the object. Field can be NULL.

BigInt

8

 

1.8

RubricId

Identifier of the rubric. This field is only valid for competency activities associated with a rubric.

Field can be NULL.

BigInt

8

 

1.8

LevelId

Identifier of the rubric level associated with the competency activity. This field is only valid for competency activities associated with a rubric. Field can be NULL

BigInt

8

 

1.8

RubricCriterionId

Identifier of the rubric criterion associated with the activity. This field is only valid for competency activities associated with a rubric and scored at the criteria level. If the overall rubric score is used, the value is NULL.

BigInt

8

 

1.8

AssessmentThresholdCriteria

For numeric activity only. Can be >= (greater than or equal to), > (greater than), = (equal to), <= (less than or equal to), or < (less than). Field can be NULL.

String

2

 

1.8

AssessmentThreshold

When a competency activity is evaluated, the assessment threshold is the value that must be met by a learner to achieve the competency.

Numeric

19, 9

 

1.8

IsAutoEval

Indicates if this competency is automatically evaluated. If this is false, the competency is a manual evaluation.

Boolean

1

 

1.8

RubricName

Name of the rubric

nvarchar

256

 

1.8

RubricLevelRequired

Level required to achieve this learning objective

String

512

 

1.8

ObjectId

Identifier of the competency object associated with the competency activity. This field can be NULL.

BigInt

8

FK

 

Brightspace Data Set: Competency Activity Results

About

Returns data on activities associated with learning objectives that have been created for your org units.

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 - Added FK

ActivityId

Unique identifier for activity associated with a competency

BigInteger

8

PK, FK

1.0

OrgUnitId

Unique org unit identifier

Integer

4

PK

FK

1.0

UserId

Unique user Identifier

Integer

4

PK

FK

1.0

LearningObjectId

Unique learning object identifier

BigInteger

8

PK

FK

1.0

ActivityType

Type of activity

nvarchar

100

 

1.0

ActivityName

Name of activity

String

2000

 

1.0

ObjectLookupId

Look up ID of the activity associated with a Brightspace tool

BigInteger

8

 

1.0

AssessmentType

Rubric assessment type

String

7

 

1.0

RubricName

Rubric name

nvarchar

512

 

1.0

RubricLevelRequired

Level required to achieve this learning objective

nvarchar

512

 

4.8 / 5.2 - Updated column size

AssessmentThreshold

Threshold required to achieve the learning objective. Field can be null.

Numeric

19, 9

 

1.0

AssessmentThresholdCriteria

Greater than/less than/equal to assessment threshold. Field can be null.

String

2

 

1.0

IsAchieved

Is learning objective achieved

Boolean

1

 

4.8 / 5.2 - Updated column size

PercentAchieved

Percentage achieved in the activity. Field can be null.

Numeric

19, 9

 

4.8 / 5.2 - Updated column size

RubricScore

Rubric score achieved in the activity. Field can be null.

Numeric

19, 9

 

1.0

RubricLevelAchieved

Rubric level achieved in the activity

nvarchar

512

 

1.4 - Added RubricId Rubric id attached to the competency activity (used for evaluation). Field can be null. BigInteger 8  
1.6 - Added RubricCriterionId Criterion attached to the competency activity. Field can be null. BigInteger 8  
3.6 / 4.1 AchievedDate

Date the competency was achieved (UTC).

DateTime

8

 

 

Brightspace Data Set: Competency Log

About

Returns data changes to the competency structure.

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.5

CompetencyLogId

Unique log identifier

BigInteger

8

PK

1.5

LogTypeId

Log type identifier

Integer

4

Y

1.5

LogTypeName

Name of the log type

String

50

 

1.5

ObjectId

Identifier for the object that created the change in the competency structure recorded in the log.

BigInteger

8

FK

1.5

ObjectTypeId

Identifier for the object type that created the change in the competency structure recorded in the log.

Integer

4

 

1.5 ObjectTypeName Name of the object type String 20  
1.5

ObjectVersion

Version of the object that created the change in the competency structure

Integer

4

 

1.5

LogDateTime

Time and date of the entry in the log (UTC)

DateTime

8

 

1.5 ModifiedBy User who modified the competency structure. BigInteger 8 FK
1.5 IndirectObjectId Identifier for the indirect object that created the change in the log. BigInteger 8  
1.8 IndirectObjectTypeName Name of the indirect object type. Can be null String 20  
1.5 IndirectObjectTypeId Identifier of the type of indirect object that created the change in the log. Integer 4  
1.5 IndirectObjectVersion Version of the object that indirectly created the change in the log. Integer 4  

 

Brightspace Data Set: Competency Activity Log

About

Records changes as competencies are mapped to specific activities.

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.6

ActivityId

Unique activity identifier

BigInteger

8

PK

1.6 ActivityLogId Unique identifier for the activity log BigInteger 8 PK
1.6

LogTypeId

Log type identifier

Integer

4

 

1.6

LogTypeName

Name of the log type.

String

50

 

1.6

LogDateTime

Time and date of the entry in the log

DateTime

8

 

1.6 ModifiedBy User who modified the competency structure. BigInteger 8 FK

 

Brightspace Data Set: Competency Objects

About

Returns the competencies and learning objectives which have been created within your organization.

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

ObjectId

Unique competency or learning objective ID

BigInteger

8

PK

1.0

OrgUnitId

Unique org unit identifier

Integer

4

FK

1.0

Name

Competency name

nvarchar

512

 

1.0

Type

Competency type

varchar

512

 

1.0

ReadyForEvaluation

Is flagged as ready for evaluation

Boolean

1

 

1.0

Status

Status of competency: Draft, In Review, Approved, Archived

String

10

 

1.0

Description

Competency or learning objective description. Field can be null.

String

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

 

1.0

NeedReevaluation

Flag indicating if the competency or learning objective needs to be reevaluated

Boolean

1

 

1.0

ReevaluationIfAchieved

Determines if reevaluation will occur when the competency or learning objective is updated and the competency or learning objective has already been achieved

Boolean

1

 

1.0

ReevaluationIfNotAchieved

Determines if reevaluation will occur when the competency or learning objective is updated and the competency or learning objective has not been achieved

Boolean

1

 

1.0

AdditionalIdentifier

Additional competency or learning objective identifier. Field can be null.

nvarchar

1024

 

3.9/4.4 IsHidden Indicates if the competency is hidden to consumers. Boolean 1  

 

Brightspace Data Set: Competency Structure

About

Returns information about all competency structures for your org units.

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.4 - Added Primary Key designation

ObjectId

Unique competency or learning objective ID

BigInteger

8

PK, FK

1.4 - Added Primary Key designation

ParentObjectId

Parent competency or learning objective ID

BigInteger

8

PK, FK

1.4 - Added Primary Key designation BaseObjectID Unique basic object ID BigInteger 8

PK, FK

1.2 - Added Depth Indicates the depth of the competency structure Integer 4  
1.4 - Added EntryTime

The order in which a competency object exists with respect to its hierarchy.

Integer 4 PK