Expand All Collapse All
Organization Connection (Interaction Address)

OrgConnection Table

Organization Connection (Interaction Address)

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

  • 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 OrgConnection 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 an organization. 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 an organization. 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
OrgID char (22) False No

This column stores the Globally Unique Identifier(GUID) of the organization that an interaction address is being assigned to. Refer to the Organization table for more information about organization.

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

This column stores the textual value of an organization 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 an interaction address is the default interaction address for an organization.

 4.0.106.453 4.0 Release
IsDefForLoc tinyint False No

This column stores a value indicating whether or not an interaction address is the default interaction address for the locations of an organization.

 4.0.106.453 4.0 Release
IsDefForIndiv tinyint False No

This column stores a value indicating whether or not an interaction address is the default interaction address for individuals (contacts) in an organization.

 4.0.106.453 4.0 Release
SystemInsertDate datetime2 True No

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

 4.0.106.453 4.0 Release
Version int False No

Stores the version of an organization interaction address. Every time an organization interaction address 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_OrgConnection Non-clustered ConnInstId (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_OrgConnection_ConnTypeID ConnTypeID ConnectionType ConnTypeID Yes
FK_OrgConn_ConnSubTypeId ConnSubTypeId ConnSubType ConnSubTypeId Yes
FK_OrgConnection_OrgID OrgID Organization OrgID Yes

Index Name Type Column Name (sort order)
IX_OrgConnection_OrgID_IsDef Clustered OrgID (Ascending)
IsDefault (Descending)
IX_OrgConnection_Value Non-clustered Value (Ascending)