Expand All Collapse All
Address Types

AddrType Table

Address Types

This table stores the address types that are used by Interaction Tracker. Address types are configured in Interaction Administrator. They represent the type of an address, such as business or home. These address types are used in Interaction Desktop when adding or modifying contacts (Tracker individuals). Some address types come preconfigured with CIC installation. Others can be added using Interaction Administrator.

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

A unique numeric identifier for an address type.

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

The name of an address type. This will be shown wherever address types are displayed. The address types are configured in Interaction Administrator under the Interaction Tracker node.

 4.0.106.453 4.0 Release
InsertionOrder int False No

Represents the order in which address types are displayed in Interaction Desktop.

 4.0.106.453 4.0 Release
Admin_Editable int False No

Stores a value indicating whether or not an address type can be edited in Interaction Center Administrator.

 4.0.106.453 4.0 Release
Version int False No

The version field is used to track changes to an address type.

 4.0.106.453 4.0 Release

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_AddrType Clustered AddrTypeId (Ascending)


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