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.


Table of Contents