Brightspace Data Sets for Content have no tool dependencies.
Entity Relationship Diagram
The following diagram shows the relationships between entities used to create Brightspace Data Sets for Content. To enlarge the diagram, right-click on the image and select Open image in a new tab.
Content Files Properties Log
In the Content Files Properties Log Brightspace Data Set, each row represents a change (created, edited, or deleted) to a file that is linked to a content object within an org unit. The data set only captures changes to content files from July 2022 onwards.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 7.8 |
OrgUnitId
|
Unique org unit identifier.
|
int
|
4
|
PK, FK
|
| 7.8 |
ContentObjectId
|
Unique identifier of the content object.
|
int
|
4
|
PK, FK
|
| 7.8 |
Action
|
Action taken on the file: Created, Updated, or Deleted.
|
nvarchar
|
10
|
|
| 7.8 |
FilePath
|
Virtual file path of the file.
|
nvarchar
|
10000
|
|
| 7.8 |
FileName
|
Name of the file.
|
nvarchar
|
512
|
|
| 7.8 |
FileExtension
|
Extension of the file.
|
nvarchar
|
512
|
|
| 7.8 |
FileSizeBytes
|
Size of the file in bytes.
|
bigint
|
8
|
|
| 7.8 |
UploadDate
|
Time the file was uploaded (UTC).
|
datetime2
|
8
|
|
| 7.8 |
LastModifiedBy
|
Unique user identifier that last modified the file.
Field can be null.
|
int
|
4
|
FK
|
|
7.8
|
LastModified
|
The last time the file was modified (UTC).
|
datetime2
|
8
|
PK
|
FAQ
Q: Does this data set provide the size of all files within Brightspace?
A: No. This data set only provides data on files associated with content objects. Additionally, it only surfaces data for newly uploaded, edited, or deleted files (associated with content) starting with the release of the data set in July 2022. It does not provide any historical data.
Q: Are Active and Inactive courses included in the data?
A: Yes. As long as the files are associated with a content object, it doesn't matter whether the course is active or inactive.
Q: Are all file formats included in the data?
A: Yes, all file formats are included when associated with a content object. However, please be aware that this data set does NOT include files that are embedded within an HTML content object.
Q: If courses are copied (via Course Copy or CCS) or imported, will files associated with the newly created course be included in the data?
A: Yes, files that are associated with content objects within a copied or imported course are surfaced in the data set with "Created" in the Action field.
Content Objects
The Content Objects Brightspace Data Set returns information about content topics and modules created for your org units.
Version
History
|
Field
|
Description
|
Type
|
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
|
|
| 7.13 - Updated column size |
Location
|
Location of the content asset.
Field can be null.
|
nvarchar
|
1024
|
|
| 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
|
|
| 8.10 - Updated description |
ObjectId1
|
Quick link Object ID for the associated tool. Maps to DropboxId, QuizId, ChecklistId, SurveyId, ChatId, Self-AssessmentId. For Discussions, this field is used if a Forum is quicklinked.
Field can be null.
|
int
|
4
|
|
| 8.10 - Updated description |
ObjectId2
|
Quick link Object ID, only used for the Discussion tool if a Topic is quicklinked.
Field can be null.
|
int
|
4
|
|
| 8.10 - Updated description |
ObjectId3
|
Quick link Object ID, only used for the Discussion tool if a Thread is quicklinked.
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 |
|
| 8.6 - Updated description |
DeletedBy |
User who deleted the content object.
Field can be null.
|
int |
4 |
|
Content User Completion
The Content User Completion Brightspace Data Set returns information about specific user's completion of content topics. The data set is limited to 3 years of data (all of the previous two calendar years and the current calendar year to date).
Version
History
|
Field
|
Description
|
Type
|
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 |
|
Content User Progress
The Content User Progress Brightspace Data Set returns user progress records modified in the past three calendar years. Results are ordered from newest to oldest. The Content User Progress Brightspace Data Set contains data from 1 January 2021 onwards and adheres to the default system limit of 150 million rows of the most recent data.
Version
History
|
Field
|
Description
|
Type
|
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
|
|
| 8.7 - Updated definition |
IsCurrentBookmark
|
Is content the last topic visited by user
|
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
|
|
| 9.10 |
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.
|
bigint |
8 |
|