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