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), (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), (SQL = numeric)
The total time the user spends during the runtime.
RUNTIME_SCORESCALED (Oracle = float (24)), (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 (Oracle = number (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), (SQL = numeric)
The total time the user spends in the session.
SESSION_MODECOUNT (Oracle = number), (SQL = bigint)
The total number of play modes the user launches during the session.
SESSION_LOGCOUNT (Oracle = number), (SQL = int)
The number of session logs in a 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 Learning Object.
ASSESSTYPE (Oracle = number (3, 0)), (SQL = tinyint)
The value indicates the assessment type of the Learning Object.
0 = Learning object in the subject tree that is not a pre-assessment or post-assessment.
1 = Pre-assessment type in knowledge activity
2 = Post-assessment type in knowledge activity
PLAY_MODE (Oracle = nvarchar (1)), (SQL = varchar)
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 = number), (SQL = real)
The time that the user spends on the play mode (in miniseconds).
PASSED (Oracle = number), (SQL = int)
Indicates whether the user passed the required score.
1 = Passed
2 = Failed
SCORE (Oracle = number), (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 identifiers of frames viewed.
SESSION_COUNT (Oracle = number), (SQL = bigint)
The number of sessions in a runtime attempt.
ONDEMANDTYPE_ID (Oracle = number (5, 0)), (SQL = smallint)
Indicates the type of item as defined in the s_ondemandtype table.
1 = Organization
2 = Module
3 = Section
4 = Topic
5 = Question
6 = Assessment
7 = Concept
8 = Deleted