This view provides launch information for all of the Learning Objects.
Upgrade Note: For installations upgraded from Professional edition 6.1, this view replaces the KPVIEW_SUBJECT_AU_DETAIL view. Previous views still appear with their original column names to preserve any existing reports based on these views.
USER_ID (Oracle = number (10, 0)), (SQL = int)
Unique identifier for the user.
This field is a primary key.
USERNAME (Oracle = nvarchar2), (SQL = nvarchar)
The name that the user enters to log in to the server.
FIRST_NAME (Oracle = nvarchar2), (SQL = nvarchar)
User's first name.
LAST_NAME (Oracle = nvarchar2), (SQL = nvarchar)
User's last name.
LO_ID (Oracle = number (10, 0)), (SQL = int)
The unique identifier of the Learning Object.
This field is a primary key.
ASSESSTYPE (Oracle = number (3, 0)), (SQL = tinyint)
The value indicates the assessment type of the Learning Object.
0 = Not an assessment
1 = Pre-assessment type
2 = Post-assessment type
This field is a primary key.
TRACK_DATE (Oracle = timestamp (6)), (SQL = datetime)
The date and time that the user accessed the subject Learning Object.
TIME_SPENT (Oracle = float), (SQL = real)
Indicates how much time (in seconds) the user has spent on the Learning Object.