Brightspace Data Sets for SCORM have a dependency on SCORM. If you turn this tool on and off during the data set query period, there may be unexpected or missing content in your data sets. Use of Legacy SCORM will not be reflected in these data sets.
Entity Relationship Diagram
The following diagram shows the relationships between entities used to create Brightspace Data Sets for SCORM. To enlarge the diagram, right-click on the image and select Open image in a new tab.
SCORM Activities
The SCORM Activities Brightspace Data Set describes the activities that exist in the SCORM package. Each activity will only be known after the first user, regardless of role, attempts it.
Returned Fields
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 5.5 |
ActivityId |
Unique identifier of the SCORM activity. |
uniqueidentifier |
16 |
PK |
| 5.5 |
ScormObjectId
|
Unique identifier for each content object.
|
uniqueidentifier
|
16
|
FK
|
| 5.5 |
ParentActivityId
|
Unique identifier of the parent activity.
Field can be null.
|
uniqueidentifier
|
16
|
FK
|
| 5.5 |
NumChildren
|
Number of child activities of this activity.
|
int
|
4
|
|
| 5.5 |
InternalId
|
Unique label for the activity.
Field can be null.
|
nvarchar
|
255
|
|
| 5.5 |
Title
|
The title of the activity.
Field can be null.
|
nvarchar
|
200
|
|
| 5.5 |
CompletionThreshold
|
Used to determine when the activity is considered complete.
Field can be null.
|
float
|
24
|
|
| 5.5 |
PassingScore
|
Scaled score required to pass the activity, between 0 and 100.
Field can be null.
|
float
|
24
|
|
| 5.5 |
PassingScoreUsed
|
Whether the passing score was used to determine the learner success status.
Field can be null.
|
bit
|
1
|
|
| 5.5 |
ScoreMin
|
Minimum value in the range for the raw score in an activity attempt.
Field can be null.
|
float
|
24
|
|
| 5.5 |
ScoreMax
|
Maximum value in the range for the raw score in an activity attempt.
Field can be null.
|
float
|
24
|
|
| 5.5 |
LastModified |
Date when the activity was last modified (UTC). |
datetime2 |
8 |
|
SCORM Activity Attempts
The SCORM Activity Attempts Brightspace Data Set lists each user attempt on each activity within a SCORM package, the completion status, success status, and time spent for each attempt.
Returned Fields
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 5.5 |
VisitId |
Unique identifier of the SCORM visit. |
uniqueidentifier |
16 |
PK, FK |
| 5.5 |
ActivityId
|
Unique identifier of the activity.
|
uniqueidentifier
|
16
|
PK, FK
|
| 5.5 |
AttemptNumber
|
Number of the attempt on the objective.
|
int
|
4
|
PK
|
| 5.5 |
Completion
|
The completion status of the learner in this attempt (UNKNOWN, COMPLETED, INCOMPLETE).
Field can be null.
|
nvarchar
|
100
|
|
| 5.5 |
Success
|
The success status of the learner in this attempt (UNKNOWN, PASSED, FAILED).
Field can be null.
|
nvarchar
|
100
|
|
| 5.5 |
Score
|
The score achieved by the learner in this attempt, between 0 and 100.
Field can be null.
|
float
|
24
|
|
| 5.5 |
ScoreRaw
|
The raw score that the learner achieved in this attempt, between the min and max score of the activity.
Field can be null.
|
float
|
24
|
|
| 5.5 |
TimeSpent |
The time the learner spent in this attempt, in seconds.
Field can be null.
|
float |
24 |
|
| 5.5 |
Progress |
How much of the activity was completed in this attempt, between 0 and 100.
Field can be null.
|
float |
24 |
|
| 5.5 |
LastModified
|
Date when the activity attempt was last modified (UTC).
|
datetime2
|
8
|
|
SCORM Interaction Attempts
The SCORM Interaction Attempts Brightspace Data Set lists the runtime interactions for each user on the activities they have attempted, including their response and time spent.
Returned Fields
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 5.5 |
VisitId |
Unique identifier of the visit. |
uniqueidentifier |
16 |
PK, FK |
| 5.5 |
InteractionId
|
Unique identifier of the interaction.
|
uniqueidentifier
|
16
|
PK, FK
|
| 5.5 |
AttemptNumber
|
Number of the attempt on the interaction.
|
int
|
4
|
PK
|
| 5.5 |
ActivityId
|
Unique identifier of the activity.
|
uniqueidentifier
|
16
|
FK
|
| 5.5 |
Timestamp
|
Point in time at which the interaction was first made available to the learner for learner interaction and response.
Field can be null.
|
datetime2
|
8
|
|
| 5.5 |
Response
|
Data generated when a learner responds to an interaction.
Field can be null.
|
nvarchar
|
1000
|
|
| 5.5 |
Result
|
Judgment of the correctness of the learner response (CORRECT, INCORRECT, UNANTICIPATED, NEUTRAL).
Field can be null.
|
nvarchar
|
100
|
|
| 5.5 |
NumericResult |
Numeric judgement of the correctness of the learner response.
Field can be null.
|
float |
24 |
|
| 5.5 |
TimeSpent |
The time the learner spent in this attempt, in seconds.
Field can be null.
|
float |
24 |
|
| 5.5 |
LastModified
|
Date when the interaction attempt was last modified (UTC).
|
datetime2
|
8
|
|
SCORM Interaction Objectives
The SCORM Interaction Objectives Brightspace Data Set defines the relationship between interactions and their objectives.
Returned Fields
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 5.5 |
InteractionId |
Unique identifier of the interaction. |
uniqueidentifier |
16 |
PK, FK |
| 5.5 |
ObjectiveId
|
Unique identifier of the objective.
|
uniqueidentifier
|
16
|
PK, FK
|
| 5.5 |
LastModified
|
Date when the activity was last modified (UTC).
|
datetime2
|
8
|
|
SCORM Interactions
The SCORM Interactions Brightspace Data Set describes the runtime interactions that exist in each activity in the SCORM package. Each interaction will only be known after the first user, regardless of role, attempts it.
Returned Fields
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 5.5 |
InteractionId |
Unique identifier of the interaction. |
uniqueidentifier |
16 |
PK |
| 5.5 |
ActivityId
|
Unique identifier for each activity.
|
uniqueidentifier
|
16
|
FK
|
| 5.5 |
InternalId
|
Unique label for the interaction.
Field can be null.
|
nvarchar
|
255
|
|
| 5.5 |
InteractionType
|
The type of interaction (UNDEFINED, TRUEFALSE, CHOICE, FILLIN, LONGFILLIN, LIKERT, MATCHING, PERFORMANCE, SEQUENCING, NUMERIC, OTHER).
|
nvarchar
|
100
|
|
| 5.5 |
Description
|
Brief informative description of the interaction.
Field can be null.
|
nvarchar
|
250
|
|
| 5.5 |
Weighting
|
Weight given to the interaction relative to other interactions.
Field can be null.
|
float
|
24
|
|
| 5.5 |
CorrectResponses
|
JSON representation of an array of correct responses for this interaction.
Field can be null.
|
nvarchar
|
2000
|
|
| 5.5 |
LastModified
|
Date when the activity was last modified (UTC).
|
datetime2
|
8
|
|
SCORM Objective Attempts
The SCORM Objective Attempts Brightspace Data Set outputs the score and completion information on every objective associated to the SCORM object where an attempt has been made.
Returned Fields
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 5.5 |
VisitId |
Unique identifier of the SCORM visit. |
uniqueidentifier |
16 |
PK, FK |
| 5.5 |
ObjectiveId
|
Unique identifier of the objective.
|
uniqueidentifier
|
16
|
PK, FK
|
| 5.5 |
AttemptNumber
|
Number of the attempt on the objective.
|
int
|
4
|
PK
|
| 5.5 |
Score
|
Number that reflects the performance of the learner on this objective, scaled to between 0 and 100.
Field can be null.
|
float
|
24
|
|
| 5.5 |
ScoreRaw
|
Number that reflects the performance of the learner on this objective, relative to the min and max scores.
Field can be null.
|
float
|
24
|
|
| 5.5 |
Success
|
Indicates whether the learner has mastered the objective (PASSED, FAILED, UNKNOWN).
Field can be null.
|
nvarchar
|
100
|
|
| 5.5 |
Completion
|
Indicates whether the learner has completed the objective (COMPLETED, INCOMPLETE, UNKNOWN, NOT_ATTEMPTED, BROWSED).
Field can be null.
|
nvarchar
|
100
|
|
| 5.5 |
Progress |
How much of the objective was completed in this attempt, between 0 and 100.
Field can be null.
|
float |
24 |
|
| 5.5 |
LastModified
|
Date when the activity was last modified (UTC).
|
datetime2
|
8
|
|
SCORM Objectives
The SCORM Objectives Brightspace Data Set describes the global, activity, and runtime interactions that exist for each SCORM package. The objectives will only be known after the first user registration or visit.
Returned Fields
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 5.5 |
ObjectiveId |
Unique identifier of the objective. |
uniqueidentifier |
16 |
PK |
| 5.5 |
ScormObjectId
|
Unique identifier for each SCORM object.
|
uniqueidentifier
|
16
|
FK
|
| 5.5 |
ObjectiveType
|
Type of objective (GLOBAL, ACTIVITY, RUNTIME).
|
nvarchar
|
100
|
|
| 5.5 |
ActivityId
|
Unique identifier for each activity.
Field can be null.
|
uniqueidentifier
|
16
|
FK
|
| 5.5 |
InternalId
|
Unique label for the objective.
Field can be null.
|
nvarchar
|
255
|
|
| 5.5 |
IsPrimary
|
Whether this is the primary objective of the activity.
Field can be null.
|
bit
|
1
|
|
| 5.5 |
Description
|
Brief informative description of the objective.
Field can be null.
|
nvarchar
|
250
|
|
| 5.5 |
ScoreMin |
Minimum value, for the objective, in the range for the raw score.
Field can be null.
|
float |
24 |
|
| 5.5 |
ScoreMax |
Maximum value, for the objective, in the range for the raw score.
Field can be null.
|
float |
24 |
|
| 5.5 |
LastModified
|
Date when the activity was last modified (UTC).
|
datetime2
|
8
|
|
SCORM Objects
The SCORM Objects Brightspace Data Set describes all the SCORM objects that exist, and which course and which topic they are located in. At time of launch, this data set contains data from July 2020 onwards. Remaining baseline data will be filled in upon a future release.
Returned Fields
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 5.5 |
ScormObjectId
|
Unique identifier of the SCORM object.
|
uniqueidentifier
|
16
|
PK
|
| 5.5 |
OrgUnitId
|
Unique org unit identifier.
|
int
|
4
|
FK
|
| 5.5 |
ContentObjectId
|
Unique identifier of the content topic.
|
int
|
4
|
FK
|
| 5.5 |
ContentServiceContentId
|
Unique identifier for the associated content in content service.
|
uniqueidentifier
|
16
|
|
| 5.5 |
ContentServiceRevisionId
|
Unique identifier of the associated revision in content service.
|
uniqueidentifier
|
16
|
|
| 5.5 |
ContentServiceTopicId
|
Unique identifier of the associated topic in content service.
|
uniqueidentifier
|
16
|
|
| 5.5 |
Title
|
The title of the SCORM object.
Field can be null.
|
nvarchar
|
1000
|
|
| 5.5 |
Description
|
The description of the SCORM package.
Field can be null.
|
nvarchar
|
1000
|
|
| 5.5 |
LearningStandard
|
The learning standard used by the SCORM content, one of SCORM_11, SCORM_12, SCORM_2004_2ND_EDITION, SCORM_2004_3RD_EDITION, SCORM_2004_4TH_EDITION, AICC, XAPI, CMI5.
Field can be null.
|
nvarchar
|
100
|
|
| 5.5 |
LastModified
|
Date when the SCORM content was last modified (UTC).
|
datetime2
|
8
|
|
| 5.5 |
LastModifiedBy |
User that last modified this SCORM object. |
int |
4 |
FK |
SCORM Visits
The SCORM Visits Brightspace Data Set lists each user visit on each SCORM object, the overall completion status, and time spent on the visit.
Returned Fields
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 5.5 |
VisitId |
Unique identifier for each SCORM visit. |
uniqueidentifier |
16 |
PK |
| 5.5 |
ScormObjectId
|
Unique identifier of the SCORM object.
|
uniqueidentifier
|
16
|
FK
|
| 5.5 |
UserId
|
User associated with the SCORM visit.
|
int
|
4
|
FK
|
| 5.5 |
OrgUnitId
|
Unique org unit identifier.
|
int
|
4
|
FK
|
| 5.5 |
FirstAccessDate
|
The date the user first accessed the SCORM object.
Field can be null.
|
datetime2
|
8
|
|
| 5.5 |
LastAccessDate
|
The date the user last accessed the SCORM object.
Field can be null.
|
datetime2
|
8
|
|
| 5.5 |
CompletedDate
|
The date the user first completed the SCORM object.
Field can be null.
|
datetime2
|
8
|
|
| 5.5 |
Completion |
The completion status of the user for the SCORM object. One of UNKNOWN, COMPLETED, or INCOMPLETE.
Field can be null.
|
nvarchar |
100 |
|
| 5.5 |
Success |
The success status of the user for the SCORM object. One of UNKNOWN, PASSED, or FAILED.
Field can be null.
|
nvarchar |
100 |
|
| 5.5 |
Score |
The score attained by the user for the SCORM object, between 0 and 100.
Field can be null.
|
float |
24 |
|
| 5.5 |
TimeSpent |
The amount of time the user has had the SCORM object open, in seconds.
Field can be null.
|
int |
4 |
|
| 6.15 / 7.3 - updated Type and Size |
Progress |
How much of the activity has been completed, between 0 and 100.
Field can be null.
|
float |
24 |
|
| 5.5 |
LastModified
|
Date when the activity was last modified (UTC).
Field can be null.
|
datetime2
|
8
|
|