This view is inherited from Professional edition 6.1 and only appears for upgraded installations; however, the column descriptions correspond to the new database views. To review the original descriptions for a view, please consult your Professional edition 6.1 documentation. 

 

AU_SID (Oracle = number (10, 0)), (SQL = int)
There is no server ID in the current database, so this field is always 0.
 
 

ASSESS_ID (Oracle = number (10, 0)), (SQL = int) 
The unique identifier of the Assessment Learning Object. 
This field is a primary key. 
 

QUESTION_SID (Oracle = number (10, 0)), (SQL = int)
There is no server ID in the current database, so this field is always 0. 
 

QUESTION_ID (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_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