Table G_DSS_GUD_PROVIDER

The control table for the gud role, which stores data that pertains to attached data associated with interactions. The data sources are T-Server and Interaction Server.

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
DSS_ID	INTEGER	X	X		The data source session ID. Refer to the GSYS_DOMAIN field in all corresponding operational tables.
ICON_DBID	INTEGER	X	X		The DBID of the ICON instance that created this record.
DS_DBID	INTEGER				The DBID of the data source to which ICON connected.
DS_DBID_PRIM	INTEGER				The DBID of the primary data source server (if defined in the Configuration Layer).
DS2_DBID	INTEGER				The DBID of the Switch for the T-Server or Interaction Server.
DS_TYPE	INTEGER				The type of data source server: 1—T-Server 2—Interaction Server
ICON_STIME	TIMESTAMP				The timestamp when ICON was started.
DSCONN_STIME	TIMESTAMP				The timestamp when connection to the data source server was established.
DSCONN_SDSTIME	TIMESTAMP				The data source server timestamp when the connection to ICON was established. If the data source server timestamp is not available, the ICON timestamp is used.
DSCONN_SDSTS	INTEGER				The UTC-equivalent value of the DSCONN_SDSTIME field.
DSCONN_TYPE	INTEGER				The type of connection: 1—First connection 2—Reconnect 3—Data source server restart (when possible) 4—Switch reconnection (when possible) 5—Switchover (when possible)
ICON_ETIME	TIMESTAMP				The timestamp when ICON shut down.
DSCONN_ETIME	TIMESTAMP				The timestamp when the data source server disconnected.
FEVENT_ITIME	TIMESTAMP				The timestamp of the first event for which data was stored on the connection (ICON time).
FEVENT_DSTIME	TIMESTAMP				The timestamp of the first event for which data was stored on the connection (time from the data source server event).
FEVENT_DSSEQ	VARCHAR(255)				The event sequence number of the first event for which data was stored on the connection (sequence number from the data source server event).
FEVENT_CSEQ	BIGINT				The transaction ID (CSEQ) of data storage for the first stored event on the connection.
FEVENT_DSUTC	INTEGER				The UTC-equivalent value of the FEVENT_DSTIME field.
LEVENT_ITIME	TIMESTAMP				The timestamp of the last event for which data was stored on the connection (ICON time).
LEVENT_DSTIME	TIMESTAMP				The timestamp of the last event for which data was stored on the connection (time from the data source server event).
LEVENT_DSSEQ	VARCHAR(255)				The event sequence number of the last event for which data was stored on the connection (sequence number from the data source server event).
LEVENT_CSEQ	BIGINT				The transaction ID (CSEQ) of data storage for the last stored event on the connection.
LEVENT_DSUTC	INTEGER				The UTC-equivalent value of the LEVENT_DSTIME field.
NODATA_IUTC	INTEGER				The UTC equivalent of the ICON timestamp in situations in which no data is received during a predefined time interval. The value of the time interval is 5 minutes.
ICON_DBID_PRIM	INTEGER				The DBID of the Primary ICON. Currently not used (reserved).
DS_VERSION	VARCHAR(255)				Reserved
CFG_SERVER	VARCHAR(255)				Reserved
R_CREATE_DBLT	TIMESTAMP				The timestamp for record creation (IDB local time).
R_UPDATE_DBLT	TIMESTAMP				The timestamp of record update when event data changes (IDB local time).
R_CREATE_UTC	INTEGER				The UTC-equivalent value of the R_CREATE_DBLT field.
R_UPDATE_UTC	INTEGER				The UTC-equivalent value of the R_UPDATE_DBLT field when event data changes.
EXT_INT1	BIGINT				Reserved
EXT_INT2	BIGINT				Reserved
EXT_INT3	BIGINT				Reserved
EXT_VCH1	VARCHAR(255)				Reserved
EXT_VCH2	VARCHAR(255)				Reserved
EXT_VCH3	VARCHAR(255)				Reserved