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