• 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.