Jump to: navigation, search

In the Column List:

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

Table G_CALL_USERDATA_CUST1


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

Column List

Legend

Column Data Type P M F Description

ID

NUMBER(16) X X The unique, autonumbered ID of this record.

CALLID

VARCHAR2(50) X The unique ID of this interaction.

CUST_DATA_1

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

CUST_DATA_2

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

CUST_DATA_3

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

CUST_DATA_4

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

CUST_DATA_5

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

CUST_DATA_6

VARCHAR2(255) The value of the cust-data-6 attribute of userdata.

CUST_DATA_7

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

CUST_DATA_8

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

CUST_DATA_9

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

CUST_DATA_10

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

CUST_DATA_11

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

CUST_DATA_12

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

CUST_DATA_13

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

CUST_DATA_14

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

CUST_DATA_15

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

CUST_DATA_16

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

CUST_DATA_17

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

CUST_DATA_18

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

CUST_DATA_19

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

GSYS_DOMAIN

INTEGER 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

INTEGER A key that is used for partitioning.

GSYS_SYS_ID

INTEGER System ID. Reserved for future use.

GSYS_SEQ

INTEGER Insert Sequence. Not unique.

GSYS_USEQ

INTEGER Update Sequence. Not unique.

GSYS_TS

TIMESTAMP(3) Reserved

GSYS_TC

INTEGER Reserved

GSYS_EXT_VCH1

VARCHAR2(255) Reserved

GSYS_EXT_VCH2

VARCHAR2(255) Reserved

GSYS_EXT_INT1

INTEGER Reserved

GSYS_EXT_INT2

INTEGER Reserved


Index List

Index Name U C

IDX_CUDATA_CUST1_CID

X

 

 

Feedback

Comment on this article:

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