Brightspace Data Sets for Content

Brightspace Data Sets for Content include:

These data sets have a dependency on Content. 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 Content, click the following thumbnail image:

Entity Relationship Diagram for Content

 

Brightspace Data Set: Content Objects

About

Returns information about content topics and modules created for your org units.

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

1.0

ContentObjectId

Unique identifier of the content

int

4

PK

1.0

OrgUnitId

Unique org unit identifier

int

4

FK

5.7 / 6.0 - Updated column size

Title

Content title

nvarchar

150

 

1.0

ContentObjectType

Content object type

varchar

6

 

5.7 / 6.0 - Updated column size

CompletionType

Content completion type

varchar

7

 

1.0

ParentContentObjectId

Parent content object identifier

int

4

 

5.7 / 6.0 - Updated column size

Location

Location of the content asset.

Field can be null.

nvarchar

1000

 

1.0

StartDate

Content availability start date (UTC).

Field can be null.

datetime2

8

 

1.0

EndDate

Content availability end date (UTC).

Field can be null.

datetime2

8

 

1.0

DueDate

Content availability due date (UTC).

Field can be null.

datetime2

8

 

1.0

ObjectId1

Object ID, depending on the type of associated tool: TopicId, ChecklistId, SurveyId, QuizId, DropboxId, ChatId, Self-AssessmentId.

Field can be null.

int

4

 

1.0

ObjectId2

Object ID, depending on the type of associated tool: TopicId, ChecklistId, SurveyId, QuizId, DropboxId, ChatId, Self-AssessmentId.

Field can be null.

int

4

 

1.0

ObjectId3

Object Id, depending on the type of associated tool: TopicId, ChecklistId, SurveyId, QuizId, DropboxId, ChatId, Self-AssessmentId.

Field can be null.

int

4

 

5.0 – Updated name

LastModified Date the content was last modified (UTC). datetime2 8  
1.0

IsDeleted

Content is deleted

bit

1

 

2.2 SortOrder Display sort order used for the content objects int 4  
2.5 / 3.0 Depth Indicates the number of nested hierarchical levels in the discussion post. int 4  
4.6 / 5.0 ToolId

Unique identifier for the tool.

Field can be null.

int 4 FK
4.6 / 5.0 IsHidden Content object has not been published yet bit 1  

4.7 / 5.1 - Updated description

ResultId

Release Condition unique result identifier.

Field can be null.

int 4  
4.6 / 5.0 DeletedDate

Date when the content object was deleted (UTC).

Field can be null.

datetime2 8  
4.6 / 5.0 CreatedBy

User who created the content object.

Field can be null.

int 4  
4.6 / 5.0 LastModifiedBy

User who last modified the content object.

Field can be null.

int 4  
4.6 / 5.0 DeletedBy

User who deleted the discussion forum.

Field can be null.

int 4  

 

Brightspace Data Set: Content User Completion

About

Returns information about specific user's completion of content topics. The Content User Completion data set is limited to 3 years of data (all of the previous two calendar years and the current calendar year to date).

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

1.0

ContentObjectId

Unique identifier of the content

int

4

PK, FK

1.0

OrgUnitId

Unique org unit identifier

int

4

FK

1.0

UserId

Unique user identifier

int

4

PK, FK

1.0

DateCompleted

Date content was completed (UTC).

Field can be null.

datetime2

8

 

6.7 LastModified

Date the content user completion was last modified (UTC).

Field can be null.

datetime2 8  

 

Brightspace Data Set: Content User Progress

About

Returns user progress records modified in the past three calendar years. Results are ordered from newest to oldest. The Content User Progress data set is limited to 3 years of data (all of the previous two calendar years and the current calendar year to date).

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

1.0

ContentObjectId

Unique identifier of the content

int

4

PK, FK

2.5 / 3.0 - Added FK

UserId

Unique user identifier

int

4

PK, FK

3.2 - Updated to indicate not in use.

CompletedDate

This column is currently not in use and appears as null.

datetime2

8

 

1.0

LastVisited

Date content was last visited (UTC).

Field can be null.

datetime2

8

 

1.0

IsRead

Is content read by user

bit

1

 

2.4 - Updated definition

NumRealVisits

Number of visits where the content is viewed, and the user continues in Brightspace. Recommend adding Real and Fake visits for total visits by a user.

int

4

 

2.4 - Updated definition

NumFakeVisits

Number of visits where the content is viewed and the user leaves by closing the browser/tab or the session times out while the content is open.

int

4

 

2.5 / 3.0 - Updated definition

TotalTime

Total real visit time spent in content, in seconds

bigint

8

 

1.0

IsVisited

Is content visited by user

bit

1

 

1.0

IsCurrentBookmark

Is content bookmarked

bit

1

 

1.0

IsSelfAssessComplete

Is self assessment topic completed

bit

1

 

2.5 / 3.0 LastModified

Indicates the last time the user progress record was changed.

datetime2

8