- 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)