Expand All Collapse All
Connection Types (Interaction Address Types)

ConnectionType Table

Connection Types (Interaction Address Types)

This table stores the details of connection types (interaction address types) that are used by Interaction Tracker. Connection types are referred to as interaction address types in Interaction Administrator and Interaction Desktop. An interaction address type is combined with an interaction address subtype 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
ConnTypeID int False No

A unique numeric identifier for a connection type (interaction address type).

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

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

 4.0.106.453 4.0 Release
Admin_Editable int False No

Stores a value indicating whether or not a connection type (interaction address type) 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 type (interaction address type).

 4.0.106.453 4.0 Release

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_ConnectionType Clustered ConnTypeID (Ascending)


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