This view displays information about where the Learning Objects are used in the various titles. The actual structure of the Learning Object is displayed, no matter where the Learning Object was created or where it may be linked to another title. PARENT refers to the Learning Object's actual position where it is used in the hierarchy of a title. There is a row for each Learning Object; however, one Learning Object may appear in several different rows in the table if it is linked to several different titles.
Upgrade Note: For installations upgraded from a previous Knowledge Pathways version, this view replaces the KPVIEW_AU, KPVIEW_AU_STRUCTURE, and KPVIEW_ASSESSMENT views. Previous views still appear with their original column names to preserve any existing reports based on these views.
LO_ID (Oracle = number (10, 0)), (SQL = int)
The unique identifier of the Learning Object on a server.
This field is a primary key.
GUIDMAPID (Oracle = number (10, 0)), (SQL = int)
This unique identifier correlates to the primary key in the GUIDMAP table for the Learning Object and is used to join this table to other tables.
GUID (Oracle = nvarchar2), (SQL = nvarchar)
The unique identifier of the Learning Object on a server.
NAME (Oracle = nvarchar2), (SQL = nvarchar)
The name of the Learning Object (as specified when it was created in the Developer).
ORIGINALPLACEMENT (Oracle = number (10, 0)), (SQL = int)
The placement order of the Learning Object under its parent.
ONDEMANDTYPE_ID (Oracle = number (5, 0)), (SQL = smallint)
The value corresponds to the type of Learning Object.
1 = organization (root document)
2 = module
3 = section
4 = topic
5 = question
6 = assessment
7 = concept
PARENT_LO_ID (Oracle = number (10, 0)), (SQL = int)
The identifier of the parent Learning Object in the structure (as specified in LO_ID column).
ROOT_LO_ID (Oracle = number (10, 0)), (SQL = int)
The identifier of the root Learning Object (as specified in the LO_ID column).
PACKAGEID (Oracle = number (10, 0)), (SQL = int)
The identifier of the player content published from the Developer.
ACTIVE (Oracle = number (10, 0)), (SQL = int)
Indicates whether the Learning Object is active.
0 = The Learning Object has been deleted.
1 = The Learning Object is active.