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