Expand All Collapse All
Location Attributes

LocAttribute Table

Location Attributes

This table stores information on attributes and its values assigned on configured locations.

  • 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
LocID char (22) False No

This column stores a GUID (Globally Unique Identifier) to uniquely identify a location. Refer to the LocID column in the Location table.

 4.0.106.453 4.0 Release
AttrTypeID int False No

This column stores an identifier for attribute types. Refer to the AttrTypeID column of the AttributeType table.

 4.0.106.453 4.0 Release
FldVal nvarchar (2000) True No

This column stores the actual value for the location attribute.

 4.0.106.453 4.0 Release
Version int False No

Stored the version for the LocAttribute record. Every time a location attribute is modified, the version field 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
LocID char (22) False No

This column stores a GUID (Globally Unique Identifier) to uniquely identify a location. Refer to the LocID column in the Location table.

 4.0.106.453 4.0 Release
AttrTypeID integer False No

This column stores an identifier for attribute types. Refer to the AttrTypeID column of the AttributeType table.

 4.0.106.453 4.0 Release
FldVal nvarchar2 (2000) True No

This column stores the actual value for the location attribute.

 4.0.106.453 4.0 Release
Version integer False No

Stored the version for the LocAttribute record. Every time a location attribute is modified, the version field will be incremented.

 4.0.106.453 4.0 Release

Constraints

Primary Key Name Type Column Name (sort order)
PK_LocAttribute Clustered LocID (Ascending)
AttrTypeID (Ascending)

Primary Key Name Column Name (sort order)
PK_LocAttribute LocID (Ascending)
AttrTypeID (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_LocAttribute_LocID LocID Location LocID Yes
FK_LocAttribute_AttrTypeID AttrTypeID AttributeType AttrTypeID Yes

Foreign Key Name Column Reference Table Reference Column Indexed
FK_LocAttribute_LocID LocID Location LocID Yes
FK_LocAttribute_AttrTypeID AttrTypeID AttributeType AttrTypeID Yes