Expand All Collapse All
Organization Addresses

OrgAddress Table

Organization Addresses

This table stores the details of addresses for organizations. Organizations can be added and modified in Interaction Desktop. Organizations can have multiple addresses (shipping, billing, etc.).

  • 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

An identifier for Organization address records.

 4.0.106.453 4.0 Release
AddrTypeID int False No

This column stores an identifier to represent the address type. Refer to the AddTypeId column in the AddrType table for more information about address types.

 4.0.106.453 4.0 Release
OrgID char (22) False No

This column stores a Globally Unique Identifier(GUID) to uniquely identify the organization that an address is assigned to.

 4.0.106.453 4.0 Release
StreetAddress nvarchar (255) True Depends on customer usage

This column stores the street address for an organization address.

 4.0.106.453 4.0 Release
City nvarchar (50) True Depends on customer usage

This column stores the city for an organization address.

 4.0.106.453 4.0 Release
State nvarchar (20) True Depends on customer usage

This column stores the state for an organization address.

 4.0.106.453 4.0 Release
Zip nvarchar (20) True Depends on customer usage

This column stores the zip code for an organization address.

 4.0.106.453 4.0 Release
Country nvarchar (50) True Depends on customer usage

This column stores the country for an organization address.

 4.0.106.453 4.0 Release
IsDefault tinyint False No

This column stores a value indicating whether or not an organization address is the default 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 organization address is the default 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 organization address is the default address for the individuals (contacts) of an organization.

 4.0.106.453 4.0 Release
SystemInsertDate datetime2 True No

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

 4.0.106.453 4.0 Release
Version int False No

Stores the version for an organization address record. Every time organization 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_OrgAddress Non-clustered AddrInstID (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_OrgAddress_AddrTypeId AddrTypeID AddrType AddrTypeId Yes
FK_OrgAddress_OrgID OrgID Organization OrgID Yes

Index Name Type Column Name (sort order)
IX_OrgAddress_City Non-clustered City (Ascending)
IX_OrgAddress_OrgID_IsDef Clustered OrgID (Ascending)
IsDefault (Descending)
IX_OrgAddress_Zip Non-clustered Zip (Ascending)