Outcomes and recognition

Checklist Item Details data set: columns, keys and joins

Primary key: ItemId 13 columns

Checked against D2L on October 31, 2026

Back to the map

Columns

Column	Type	Size	Key
`ItemId`	`bigint`	`8`	PK
`CategoryId`	`bigint`	`8`	FK
`Name`	`nvarchar`	`512`
`Description`	`nvarchar`	`1000`
`DescriptionIsHtml`	`bit`	`1`
`DueDate`	`datetime2`	`8`
`ScheduleId`	`int`	`4`	FK
`SortOrder`	`int`	`4`
`IsAutoChecked`	`bit`	`1`
`LastModifiedUtc`	`datetime2`	`8`
`DateDeleted`	`datetime2`	`8`
`DeletedBy`	`int`	`4`	FK
`Version`	`bigint`	`8`

Joins to (1)

Checklist Category DetailsCategoryId → CategoryId

Joined from (1)

Checklist CompletionsItemId → ItemId

Edit history links

UsersDeletedBy → UserId

Foreign keys without a stated target

ScheduleId: Marked as a foreign key by D2L, without a stated target data set.

Source

Source: Checklist data sets on the D2L Brightspace Community