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 (10, 0)), (SQL = int)
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  Back

KPVIEW_LO_QUESTION