Content and tools

SCORM Activities data set: columns, keys and joins

Primary key: ActivityId 12 columns

Checked against D2L on October 31, 2026

Back to the map

Columns

Column	Type	Size	Key
`ActivityId`	`uniqueidentifier`	`16`	PK
`ScormObjectId`	`uniqueidentifier`	`16`	FK
`ParentActivityId`	`uniqueidentifier`	`16`	FK
`NumChildren`	`int`	`4`
`InternalId`	`nvarchar`	`255`
`Title`	`nvarchar`	`200`
`CompletionThreshold`	`float`	`24`
`PassingScore`	`float`	`24`
`PassingScoreUsed`	`bit`	`1`
`ScoreMin`	`float`	`24`
`ScoreMax`	`float`	`24`
`LastModified`	`datetime2`	`8`

Joins to (1)

SCORM ObjectsScormObjectId → ScormObjectId

Joined from (4)

SCORM Activity AttemptsActivityId → ActivityId
SCORM Interaction AttemptsActivityId → ActivityId
SCORM InteractionsActivityId → ActivityId
SCORM ObjectivesActivityId → ActivityId

Edit history links

None

Foreign keys without a stated target

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

Source

Source: SCORM data sets on the D2L Brightspace Community