Brightspace Data Sets for Outcomes

Brightspace Data Sets for Outcomes include:

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

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

Entity Relationship Diagram for Outcomes

 

Tool-Specific Object Lookup

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:

  • AlignedObjectType: hard-coded number representing the tool-specific object that the outcome is linked to.

  • AlignedObjectId: unique identifier for the row in the tool-specific object's data set.

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 SetCheckpoint Definition (coming soon)

Column: CheckpointId

Type: uniqueidentifier

5

Data SetPortfolio 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 Outcome Alignments to Tool Objects.

The deletion is implicitly inherited down to child activities, so ensure you check deletion at all levels.

 

Brightspace Data Set: Outcomes Scale Definition

About

Each entry represents an achievement scale defined at the organization level.

All data for the Outcomes Scale Definition data set is available, starting with your organization's first use of Learning Outcomes.

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

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  

 

Brightspace Data Set: Outcomes Scale Level Definition

About

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 Outcomes Scale Level Definition data set is available, starting with your organization's first use of Learning Outcomes.

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

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.8 RGB Color of this scale level in HTML hex notation. nvarchar 1000  
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

 

Brightspace Data Set: Outcome Details

About

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

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

6.8

OutcomeId

Unique outcome identifier.

uniqueidentifier

16

PK

6.8 OutcomeDefinitionSource Provider for this outcome, e.g. ASN. nvarchar 1000  
6.8 OutcomeDefinitionId

ID of outcome within provider (e.g. ASN), or null if locally authored.

Field can be null.

nvarchar 1000  
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  

 

Brightspace Data Set: Outcomes Registry Owners

About

Each entry represents a registry for both program and org unit owned registries.

The Outcomes Registry Owners data set only captures data from June 2021 onwards.

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

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.8 OwnerId ID or org unit owner when OwnerType is 1. ID of program when OwnerType is 2. nvarchar 1000 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  

 

Brightspace Data Set: Outcomes in Registries

About

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.

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

6.8 OutcomeId ID of this Outcome in the Outcome Details data set. nvarchar 1000 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  

 

Brightspace Data Set: Outcomes Alignments to Tool Objects

About

Provides details of which outcomes are aligned to which assessment tools for all your org units. Includes a row for every outcome aligned to an assessment activity, for both direct alignments and alignments references via rubrics.

The Outcome Alignments to Tool Objects data set only captures data from June 2021 onwards.

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

6.8 ObjectType Type of tool this outcome is aligned to. See Tool-Specific Object Lookup for details. int 4 PK
6.8 ObjectId ID of the tool this outcome is aligned to. See Tool-Specific Object Lookup for details. nvarchar 1000 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  

 

Brightspace Data Set: Outcomes Demonstrations

About

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 Outcomes Demonstrations data set only captures data from June 2021 onwards.

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

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  

 

Brightspace Data Set: Outcomes Program Details

About

Provides details about the programs that are defined to hold a collection of outcomes (registry).

All data for the Outcomes Program Details data set is available, starting with your organization's first use of Learning Outcomes.

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

6.8 ProgramId ID of this program which owns the registry. uniqueidentifier 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  

 

Brightspace Data Set: Outcomes Assessed Checkpoints

About

Provides details about the Overall Achievement Calculation Settings for a checkpoint.

The Outcomes Assessed Checkpoints data set only captures data from July 2021 onwards.

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

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:

  • No Automatic Calculation = 0

  • Most Common = 1

  • Most Recent = 2

  • Highest = 3

  • Decaying Average = 4

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:

  • All Activities = 0

  • Most Recently Assessed Activities = 1

int 4  
6.9 ConfigMultipleAttemptStrategy

Selected attempt for use in calculation in Mastery View Settings.

Possible values:

  • Highest Attempt = 0

  • Last Attempt = 1

  • Average of All Attempts = 2

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