Expand All Collapse All
Connection Sub Types (Interaction Address Subtypes)

ConnSubType Table

Connection Sub Types (Interaction Address Subtypes)

This table stores the details of connection subtypes (interaction address subtypes) that are used by Interaction Tracker. Connection subtypes are referred to as interaction address subtypes in Interaction Administrator and Interaction Desktop. An interaction address subtype is combined with an interaction address type to designate a means for interacting with an individaul, organization or location. An example of an interaction address type with subtype is "business e-mail." In this case the interaction address type is "e-mail" and the interaction address subtype is "business." Some other examples are "home phone", "business mobile" and "home e-mail."

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

A uniqueue numeric identifier for a connection subtype (interaction address subtype).

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

A descriptive name for a connection subtype (interaction address subtype).

 4.0.106.453 4.0 Release
InsertionOrder int False No

Represents the order in which connection subtypes (interaction address subtypes) are displayed in Interaction Desktop.

 4.0.106.453 4.0 Release
Admin_Editable int False No

Stores a value indicating whether or not a connection subtype (interaction address subtype) can be edited by an Interaction Center Administrator.

 4.0.106.453 4.0 Release
Version int False No

The version field is used to track changes to a connection subtype (interaction address subtype).

 4.0.106.453 4.0 Release

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_ConnSubType Clustered ConnSubTypeId (Ascending)


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