Brightspace Data Sets for Creator+ are only visible in Brightspace instances with Creator+ enabled. The d2l.Tools.CreatorPlus.IsEnabled configuration variable must be set to ON at the org level. 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 Creator+. To enlarge the diagram, right-click on the image and select Open image in a new tab.
Creator+ Practices Adoption
In the Creator+ Practices Adoption Brightspace Data Set, each row represents a Practice created using Creator+.
Version History
|
Field
|
Description
|
Type
|
Size
|
Key
|
---|
9.7 |
ActivityInstanceId |
Identifies the unique location of the Practice within a Brightspace course. If a Practice appears multiple times in a course, this value changes but the CourseId and ProviderObjectId remain the same.
|
int
|
4
|
PK
|
9.7 |
CreatedById |
Identifies the user who created the Practice. |
int
|
4
|
FK
|
9.8 - Change Field name |
OrgUnitId
|
Identifies the Brightspace organizational unit containing the Practice.
Field can be null.
|
int
|
4
|
FK
|
9.7 |
PracticeType
|
The type of Practice. |
nvarchar
|
32
|
|
9.7 |
PracticeTitle |
The title provided by the creator of the Practice.
|
nvarchar
|
255
|
|
9.7 |
ProviderObjectId |
ID of the Practice on the provider service. If a Practice is copied to multiple courses, the CourseId changes but this value remains the same. |
int
|
4
|
|
9.7 |
CreatedDate |
The date and time (UTC) the Practice was created. For Practices created before July 2024, this is the date the Practice was transformed into a data-enabled Practice. |
datetime2
|
8
|
|
9.7 |
Version |
Indicates the version of the row. This information is used to determine which table row occurred first.
|
int
|
4
|
|
Creator+ Practices Engagement
In the Practices Engagement Brightspace Data Set, each row represents an instance where a learner attempted a Practice and checked their answer.
Version History
|
Field
|
Description
|
Type
|
Size
|
Key
|
---|
9.8 |
PracticeEngagementId
|
Identifies each attempt available for a learner to complete a Practice.
|
int
|
4
|
PK
|
9.8 |
UserId
|
Identifies the user engaging with the Practice attempt. |
int
|
4
|
FK
|
9.8 |
OrgUnitId |
Identifies the Brightspace course containing the Practice.
Field can be null.
|
int
|
4
|
FK
|
9.8 |
CompletionStatus |
The status of the engagement: NotStarted or Completed. |
nvarchar
|
10
|
|
9.8 |
ActivityInstanceId |
Identifies the Practice being attempted.
|
int
|
4
|
FK
|
9.8 |
CompletionDate |
The date and time (UTC) the attempt was completed. |
datetime2
|
8
|
|
9.8 |
Version |
Indicates the version of the row. This information is used to determine which table row occurred first.
|
int
|
4
|
|