Brightspace Data Sets for Portfolio

Brightspace Data Sets for Portfolio include:

These data sets depend on Portfolio being enabled. 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 Portfolio, click the following thumbnail image:

Entity Relationship Diagram for Portfolio

Brightspace Data Set: Portfolio Evidence Log

About

Reports on the actions that occur to each piece of evidence in the Portfolios in your organization. The first data point is from May, 2019 or your first use of the Portfolio tool, whichever is more recent.

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.5 LogId Unique identifier for each action that occurs on each object in a portfolio. nvarchar 40 PK
4.5 ParentObjectId Unique identifier of the evidence. Field can be null. nvarchar 40  
4.5 ObjectId Unique identifier of the object where the action occurred. This is equal to ParentObjectId when the ObjectType is evidence nvarchar 40  

4.5

4.7 / 5.1 - Updated description

ObjectType Indicates what type of object the action occurred on such as the evidence itself or reflection, etc. nvarchar 40  
4.5 UserId Unique user identifier. Integer 4 FK
4.5 OrgUnitId Unique org unit identifier. Integer 4 FK
4.5 Action The action that occurred: Created, Updated or Deleted. navchar 16  
4.5 IsMobile Indicates if the action occurred on a mobile device. Boolean 1  
4.5 ActionDate Date action was completed. (UTC). DateTime 8  

Brightspace Data Set: Portfolio Categories

About

Details the categories that have been created in 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

5.0

4.7 / 5.1 - Removed FK

CategoryId Unique category identifier nvarchar 40 PK
5.0 OrgUnitId Unique org unit identifier. Field can be null Integer 4 FK
5.0 Name Portfolio category name. nvarchar 256  

5.0

4.7 / 5.1 - Updated description

IsRetired Indicates the category is retired and therefore cannot be used. Boolean 1  
5.0 IsDeleted Indicates if the portfolio category is deleted Boolean 1  
5.0 LastModified Date when the portfolio category was last modified (UTC). DateTime 8  
5.0 LastModifiedBy User who last modified the portfolio category. Integer 4 FK

Brightspace Data Set: Portfolio Evidence Objects

About

Defines the attributes of each piece of evidence in Portfolios in 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

5.0

4.7 / 5.1 - Removed FK

EvidenceId Unique evidence identifier nvarchar 40 PK
5.0 OwnerId The user ID that this evidence belongs to Integer 4 FK
5.0 OrgUnitId Unique org unit identifier Integer 8 FK
5.0 EvidenceType The type of evidence nvarchar 30  
5.0 Title The evidence title nvarchar 1000  
5.0 IsApproved Indicates the evidence is approved Boolean 1  
5.0 IsSpotlighted Indicates the evidence is spotlighted Boolean 1  
5.0 IsSharedToParents Indicates the evidence is shared to parents Boolean 1  
5.0 IsDeleted Indicates that the evidence object is deleted. Boolean 1  
5.0 IsRecoverableByInstructor Indicates that the deleted evidence object can be recovered by the instructor. Field can be null Boolean 1  
5.0 LastModified Date when the evidence object was last modified (UTC) DateTime 8  
5.0 LastModifiedBy User who last modified the evidence object Integer 4 FK

Brightspace Data Set: Portfolio Evidence Categories

About

Details the one or many categories that are mapped to each piece of evidence in the Portfolios in 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

5.0 CategoryId The identifier for the category nvarchar 40 PK, FK
5.0 EvidenceId The identifier for the evidence nvarchar 40 PK, FK

5.0

4.7 / 5.1 - Updated description

Group Indicates how the category was linked to the evidence. By the learner or instructor. nvarchar 30 PK
5.0 IsDeleted Indicates whether the link between the category and the evidence is deleted Boolean 1  
5.0 LastModified Date when the portfolio category was last modified (UTC) DateTime 8  
5.0 LastModifiedBy User who last modified the portfolio category Integer 4 FK