Content and tools

SCORM Objects data set: columns, keys and joins

Primary key: ScormObjectId 11 columns

Checked against D2L on October 31, 2026

Back to the map

Columns

Column	Type	Size	Key
`ScormObjectId`	`uniqueidentifier`	`16`	PK
`OrgUnitId`	`int`	`4`	FK
`ContentObjectId`	`int`	`4`	FK
`ContentServiceContentId`	`uniqueidentifier`	`16`
`ContentServiceRevisionId`	`uniqueidentifier`	`16`
`ContentServiceTopicId`	`uniqueidentifier`	`16`
`Title`	`nvarchar`	`1000`
`Description`	`nvarchar`	`1000`
`LearningStandard`	`nvarchar`	`100`
`LastModified`	`datetime2`	`8`
`LastModifiedBy`	`int`	`4`	FK

Joins to (1)

Organizational UnitsOrgUnitId → OrgUnitId

Joined from (3)

SCORM ActivitiesScormObjectId → ScormObjectId
SCORM ObjectivesScormObjectId → ScormObjectId
SCORM VisitsScormObjectId → ScormObjectId

Edit history links

UsersLastModifiedBy → UserId

Foreign keys without a stated target

ContentObjectId: Marked as a foreign key by D2L, without a stated target data set.

Source

Source: SCORM data sets on the D2L Brightspace Community