- KPVIEW_USER
- KPVIEW_USER
- "21c10144-2220-4fc6-8902-e69edce10191
- This view displays information about the user accounts that have been created on the server in Manager. Custom user fields are included in the view, with the exception of a custom user field with an Unordered List data type. The columns in the view are created automatically when custom user fields are added, removed, and/or updated in Manager.
- Note:
- USER_ID (Oracle = number (10, 0)), (SQL = int)
- Unique identifier for the user.
- This field is a primary key
- WORKGROUP_ID (Oracle = number (10, 0)), (SQL = int)
- WORKGROUP_NAME (Oracle = nvarchar2), (SQL = nvarchar)
- USERNAME (Oracle = nvarchar2), (SQL = nvarchar)
- FIRST_NAME (Oracle = nvarchar2), (SQL = nvarchar)
- LAST_NAME (Oracle = nvarchar2), (SQL = nvarchar)
- MIDDLE_INITIAL (Oracle = nvarchar2), (SQL = nvarchar)
- EMAIL (Oracle = nvarchar2), (SQL = nvarchar)
- ACTIVE (Oracle = number (1, 0)), (SQL = bit)
- 1 = active
- START_DATE (Oracle = timestamp (6)), (SQL = datetime)
- END_DATE (Oracle = timestamp (6)), (SQL = datetime)
- LAST_LOGIN_DATE (Oracle = timestamp (6)), (SQL = datetime)
- CUF_<custom user field name> (varies)