Outcomes and recognition

Award Objects data set: columns, keys and joins

Primary key: AwardId 13 columns

Checked against D2L on October 31, 2026

Back to the map

Columns

Column	Type	Size	Key
`AwardId`	`bigint`	`8`	PK
`Name`	`nvarchar`	`256`
`AwardTypeId`	`int`	`4`
`Type`	`nvarchar`	`128`
`Description`	`nvarchar`	`512`
`ExpiryCalculationType`	`nvarchar`	`128`
`ExpiryNotificationType`	`nvarchar`	`128`
`ExpiryDate`	`datetime2`	`8`
`ImagePath`	`varchar`	`1000`
`CreatedByUserId`	`bigint`	`8`
`LastModified`	`datetime2`	`8`
`IsDeleted`	`bit`	`1`
`Criteria`	`nvarchar`	`1000`

Joins to (0)

None

Joined from (2)

Awards IssuedAwardId → AwardId
Course AwardsAwardId → AwardId

Edit history links

None

Source

Source: Awards data sets on the D2L Brightspace Community