Brightspace Data Sets for Activity Feed have a dependency on the Activity Feed widget. If you turn this widget on and off during the data set query period, there may be unexpected or missing content in your data sets.
Entity Relationship Diagram
The following diagram shows the relationships between entities used to create Brightspace Data Sets for Activity Feed. To enlarge the diagram, right-click on the image and select Open image in a new tab.
Activity Feed Comment Log
The Activity Feed Comment Log Brightspace Data Set returns details on all actions that occur to each comment in the organization.
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 5.8 / 6.1 |
LogId |
Unique log entry identifier. |
uniqueidentifier |
16 |
PK |
| 5.8 / 6.1 |
UserId |
Unique identifier of the user who last modified the comment. |
int |
4 |
FK |
| 5.8 / 6.1 |
OrgUnitId |
Unique organization unit identifier. |
int |
4 |
FK |
| 5.8 / 6.1 |
CommentId |
Unique comment identifier. |
uniqueidentifier |
16 |
|
| 5.8 / 6.1 |
Action |
Indicates whether the comment was created, updated, or deleted. |
nvarchar |
16 |
|
| 5.8 / 6.1 |
ActionDate |
Date the comment was created, updated, or deleted (UTC). |
datetime2 |
8 |
|
| 5.8 / 6.1 |
Content |
Text of the comment. |
nvarchar |
3072 |
|
| 5.9 / 6.2 - Added Key |
PostId |
Unique identifier for the parent post. |
uniqueidentifier |
16 |
FK |
Activity Feed Comment Objects
The Activity Feed Comment Objects Brightspace Data Set returns details on each comment in the organization.
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 5.9/6.2 |
OrgUnitId |
Unique org unit identifier.
|
int |
4 |
FK |
| 5.9/6.2 |
CommentId |
Unique comment identifier.
|
uniqueidentifier
|
16 |
PK |
| 5.9/6.2 |
LastModifiedBy |
Unique identifier of the user who last modified the comment. |
int |
4 |
FK |
| 5.9/6.2 |
LastModified |
Date the comment was created, updated, or deleted (UTC). |
datetime2
|
8 |
|
| 5.9/6.2 |
Content
|
The text of the comment.
|
nvarchar
|
3072 |
|
| 5.9/6.2 |
IsDeleted
|
Indicates if the comment has been deleted.
|
bit |
1 |
|
| 5.9/6.2 |
PostId
|
Unique identifier for the parent post.
|
uniqueidentifier
|
16 |
FK |
| 5.9/6.2 |
Version
|
Version of comment.
|
bigint |
8 |
|
Activity Feed Post Log
The Activity Feed Post Log Brightspace Data Set returns details on all actions that occur to each post in the organization.
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 5.8 / 6.1 |
LogId |
Unique log entry identifier |
uniqueidentifier |
16 |
PK |
| 5.8 / 6.1 |
UserId |
Unique identifier of the user who last modified the post. |
int |
4 |
FK |
| 5.8 / 6.1 |
OrgUnitId |
Unique org unit identifier.
|
int |
4 |
FK |
| 5.8 / 6.1 |
PostId |
Unique post identifier. |
uniqueidentifier |
16 |
|
| 5.8 / 6.1 |
PostType |
Type of post. |
nvarchar |
16 |
|
| 5.8 / 6.1 |
Action |
Indicates whether the post was created, updated, or deleted. |
nvarchar |
16 |
|
| 5.8 / 6.1 |
ActionDate |
Date the post was created, updated, or deleted (UTC). |
datetime2 |
8 |
|
| 5.8 / 6.1 |
DropboxId |
Unique ID of the posted assignment, if the post is of type assignment. Field can be null. |
bigint |
8 |
FK |
| 5.8 / 6.1 |
Content |
The text of the message post, if the post is of type message. Field can be null. |
nvarchar |
3072 |
|
| 5.8 / 6.1 |
CommentCount |
Number of comments associated with the post. |
int |
4 |
|
| 5.8 / 6.1 |
AttachmentCount |
Indicates the number of attachments associated with the post, if the post is of type message. Field can be null. |
int |
4 |
|
Activity Feed Post Objects
The Activity Feed Post Objects Brightspace Data Set returns details on each post in the organization.
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 5.9 / 6.2 |
OrgUnitId |
Unique org unit identifier.
|
int |
4 |
FK |
| 5.9 / 6.2 |
PostId |
Unique post identifier.
|
uniqueidentifier
|
16 |
PK |
| 5.9 / 6.2 |
PostType
|
The type of post.
|
nvarchar
|
16 |
|
| 5.9 / 6.2 |
LastModifiedBy
|
Unique identifier of the user who last modified the post.
|
int |
4 |
FK |
| 5.9 / 6.2 |
LastModified |
Date the post was created, updated, or deleted (UTC).
|
datetime2
|
8 |
|
| 5.9 / 6.2 |
DropboxId
|
Unique identifier of the posted assignment, if the post is of type assignment. Field can be null.
|
bigint |
8 |
FK |
| 5.9 / 6.2 |
Content
|
The text of the message post, if the post is of type message.
Field can be null.
|
nvarchar |
3072 |
|
| 5.9 / 6.2 |
IsDeleted
|
Indicates if the post has been deleted.
|
bit |
1 |
|
| 5.9 / 6.2 |
CommentCount |
Indicates the number of comments associated with the post.
|
int |
4 |
|
| 5.9 / 6.2 |
AttachmentCount |
Indicates the number of attachments associated with the post, if the post is of type message.
Field can be null.
|
int |
4 |
|
| 5.9 / 6.2 |
Version |
Version of post. |
bigint |
8 |
|