Expand All Collapse All
Location Connection (Interaction Address)

LocConnection Table

Location Connection (Interaction Address)

This table stores the details of interaction addresses assigned to locations. A location can have more than one interaction address. There will be one record in this table for each interaction address assigned to a location.

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

This column stores an identifier for LocConnection records.

 4.0.106.453 4.0 Release
ConnTypeID int False No

This column stores the identifier for the interaction address type that is being assigned to a location in this record. Refer to the ConnectionType (interaction address type) table for more information about connection types (intereaction address types) configured in your system.

 4.0.106.453 4.0 Release
ConnSubTypeId int False No

This column stores the identifier for the interaction address subtype that is being assigned to a location in this record. Refer to the ConnectionSubType (interaction address subtype) table for more information about connection subtypes (intereaction address subtypes) configured in your system.

 4.0.106.453 4.0 Release
LocID char (22) False No

This column stores the Globally Unique Identifier(GUID) of the location that the interaction address in this record is being assigned to. Refer to the Location table for more information about locations.

 4.0.106.453 4.0 Release
Value nvarchar (255) False Depends on customer usage

This column stores the textual value of a location interaction address. This value can be an email address, phone number web url, etc.

 4.0.106.453 4.0 Release
IsDefault tinyint False No

This column stores a value indicating whether or not the interaction address is the default interaction address for the location.

 4.0.106.453 4.0 Release
IsDefForIndiv tinyint False No

This column stores a value indicating whether or not the interaction address is the default interaction address for individuals (contact) at this location.

 4.0.106.453 4.0 Release
SystemInsertDate datetime2 True No

This column stores the date time-stamp when this location interaction address was inserted into the database.

 4.0.106.453 4.0 Release
Version int False No

Version for the LocConnection table record. Every time a location connection is modified, the version field will be incremented.

 4.0.106.453 4.0 Release

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_LocConnection Non-clustered ConnInstID (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_LocConnection_ConnTypeID ConnTypeID ConnectionType ConnTypeID Yes
FK_LocConn_ConnSubTypeId ConnSubTypeId ConnSubType ConnSubTypeId Yes
FK_LocConnection_LocID LocID Location LocID Yes

Index Name Type Column Name (sort order)
IX_LocConn_LocID_IsDef Clustered LocID (Ascending)
IsDefault (Descending)
IX_LocConnection_Value Non-clustered Value (Ascending)