Brightspace Data Sets for Discussions

Brightspace Data Sets for Discussions include:

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

Entity Relationship Diagram for Discussions

 

Brightspace Data Set: Discussion Posts

About

Returns discussion posts posted in the past three calendar years. Results are ordered from newest to oldest. The Discussion Posts 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.

Note: You can extract the body of the discussion post through the API.

Returned Fields

Version History

Field

Description

Type

Column Size

Key

1.0

OrgUnitId

Unique org unit identifier

Integer

4

FK

4.8 / 5.2 - Added FK

ForumId

Unique forum identifier

BigInteger

8

FK

2.5 / 3.0 - Added FK

TopicId

Unique topic identifier

BigInteger

8

FK

1.0

UserId

Unique user identifier

Integer

4

FK

1.0

PostId

Unique post identifier

BigInteger

8

PK

1.0

ThreadId

Unique thread identifier

BigInteger

8

 

1.0

IsReply

If post is a reply

Boolean

1

 

1.0

ParentPostId

Parent post Id. Field can be null.

BigInteger

8

FK

1.0

NumReplies

Number of replies to a post

Integer

4

 

1.0

DatePosted

Date the post was made (UTC)

DateTime

8

 

1.0

IsDeleted

Is post deleted

Boolean

1

 

1.0

RatingSum

Sum of all ratings for a post

BigInteger

8

 

1.0

NumRatings

Number of ratings for a post

BigInteger

8

 

4.8 / 5.2 - Updated column size

Score

Users score on the post (if graded). Field can be null.

Numeric

19, 9

 

2.2 - Added LastEditDate Indicates the date when the discussion post was edited. (UTC) DateTime 8  
2.2 - Added SortOrder Display sort order used for the content objects Integer 4  
3.0 / 2.5 - Added Depth Indicates the number of nested hierarchical levels in the discussion post. Integer 4  
3.7 / 4.2 - Added Thread Discussion thread name. Field can be null. Nvarchar 400  

 

Brightspace Data Set: Discussion Posts Read Status

About

Returns details on discussion posts read by users for your org units. The Discussion Post Read Status 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

TopicId

Unique topic identifier

BigInteger

8

FK

1.0

UserId

Unique user identifier

Integer

4

PK

FK

1.0

PostId

Unique post identifier

BigInteger

8

PK

FK

1.0

IsRead

If post has been read

Boolean

1

 

1.0

FirstReadDate

First time the post was read. Field can be null (UTC).

DateTime

8

 

1.0

LastReadDate

Latest date when post was read. Field can be null (UTC).

DateTime

8

 

 

Brightspace Data Set: Discussion Topic User Scores

About

Returns the scores a user received for a discussion topic.

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

UserId

Unique user identifier

Integer

4

PK,

FK

1.0

TopicId

Unique topic identifier

BigInteger

8

PK,

FK

4.8 / 5.2 - Updated column size

Score

Topic score. Field can be null.

Numeric

19, 9

 

1.0

IsGraded

If topic was graded

Boolean

1

 

4.7 / 5.0 - Added Version Indicates the version of the row. This information is used to determine which table row occurred first, similar to the way time stamps function in other data sets. Timestamp 8  

 

Brightspace Data Set: Discussion Forums

About

Returns discussion forums. Results are ordered from newest to oldest.

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

2.3

OrgUnitId

Unique org unit identifier.

Integer

4

FK

2.3

ForumId

Unique forum identifier.

BigInteger

8

PK
2.4 - Updated Name Name of the discussion topic. nvarchar 800  
2.4 - Updated Description Description of the discussion forum. nvarchar Truncated to 1000 characters. To change the default value, contact D2L.  
2.3 VisibleStartDate First date when the discussion forum is visible to learners. (UTC). Can be null. DateTime 8  
2.3 VisibleEndDate Last date when the discussion forum is visible to learners (UTC). Can be null. DateTime 8  
2.3 PostingStartDate First date when learners can post to the discussion forum (UTC). Can be null. DateTime 8  
2.3 PostingEndDate Last date when learners can post to the discussion forum (UTC). Can be null. DateTime 8  
2.3 MustPostToParticipate Indicates that a user must post in the discussion forum in order to participate in any discussion threads. Boolean

1

 
2.3 AllowAnon Indicates whether there is anonymous posting permitted for the discussion forum. Boolean

