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

Integer

4

PK

FK

1.0

DateCompleted

Checklist completion date (UTC)

DateTime

8

 

1.0 ItemId Unique checklist item identifier BigInteger 8 PK

 

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 BigInteger 8 PK
3.3 CategoryId Unique category identifier BigInteger 8 FK
3.3 Name Checklist item name. Field can be null. nvarchar 1024  
3.3 Description Checklist item description. Can be null nvarchar Truncated to 1000 characters. To change the default value, contact D2L.  
3.3 DescriptionIsHtml Indicates if the description is in HTML. Boolean 1  
3.3 DueDate Date the item is due. Can be null DateTime 8  
3.3 ScheduleId Indicates the schedule to which this checklist belongs. Can be null. BigInteger 8 FK
3.3 SortOrder The order in which the checklist items are sorted. Integer 4  
3.3 IsAutoChecked Indicates if the checklist item is automatically selected. Boolean 1  
3.3 LastModifiedUtc Last modified date/time (UTC)

DateTime

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 BigInteger 8 PK
3.3 ChecklistId Unique checklist identifier BigInteger 8 FK
3.3 Name Name of the checklist category nvarchar 1024  
3.3 Description Description of the category. Can be null nvarchar Truncated to 1000 characters. To change the default value, contact D2L.  
3.3 DescriptionIsHtml Indicates if the description is in HTML. Boolean 1  
3.3 SortOrder The order in which the checklist categories are sorted. Integer 4  
3.3 NumberofItems Number of items in the checklist category Integer 4  
3.3 LastModifiedUtc Last modified date/time (UTC)

DateTime

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 BigInteger 8 PK
3.3 OrgUnitId Unique identifier for the org unit where the checklist exists. Integer 4 FK
3.3 Name Checklist name nvarchar 1024  
3.3 Description Description of the checklist. Can be null. nvarchar Truncated to 1000 characters. To change the default value, contact D2L.  
3.3 DescriptionIsHtml Indication if the description is in HTML. Boolean 1  
3.3 SharedUserId Can be null Integer 4 FK
3.3 DisplayInNewWindow Indicates if the checklist appears in a new browser window when viewed. Boolean 1  
3.3 SortOrder The order in which the checklist is sorted. Integer 4  
3.3 ChecklistItemCount The number of items in the checklist Integer 4  
3.3 Version Indicates the version for this row entry. TimeStamp 8  
4.9 / 5.3 - Added ResultId Unique release condition result identifier. Field can be null. Integer 4 FK