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