(Created target blank page For Version: PSAAS:Public) |
(Update with the copy of version: 8.5.0) |
||
| Line 1: | Line 1: | ||
| − | <!-- | + | = 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: | ||
| + | {{MiniTOC|pattern=PSAAS:RPRT:Table-GIDB_%:{{PONYDOCSVERSION}}%}} | ||
| + | |||
| + | <!-- Note to writer: The "System Fields" section is copied from the ICON 8.1Source Library Welcome page (https://docs.genesys.com/Documentation/ICON/8.1Source/Library/Welcome), edited to exclude the system fields the GIDB tables do not include. Confirm that the following content is up-to-date before publishing.--> | ||
| + | {{AnchorDiv|SystemFields}} | ||
| + | ==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. <br/>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 [[GDict|G_DICTIONARY Values]] page lists the dictionary types that are relevant for the GIDB configuration tables documented in this guide. | ||
| + | |||
| + | [[Category:V:PSAAS:Public]] | ||
Revision as of 13:44, August 10, 2017
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:
- Table GIDB_GCX_LOGIN_INFO
- Table GIDB_GC_ANNEX
- Table GIDB_GC_CALLING_LIST
- Table GIDB_GC_CAMPAIGN
- Table GIDB_GC_FOLDER
- Table GIDB_GC_GROUP
- Table GIDB_GC_LOGIN
- Table GIDB_GC_PLACE
- Table GIDB_GC_SKILL
- Table GIDB_GC_TENANT
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.