- Contents
Interaction Administrator Help
Database tables for the Enhanced Interaction Administrator Change Log
For complete information about the database tables that are used with the Enhanced Interaction Administrator Change Log, see the PureConnect Data Dictionary in the PureConnect Documentation Library.
Click a database table for more details about its purpose and its columns.
EnhancedIAChangeLog Table
The EnhancedIAChangeLog table is the primary table that is used for the Enhanced Interaction Administrator Change Log. If you enable the log, changes in supported Interaction Administrator containers are logged in this table.
Column Name
|
Description |
EnhancedIAChangeLogId |
Unique ID for the change |
ChangeDateTime |
Local server date and time when the change was made |
ChangeTime |
Local time of the change |
ChangeDateTimeGMT |
Greenwich Mean Time for when the change was made |
UserId |
User ID that made the change |
StationId |
ID of the computer from which the change was made |
ChangeType |
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 |
EntryKey |
Item affected by the change |
EntryClass |
The Interaction Administrator container for which the change was made. Note: Log records for licenses and skills are handled in this manner:
Note: Log records for skills are handled in this manner:
Note: Log records for roles are handled in this manner:
|
I3TimeStampGMT |
GMT Timestamp |
SiteId |
Site ID |
SubsiteId |
Subsite Id |
ApplicationId - |
ID of the application from where the change was made. The ID number corresponds to the ID found in the ICApplications table. |
IAAttributeLog Table
The IAAttributeLog table is a child table of the IAChangeLog table. This table contains the specific attribute that was changed, the previous value, and the new value. There may be multiple records in the IAAttributeLog table that are for a single record in the IAChangeLog table.
Note: Changes involving licenses are not recorded in this table.
Column Name
|
Description |
IAAttributeLogId |
Unique ID for the attribute that was changed |
EnhancedIAChangeLogId |
The foreign key to the IAChangeLog table |
AttributeName |
The name of the attribute that was changed |
PrevousValue |
The value before the change was made. This field can contain an empty string if the value was never been set before change logging was enabled, or if the field was cleared of its value. |
NewValue |
The new value for the attribute. This field can contain an empty string if the field was cleared of its value. |
IALicenseAttributeLog Table
The IALicenseAttributeLog table is a child table of EnhancedIAChangeLog. This table captures the changes made for a user or a workstation license attribute.
Note: There are
several attributes for each user or workstation license. When a change
is made to a user or a workstation license attribute, this table does
not record which attribute was changed. Instead, all of the licenses for
the user or station are written to the table.
To determine which specific attribute was changed, do a diff to compare
the current set of license attributes with the previous set of license
attributes. A set of records for a single change will have the same EnhancedIAChangeLogID.
Column
Name
|
Description |
IALicenseAttributeLogId |
Unique ID for the license change |
EnhancedIAChangeLogId |
Foreign key to the IAChangeLog table |
License |
License ID. This ID corresponds to the ID found in the IALicenseLookup table. |
IsAssignable |
Indicates whether the license allocation method for the given IAChangeLog entry key is assignable or concurrent:
|
IsActive |
Indicates whether licenses are enabled for the given IAChangeLog entry key:
|
CallCallback |
Denotes whether call/callback is selected as the ACD media type. This field is valid only for ACD Media 2 and ACD Media 3 licenses. |
Chat |
Denotes whether chat is selected as the ACD media type. This field is valid only for ACD Media 2 and ACD Media 3 licenses. |
|
Denotes whether email is selected as the ACD media type. This field is valid only for ACD Media 2 and ACD Media 3 licenses. |
Generic |
Denotes whether generic is selected as the ACD media type. This field is valid only for ACD Media 2 and ACD Media 3 licenses. |
Related topics
About the Enhanced Interaction Administrator Change Log
Examples of changes to database tables
Database views for the Enhanced Interaction Administrator Change Log