Jump to: navigation, search

In the Column List:

  • P = Primary key
  • M = Mandatory field
  • F = Foreign key
  • In the Data Type column, varchar/nvarchar means that the data type is varchar except in multi-language databases that use Unicode, in which case the data type is nvarchar. (The Info Mart database in Cloud deployments is not multi-language.)

Table G_CALL_USERDATA_CUST2


This table contains additional custom-attribute information regarding the user data that is attached to the call interactions.

Column List

Legend

Column Data Type P M F Description

ID

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

CALLID

varchar(50) X The unique ID of the interaction.

CUST_DATA_1

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

CUST_DATA_2

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

CUST_DATA_3

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

CUST_DATA_4

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

CUST_DATA_5

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

CUST_DATA_6

varchar(255) 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

int Contains the data source session ID (DSS_ID) for the session that was active when the data was processed by ICON. For more information, see the description in System Fields.

GSYS_PARTITION

int A key that is used for partitioning.

GSYS_SYS_ID

int System ID. Reserved for future use.

GSYS_SEQ

bigint Insert Sequence. Not unique.

GSYS_USEQ

bigint Update Sequence. Not unique.

GSYS_TS

datetime Reserved

GSYS_TC

int Reserved

GSYS_EXT_VCH1

varchar(255) Reserved

GSYS_EXT_VCH2

varchar(255) Reserved

GSYS_EXT_INT1

int Reserved

GSYS_EXT_INT2

int Reserved


Index List

Index Name U C

IDX_CUDATA_CUST2_CID

X

 

 

Feedback

Comment on this article:

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