Jump to: navigation, search

In the Column List:

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

Table G_CUSTOM_DATA_P


This table contains principal information about user data that is attached to a voice call interaction. This information originates from T-Server's EventUserEvent TEvents.

Tip
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

Legend

Column Data Type P M F Description

ID

serial X X The unique, autonumbered ID of this record. This is the primary key.

CallID

varchar(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.

PartyID

varchar(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.

PSEQ

integer X The sequence that corresponds to a record in the G_PARTY_HISTORY table.

EndPointID

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 exists. Otherwise, this is the party that is defined by the ThisDN attribute (if any). For other changes, the party is defined by the ThisDN attribute.

EndPointDN

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

AgentID

integer The DBID of the agent object that represents the person who changed the data. This is the agent who logged into the endpoint that is associated with the data change (if this information is available during run time).

SwitchID

integer 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 this field, and vice versa.

TenantID

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

Added

timestamp 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.

Added_ts

integer The UTC-equivalent value of the ADDED field.

Added_tcode

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

CUST_DATA_1

varchar(128) The value of the cust-data-1 attribute of userdata.

CUST_DATA_2

varchar(128) The value of the cust-data-2 attribute of userdata

CUST_DATA_3

varchar(128) The value of the cust-data-3 attribute of userdata

CUST_DATA_4

varchar(128) The value of the cust-data-4 attribute of userdata

CUST_DATA_5

varchar(128) The value of the cust-data-5 attribute of userdata

CUST_DATA_6

varchar(128) The value of the cust-data-6 attribute of userdata

CUST_DATA_7

varchar(128) The value of the cust-data-7 attribute of userdata

CUST_DATA_8

varchar(128) The value of the cust-data-8 attribute of userdata

CUST_DATA_9

varchar(128) The value of the cust-data-9 attribute of userdata

CUST_DATA_10

varchar(128) The value of the cust-data-10 attribute of userdata

CUST_DATA_11

varchar(128) The value of the cust-data-11 attribute of userdata

CUST_DATA_12

varchar(128) The value of the cust-data-12 attribute of userdata

CUST_DATA_13

varchar(128) The value of the cust-data-13 attribute of userdata

CUST_DATA_14

varchar(128) The value of the cust-data-14 attribute of userdata

CUST_DATA_15

varchar(128) The value of the cust-data-15 attribute of userdata

CUST_DATA_16

varchar(128) The value of the cust-data-16 attribute of userdata

CUST_DATA_17

varchar(128) The value of the cust-data-17 attribute of userdata

CUST_DATA_18

varchar(128) The value of the cust-data-18 attribute of userdata

CUST_DATA_19

varchar(128) The value of the cust-data-19 attribute of userdata

GSYS_DOMAIN

integer Reserved

GSYS_PARTITION

integer A key that is used for partitioning.

GSYS_SYS_ID

integer System ID. Reserved for future use.

GSYS_SEQ

bigint Insert Sequence. Not unique.

GSYS_USEQ

bigint Update Sequence. Not unique.

GSYS_TS

timestamp Reserved

GSYS_TC

integer Reserved

GSYS_EXT_VCH1

varchar(255) Reserved

GSYS_EXT_VCH2

varchar(255) Reserved

GSYS_EXT_INT1

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.

GSYS_EXT_INT2

integer Reserved

   

 

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on October 31, 2016, at 15:23.