Outcomes and recognition

Competency Log data set: columns, keys and joins

Primary key: CompetencyLogId 13 columns

Checked against D2L on October 31, 2026

Back to the map

Columns

Column	Type	Size	Key
`CompetencyLogId`	`bigint`	`8`	PK
`LogTypeId`	`int`	`4`
`LogTypeName`	`varchar`	`19`
`ObjectId`	`bigint`	`8`	FK
`ObjectTypeId`	`int`	`4`
`ObjectTypeName`	`varchar`	`18`
`ObjectVersion`	`int`	`4`
`LogDateTime`	`datetime2`	`8`
`ModifiedBy`	`bigint`	`8`	FK
`IndirectObjectId`	`bigint`	`8`
`IndirectObjectTypeName`	`varchar`	`18`
`IndirectObjectTypeId`	`int`	`4`
`IndirectObjectVersion`	`int`	`4`

Joins to (1)

Competency ObjectsObjectId → ObjectId

Joined from (0)

None

Edit history links

UsersModifiedBy → UserId

Source

Source: Competency data sets on the D2L Brightspace Community