Brightspace Data Sets for Content Service have a dependency on Media Library. 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
The following diagram shows the relationships between entities used to create Brightspace Data Sets for Content Service. To enlarge the diagram, right-click on the image and select Open image in a new tab.
Audio Video Processed
In the Audio Video Processed Brightspace Data Set, each row represents one completed media processing job. The data set captures events from January 2022 onwards.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 8.10 |
ContentId
|
Unique content identifier.
|
uniqueidentifier
|
16
|
PK, FK
|
| 8.10 |
RevisionId
|
Unique revision identifier. |
uniqueidentifier
|
16
|
PK
|
| 8.10 |
RevisionNumber |
Indicates the version of the media object that this processing job applies to. For example: for a video that's been edited 4 times, the row representing the media processing job for version 3 will have "3" in this column.
|
int
|
4
|
|
| 8.10 |
Type |
Type of content for this revision: Audio or Video. |
nvarchar
|
5
|
|
| 8.10 |
Source |
Location in Brightspace from which the content was added.
Field can be null.
|
nvarchar
|
32
|
|
| 8.10 |
RevisionSize |
Size of all resources for this revision in bytes. |
bigint
|
8
|
|
| 8.10 |
Duration |
Duration of the revision in seconds. |
int
|
4
|
|
| 8.10 |
RequiredTranscoding |
True if the revision required transcoding. |
bit
|
1
|
|
| 8.10 |
RequiredTranscribing |
True if the revision required transcribing. |
bit
|
1
|
|
|
8.10
|
LastModified |
Date this revision was last modified (UTC). |
datetime2
|
8
|
|
Media Consumption Log
In the Media Consumption Log Brightspace Data Set, each row represents one session where a user interacted with a media object, beginning when the user starts playback and ending when the user stops engaging with the media object. The data set captures events from November 2023 onwards.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 8.10 |
LogId
|
Unique identifier for this consumption session.
|
uniqueidentifier
|
16
|
PK
|
| 8.10 |
UserId |
Unique identifier for the user who consumed the content. |
int
|
4
|
FK
|
| 8.10 |
ContentId |
Unique identifier for the content that was consumed. |
uniqueidentifier
|
16
|
FK
|
| 8.10 |
RevisionId |
Unique identifier for the revision of the content that was consumed. |
uniqueidentifier
|
16
|
|
| 8.10 |
ContentType |
Type of content for this revision: Audio or Video. |
nvarchar |
5 |
|
| 8.10 |
ClientApp |
Location in Brightspace from which the content was added.
Field can be null.
|
nvarchar |
32 |
|
| 8.10 |
DateConsumed |
Date and time when the user started this consumption session (UTC). |
datetime2 |
8 |
|
| 8.10 |
DurationPercentageWatched |
Percentage (from 0 to 100) of the content's duration that the user consumed in this session. |
int |
4 |
|
Media Objects
In the Media Objects Brightspace Data Set, each row represents one audio or video content object uploaded to Media Library. The data set captures media objects from January 2022 onwards.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 8.10 |
ContentId
|
Unique content identifier.
|
uniqueidentifier
|
16
|
PK
|
| 8.10 |
Title |
Title of the media object. |
nvarchar
|
1000
|
|
| 8.10 |
RevisionCount |
Number of revisions of this media object. |
int
|
4
|
|
| 8.10 |
OwnerId |
Brightspace user identifier for the owner of the media object. |
int
|
4
|
FK
|
| 8.10 |
LastModified |
Date the media object was last modified (UTC). |
datetime2
|
8
|
|