Outcomes and recognition

Competency Objects data set: columns, keys and joins

Primary key: ObjectId 12 columns

Checked against D2L on October 31, 2026

Back to the map

Columns

Column	Type	Size	Key
`ObjectId`	`bigint`	`8`	PK
`OrgUnitId`	`int`	`4`	FK
`Name`	`nvarchar`	`256`
`Type`	`varchar`	`256`
`ReadyForEvaluation`	`bit`	`1`
`Status`	`varchar`	`9`
`Description`	`nvarchar`	`1000`
`NeedReevaluation`	`bit`	`1`
`ReevaluationIfAchieved`	`bit`	`1`
`ReevaluationIfNotAchieved`	`bit`	`1`
`AdditionalIdentifier`	`nvarchar`	`512`
`IsHidden`	`bit`	`1`

Joins to (1)

Organizational UnitsOrgUnitId → OrgUnitId

Joined from (3)

Competency ActivitiesObjectId → ObjectId
Competency LogObjectId → ObjectId
Competency StructureObjectId → ObjectId

Edit history links

None

Source

Source: Competency data sets on the D2L Brightspace Community