Expand All Collapse All
Interaction Types

IntxType Table

Interaction Types

This table stores the different interaction types supported by Interaction Center.

  • 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
IntxTypeID int False No

An identifier for the interaction type

 4.0.106.453 4.0 Release
Name nvarchar (30) False Depends on customer usage

This column stores the name for an interaction type. Valid values are :

  • eINTX_TYPE_UNKNOWN = 0, unknown interaction type. This is not used under normal circumstances.
  • eINTX_TYPE_CALL = 1, Call Interaction
  • eINTX_TYPE_CHAT = 2, Chat Interaction
  • eINTX_TYPE_EMAIL = 3, Email Interaction
  • eINTX_TYPE_FAX = 4, Fax Interaction
  • eINTX_TYPE_WEBCOLLABORATION = 5, Web Collaboration Interaction
  • eINTX_TYPE_INSTANTQUESTION = 6, Instant Question Interaction
  • eINTX_TYPE_GENERICOBJECT = 7, Generic Object Interaction
  • eINTX_TYPE_WORKFLOW_ITEM_OBJECT = 8, Workflow Item Object (IPA) Interaction
  • eINTX_TYPE_SMS = 9, SMS Interaction
  • eINTX_TYPE_CALLBACK = 10, Callback Interaction
 4.0.106.453 4.0 Release
Admin_Editable int False No

Stores a value indicating whether or not the interaction type is editable by the administrator.

 4.0.106.453 4.0 Release
Version int False No

Stores the version for the interaction type.

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

An identifier for the interaction type

 4.0.106.453 4.0 Release
Name nvarchar2 (30) False Depends on customer usage

This column stores the name for an interaction type. Valid values are :

  • eINTX_TYPE_UNKNOWN = 0, unknown interaction type. This is not used under normal circumstances.
  • eINTX_TYPE_CALL = 1, Call Interaction
  • eINTX_TYPE_CHAT = 2, Chat Interaction
  • eINTX_TYPE_EMAIL = 3, Email Interaction
  • eINTX_TYPE_FAX = 4, Fax Interaction
  • eINTX_TYPE_WEBCOLLABORATION = 5, Web Collaboration Interaction
  • eINTX_TYPE_INSTANTQUESTION = 6, Instant Question Interaction
  • eINTX_TYPE_GENERICOBJECT = 7, Generic Object Interaction
  • eINTX_TYPE_WORKFLOW_ITEM_OBJECT = 8, Workflow Item Object (IPA) Interaction
  • eINTX_TYPE_SMS = 9, SMS Interaction
  • eINTX_TYPE_CALLBACK = 10, Callback Interaction
 4.0.106.453 4.0 Release
Admin_Editable integer False No

Stores a value indicating whether or not the interaction type is editable by the administrator.

 4.0.106.453 4.0 Release
Version integer False No

Stores the version for the interaction type.

 4.0.106.453 4.0 Release

Constraints

Primary Key Name Type Column Name (sort order)
PK_IntxType Clustered IntxTypeID (Ascending)

Primary Key Name Column Name (sort order)
PK_IntxType IntxTypeID (Ascending)


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

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