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.
ASSESS_RESULT_ID (Oracle = number (10, 0)), (SQL = int)
The unique identifier for the assessment result.
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)
The unique identifier of the question.
This field is a primary key.
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.
ANSWER (Oracle = nclob), (SQL = ntext)
The user's answer to the question in SCORM format.
CORRECT (Oracle = number (1, 0)), (SQL = bit)
Indicates whether the user answered the question correctly.
0 = incorrect
1 = correct
TIME_SPENT (Oracle = float), (SQL = real)
The total time (in seconds) that the user spends on the question.
QUESTION_ORDER (Oracle = number (10, 0)), (SQL = int)
The actual sort order of the questions when the user took the assessment.
This field is a primary key.