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

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
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 integer False No

This column stores the identifier of an individual type.

 4.0.106.453 4.0 Release
Name nvarchar2 (30) False No

This column stores the name of an individual type.

 4.0.106.453 4.0 Release
Admin_Editable integer 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 integer 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

Constraints

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

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


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

Index Name Column Name (sort order)
IX_IndivType_Name Name (Ascending)