This view displays information about user enrollment in knowledge paths, including all users enrolled as part of a user group or as an individual user. If a user is enrolled in the same path as a user and as part of one or more user groups, there will be several rows in the view with the enrollment information for each occurrence.
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.
PATH_ID (Oracle = number (10, 0)), (SQL = int)
Unique identifier of the knowledge path.
This field is a primary key.
PATH_NAME (Oracle = nvarchar2), (SQL = nvarchar)
Name of the knowledge path.
ENROLL_DATE (Oracle = timestamp (6)), (SQL = datetime)
The date that the user is enrolled in the knowledge path.
START_DATE (Oracle = timestamp (6)), (SQL = datetime)
The date that the enrollment begins to track the enrollment expiration.
END_DATE (Oracle = timestamp (6)), (SQL = datetime)
The date that the enrollment in the knowledge path expires.
ENROLL_USERGROUP_ID (Oracle = number (10, 0)), (SQL = int)
If the user is enrolled in the path as part of a user group, this column displays the unique identifier of the user group. If the user is enrolled as an individual user, a value of -1 appears.
This field is a primary key.
ENROLL_USERGROUP_NAME (Oracle = nvarchar2), (SQL = nvarchar)
If the user is enrolled in the path as part of a user group, this column displays the name of the user group. If the user is enrolled as an individual user, a value of <NULL> appears.