1

 
2.3 IsHidden Indicates whether the discussion forum is hidden. Boolean

1

 
2.3 RequiresApproval Indicates that the discussion forum requires approval from a moderator before contributions to the forum are posted. Boolean

1

 
2.3 SortOrder Display sort order used for the content objects Integer 4  
2.3

IsDeleted

Indicates if the discussion topic is deleted

Boolean

1

 

2.3

DeletedDate

Date when the discussion forum was deleted. (UTC). Can be null

DateTime

8

 

2.3

DeletedByUserId

User who deleted the discussion forum. Can be null.

Integer

4

FK

4.9 / 5.3 - Added ResultId Unique release condition result identifier. Field can be null. Integer 4 FK

 

Brightspace Data Set: Discussion Topics

About

Returns discussion topics. Results are ordered from newest to oldest.

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

2.3

OrgUnitId

Unique org unit identifier.

Integer

4

 

2.3

TopicId

Unique topic identifier.

BigInteger

8

PK
2.3 ForumId Unique discussion forum identifier.

BigInteger

8

FK
2.4 Name Name of the discussion topic. nvarchar 1000  
2.4 Description Description of the discussion topic. nvarchar Truncated to 1000 characters. To change the default value, contact D2L.  
2.3 VisibleStartDate First date when the discussion topic is visible to learners. (UTC). Can be null. DateTime 8  
2.3 VisibleEndDate Last date when the discussion topic is visible to learners (UTC). Can be null. DateTime 8  
2.3 PostingStartDate First date when learners can post to the discussion topic (UTC). Can be null. DateTime 8  
2.3 PostingEndDate Last date when learners can post to the discussion topic (UTC). Can be null. DateTime 8  
2.3 MustPostToParticipate Indicates that a user must post in the discussion topic in order to participate in any discussion threads. Boolean

1

 
2.3 AllowAnon Indicates whether there is anonymous posting permitted for the discussion topic. Boolean

1

 
2.3 IsHidden Indicates whether the discussion topic is hidden. Boolean

1

 
2.3 RequiresApproval Indicates that the discussion topic requires approval from a moderator before contributions to the forum are posted. Boolean

1

 
2.3 LastPostDate Indicates the last time a post was made to the discussion topic (UTC). Can be null. DateTime 8  
2.3 LastPostUserId Indicates the last user who made a post to the discussion topic. Can be null. BigInteger 8  
2.3

NumViews

Indicates the number of views on the discussion topic.

BigInteger

8

 

2.3 SortOrder Display sort order used for the content objects. Integer 4  
2.3

IsDeleted

Indicates if the discussion topic is deleted.

Boolean

1

 

2.3

DeletedDate

Date when the discussion topic was deleted. (UTC). Can be null.

DateTime

8

 

2.3

DeletedByUserId

User who deleted the discussion topic. Can be null.

Integer

4

FK

3.8/4.3 GradeItemId Unique grade identifier. Field can be null. Integer 4 FK
3.8/4.3 ScoreOutOf Topic score used to evaluate the discussion thread. Field can be null. Note: Score can exceed ScoreOutOf. Float 9  
3.8/4.3 ScoreCalculationMethod Method used to calculate score. Strings are predefined, with the following values:
Average - Calculates the score from the average score of each post in the topic made by a user.
Max - Calculates the score based on the maximum score of any one post in the topic for a user.
Min - Calculates the score based on the minimum score of any one post in the topic for a user.
Mode Max - Given the number of posts, selects the score that is repeated the most. If there is a tie, it takes the highest score.
Mode Min - Given the number of posts, selects the score that is repeated the most. If there is a tie, it takes the lowest score.
Sum - Calculates the score from the sum of scores on each post in a topic for a user.
Blank value (null) - The score is not calculated based on the scores of each post (Manual updates).
String 19  
3.8/4.3 IncludeNonScoredValues Indicates whether to include non-scored values. True posts that have not been scored are scored as 0. Otherwise, posts without a score are not included in the score aggregate (defined in the ScoreCalculationType). Boolean 1  
3.8/4.3 Version Indicates the version of the row. This information is used to determine which table row occurred first, similar to the way time stamps function in other data sets. Timestamp 8  
4.9 / 5.3 - Added ResultId Unique release condition result identifier. Field can be null. Integer 4 FK