This view provides detail information about the user's responses to the questions, grouped by the Runtime ID and sorted by the question order in the Learning Object.  This view includes tracking information for questions in assessments, questions in the courses, and Know It? mode in topics. 

 

Upgrade Note: For installations upgraded from Professional edition 6.1, this view replaces the KPVIEW_QUESTION_DETAIL view. Previous views still appear with their original column names to preserve any existing reports based on these views.

 

RUNTIMEID (Oracle = number (10, 0)), (SQL = int)  

A server-generated unique value identifying the attempt to respond to a question.

This field is a primary key.
 

QUESTION_GUIDMAPID (Oracle = number (10, 0)), (SQL = int) 

This unique identifier correlates to the primary key in the GUIDMAP table for the question and is used to join this table to other tables.

 

QUESTION_GUID (Oracle = nvarchar2), (SQL = nvarchar)

The unique identifier of the question.

 

QUESTION_NAME (Oracle = nvarchar2), (SQL = nvarchar)

The name of the question.

 

QUESTION_TYPE_ID (Oracle = number (5, 0)), (SQL = smallint)

SCORM Interaction Type ID.

 

QUESTION_TYPE_NAME (Oracle = nvarchar2), (SQL = nvarchar)

SCORM Interaction Type name.

 

ANSWER_BOOL (Oracle = number (1, 0)), (SQL = bit) 

The user's answer to the question, boolean-type. 

 

ANSWER_NUMERIC (Oracle = float), (SQL = real) 

The user's answer to the question, numeric-type. 

 

ANSWER_STRING (Oracle = nclob), (SQL = ntext) 

The user's answer to the question, string-type. 

 

CORRECT (Oracle = number), (SQL = int) 

Indicates whether the user answered the question correctly. 

0 = incorrect 

1 = correct 

 

LATENCY (Oracle = float), (SQL = real) 

The time elapsed between the time the interaction was made available to the learner for response and the time of the first response. 

 

QUESTION_ORDER (Oracle = number), (SQL = int) 

The actual sort order of the questions when the user took the assessment. This field is a primary key. 


Table of Contents  Back

KPVIEW_QUESTION_INTERACTION