Outcomes and recognition

Competency Activities data set: columns, keys and joins

Primary key: ActivityId 17 columns

Checked against D2L on October 31, 2026

Back to the map

Columns

Column	Type	Size	Key
`ActivityId`	`bigint`	`8`	PK
`OrgUnitId`	`int`	`4`	FK
`ActivityName`	`nvarchar`	`256`
`ActivityTypeId`	`int`	`4`
`AssessmentType`	`varchar`	`7`
`ObjectLookupId`	`bigint`	`8`
`RubricId`	`bigint`	`8`
`LevelId`	`bigint`	`8`
`RubricCriterionId`	`bigint`	`8`
`AssessmentThresholdCriteria`	`varchar`	`2`
`AssessmentThreshold`	`decimal`	`19, 9`
`IsAutoEval`	`bit`	`1`
`RubricName`	`nvarchar`	`256`
`RubricLevelRequired`	`nvarchar`	`256`
`ObjectId`	`bigint`	`8`	FK
`ActivityType`	`nvarchar`	`50`
`Version`	`bigint`	`8`

Joins to (2)

Competency ObjectsObjectId → ObjectId
Organizational UnitsOrgUnitId → OrgUnitId

Joined from (1)

Competency Activity ResultsActivityId → ActivityId

Edit history links

None

Source

Source: Competency data sets on the D2L Brightspace Community