Brightspace Data Sets for Checklist have a dependency on the Checklist tool. 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 Checklist. To enlarge the diagram, right-click on the image and select Open image in a new tab.
Checklist Category Details
The Checklist Category Details Brightspace Data Set returns information on categories within checklists.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 3.3 |
CategoryId |
Unique category identifier. |
bigint |
8 |
PK |
| 3.3 |
ChecklistId |
Unique checklist identifier. |
bigint |
8 |
FK |
| 5.7 / 6.0 - Changed Column Size |
Name |
Name of the checklist category. |
nvarchar |
512 |
|
| 3.3 |
Description |
Description of the category.
Field can be null.
|
nvarchar |
1000 |
|
| 3.3 |
DescriptionIsHtml |
Indicates if the description is in HTML. |
bit |
1 |
|
| 3.3 |
SortOrder |
The order in which the checklist categories are sorted. |
int |
4 |
|
| 3.3 |
LastModifiedUtc |
Last modified date/time (UTC).
Field can be null.
|
datetime2
|
8
|
|
| 8.9 |
DateDeleted |
Date the category was deleted (UTC).
Field can be null.
|
datetime2 |
8 |
|
| 8.9 |
DeletedBy |
User who deleted the checklist category.
Field can be null.
|
int |
4 |
FK |
| 8.9 |
Version |
Indicates the version of the checklist category. |
bigint |
8 |
|
Checklist Completions
The Checklist Completions Brightspace Data Set returns the completion status of each checklist item.
Note: The IsCompleted column is set to TRUE in all data prior to 20.23.8.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 1.0 |
UserId
|
Unique user Identifier.
|
int
|
4
|
PK, FK
|
| 8.11 / 9.0 - Changed description |
DateCompleted
|
Date the checklist item was last completed (UTC).
|
datetime2
|
8
|
|
| 1.0 |
ItemId |
Unique checklist item identifier. |
bigint |
8 |
PK, FK |
| 9.4 - Changed description |
LastModified |
Date the content user completion was last modified (UTC).
|
datetime2 |
8 |
|
| 9.4 |
IsCompleted |
Indicates whether the checklist item is currently complete or incomplete in the user's copy of the checklist. |
bit |
1 |
|
| 9.4 |
DateDeleted |
Date the completion status was deleted (UTC).
Field can be null.
|
datetime2 |
8 |
|
| 9.4 |
DeletedBy |
User who deleted the completion status.
Field can be null.
|
int |
4 |
FK |
| 9.4 |
Version |
Indicates the version of the completion status. |
bigint |
8 |
|
Checklist Item Details
The Checklist Item Details Brightspace Data Set returns information on each checklist item within a checklist.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 3.3 |
ItemId |
Unique checklist item identifier. |
bigint |
8 |
PK |
| 3.3 |
CategoryId |
Unique category identifier.
Field can be null.
|
bigint |
8 |
FK |
| 5.7 / 6.0 - Changed Column Size |
Name |
Checklist item name.
Field can be null.
|
nvarchar |
512 |
|
| 3.3 |
Description |
Checklist item description.
Field can be null.
|
nvarchar |
1000 |
|
| 3.3 |
DescriptionIsHtml |
Indicates if the description is in HTML. |
bit |
1 |
|
| 3.3 |
DueDate |
Date the item is due.
Field can be null.
|
datetime2 |
8 |
|
| 5.7 / 6.0 - Changed Type and Column Size |
ScheduleId |
Indicates the schedule to which this checklist belongs.
Field can be null.
|
int |
4 |
FK |
| 3.3 |
SortOrder |
The order in which the checklist items are sorted. |
int |
4 |
|
| 3.3 |
IsAutoChecked |
Indicates if the checklist item is automatically selected. |
bit |
1 |
|
| 3.3 |
LastModifiedUtc |
Last modified date/time (UTC).
Field can be null.
|
datetime2
|
8
|
|
| 8.9 |
DateDeleted |
Date the item was deleted (UTC).
Field can be null.
|
datetime2 |
8 |
|
| 8.9 |
DeletedBy |
User who deleted the checklist item.
Field can be null.
|
int |
4 |
FK |
| 8.9 |
Version |
Indicates the version of the checklist item. |
bigint |
8 |
|
Checklist Objects
The Checklist Objects Brightspace Data Set returns information on checklist attributes.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 3.3 |
ChecklistId |
Unique checklist identifier. |
bigint |
8 |
PK |
| 3.3 |
OrgUnitId |
Unique identifier for the org unit where the checklist exists. |
int |
4 |
FK |
| 5.7 / 6.0 - Changed Column Size |
Name |
Checklist name. |
nvarchar |
512 |
|
| 3.3 |
Description |
Description of the checklist.
Field can be null.
|
nvarchar |
1000 |
|
| 3.3 |
DescriptionIsHtml |
Indication if the description is in HTML. |
bit |
1 |
|
| 3.3 |
SharedUserId |
Unique user Id that the checklist is shared with.
Field can be null.
|
int |
4 |
FK |
| 3.3 |
DisplayInNewWindow |
Indicates if the checklist appears in a new browser window when viewed. |
bit |
1 |
|
| 3.3 |
SortOrder |
The order in which the checklist is sorted. |
int |
4 |
|
| 3.3 |
Version |
Indicates the version for this row entry.
Field can be null.
|
bigint |
8 |
|
| 4.9 / 5.3 |
ResultId |
Unique release condition result identifier.
Field can be null.
|
int |
4 |
FK |
| 8.10 |
DateDeleted |
Date the checklist item was deleted (UTC).
Field can be null.
|
datetime2 |
8 |
|
| 8.10 |
DeletedBy |
User who deleted the checklist item.
Field can be null.
|
int |
4 |
FK |