Expand All Collapse All
Individual Types

IndivType Table

Individual Types

This table stores the details of the individual types that are configured in Interaction Center. Individual types can be configured in the Interaction Administrator under the Interaction Tracker node. Some examples of individual types are IC User, Customer, External and Partner.

  • Table Type - Lookup
  • Last Changed Version - 4.0.106.453
  • Last Changed Reason - 4.0 Release

SQL Column Definitions

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason CX Insights Name CX Insights Type CX Insights Folder Name
IndivTypeID int False No

This column stores the identifier of an individual type.

 4.0.106.453 4.0 Release
Name nvarchar (30) False No

This column stores the name of an individual type.

 4.0.106.453 4.0 Release
Admin_Editable int False No

This column stores a value indicating whether or not an individual type can be edited by an Interaction Center Administrator.

 4.0.106.453 4.0 Release
Version int False No

Stores the version of the individual type. The version field is used to track changes to individual types.

 4.0.106.453 4.0 Release

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_IndivType Clustered IndivTypeID (Ascending)


Index Name Type Column Name (sort order)
IX_IndivType_Name Unique non-clustered Name (Ascending)