Feedback

  • Contents
 

Database views for the Enhanced Interaction Administrator Change Log

The following views are available for use with the Enhanced Interaction Administrator Change Log:

For more information on how to use these views, see the PureConnect Data Dictionary Technical Reference in the PureConnect Documentation Library.
 

Note: Some of the values recorded for attributes may have multiple entries. The delimiter is the unit separator character (0x1F).

 
 

EIACL_CurrentLicenses

This view shows the current license allocation.

  • This view will always be ordered by EntryKey. It displays only the most recent entry for each entry key.  The entry key is always going to be a user or a station. 

  • The EntryKeyLicenseCount column provides a quick way to see how many licenses are currently allocated to a specific entry key. 

  • The License column displays license names the same way that they are displayed in the License Management dialog box.

Back to top

 

EIACL_HistoricalLicenses

This view shows all the changes for licenses.

  • This view will always be in descending order by EntryKey and ChangeDateTime. It displays all of the changes for each entry key. The entry key will always be a user or a station.

  • The DESCLicenseChangeSequence column displays the ranking of changes for a specific entry key in descending order. A value of 1 always indicates the most recent license change for a specific entry key.

  • The EntryKeyLicenseCount column provides a quick way to see how many licenses are currently allocated to a specific entry key and change sequence.

  • The License column will display license names in the same way that they appear in the License Management dialog box.

 

When a user or station is deleted, the most recent entry for that entry key shows a - in the license column and a 1 in the DescLicenseChangeSequence column. This provides an easy way to tell which licenses were allocated to the  user or station when the user or station was deleted, in case you need to recreate the user or station later with the same licenses.

Back to top

 

EIACL_HistoricalLicensesDP

This view shows all the changes for licenses. It also includes some date part columns for use in sorting and grouping the data.

  • This view will always be in descending order by EntryKey and ChangeDateTime. It displays all of the changes for each entry key. The entry key will always be a user or a station.

  • The DESCLicenseChangeSequence column displays the ranking of changes for a specific entry key in descending order. A value of 1 always indicates the most recent license change for a specific entry key.

  • The EntryKeyLicenseCount column provides a quick way to see how many licenses are currently allocated to a specific entry key and change sequence.

  • The License column will display license names in the same way that they appear in the License Management dialog box.

  • Additional columns have been added to show date parts of the local and gmt date time columns.  

Back to top

 

EIACL_CurrentSkills

This view shows the current skills allocation for skills that have users or workgroups allocated to them.

  • This view will always be ordered by EntryKey and ChangeDateTime descending and display all of the changes for each entry key.  The entry key is always going to be a user or a workgroup.

  • The SkillNewValue column displays the skill name.

Back to top

 

EIACL_HistoricalSkills

This view shows all the changes for skills that have users or workgroups allocated to them.

  • The entry key is always going to be a user or a workgroup.

  • The SkillNewValue column displays the skill name.

  • The SkillPreviousValue column displays the skill name for the previous value.

  • This view is different from EIACL_CurrentSkills in that it also displays the previous values for the skill on the same row as the new value.

  • In order to make this data easier to consume, it is recommended that you order the view by EntryKey and ChangeDateTime DESC.

  • The DESCSkillChangeSequence column will show the ranking of the EntryKeys ordered by ChangeDateTimeGMT DESC

When a user or workgroup is deleted, the SkillNewValue, ProficiencyNewValue and DesireToUseNewValue columns display a -. This provides an easy way to tell what skills were allocated to a user or workgroup when it was deleted in case you need to recreate the user or workgroup later with the same skill allocations.

Back to top

 

EIACL_HistoricalSkillsDP

This view shows all the changes for skills.

  • The entry key is always going to be a user or a workgroup.

  • The SkillNewValue column displays the skill name.

  • The SkillPreviousValue column displays the skill name for the previous value.

  • This view is different from EIACL_CurrentSkills in that it also displays the previous values for the skill on the same row as the new value.

  • In order to make this data easier to consume, it is recommended that you order the view by EntryKey and ChangeDateTime DESC.

  • The DESCSkillChangeSequence column will show the ranking of the EntryKeys ordered by ChangeDateTimeGMT DESC

  • This view includes some date part columns for use in sorting and grouping the data.

  
 
  Back to top

 

Related topics

About the Enhanced Interaction Administrator Change Log

Database tables for the Enhanced Interaction Administrator Change Log

Examples of changes to database tables