This view provides a tracking summary of all the Subject Learning Objects in learning activities. The Subject Learning Object is the learning object assigned to the subject of an activity, and it can be any learning object with an "Organization" or "Module" ONDEMANDTYPE in a package.
Upgrade Note: For installations upgraded from Professional edition 6.1, this view replaces the KPVIEW_SUBJECT_AU_SUMMARY 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.
SUBJECT_LO_ID (Oracle = number (10, 0)), (SQL = int)
Unique identifier of the subject Learning Object.
This field is a primary key.
COMPLETION_STATUS (Oracle = number (3, 0)), (SQL = tinyint)
Indicates whether the user has completed the subject.
1 = Completed
2 = Incomplete
3 = Not attempted
4 = Unknown
COMPLETE_PERCENT (Oracle = float), (SQL = real)
Indicates the percentage of the subject the user has completed.
TOTAL_TIME_SPENT (Oracle = float), (SQL = real)
Indicates how much time (in seconds) the user has spent on the subject.
START_DATE (Oracle = timestamp (6)), (SQL = datetime)
The date that the user started the subject Learning Object.
COMPLETE_DATE (Oracle = timestamp (6)), (SQL = datetime)
The date that the user completed the subject Learning Object.
LAST_TRACK_DATE (Oracle = timestamp (6)), (SQL = datetime)
The most recent date and time that the user accessed the subject Learning Object.