• 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.