Expand All Collapse All
Enhanced Interaction Administrator Change Log

EnhancedIAChangeLog Table

Enhanced Interaction Administrator Change Log

The primary table that is used for enhanced IA logging. Changes made from within IA from containers that support this feature will be logged in this table if enhanced logging is enabled. Some column names may be similar to the IAChangeLog table, but they may be used differently in the Enhanced IA Change Log table.

  • Table Type - Historical
  • 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
EnhancedIAChangeLogId int False No

Unique ID for the change

 16.1.0.378 Added for IA Enhanced Change Log.
ChangeDateTime datetime False No

Local server date and time when the change was made.

 16.1.0.378 Added for IA Enhanced Change Log.
ChangeTime nchar (8) False No

Local time of the change.

 16.1.0.378 Added for IA Enhanced Change Log.
ChangeDateTimeGMT datetime False No

Greenwich Mean Time for when the change was made.

 16.1.0.378 Added for IA Enhanced Change Log.
UserId nvarchar (50) False Yes

The user ID that made the change.

 16.1.0.378 Added for IA Enhanced Change Log.
StationId nvarchar (50) False Depends on customer usage

The ID of the computer from which the change was made. This may also be the IP address in when the change was made from ICWS or IceLib APIs

 16.1.0.378 Added for IA Enhanced Change Log.
ChangeType nvarchar (50) False No

The type of change that was made. The values are Addition, Modification, Deletion, and Initial. Initial is the data taken when the system takes a snapshot point of the DS data.

 16.1.0.378 Added for IA Enhanced Change Log.
EntryKey nvarchar (128) False No

Is the specific item the change affects.

 16.1.0.378 Added for IA Enhanced Change Log.
EntryClass nvarchar (50) False No

Represents the IA container for which the change was made. Licenses and Skills are special cases. "License" denotes a change from the License Allocation container. "UserLicense" represents the license change was made from the user container. "StationLicense" represents the change was made from the stations container. Skills is represented in a similar manner. "Skills" denotes a change from Skills container, "SkillsUser" represents a change to the user from the skills container, and "SkillsWorkgroup" indicates a change to the workgroup from the Skills container.

 16.1.0.378 Added for IA Enhanced Change Log.
I3TimeStampGMT datetime False No

The Date/Time the entry was sent for insertion into the table.

 16.1.0.378 Added for IA Enhanced Change Log.
SiteId smallint False No

Site ID

 16.1.0.378 Added for IA Enhanced Change Log.
SubSiteId smallint False No

Reserved for future use.

 16.1.0.378 Added for IA Enhanced Change Log.
ApplicationID smallint False No

Application ID that the change was made from. The ID number corresponds to the one ID found in the ICApplications Table

 16.1.0.378 Added for IA Enhanced Change Log.

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_EnhancedIAChangeLog Clustered EnhancedIAChangeLogId (Ascending)


Index Name Type Column Name (sort order)
IX_EnhancedIAChangeLog Non-clustered EnhancedIAChangeLogId (Ascending)