Expand All Collapse All
Location Addresses

LocAddress Table

Location Addresses

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

  • Table Type - Lookup
  • Last Changed Version - 4.0.106.453
  • Last Changed Reason - 4.0 Release

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 each location address created in Interaction Center.

 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 information on address types.

 4.0.106.453 4.0 Release
LocID char (22) False No

This column stores a GUID (Globally Unique Identifier) to uniquely identify a location address.

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

This column stores the street address for a location address.

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

This column stores the city for a location address.

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

This column stores the state for a location address.

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

This column stores the zip code for a location address.

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

This column stores the country for a location address.

 4.0.106.453 4.0 Release
IsDefault tinyint False No

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

 4.0.106.453 4.0 Release
IsDefForIndiv tinyint False No

This column tells if the location address is the default address for individual assigned to this location.

 4.0.106.453 4.0 Release
SystemInsertDate datetime2 True No

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

 4.0.106.453 4.0 Release
Version int False No

Stores the version of the location address record. Every time a location address is edited, the version will be incremented.

 4.0.106.453 4.0 Release
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 integer False No

An identifier for each location address created in Interaction Center.

 4.0.106.453 4.0 Release
AddrTypeID integer False No

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

 4.0.106.453 4.0 Release
LocID char (22) False No

This column stores a GUID (Globally Unique Identifier) to uniquely identify a location address.

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

This column stores the street address for a location address.

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

This column stores the city for a location address.

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

This column stores the state for a location address.

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

This column stores the zip code for a location address.

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

This column stores the country for a location address.

 4.0.106.453 4.0 Release
IsDefault number False No

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

 4.0.106.453 4.0 Release
IsDefForIndiv number False No

This column tells if the location address is the default address for individual assigned to this location.

 4.0.106.453 4.0 Release
SystemInsertDate timestamp True No

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

 4.0.106.453 4.0 Release
Version integer False No

Stores the version of the location address record. Every time a location address is edited, the version will be incremented.

 4.0.106.453 4.0 Release

Constraints

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

Primary Key Name Column Name (sort order)
PK_LocAddress AddrInstID (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_LocAddress_AddrTypeId AddrTypeID AddrType AddrTypeId Yes
FK_LocAddress_LocID LocID Location LocID Yes

Foreign Key Name Column Reference Table Reference Column Indexed
FK_LocAddress_AddrTypeId AddrTypeID AddrType AddrTypeId Yes
FK_LocAddress_LocID LocID Location LocID Yes

Index Name Type Column Name (sort order)
IX_LocAddress_City Non-clustered City (Ascending)
IX_LocAddress_LocID_IsDef Clustered LocID (Ascending)
IsDefault (Descending)
IX_LocAddress_Zip Non-clustered Zip (Ascending)

Index Name Column Name (sort order)
IX_LocAddress_City City (Ascending)
IX_LocAddress_LocID_IsDef LocID (Ascending)
IsDefault (Descending)
IX_LocAddress_Zip Zip (Ascending)