Jump to: navigation, search

Info Mart GIDB Tables

The Global Interaction Database (GIDB) tables in the Info Mart schema are based on equivalent tables in the Interaction Concentrator database (IDB), which is the upstream data source for Info Mart data. The GIDB table descriptions in this document are reproduced from the Interaction Concentrator documentation.

The following GIDB tables are available for export:


System Fields

Certain fields appear in multiple tables. These fields, whose field names all begin with GSYS_, are reserved for use by internal Genesys system functions.

The following fields can have special and unique meanings in various tables:

  • GSYS_EXT_VCH1
  • GSYS_EXT_VCH2
  • GSYS_EXT_INT1
  • GSYS_EXT_INT2

The following fields have identical meanings regardless of where they appear:

  • GSYS_DOMAIN—In all operational tables, contains the data source session ID (DSS_ID) for the session that was active when the data was processed by ICON. The DSS_ID identifies the session in the data source session control tables (the G_DSS_*_PROVIDER tables, where the asterisk represents the particular provider, as specified by the ICON role—cfg, gcc, gls, gos, or gud). The value points to (a) a data source session ID that uniquely identifies the connection between the ICON application, the data source application (for example, T Server), and the switch; and (b) the timeframe during which the connection was active.
    In other tables, GSYS_DOMAIN is reserved for internal use.
  • GSYS_SYS_ID—Reserved for internal use.

Dictionary Types

Some field descriptions refer to dictionary types, which are defined by ICON. The G_DICTIONARY Values page lists the dictionary types that are relevant for the GIDB configuration tables documented in this guide.

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on August 10, 2017, at 05:44.