• KPVIEW_LO_QUESTION
  • KPVIEW_LO_QUESTION
  • "fd2372e4-9694-4adf-9e66-793f3ab24b40
  • This view displays the information about all the questions in the assessments and question Learning Objects.
  • For installations upgraded from Professional edition 6.1, this view replaces the KPVIEW_QUESTION view. Previous views still appear with their original column names to preserve any existing reports based on these views.
  • Upgrade Note:
  • LO_ID (Oracle = number (10, 0)), (SQL = int)
  • The unique identifier of the Learning Object.
  • This field is a primary key.
  • QUESTION_GUIDMAPID (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_GUID (Oracle = nvarchar2), (SQL = nvarchar)
  • The unique identifier of the question.
  • QUESTION_NAME (Oracle = nvarchar2), (SQL = nvarchar)
  • The name of the question.
  • QUESTION_TYPE_ID (Oracle = number (10, 0)), (SQL = int)
  • 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.