Expand All Collapse All
Interaction Administrator Change Log

IAChangeLog Table

Interaction Administrator Change Log

This table is a log of all changes you make using the Interaction Administrator program. CIC adds a record in the IA Change Notification table for any change you make using Interaction Administrator. A change you make using handlers or other methods is not recorded here.

  • Table Type - Historical
  • 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
ChangeDateTime datetime False No

Date/time of the change.

 4.0.106.453 4.0 Release
ChangeTime char (8) False No

Time of the change.

 4.0.106.453 4.0 Release
ChangeDateTimeGMT datetime False No

Date/time of the change adjusted to Greenwich Mean Time.

 4.0.106.453 4.0 Release
UserId nvarchar (50) False Yes

User identifier of the user whose configuration has changed. This is the User ID as defined in Interaction Administrator

 4.0.106.453 4.0 Release
StationId nvarchar (50) False Depends on customer usage

Identifier of station whose configuration has changed.

 4.0.106.453 4.0 Release
ChangeType varchar (50) False No

Type of change. Expected values are "Created", "Deleted", "Renamed", "Modified"

 4.0.106.453 4.0 Release
EntryKey nvarchar (128) False No

Entry path of the directory services key changed. Includes key name.

 4.0.106.453 4.0 Release
EntryClass nvarchar (50) False No

Directory services class of the key that was changed. Typical values are "User" or "Report Log".

 4.0.106.453 4.0 Release
I3TimeStampGMT datetime False No

System supplied date/time when the row was sent to the IC Logging server for insertion into the database.

 4.0.106.453 4.0 Release
SiteId smallint False No

Site identifier of the source of this interaction row. Used in multi-site rollup to distinguish the origin of data.

 4.0.106.453 4.0 Release
SubSiteId smallint False No

The purpose of this field is to divide use within a site, such as for multiple independent companies on one CIC system. Until CIC has such functionality, this field is zero and is reserved for future use

 4.0.106.453 4.0 Release

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_IAChangeLog Non-clustered ChangeDateTimeGMT (Ascending)
SiteId (Ascending)
EntryClass (Ascending)
ChangeType (Ascending)
EntryKey (Ascending)


Index Name Type Column Name (sort order)
I3TimeStampGMT Clustered I3TimeStampGMT (Ascending)
SiteId (Ascending)
IEChangeTime Non-clustered ChangeDateTime (Ascending)
EntryClass (Ascending)
SiteId (Ascending)
IEEntryKey Non-clustered EntryKey (Ascending)
ChangeDateTime (Ascending)
SiteId (Ascending)
IEStationId Non-clustered StationId (Ascending)
ChangeDateTime (Ascending)
SiteId (Ascending)
IEUserId Non-clustered UserId (Ascending)
ChangeDateTime (Ascending)
SiteId (Ascending)