Brightspace Data Sets for Course Publisher

Brightspace Data Sets for Course Publisher include:

These data sets depend on the Course Publisher tool 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 Course Publisher, click the following thumbnail image:

Entity Relationship Diagram for Course Publisher

Brightspace Data Set: Content Publisher Launches

About

Returns details about course packages launched from the Content Publisher tool.

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 LaunchId Unique course package launch identifier uniqueidentifier 16 PK
6.8 OrgUnitId

Unique org unit identifier

int 8 FK
6.8 RecipientId Unique recipient identifier uniqueidentifier 16 FK

6.8

UserId Unique user identifier int 8 FK
6.8 RoleId Unique role identifier int 8 FK
6.8 LaunchMethod Method for launching the course package nvarchar 256  
6.8 ExternalUserId Unique external user identifier nvarchar 256  
6.8 ExternalLMSType External LMS type used by the recipient nvarchar 256  
6.8 IsNewUser If the external user is new bit 1  
6.8 LastModified Date the course package was last modified (UTC) datetime2 8  

Brightspace Data Set: Publisher Recipients

About

Returns details about course package recipients in the Course Publisher tool.

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

RecipientID Unique recipient identifier uniqueidentifier 16 PK
6.8 Name

Recipient name

nvarchar 256  
6.8 CreatedAt Date the recipient was created (UTC) datetime2 8  

6.8

LastModified Date the recipient was last modified (UTC) datetime2 8