• KPVIEW_USER_ACTIVITY
  • KPVIEW_USER_ACTIVITY
  • "2a4c9976-cf36-43bf-8b21-6f347fd4c943
  • 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)
  • FIRST_NAME (Oracle = nvarchar2), (SQL = nvarchar)
  • LAST_NAME (Oracle = nvarchar2), (SQL = nvarchar)
  • ACTIVITY_ID (Oracle = number (10, 0)), (SQL = int)
  • ACTIVITY_NAME (Oracle = nvarchar2), (SQL = nvarchar)
  • PATH_ID (Oracle = number (10, 0)), (SQL = int)
  • PATH_NAME (Oracle = nvarchar2), (SQL = nvarchar)