Brightspace Data Sets for Checklist

Brightspace Data Sets for Checklist include:

This data set has a dependency on Checklist. 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

To show the relationships between entities used to create Brightspace Data Sets for Checklist, click the following thumbnail image:

Entity Relationship Diagram for Checklist

Brightspace Data Set: Checklist Completions

About

Returns the completion status of each checklist item.

Data Set Availability

This data set is available as:

  • Full CSV, produced on a weekly basis, containing all of the data.
  • Differential CSV, produced on a daily basis or hourly basis as a paid add-on, containing the differences (diffs) of the data that was updated or inserted since the last successful differential which is typically the previous day or hour, respectively.

Returned Fields

Version History

Field

Description

Type

Column Size

Key

1.0

UserId

Unique user Identifier.

int

4

PK, FK

1.0

DateCompleted

Checklist completion date (UTC).

datetime2

8

 

1.0 ItemId Unique checklist item identifier. bigint 8 PK, FK
6.8 LastModified

Date the content user completion was last modified (UTC).

Field can be null.

datetime2 8  

 

Brightspace Data Set: Checklist Item Details

About

Returns information on each checklist item within a checklist.

Data Set Availability

This data set is available as:

  • Full CSV, produced on a weekly basis, containing all of the data.
  • Differential CSV, produced on a daily basis or hourly basis as a paid add-on, containing the differences (diffs) of the data that was updated or inserted since the last successful differential which is typically the previous day or hour, respectively.

Returned Fields

Version History

Field

Description

Type

Column 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

 

 

Brightspace Data Set: Checklist Category Details

About

Returns information on categories within checklists.

Data Set Availability

This data set is available as:

  • Full CSV, produced on a weekly basis, containing all of the data.
  • Differential CSV, produced on a daily basis or hourly basis as a paid add-on, containing the differences (diffs) of the data that was updated or inserted since the last successful differential which is typically the previous day or hour, respectively.

Returned Fields

Version History

Field

Description

Type

Column 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  
7.0 - REMOVED NumberofItems Number of items in the checklist category. int 4  
3.3 LastModifiedUtc

Last modified date/time (UTC).

Field can be null.

datetime2

8

 

 

Brightspace Data Set: Checklist Objects

About

Returns information on checklist attributes.

Data Set Availability

This data set is available as:

  • Full CSV, produced on a weekly basis, containing all of the data.
  • Differential CSV, produced on a daily basis or hourly basis as a paid add-on, containing the differences (diffs) of the data that was updated or inserted since the last successful differential which is typically the previous day or hour, respectively.

Returned Fields

Version History

Field

Description

Type

Column 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  
7.0 - REMOVED ChecklistItemCount The number of items in the checklist 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