Expand All Collapse All
Interaction Administrator License Lookup

IALicenseLookup Table

Interaction Administrator License Lookup

Table contains lookups of license names. This table is used with the Enhanced IA Change Log tables.

  • Table Type - Lookup
  • Last Changed Version - 16.1.0.378
  • Last Changed Reason - Added for IA Enhanced Change Log.

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
IALicenseLookupId smallint False No

An identifier that gets stored in IALicenseAttributeLog table instead of storing the full license name.

 16.1.0.378 Added for IA Enhanced Change Log.
License nvarchar (200) False No

This is the name of a license, for example, I3_ACCESS_ACD_MEDIA_1.

 16.1.0.378 Added for IA Enhanced Change Log.

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_IALicenseLookup Clustered License (Ascending)