Outcomes and recognition

Outcomes Assessed Checkpoints data set: columns, keys and joins

Primary key: CheckpointIdDemonstrationId 14 columns

Checked against D2L on October 31, 2026

Back to the map

Columns

Column	Type	Size	Key
`CheckpointId`	`uniqueidentifier`	`16`	PK
`DemonstrationId`	`uniqueidentifier`	`16`	PK, FK
`Feedback`	`nvarchar`	`1000`
`ConfigDecayRate`	`int`	`4`
`ConfigAggregationMethod`	`int`	`4`
`ConfigIncludedActivities`	`int`	`4`
`ConfigMultipleAttemptStrategy`	`int`	`4`
`ConfigRecentlyAssessedActivityCount`	`int`	`4`
`ConfigTieBreaker`	`int`	`4`
`LastModifiedDate`	`datetime2`	`8`
`LastModifiedBy`	`int`	`4`
`IsDeleted`	`bit`	`1`
`HasMetAchievementThreshold`	`bit`	`1`
`AchievedLevelId`	`uniqueidentifier`	`16`

Joins to (1)

Outcomes DemonstrationsDemonstrationId → DemonstrationId

Joined from (0)

None

Edit history links

None

Source

Source: Outcomes data sets on the D2L Brightspace Community