Brightspace Data Sets for Outcomes have a dependency on the Learning Outcomes tool. 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 Outcomes. To enlarge the diagram, right-click on the image and select Open image in a new tab.
To retrieve details about tool-specific objects that are aligned to or assessed against learning outcomes, you must reference other Brightspace Data Sets. The values you need to look up a tool-specific object are:
Locate your AlignedObjectType in the following table, navigate to the corresponding Reference Column, and locate the row where the unique identifier value matches your AlignedObjectId.
AlignedObjectType
|
Reference Column |
|---|
| 1 |
Data Set: Discussion Topics
Column: TopicId
Type: bigint
|
| 2 |
Data Set: Assignment Summary
Column: DropboxId
Type: bigint
|
| 3 |
Data Set: Quiz Attempts
Column: AttemptId
Type: bigint
|
| 4 |
Data Set: Checkpoint Definition (future delivery)
Column: CheckpointId
Type: uniqueidentifier
|
| 5 |
Data Set: Portfolio Evidence Objects
Column: EvidenceId
Type: uniqueidentifier
|
Note: AlignedObjectIds are stored as plain strings in Learning Outcomes data sets, so they must be parsed as the appropriate data type to look up a tool-specific object.
Deleting Outcome Objects
When an outcome object is deleted from a course, the Outcome Details data set will have a non-null value in the IsDeleted field for that object. However, all secondary data set references to that object will still have a null IsDeleted value unless the object context is specifically deleted.
For example: an outcome is aligned to an assessment activity, has not yet been evaluated, and is deleted from the course intent list. The outcome object will have a non-null IsDeleted value in Outcome Details, but IsDeleted is still null for the aligned assessment activity in Outcomes Aligned to Tool Objects.
The deletion is implicitly inherited down to child activities, so ensure you check deletion at all levels.
Outcome Details
The Outcome Details Brightspace Data Set provides details of the outcomes that are part of all registries in all your org units.
User IDs and dates are only populated for authored outcomes because updates to ASN outcomes rely on the cache invalidation system (performed by a system user).
The only available data for authored outcomes is from June 2021 onwards. All data for ASN imported outcomes is available, starting with your organization's first use of Learning Outcomes.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 6.8 |
OutcomeId
|
Unique outcome identifier.
|
uniqueidentifier
|
16
|
PK
|
| 6.8 |
OutcomeDefinitionSource |
Provider for this outcome, e.g. ASN. |
nvarchar |
1000 |
|
| 8.11 / 9.0 - Changed Description |
OutcomeDefinitionId |
ID of outcome within provider (for example ASN or locally authored).
Field can be an empty string.
|
nvarchar |
128 |
|
| 6.8 |
ParentOutcomeId |
ID of the parent outcome, if nested under a parent outcome object in the same org unit, or null for top level outcomes with no parent.
Field can be null.
|
uniqueidentifier |
16 |
|
| 6.8 |
Description |
Main body of this outcome. Truncated to 1000 characters. |
nvarchar |
1000 |
|
| 6.8 |
Notation |
Outcome notation for ASN outcomes. |
nvarchar |
1000 |
|
| 6.8 |
CreatedDate |
For authored outcomes, date when this item was initially created (UTC). For imported outcomes, this field is null.
Field can be null.
|
datetime2 |
8 |
|
| 6.8 |
CreatedBy |
For authored outcomes, ID of user who initially created this item. For imported outcomes, this field is null.
Field can be null.
|
int |
4 |
FK |
| 6.8 |
LastModifiedDate |
Date when this item was last modified (UTC). Contains created date upon creation and deleted date for deleted items.
Field can be null.
|
datetime2 |
8 |
|
| 6.8 |
LastModifiedBy |
ID of user who last modified, created, or deleted this item.
Field can be null.
|
int |
4 |
FK |
| 6.8 |
IsDeleted |
Indicates if this item has been deleted for authored outcomes. This flag will be null for outcomes imported from external providers, e.g. ASN.
Field can be null.
|
bit |
1 |
|
Outcomes Aligned to Tool Objects
The Outcomes Aligned to Tool Objects Brightspace Data Set provides details of which outcomes are aligned to which assessment tools for all your org units. It includes a row for every outcome aligned to an assessment activity, for both direct alignments and alignments references via rubrics. The data set only captures data from June 2021 onwards.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 6.8 |
ObjectType |
Type of tool this outcome is aligned to. See Tool-Specific Object Lookup for details. |
int |
4 |
PK |
| 6.14 / 7.2 - Updated Column size |
ObjectId |
ID of the tool this outcome is aligned to. See Tool-Specific Object Lookup for details. |
nvarchar |
255 |
PK, FK |
| 6.8 |
OutcomeId |
ID of this Outcome in the Outcome Details data set. |
uniqueidentifier |
16 |
PK |
| 6.8 |
RegistryId |
ID of registry representing the context in which this alignment exists. |
uniqueidentifier |
16 |
PK |
| 6.8 |
CreatedDate |
Date when this item was initially created (UTC).
Field can be null.
|
datetime2 |
8 |
|
| 6.8 |
CreatedBy |
ID of user who initially created this item.
Field can be null.
|
int |
4 |
FK |
| 6.8 |
LastModifiedDate |
Date when this item was last modified (UTC). Contains created date upon creation and deleted date for deleted items. |
datetime2 |
8 |
|
| 6.8 |
LastModifiedBy |
ID of user who last modified, created, or deleted this item. |
int |
4 |
FK |
| 6.8 |
IsDeleted |
Indicates if this item has been deleted. |
bit |
1 |
|
Outcomes Assessed Checkpoints
The Outcomes Assessed Checkpoints Brightspace Data Set provides details about the Overall Achievement Calculation Settings for a checkpoint. The data set only captures data from July 2021 onwards.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 6.9 |
CheckpointId |
ID of this checkpoint. |
uniqueidentifier |
16 |
PK |
| 6.9 |
DemonstrationId |
ID of demonstration which assesses this outcome against the checkpoint. |
uniqueidentifier |
16 |
PK, FK |
| 6.9 |
Feedback |
Feedback left by assessor, truncated to 1000 characters. |
nvarchar |
1000 |
|
| 6.9 |
ConfigDecayRate |
Value of the decay rate in Mastery View Settings for checkpoint calculation. |
int |
4 |
|
| 6.9 |
ConfigAggregationMethod |
Calculation method selected in Mastery View Settings.
Possible values:
|
int |
4 |
|
| 6.9 |
ConfigIncludedActivities |
Selected activities for use in calculation in Mastery View Settings. If Most Recently Assessed Activities is selected, the specific number of activities to include is stored in ConfigRecentlyAssessedActivityCount.
Possible values:
|
int |
4 |
|
| 6.9 |
ConfigMultipleAttemptStrategy |
Selected attempt for use in calculation in Mastery View Settings.
Possible values:
|
int |
4 |
|
| 6.9 |
ConfigRecentlyAssessedActivityCount |
The number of recently assessed activities to include in calculation, when Most Recently Assessed Activities is selected.
|
int |
4 |
|
| 6.9 |
ConfigTieBreaker |
Selected method for how to handle multiple items of the same count in calculating the overall level of achievement in Mastery View Settings.
Possible values:
-
Highest Level = 0
-
Most Recent Level = 1
|
int |
4 |
|
| 6.9 |
LastModifiedDate |
Date when this item was last modified. Contains created date upon creation and deleted date for deleted items.
Field can be null.
|
datetime2 |
8 |
|
| 6.9 |
LastModifiedBy |
ID of user who last modified, created, or deleted this item.
Field can be null.
|
int |
4 |
|
| 6.9 |
IsDeleted |
Indicates if this item has been deleted. |
bit |
1 |
|
| 8.12 / 9.1 |
HasMetAchievementThreshold |
Indicates whether a learner has met the achievement threshold.
Field can be null.
|
bit |
1 |
|
Outcomes Course Specific Scales
The Outcomes Course Specific Scales Brightspace Data Set provides details on which achievement scales and achievement thresholds are being used in each of your courses. The only available data for course specific achievement scales is from May 2023 onwards.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 8.9 |
OrgUnitId |
ID of the org unit this registry is associated with. |
int |
4 |
PK, FK
|
| 8.9 |
RegistryId |
ID of the current registry.
|
uniqueidentifier |
16 |
FK |
| 8.9 |
ScaleId |
ID of the scale set as the LOA for the current registry. |
uniqueidentifier |
16 |
FK |
| 8.9 |
AchievementThreshold |
Level ID representing the threshold of achievement for this registry.
Field can be null.
|
uniqueidentifier |
16 |
FK |
| 8.9 |
CreatedDate |
Date when this item was originally created (UTC).
|
datetime2 |
8 |
|
| 8.9 |
LastModifiedDate |
Date when this item was last modified. Contains created date upon creation and deleted date for deleted items (UTC).
|
datetime2 |
8 |
|
| 8.9 |
LastModifiedBy |
ID of user who last modified, created, or deleted this item.
Field can be null.
|
int |
4 |
FK |
| 8.9 |
IsDeleted |
Whether this item has been deleted. |
bit |
1 |
|
Outcomes Demonstrations
In the Outcomes Demonstrations Brightspace Data Set, each entry represents an evaluation of an assessment activity that is aligned to a learning outcome. For most tool object types, assessments are only visible in this data set when they are made visible to learners. The data set only captures data from June 2021 onwards.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 6.8 |
DemonstrationId |
ID of this demonstration. |
uniqueidentifier |
16 |
PK
|
| 6.8 |
ExplicitlyEnteredScaleLevelId |
Result of this evaluation if manually entered by assessor.
Field can be null if achieved level has not been manually overridden.
|
uniqueidentifier |
16 |
FK |
| 6.8 |
AutomaticallyGeneratedScaleLevelId |
Result of this evaluation if automatically generated by LMS.
Field can be null.
|
uniqueidentifier |
16 |
FK |
| 6.8 |
AlignedObjectType |
Type of assessed tool for this demonstration. See Tool-Specific Object Lookup for details. |
int |
4 |
|
| 6.8 |
AlignedObjectId |
ID of assessed tool for this demonstration. See Tool-Specific Object Lookup for details. |
nvarchar |
1000 |
FK |
| 6.8 |
OutcomeId |
ID of assessed outcome. |
uniqueidentifier |
16 |
|
| 6.8 |
RegistryId |
ID of registry representing the context in which the demonstration was made. |
uniqueidentifier |
16 |
|
| 6.8 |
IsPublished |
Indicates if this demonstration has been made available to the assessed learner.
Field can be null.
|
bit |
1 |
|
| 6.8 |
AssessedUserId |
ID of the user who made the submission. |
int |
4 |
FK |
| 6.8 |
AssessedDate |
Date of initial assessment (UTC). |
datetime2 |
8 |
|
| 6.8 |
AssessorUserId |
ID of the user who initially evaluated the submission.
Field can be null.
|
int |
4 |
FK |
| 6.8 |
LastModifiedDate |
Date when this item was last modified (UTC). Contains created date upon creation and deleted date for deleted items. |
datetime2 |
8 |
|
| 6.8 |
LastModifiedBy |
ID of user who last modified, created, or deleted this item. |
int |
4 |
FK |
| 6.8 |
IsDeleted |
Indicates if this item has been deleted. |
bit |
1 |
|
Outcomes in Registries
The Outcomes in Registries Brightspace Data Set provides details of which outcomes belong to which registries for all your org units. It can be used to list all outcomes in the intent list of a course, or all the outcomes in a program.
The only available data for org unit owned registries is from June 2021 onwards. All data for program registries is available, starting with your organization's first use of Learning Outcomes.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 7.7 - Updated Type and Size |
OutcomeId |
ID of this Outcome in the Outcome Details data set. |
uniqueidentifier |
16 |
PK, FK |
| 6.8 |
RegistryId |
ID of registry representing the context in which this outcome exists. |
uniqueidentifier |
16 |
PK |
| 6.8 |
CreatedDate |
For imported outcomes, the date that this outcome was mapped to the registry (UTC). For authored outcomes, the date this outcome was created.
Field can be null.
|
datetime2 |
8 |
|
| 6.8 |
CreatedBy |
ID of user who imported or created the outcome in the registry.
Field can be null.
|
int |
4 |
FK |
| 6.8 |
LastModifiedDate |
Date when this item was last modified (UTC). Contains created date upon creation and deleted date for deleted items. |
datetime2 |
8 |
|
| 6.8 |
LastModifiedBy |
ID of user who last modified, created, or deleted this item. |
int |
4 |
FK |
| 6.8 |
IsDeleted |
Indicates if this item has been deleted. |
bit |
1 |
|
Outcomes Program Details
The Outcomes Program Details Brightspace Data Set provides details about the programs that are defined to hold a collection of outcomes (registry). All data for the data set is available, starting with your organization's first use of Learning Outcomes.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 7.6 - Updated Type |
ProgramId |
ID of this program which owns the registry. |
bigint |
16 |
PK |
| 6.8 |
ProgramName |
The name of this program. |
nvarchar |
1000 |
|
| 6.8 |
OrgUnitId |
ID of the org unit which owns this program. |
int |
4 |
FK |
| 6.8 |
CreatedDate |
Date when this item was initially created (UTC).
Field can be null.
|
datetime2 |
8 |
|
| 6.8 |
CreatedBy |
ID of user who initially created this item.
Field can be null.
|
int |
4 |
FK |
| 6.8 |
LastModifiedDate |
Date when this item was last modified (UTC). Contains created date upon creation and deleted date for deleted items. |
datetime2 |
8 |
|
| 6.8 |
LastModifiedBy |
ID of user who last modified, created, or deleted this item. |
int |
4 |
FK |
| 6.8 |
IsDeleted |
Indicates if this item has been deleted. |
bit |
1 |
|
Outcomes Registry Owners
In the Outcomes Registry Owners Brightspace Data Set, each entry represents a registry for both program and org unit owned registries. The data set only captures data from June 2021 onwards.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 6.8 |
OwnerType |
Type of entity which owns this registry. Set to 1 if owner is org unit, set to 2 if owner is program. |
int
|
4
|
PK
|
| 6.14 / 7.2 - Updated Column size |
OwnerId |
ID or org unit owner when OwnerType is 1. ID of program when OwnerType is 2. |
nvarchar |
255 |
PK |
| 6.8 |
RegistryId |
ID of registry for the org unit or program. |
uniqueidentifier |
16 |
PK |
| 6.8 |
CreatedDate |
Date when this item was initially created (UTC).
Field can be null.
|
datetime2 |
8 |
|
| 6.8 |
CreatedBy |
ID of user who initially created this item.
Field can be null.
|
int |
4 |
FK |
| 6.8 |
LastModifiedDate |
Date when this item was last modified (UTC). Contains created date upon creation and deleted date for deleted items. |
datetime2 |
8 |
|
| 6.8 |
LastModifiedBy |
ID of user who last modified, created, or deleted this item. |
int |
4 |
FK |
| 6.8 |
IsDeleted |
Indicates if this item has been deleted. |
bit |
1 |
|
Outcomes Rubric Alignments
In the Outcomes Rubric Alignments Brightspace Data Set, each entry represents an alignment for a learning outcome to a rubric criterion row. The data set only captures data from June 2021 onwards.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 7.6 |
RubricId |
Unique rubric identifier. |
bigint |
8 |
PK, FK |
| 7.6 |
CriterionId |
Identifier for the criterion row of the rubric. |
bigint |
8 |
PK, FK |
| 7.6 |
OutcomeId |
Unique identifier for the outcome object. |
uniqueidentifier |
16 |
PK, FK |
| 7.6 |
RegistryId |
ID of the registry for the org unit or program. |
uniqueidentifier |
16 |
PK, FK |
| 7.6 |
CreatedDate |
The date when the alignment of this outcome was recorded for this rubric criterion row.
Field can be null.
|
datetime2 |
8 |
|
| 7.6 |
CreatedBy |
ID of the user who initially created this alignment.
Field can be null.
|
int |
4 |
FK |
| 7.6 |
LastModifiedDate |
Date when this item was last modified (UTC). Contains created date upon creation and deleted date for deleted items.
|
datetime2 |
8 |
|
| 7.6 |
LastModifiedBy |
ID of user who last modified, created, or deleted this item.
|
int |
4 |
FK |
| 7.6 |
IsDeleted |
Set to true if the outcome alignment has been removed from the rubric or the rubric has been deleted. |
bit |
1 |
|
Outcomes Scale Definition
In the Outcomes Scale Definition Brightspace Data Set, each entry represents an achievement scale defined at the organization level. All data for the data set is available, starting with your organization's first use of Learning Outcomes.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 6.8 |
ScaleId
|
ID for this scale.
|
uniqueidentifier
|
16
|
PK
|
| 6.8 |
Name |
Name of this scale. |
nvarchar |
1000 |
|
| 6.8 |
IsDefault |
Indicates if this is the scale used by default whenever an assessment of an outcome takes place. |
bit |
1 |
|
| 6.8 |
UsePercentages |
Indicates if percentage ranges are specified for each scale level. This is used when suggesting a scale level for an assessment. Specific percentage threshold values are associated with each Scale Level. |
bit |
1 |
|
| 6.8 |
CreatedDate |
Date when this item was initially created (UTC).
Field can be null.
|
datetime2 |
8 |
|
| 6.8 |
CreatedBy |
ID of user who initially created this item.
Field can be null.
|
int |
4 |
FK |
| 6.8 |
LastModifiedDate |
Date when this item was last modified (UTC). Contains created date upon creation and deleted date for deleted items. |
datetime2 |
8 |
|
| 6.8 |
LastModifiedBy |
ID of user who last modified, created, or deleted this item. |
int |
4 |
FK |
| 6.8 |
IsDeleted |
Indicates if this item has been deleted. |
bit |
1 |
|
| 6.8 |
RegistryId |
ID of registry that owns this scale. |
uniqueidentifier |
16 |
|
Outcomes Scale Level Definition
In the Outcomes Scale Level Definition Brightspace Data Set, each entry represents a scale level defined in your scales. On the evaluation UI, they are represented by a single, clickable "frame". Examples include "Not Yet Achieved", "Achieved", and "Mastered".
Scale levels can't be deleted once created. Scale levels become inaccessible when their parent scale is deleted.
All data for the data set is available, starting with your organization's first use of Learning Outcomes.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 6.8 |
ScaleLevelId
|
ID for this scale level.
|
uniqueidentifier
|
16
|
PK
|
| 6.8 |
ScaleId |
ID of the parent scale. |
uniqueidentifier |
16 |
FK |
| 6.8 |
Name |
Name of this scale level. |
nvarchar |
1000 |
|
| 6.8 |
SortOrder |
Determines ordering for this scale level. |
int |
4 |
|
| 6.8 |
PercentageRangeStart |
The score percentage threshold boundary for this scale level. This value is used when automatically suggesting a scale level from numeric assessment results.
Field can be null.
|
int |
4 |
|
| 6.14 / 7.2 - Updated Column size |
RGB |
Color of this scale level in HTML hex notation. |
nvarchar |
40 |
|
| 6.8 |
CreatedDate |
Date when this item was initially created (UTC).
Field can be null.
|
datetime2 |
8 |
|
| 6.8 |
CreatedBy |
ID of user who initially created this item.
Field can be null.
|
int |
4 |
FK |
| 6.8 |
LastModifiedDate |
Date when this item was last modified (UTC). Contains created date upon creation and deleted date for deleted items. |
datetime2 |
8 |
|
| 6.8 |
LastModifiedBy |
ID of user who last modified, created, or deleted this item. |
int |
4 |
FK |