Brightspace Data Sets for Competency 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
The following diagram shows the relationships between entities used to create Brightspace Data Sets for Competency. To enlarge the diagram, right-click on the image and select Open image in a new tab.
Competency Activities
The Competency Activities Brightspace Data Set retrieves the data required to associate rubrics with competency activities. Using the returned data, clients can validate that they have configured the associations correctly.
Returned Fields
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 8.9 - Updated Description |
ActivityId
|
Unique identifier for the activity associated with the competency. Can join with Competency Activity Results, Activity Exemptions Log, SCORM Objectives, SCORM Activity Attempts, SCORM Interactions, and SCORM Interaction Attempts.
|
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
|
varchar
|
7
|
|
| 1.8 |
ObjectLookupId
|
Lookup object id that is associated with the object.
|
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.
|
varchar
|
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.
Field can be null.
|
decimal
|
19, 9
|
|
| 1.8 |
IsAutoEval
|
Indicates if this competency is automatically evaluated. If this is false, the competency is a manual evaluation.
|
bit
|
1
|
|
| 1.8 |
RubricName
|
Name of the rubric.
Field can be null.
|
nvarchar
|
256
|
|
| 5.7 / 6.0 - Changed Column Size |
RubricLevelRequired
|
Level required to achieve this learning objective.
Field can be null.
|
nvarchar
|
256
|
|
| 1.8 |
ObjectId
|
Identifier of the competency object associated with the competency activity.
Field can be null.
|
bigint
|
8
|
FK
|
| 5.7 / 6.0 |
ActivityType |
Type of activity.
Field can be null.
|
nvarchar |
50 |
|
| 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 |
|
Competency Activity Log
The Competency Activity Log Brightspace Data Set records changes as competencies are mapped to specific activities.
Returned Fields
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 1.6 |
ActivityId
|
Unique activity identifier
|
bigint
|
8
|
PK
|
| 1.6 |
ActivityLogId |
Unique identifier for the activity log |
bigint |
8 |
PK |
| 1.6 |
LogTypeId
|
Log type identifier
|
int
|
4
|
|
| 5.7 / 6.0 - Changed Column Size |
LogTypeName
|
Name of the log type.
Field can be null.
|
varchar
|
19
|
|
| 1.6 |
LogDateTime
|
Time and date of the entry in the log
|
datetime2
|
8
|
|
| 1.6 |
ModifiedBy |
User who modified the competency structure. |
bigint |
8 |
FK |
Competency Activity Results
The Competency Activity Results Brightspace Data Set returns data on activities associated with learning objectives that have been created for your org units.
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
|
bigint
|
8
|
PK, FK
|
| 1.0 |
OrgUnitId
|
Unique org unit identifier
|
int
|
4
|
PK, FK
|
| 1.0 |
UserId
|
Unique user Identifier
|
int
|
4
|
PK, FK
|
| 1.0 |
LearningObjectId
|
Unique learning object identifier
|
bigint
|
8
|
PK, FK
|
| 1.0 |
IsAchieved
|
Is learning objective achieved.
Field can be null.
|
bit
|
1
|
|
| 4.8 / 5.2 - Updated column size |
PercentAchieved
|
Percentage achieved in the activity.
Field can be null.
|
decimal
|
19, 9
|
|
| 4.8 / 5.2 - Updated column size |
RubricScore
|
Rubric score achieved in the activity.
Field can be null.
|
decimal
|
19, 9
|
|
| 5.7 / 6.0 - Changed Column Size |
RubricLevelAchieved
|
Rubric level achieved in the activity.
Field can be null.
|
nvarchar
|
256
|
|
| 1.4 |
RubricId |
Rubric id attached to the competency activity (used for evaluation).
Field can be null.
|
bigint |
8 |
|
| 1.6 |
RubricCriterionId |
Criterion attached to the competency activity.
Field can be null.
|
bigint |
8 |
|
| 3.6 / 4.1 |
AchievedDate |
Date the competency was achieved (UTC).
Field can be null.
|
datetime2
|
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 |
|
Competency Log
The Competency Log Brightspace Data Set returns data changes to the competency structure.
Returned Fields
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 1.5 |
CompetencyLogId
|
Unique log identifier
|
bigint
|
8
|
PK
|
| 1.5 |
LogTypeId
|
Log type identifier
|
int
|
4
|
|
| 5.7 / 6.0 - Changed Column Size |
LogTypeName
|
Name of the log type.
Field can be null.
|
varchar
|
19
|
|
| 1.5 |
ObjectId
|
Identifier for the object that created the change in the competency structure recorded in the log.
|
bigint
|
8
|
FK
|
| 1.5 |
ObjectTypeId
|
Identifier for the object type that created the change in the competency structure recorded in the log.
|
int
|
4
|
|
| 5.7 / 6.0 - Changed Column Size |
ObjectTypeName |
Name of the object type.
Field can be null.
|
varchar |
18 |
|
| 1.5 |
ObjectVersion
|
Version of the object that created the change in the competency structure
|
int
|
4
|
|
| 1.5 |
LogDateTime
|
Time and date of the entry in the log (UTC).
|
datetime2
|
8
|
|
| 1.5 |
ModifiedBy |
User who modified the competency structure. |
bigint |
8 |
FK |
| 1.5 |
IndirectObjectId |
Identifier for the indirect object that created the change in the log.
Field can be null.
|
bigint |
8 |
|
| 5.7 / 6.0 - Changed Column Size |
IndirectObjectTypeName |
Name of the indirect object type.
Field can be null.
|
varchar |
18 |
|
| 1.5 |
IndirectObjectTypeId |
Identifier of the type of indirect object that created the change in the log.
Field can be null.
|
int |
4 |
|
| 1.5 |
IndirectObjectVersion |
Version of the object that indirectly created the change in the log.
Field can be null.
|
int |
4 |
|
Competency Objects
The Competency Objects Brightspace Data Set returns the competencies and learning objectives which have been created within your organization.
Returned Fields
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 1.0 |
ObjectId
|
Unique competency or learning objective ID
|
bigint
|
8
|
PK
|
| 1.0 |
OrgUnitId
|
Unique org unit identifier
|
int
|
4
|
FK
|
| 5.7 / 6.0 - Changed Column Size |
Name
|
Competency name
|
nvarchar
|
256
|
|
| 5.7 / 6.0 - Changed Column Size |
Type
|
Competency type
|
varchar
|
256
|
|
| 1.0 |
ReadyForEvaluation
|
Is flagged as ready for evaluation
|
bit
|
1
|
|
| 5.7 / 6.0 - Changed Column Size |
Status
|
Status of competency: Draft, In Review, Approved, Archived.
Field can be null.
|
varchar
|
9
|
|
| 1.0 |
Description
|
Competency or learning objective description.
Field can be null.
|
nvarchar
|
1000
|
|
| 1.0 |
NeedReevaluation
|
Flag indicating if the competency or learning objective needs to be reevaluated
|
bit
|
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.
Field can be null.
|
bit
|
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.
Field can be null.
|
bit
|
1
|
|
| 5.7 / 6.0 - Changed Column Size |
AdditionalIdentifier
|
Additional competency or learning objective identifier.
Field can be null.
|
nvarchar
|
512
|
|
| 3.9 / 4.4 |
IsHidden |
Indicates if the competency is hidden to consumers. |
bit |
1 |
|
Competency Structure
The Competency Structure Brightspace Data Set returns information about all competency structures for your org units.
Returned Fields
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 1.4 - Added Primary Key designation |
ObjectId
|
Unique competency or learning objective ID
|
bigint
|
8
|
PK, FK
|
| 1.4 - Added Primary Key designation |
ParentObjectId
|
Parent competency or learning objective ID
|
bigint
|
8
|
PK, FK
|
| 1.4 - Added Primary Key designation |
BaseObjectID |
Unique basic object ID |
bigint |
8 |
PK, FK
|
| 1.2 |
Depth |
Indicates the depth of the competency structure |
int |
4 |
|
| 1.4 |
EntryTime |
The order in which a competency object exists with respect to its hierarchy.
|
int |
4 |
PK |