Outcomes and recognition

Outcome Details data set: columns, keys and joins

Primary key: OutcomeId 11 columns

Checked against D2L on October 31, 2026

Back to the map

Columns

Column	Type	Size	Key
`OutcomeId`	`uniqueidentifier`	`16`	PK
`OutcomeDefinitionSource`	`nvarchar`	`1000`
`OutcomeDefinitionId`	`nvarchar`	`128`
`ParentOutcomeId`	`uniqueidentifier`	`16`
`Description`	`nvarchar`	`1000`
`Notation`	`nvarchar`	`1000`
`CreatedDate`	`datetime2`	`8`
`CreatedBy`	`int`	`4`	FK
`LastModifiedDate`	`datetime2`	`8`
`LastModifiedBy`	`int`	`4`	FK
`IsDeleted`	`bit`	`1`

Joins to (0)

None

Joined from (2)

Outcomes in RegistriesOutcomeId → OutcomeId
Outcomes Rubric AlignmentsOutcomeId → OutcomeId

Edit history links

UsersCreatedBy → UserId
UsersLastModifiedBy → UserId

Source

Source: Outcomes data sets on the D2L Brightspace Community