- KPVIEW_QUESTION_DETAIL
- KPVIEW_QUESTION_DETAIL
- "eabc530e-0915-41ad-b471-821344c2f5bc
- 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.