This view displays information about user enrollment in activities, including all users enrolled as part of a user group or as an individual user. Note that if a user is enrolled in an activity both as a user and as part of a user group, there will be only one row in the report for the user in this activity.
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.
ACTIVITY_ID (Oracle = number (10, 0)), (SQL = int)
Unique identifier of the activity.
This field is a primary key.
ACTIVITY_NAME (Oracle = nvarchar2), (SQL = nvarchar)
The name of the activity.
PATH_ID (Oracle = number (10, 0)), (SQL = int)
Unique identifier of the knowledge path that the activity is in.
PATH_NAME (Oracle = nvarchar2), (SQL = nvarchar)
Name of the knowledge path that the activity is in.