Content and tools

SCORM Visits data set: columns, keys and joins

Primary key: VisitId 13 columns

Checked against D2L on October 31, 2026

Back to the map

Columns

Column	Type	Size	Key
`VisitId`	`uniqueidentifier`	`16`	PK
`ScormObjectId`	`uniqueidentifier`	`16`	FK
`UserId`	`int`	`4`	FK
`OrgUnitId`	`int`	`4`	FK
`FirstAccessDate`	`datetime2`	`8`
`LastAccessDate`	`datetime2`	`8`
`CompletedDate`	`datetime2`	`8`
`Completion`	`nvarchar`	`100`
`Success`	`nvarchar`	`100`
`Score`	`float`	`24`
`TimeSpent`	`int`	`4`
`Progress`	`float`	`24`
`LastModified`	`datetime2`	`8`

Joins to (3)

Organizational UnitsOrgUnitId → OrgUnitId
SCORM ObjectsScormObjectId → ScormObjectId
UsersUserId → UserId

Joined from (3)

SCORM Activity AttemptsVisitId → VisitId
SCORM Interaction AttemptsVisitId → VisitId
SCORM Objective AttemptsVisitId → VisitId

Edit history links

None

Source

Source: SCORM data sets on the D2L Brightspace Community