- TOPIC_VIEW
- TOPIC_VIEW
- "3a0f2a04-65d1-48ed-94e1-3e5751b6938e
- This view provides detail information about the user's responses to the play modes.
- This view corresponds to the Topic_View table in Usage Tracking database in previous versions.
- Upgrade Note:
- 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
- (SQL = numeric)
- (Oracle = number),
- 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
- (Oracle = timestamp (6)), (SQL = datetime)
- RUNTIME_STARTDATETIME
- The date/time that the user starts the runtime.
- (Oracle = number (10, 0)), (SQL = int)
- SESSIONID
- The identifier of the session that the user launches for the item.
- (Oracle = timestamp (6)), (SQL = datetime)
- SESSION_STARTDATETIME
- The date/time that the user starts the session.
- SESSION_TIME
- (Oracle = number), (SQL = numeric)
- The total time the user spends in the session.
- (Oracle = number), (SQL = bigint)
- SESSION_MODECOUNT
- 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.