- KPVIEW_USER_PATH
- KPVIEW_USER_PATH
- "a3f2221f-e629-48f6-bf46-0c02b36198df
- 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), (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.