Expand All Collapse All
Individual Addresses

IndivAddress Table

Individual Addresses

This table stores addresses for individuals entered in the Interaction Center system. You can create and manage contacts (Tracker individuals) using Interaction Desktop.

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

A unique numeric identifier for an individual address instance.

 4.0.106.453 4.0 Release
AddrTypeID int False No

This field stores the address type for an individual address. Refer to the AddrType table documentation for information regarding address types.

 4.0.106.453 4.0 Release
IndivID char (22) False Yes

A Globally Unique Identifier (GUID) to uniquely identify the individual that an individual address is assigned to.

 4.0.106.453 4.0 Release
IsDefault tinyint False No

Stores a value indicating whether or not an address is the default address for an individual.

 4.0.106.453 4.0 Release
StreetAddress nvarchar (255) True Potentially

Stores the street address of an individual address.

 4.0.106.453 4.0 Release
City nvarchar (50) True Potentially

Stores the city of an individual address.

 4.0.106.453 4.0 Release
State nvarchar (20) True Potentially

Stores the state of an individual address.

 4.0.106.453 4.0 Release
zip nvarchar (20) True Potentially

Stores the zip code of an individual address.

 4.0.106.453 4.0 Release
Country nvarchar (50) True Potentially

Stores the country of an individual address.

 4.0.106.453 4.0 Release
SystemInsertDate datetime2 True No

Stores the system date time when the individual address was inserted into the database.

 4.0.106.453 4.0 Release
Version int False No

Stores the version of the individual address. The version field is used to track changes to an individual address.

 4.0.106.453 4.0 Release

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_IndivAddress Non-clustered AddrInstID (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_IndivAddress_AddrTypeID AddrTypeID AddrType AddrTypeId Yes
FK_IndivAddress_IndivID IndivID Individual IndivID Yes

Index Name Type Column Name (sort order)
IX_IndivAddress_City Non-clustered City (Ascending)
IX_IndivAddress_IndivID_IsDef Clustered IndivID (Ascending)
IsDefault (Descending)
IX_IndivAddress_SPINTX_RCL Non-clustered AddrTypeID (Ascending)
IndivID (Ascending)
IX_IndivAddress_Zip Non-clustered zip (Ascending)