Maintenance Notice - PDF Generation
Dynamic PDF generation for web-based content is temporarily unavailable. This maintenance affects dynamic PDF files that are generated from either the HTML-based page or manual that you are viewing. Links that normally allow this functionality have been hidden, and will reappear as soon as the feature is restored.

Note: Access to static files, including PDF files that are not dynamically generated from our web-based content, is unaffected.

Jump to: navigation, search

In the Column List:

  • P = Primary key
  • M = Mandatory field
  • F = Foreign key


This table records the changes to the user data that is associated with a voice call.

Primarily, this is the data that is attached to the call (the content of the UserData attribute of a T-Server Event). However, it is assumed that ICON might be configured so that it will also use this table to record the history of the Reasons and Extensions as well as any other attributes of a call that are not recorded in the G_CALL_HISTORY and the G_PARTY_HISTORY tables.

The only prerequisite for this table is that the data be associated with the call and that this association be known at run time.

To assist you in preparing supplementary documentation, click the following link to download a comma-separated text file containing information such as the data types and descriptions for all columns in this table: Download a CSV file.

Hint: For easiest viewing, open the downloaded CSV file in Excel and adjust settings for column widths, text wrapping, and so on as desired. Depending on your browser and other system settings, you might need to save the file to your desktop first.

Column List


Column Data Type P M F Description


NUMBER(19) X X The unique, autonumbered ID of this record. This is the primary key.


VARCHAR2(50) This field points to the record in the G_CALL table that represents the call with which the data is associated. This field may be NULL.


VARCHAR2(50) This field points to the PARTYGUID record in the G_PARTY table, which represents the party ID that remains unchanged during the lifetime of the party. This field may be NULL.


INTEGER X The sequence that corresponds to the G_PARTY_HISTORY.


INTEGER This field contains the DBID of the endpoint that added, changed, or deleted the data. If the data was taken from the event that caused the creation of the respective call, then this is the first party created in the call. If the data was taken from the AttachedDataChangedEvent, then the party is defined by the ThirdPartyDN attribute, if any exist. Otherwise, this is the party that is defined by the ThisDN attribute (if any). For the rest of changes, the party is defined by the ThisDN attribute.


VARCHAR2(255) The device number that is associated with the data.


INTEGER This field contains the DBID of the agent object that represents the person who changed the data. This is the agent who logged in to the endpoint that is associated with the data change (if this information is available during run time).


INTEGER This field contains the DBID of the Switch object that owns the endpoint that is associated with the change. If the EndPointID field is NULL, then so is the field SwitchID, and vice versa.


INTEGER The DBID of the Tenant that is associated with the Switch.


VARCHAR2(64) X This is the KeyName field. It records the name of the user data key that changed its value. The user determines which keys should be recorded by specifying them in ICON configuration user data specification. Key names defined in the custom states configuration options should be specified in one option only—it should be unique across all configuration options.


VARCHAR2(255) This field contains the value of the key in character format.


TIMESTAMP(3) X The GMT-equivalent date and time when the key was changed. The date and time are taken from the T-Server (or other data provider) notification.


INTEGER The UTC-equivalent value of the ADDED field.


INTEGER A reference, derived from the value in the ADDED_TS field, to a record in the G_TIMECODE table.


INTEGER Reserved


INTEGER A key that is used for partitioning.


INTEGER System ID. Reserved for future use.


INTEGER Insert Sequence. Not unique.


INTEGER Update Sequence. Not unique.


TIMESTAMP(3) Reserved


INTEGER Reserved


VARCHAR2(255) Reserved


VARCHAR2(255) Reserved


INTEGER A flag that identifies if the UserEvent that caused the record came from a device at a time when that device was participating in an active call. A value of 1 indicates that the UserEvent was generated while the device was participating in an active call; otherwise, the value is 0.


INTEGER Stores the value of AttributeEventSequence from the event supplying data for this record. If the sequence value is longer than the 32-bit integer limit, higher bits will be truncated to make a 32-bit integer.


This page was last edited on October 31, 2016, at 22:34.


Comment on this article:

blog comments powered by Disqus