This view provides detail information about the user's responses to the play modes.
Upgrade Note: This view corresponds to the Topic_View table in Usage Tracking database in previous versions.
TOPIC_VIEW_ID (Oracle = number (10, 0)), (SQL = int)
The identifier of the result when the user launches one of the play modes for a topic. This column is 0 if the user only selects the topic, but does not launch a play mode.
RUNTIMEID (Oracle = number (10, 0)), (SQL = int)
A server-generated unique value identifying a user attempt to run a topic play mode.
RUNTIME_EXPERIENCEDTOTALTIME (Oracle = number (18, 0)), (SQL = int)
The total time the user spends during the runtime.
RUNTIME_SCORESCALED (Oracle = float), (SQL = real)
The score of the runtime (value range from 0 to 1).
RUNTIME_SUCCESSSTATUSID (Oracle = number (3, 0)), (SQL = tinyint)
1 = Passed
2 = Failed
3 = Unknown
RUNTIME_COMPLETIONSTATUSID (Oracle = number (3, 0)), (SQL = tinyint)
1 = Completed
2 = Incomplete
3 = Not attempted
4 = Unknown
RUNTIME_STARTDATETIME (Oracle = timestamp (6)), (SQL = datetime)
The date/time that the user starts the runtime.
SESSIONID (10, 0)), (SQL = int)
The identifier of the session that the user launches for the item.
SESSION_STARTDATETIME (Oracle = timestamp (6)), (SQL = datetime)
The date/time that the user starts the session.
SESSION_TIME (Oracle = number (18, 0)), (SQL = int)
The total time the user spends in the session.
SESSION_MODECOUNT (Oracle = number (10, 0)), (SQL = int)
The total number of play modes the user launches during the session.
USER_ID (Oracle = number (10, 0)), (SQL = int)
Unique identifier for the user.
This field is a primary key.
USERNAME (Oracle = nvarchar2), (SQL = nvarchar)
The name that the user enters to log in to the server.
FIRST_NAME (Oracle = nvarchar2), (SQL = nvarchar)
User's first name.
LAST_NAME (Oracle = nvarchar2), (SQL = nvarchar)
User's last name.
GUIDMAPID (Oracle = number (10, 0)), (SQL = int)
This unique identifier correlates to the primary key in the GUIDMAP table for the Learning Object and is used to join this table to other tables.
TOPIC_ID (Oracle = nvarchar2), (SQL = nvarchar)
The unique identifier for the topic Learning Object.
ASSESSTYPE (Oracle = number (3, 0)), (SQL = tinyint)
The value indicates the assessment type of the Learning Object.
0 = Not an assessment
1 = Pre-assessment type in knowledge activity
2 = Post-assessment type in knowledge activity
PLAY_MODE (Oracle = number (3, 0)), (SQL = tinyint)
The topic play mode type.
S = See It!
T = Try It!
K = Know It?
D = Do It!
P = Print It!
START_TIME (Oracle = timestamp (6)), (SQL = datetime)
The timestamp when the user started the play mode.
END_TIME (Oracle = timestamp (6)), (SQL = datetime)
The timestamp when the user ends the play mode.
VIEW_TIME_SPAN (Oracle = float), (SQL = real)
The time that the user spends on the play mode (in milliseconds).
PASSED (Oracle = number (3, 0)), (SQL = tinyint)
Indicates whether the user passed the required score.
1 = Passed
2 = Failed
SCORE (Oracle = float), (SQL = real)
The score of the user taking the play mode (0-100).
COMPLETION_STATUS (Oracle = number (3, 0)), (SQL = tinyint)
Indicates whether the user has completed the play mode.
1 = Completed
2 = Incomplete
3 = Not Attempted
4 = Unknown
FRAME_VIEWED (Oracle = nvarchar2), (SQL = nvarchar)
The number of frames viewed.