Show Hide

 

Feedback

  • Contents
 

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:

  • “License” denotes a license change made in the License Allocation container.  

  • “UserLicense” denotes a license change made in the Users container.  

  • “StationLicense” denotes a license change was made from the Stations container.  

Note: Log records for skills are handled in this manner:

  • "Skills" denotes a change from Skills container.

  • "SkillsUser" denotes a change to the user from the Skills container.

  • "SkillsWorkgroup" denotes a change to the workgroup from the Skills container.

Note: Log records for roles are handled in this manner:

  • "Roles" denotes a change from Roles container.

  • "RolesUser" denotes a change to the user from the Roles container.

  • "RolesWorkgroup" denotes a change to the workgroup from the Roles container.

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:

  • A value of 1 means assignable

  • A value of 0 means concurrent.

IsActive

Indicates whether licenses are enabled for the given IAChangeLog entry key:

  • 1 means enabled.

  • 0 means disabled.

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.

Email

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