This view displays the information about all the questions in the assessments and question Learning Objects.   

 

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

 

LO_ID (Oracle = number (10, 0)), (SQL = int)
The unique identifier of the Learning Object. 
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 (3, 0)), (SQL = tinyint)
SCORM Interaction Type ID.
 

QUESTION_TYPE_NAME (Oracle = nvarchar2), (SQL = nvarchar)
SCORM Interaction Type name.
 

QUESTION_XML (Oracle = nclob), (SQL = ntext)
The text of the question in XML format.
 

QUESTION_ORDER (Oracle = number (10, 0)), (SQL = int)
The sort order of the questions in an assessment.


Table of Contents