Revision as of 13:24, June 11, 2018 by Jdruker (talk | contribs)
Jump to: navigation, search

Interaction Database

Also known as IDB. The database that stores data about contact-center interactions and resources at a granular level of detail.
See also Interaction Concentrator.



Glossary

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Info Mart Tables

Info Mart tables fall into one of the following categories, out of which only the first one contains data that is suitable for reporting purposes:

Fact Tables

The fact tables all include the _FACT suffix in the table name. The following Info Mart tables are fact tables, which are described in this document:



The Info Mart schema also includes the following Fact tables, which are not described in this document. Instead, as described in Dimension Views, this document provides detailed information about the parallel views:

  • CALLING_LIST_TO_CAMP_FACT_
  • GROUP_TO_CAMPAIGN_FACT_
  • PLACE_GROUP_FACT_
  • RESOURCE_GROUP_FACT_
  • RESOURCE_SKILL_FACT_


Fact Extension Tables

Special tables referred to as fact extension tables complement the INTERACTION_RESOURCE_FACT (IRF) and, depending on configuration, MEDIATION_SEGMENT_FACT (MSF) tables. The following are Info Mart fact extension tables:

Dimension Tables

The following are Info Mart dimension tables, which are described in this document:


Some tables, such as TECHNICAL_DESCRIPTOR, are populated with data upon Info Mart initialization. Other tables are populated based on the resources and configuration of your contact center, the configuration of the Genesys Info Mart application object, and the configuration of other Genesys applications from which the Genesys Info Mart Server gathers data. Still other tables, such as MEDIA_TYPE, after being populated upon Info Mart initialization, can be further extended at runtime.

Dimension Views

Genesys Info Mart database schema includes a number of dimension views that are provided on top of certain dimension tables. Dimension views can be used for reporting similarly to dimension tables. Moreover, where both a table and a view are available in the schema, dimension views are recommended to be queried for reporting purposes. For this reason, this document does not provide detailed descriptions of the following tables:

  • CALLING_LIST_TO_CAMP_FACT_
  • GROUP_TO_CAMPAIGN_FACT_
  • PLACE_GROUP_FACT_
  • RESOURCE_GROUP_FACT_
  • RESOURCE_SKILL_FACT_


See Genesys Info Mart Views for descriptions of dimension views, including those that correspond to the above tables.

Time Dimension Tables

The DATE_TIME table is the default time dimension table that is created in the Info Mart database during schema initialization. During initialization, Genesys Info Mart populates this table with calendar data for a configurable number of days in the future; new rows are added to the table at a configured frequency, as part of regular maintenance.

Custom time dimension tables can be added to the Info Mart schema at any point to support the need for multiple calendars. When tables are created, Genesys Info Mart populates these tables with calendar data for a configurable number of days in the future; it further maintains these tables, similarly to the DATE_TIME table maintenance.

Info Mart Service and Control Tables

The following control tables can be referenced to trace processing of Genesys Info Mart data while testing new reports or to troubleshoot behavior of ETL jobs:

Important
Genesys recommends that you query operational data through views rather than from the control tables directly.

The following control tables are configured and used for user data processing:

Starting with release 8.5.010, the CTL_GDPR_HISTORY table provides details about personally identifiable information (PII) that is associated with General Data Protection Regulation (GDPR) “export” or “forget” requests and that was stored in Info Mart fact tables at the time the request was processed. In addition to making the PII data available for customers to retrieve in response to "export" requests, the table provides a detailed audit trail of all the fields that were interrogated to satisfy the GDPR requests. In this way, the table serves as an execution report on "export" and "forget" processing.

The following Info Mart table can be referenced to check what purging activities have been completed:

The following Info Mart table is for reference only:

  • CTL_SCHEMA_INFO

The following control tables are listed for completeness of the schema description. They serve purely internal purposes and should not be used for either reporting or administrative needs:

  • CTL_AUDIT_LOG_KEY
  • CTL_DS
  • CTL_EXTRACT_HWM
  • CTL_EXTRACT_METRICS
  • CTL_PROCESSING_STATUS
  • CTL_SCHEDULED_JOBS
  • CTL_TIME_ZONE_OFFSET
  • CTL_TRANSFORM_HWM
  • CTL_TRANSFORM_TODO
  • CTL_WORKFLOW_STATUS


See also Info Mart Service and Staging Tables and Administrative Views.

GIDB Tables

The Global Interaction Database (GIDB) section of the Info Mart database comprises the following tables:

  • GIDB_G_AGENT_STATE_HISTORY_MM
  • GIDB_G_AGENT_STATE_HISTORY_V
  • GIDB_G_AGENT_STATE_RC_MM
  • GIDB_G_AGENT_STATE_RC_V
  • GIDB_G_CALL_HISTORY_MM
  • GIDB_G_CALL_HISTORY_V
  • GIDB_G_CALL_MM
  • GIDB_G_CALL_STAT_V
  • GIDB_G_CALL_V
  • GIDB_G_CUSTOM_DATA_S_MM
  • GIDB_G_CUSTOM_DATA_S_V
  • GIDB_G_DND_HISTORY_MM
  • GIDB_G_DND_HISTORY_V
  • GIDB_G_IR_HISTORY_MM
  • GIDB_G_IR_HISTORY_V
  • GIDB_G_IR_MM
  • GIDB_G_IR_V
  • GIDB_G_IS_LINK_HISTORY_V
  • GIDB_G_IS_LINK_V
  • GIDB_G_LOGIN_SESSION_MM
  • GIDB_G_LOGIN_SESSION_V
  • GIDB_G_PARTY_HISTORY_MM
  • GIDB_G_PARTY_HISTORY_V
  • GIDB_G_PARTY_MM
  • GIDB_G_PARTY_V
  • GIDB_G_ROUTE_RES_VQ_HIST_MM
  • GIDB_G_ROUTE_RES_VQ_HIST_V
  • GIDB_G_ROUTE_RESULT_MM
  • GIDB_G_ROUTE_RESULT_V
  • GIDB_G_SECURE_UD_HISTORY_MM
  • GIDB_G_SECURE_UD_HISTORY_V
  • GIDB_G_USERDATA_HISTORY_MM
  • GIDB_G_USERDATA_HISTORY_V
  • GIDB_G_VIRTUAL_QUEUE_MM
  • GIDB_G_VIRTUAL_QUEUE_V
  • GIDB_GC_ACTION_CODE
  • GIDB_GC_AGENT
  • GIDB_GC_ANNEX
  • GIDB_GC_APPLICATION
  • GIDB_GC_ATTR_VALUE
  • GIDB_GC_BUS_ATTRIBUTE
  • GIDB_GC_CALLING_LIST
  • GIDB_GC_CAMPAIGN
  • GIDB_GC_ENDPOINT
  • GIDB_GC_FIELD
  • GIDB_GC_FILTER
  • GIDB_GC_FOLDER
  • GIDB_GC_FORMAT
  • GIDB_GC_GROUP
  • GIDB_GC_IVR
  • GIDB_GC_IVRPORT
  • GIDB_GC_LOGIN
  • GIDB_GC_OBJ_TABLE
  • GIDB_GC_PLACE
  • GIDB_GC_SCRIPT
  • GIDB_GC_SKILL
  • GIDB_GC_SWITCH
  • GIDB_GC_TABLE_ACCESS
  • GIDB_GC_TENANT
  • GIDB_GC_TIME_ZONE
  • GIDB_GC_TREATMENT
  • GIDB_GC_VOICE_PROMPT
  • GIDB_GCX_AGENT_PLACE
  • GIDB_GCX_CAMPGROUP_INFO
  • GIDB_GCX_CAMPLIST_INFO
  • GIDB_GCX_ENDPOINT_PLACE
  • GIDB_GCX_FORMAT_FIELD
  • GIDB_GCX_GROUP_AGENT
  • GIDB_GCX_GROUP_ENDPOINT
  • GIDB_GCX_GROUP_PLACE
  • GIDB_GCX_GROUP_ROUTEDN
  • GIDB_GCX_LIST_TREATMENT
  • GIDB_GCX_LOGIN_INFO
  • GIDB_GCX_SKILL_LEVEL
  • GIDB_GCX_SUBCODE
  • GIDB_GM_F_USERDATA
  • GIDB_GM_L_USERDATA
  • GIDB_GO_CAMPAIGN
  • GIDB_GO_CAMPAIGNHISTORY
  • GIDB_GO_CHAIN
  • GIDB_GO_CHAINREC_HIST
  • GIDB_GO_FIELDHIST
  • GIDB_GO_METRICS
  • GIDB_GO_SEC_FIELDHIST
  • GIDB_GOX_CHAIN_CALL
  • GIDB_GX_SESSION_ENDPOINT_MM
  • GIDB_GX_SESSION_ENDPOINT_V


GIDB tables are populated as a result of data extraction from all IDBs that are deployed to feed data into Genesys Info Mart. Each row corresponds to a record that is extracted from a given IDB. The data that is related to interaction processing is extracted to media-dependent tables whose names are appended with _MM (for multimedia interactions) or _V (for voice interactions). The data for complete and active agent reason codes is extracted from G_AGENT_STATE_RC and G_AGENT_STATE_RC_A IDB tables, respectively, and written into the same GIDB_G_AGENT_STATE_RC_* table; any duplicated records are merged as the GIDB data is transformed for the dimensional model.

In addition to extracting all the fields from a certain IDB table, Genesys Info Mart populates values for the following columns that are specific to the Info Mart database:

  • CREATE_AUDIT_KEY
  • UPDATE_AUDIT_KEY (provided for those tables that can be updated)


Genesys Info Mart does not extract data from the IDB system fields that have no meaning for contact center reports. Otherwise, the meaning of the data in each row is the same as in the corresponding IDB record. For example, the GIDB_GC_PLACE table in the Info Mart database corresponds to the GC_PLACE table in IDB. Refer to the Interaction Concentrator Physical Data Model for your particular RDBMS for information about the data that is stored in corresponding GIDB tables.

Merge Tables

The merge tables of the Info Mart database are the following:

  • G_CALL
  • G_IR
  • G_IS_LINK
  • GSYS_DNPREMOTELOCATION


If data is being extracted from multiple IDBs, and if merging of call data is required (for example, for multi-site calls), Merge tables temporarily store data for these calls.

This document provides no descriptions for merge tables because they are used for internal processing and contain no final reporting data.

Temporary Tables

The Info Mart schema contains a large number of temporary (TMP_*) tables. These tables are used by the ETL jobs during data processing.

This document provides no listing or descriptions of TMP_* tables because they are used for internal processing and contain no final reporting data.

Staging Tables

The Info Mart schema contains a number of staging (STG_*) tables. Unlike in release 7.x, staging tables no longer make up a separate database, but instead are created as part of the Info Mart database. A majority of these tables are used by the ETL jobs to store temporary data between execution cycles.

The following two staging tables store errors that are written during ETL job execution (the transformation job, in particular) and are helpful in troubleshooting the source data that causes these errors:


The following staging tables store temporary data about active multimedia interactions and facilitate purging, from fact tables, of multimedia data that is related to ongoing interactions that meet configured criteria:

  • STG_ACTIVE_IF
  • STG_ACTIVE_IRF
  • STG_ACTIVE_IRF_REPLIES
  • STG_ACTIVE_MSF

The following staging tables keep track of interaction threads and of agent participation in threads. While a thread is active, metrics for the thread are updated in these staging tables, as applicable, and the data persists until the thread is closed.

  • STG_ACTIVE_THREAD
  • STG_THREAD_AGENT
  • STG_THREAD_AGENTRPY


Aside from the STG_IDB_FK_VIOLATION and STG_TRANSFORM_DISCARDS tables, this document provides no listing or descriptions of the STG_* tables, because they are used for internal processing and contain neither final reporting data nor troubleshooting data.

List of Dimensional Model Tables

The following fact and dimension tables are described in this document. The descriptions provide information about many aspects of each table's columns, each table's indexes (if any), and the subject areas of which each table is a member. The tables are presented in alphabetical order.



AGENT_LOCATION Records geographical locations of agents for both voice and multimedia login sessions.
AGENT_LOCATION Records geographical locations of agents for both voice and multimedia login sessions.
ANCHOR_FLAGS Enables identification of the beginning of the handling of an interaction or interaction thread from the perspective of the handling resource, such as an agent's first participation in an interaction.
ANCHOR_FLAGS Enables identification of the beginning of the handling of an interaction or interaction thread from the perspective of the handling resource, such as an agent's first participation in an interaction.
ANCHOR_FLAGS Enables identification of the beginning of the handling of an interaction or interaction thread from the perspective of the handling resource, such as an agent's first participation in an interaction.
ANCHOR_FLAGS Enables identification of the beginning of the handling of an interaction or interaction thread from the perspective of the handling resource, such as an agent's first participation in an interaction.
ATTEMPT_DISPOSITION Indicates what event caused termination of a contact attempt.
ATTEMPT_DISPOSITION Indicates what event caused termination of a contact attempt.
ATTEMPT_DISPOSITION Indicates what event caused termination of a contact attempt.
ATTEMPT_DISPOSITION Indicates what event caused termination of a contact attempt.
BGS_BOT_DIM Allows BGS session facts to be described based on the function of the bot.
BGS_BOT_DIM Allows BGS session facts to be described based on the function of the bot.
BGS_BOT_DIM Allows BGS session facts to be described based on the function of the bot.
BGS_BOT_DIM Allows BGS session facts to be described based on the function of the bot.
BGS_BOT_NAME_DIM Allows BGS session facts to be described based on the name of the bot.
BGS_BOT_NAME_DIM Allows BGS session facts to be described based on the name of the bot.
BGS_BOT_NAME_DIM Allows BGS session facts to be described based on the name of the bot.
BGS_BOT_NAME_DIM Allows BGS session facts to be described based on the name of the bot.
BGS_SESSION_DIM Allows BGS session facts to be described based on characteristics of the session.
BGS_SESSION_DIM Allows BGS session facts to be described based on characteristics of the session.
BGS_SESSION_DIM Allows BGS session facts to be described based on characteristics of the session.
BGS_SESSION_DIM Allows BGS session facts to be described based on characteristics of the session.
BGS_SESSION_FACT Represents bot activity in a chat session.
BGS_SESSION_FACT Represents bot activity in a chat session.
BGS_SESSION_FACT Represents bot activity in a chat session.
BGS_SESSION_FACT Represents bot activity in a chat session.
BOT_ATTRIBUTES Allows SDR bot session facts to be described based on the attributes of the bot.
BOT_ATTRIBUTES Allows SDR bot session facts to be described based on the attributes of the bot.
BOT_INTENT Allows SDR bot session facts to be described based on the attributes of the intent detected by the bot.
BOT_INTENT Allows SDR bot session facts to be described based on the attributes of the intent detected by the bot.
CALLBACK_DIAL_RESULTS Allows callback facts to be described based on the results of the dialing attempts.
CALLBACK_DIAL_RESULTS Allows callback facts to be described based on the results of the dialing attempts.
CALLBACK_DIAL_RESULTS Allows callback facts to be described based on the results of the dialing attempts.
CALLBACK_DIAL_RESULTS Allows callback facts to be described based on the results of the dialing attempts.
CALLBACK_DIM_1 Allows callback facts to be described based on characteristics of the callback offer and attempts.
CALLBACK_DIM_1 Allows callback facts to be described based on characteristics of the callback offer and attempts.
CALLBACK_DIM_1 Allows callback facts to be described based on characteristics of the callback offer and attempts.
CALLBACK_DIM_1 Allows callback facts to be described based on characteristics of the callback offer and attempts.
CALLBACK_DIM_2 Allows callback facts to be described based on attributes of the callback attempt.
CALLBACK_DIM_2 Allows callback facts to be described based on attributes of the callback attempt.
CALLBACK_DIM_2 Allows callback facts to be described based on attributes of the callback attempt.
CALLBACK_DIM_2 Allows callback facts to be described based on attributes of the callback attempt.
CALLBACK_DIM_3 Allows callback facts to be described based on attributes that characterize the state of the callback.
CALLBACK_DIM_3 Allows callback facts to be described based on attributes that characterize the state of the callback.
CALLBACK_DIM_3 Allows callback facts to be described based on attributes that characterize the state of the callback.
CALLBACK_DIM_3 Allows callback facts to be described based on attributes that characterize the state of the callback.
CALLBACK_DIM_4 Allows callback facts to be described based on attributes that characterize the callback dialing attempt.
CALLBACK_DIM_4 Allows callback facts to be described based on attributes that characterize the callback dialing attempt.
CALLBACK_DIM_4 Allows callback facts to be described based on attributes that characterize the callback dialing attempt.
CALLBACK_DIM_4 Allows callback facts to be described based on attributes that characterize the callback dialing attempt.
CALLBACK_FACT Represents a callback-related event.
CALLBACK_FACT Represents a callback-related event.
CALLBACK_FACT Represents a callback-related event.
CALLBACK_FACT Represents a callback-related event.
CALLING_LIST_METRIC_FACT Represents a snapshot of outbound campaign calling list metrics.
CALLING_LIST_METRIC_FACT Represents a snapshot of outbound campaign calling list metrics.
CALLING_LIST_METRIC_FACT Represents a snapshot of outbound campaign calling list metrics.
CALLING_LIST_METRIC_FACT Represents a snapshot of outbound campaign calling list metrics.
CALL_RESULT Enables facts to be described based on attributes of an outbound campaign call result.
CALL_RESULT Enables facts to be described based on attributes of an outbound campaign call result.
CALL_RESULT Enables facts to be described based on attributes of an outbound campaign call result.
CALL_RESULT Enables facts to be described based on attributes of an outbound campaign call result.
CAMPAIGN_GROUP_SESSION_FACT Represents the loading and unloading of an outbound campaign group session.
CAMPAIGN_GROUP_SESSION_FACT Represents the loading and unloading of an outbound campaign group session.
CAMPAIGN_GROUP_SESSION_FACT Represents the loading and unloading of an outbound campaign group session.
CAMPAIGN_GROUP_SESSION_FACT Represents the loading and unloading of an outbound campaign group session.
CAMPAIGN_GROUP_STATE Allows facts to be described based on attributes of an outbound campaign group status.
CAMPAIGN_GROUP_STATE Allows facts to be described based on attributes of an outbound campaign group status.
CAMPAIGN_GROUP_STATE Allows facts to be described based on attributes of an outbound campaign group status.
CAMPAIGN_GROUP_STATE Allows facts to be described based on attributes of an outbound campaign group status.
CAMPAIGN_GROUP_STATE_FACT Represents the states of a campaign group session.
CAMPAIGN_GROUP_STATE_FACT Represents the states of a campaign group session.
CAMPAIGN_GROUP_STATE_FACT Represents the states of a campaign group session.
CAMPAIGN_GROUP_STATE_FACT Represents the states of a campaign group session.
CDR_DIM1 Reserved for future use.
CDR_DIM1 Reserved for future use.
CDR_DIM1 Reserved for future use.
CDR_DIM1 Reserved for future use.
CDR_FACT Reserved for future use.
CDR_FACT Reserved for future use.
CDR_FACT Reserved for future use.
CDR_FACT Reserved for future use.
CHAT_SESSION_DIM Allows chat session facts to be described based on characteristics of the session.
CHAT_SESSION_DIM Allows chat session facts to be described based on characteristics of the session.
CHAT_SESSION_DIM Allows chat session facts to be described based on characteristics of the session.
CHAT_SESSION_DIM Allows chat session facts to be described based on characteristics of the session.
CHAT_SESSION_FACT Represents chat session activity in a multimedia interaction.
CHAT_SESSION_FACT Represents chat session activity in a multimedia interaction.
CHAT_SESSION_FACT Represents chat session activity in a multimedia interaction.
CHAT_SESSION_FACT Represents chat session activity in a multimedia interaction.
CHAT_THREAD_FACT Represents chat session activity in a given thread.
CHAT_THREAD_FACT Represents chat session activity in a given thread.
CHAT_THREAD_FACT Represents chat session activity in a given thread.
CHAT_THREAD_FACT Represents chat session activity in a given thread.
COBROWSE_END_REASON Allows Co-browse facts to be described based on reasons for Co-browse sessions to finish.
COBROWSE_END_REASON Allows Co-browse facts to be described based on reasons for Co-browse sessions to finish.
COBROWSE_END_REASON Allows Co-browse facts to be described based on reasons for Co-browse sessions to finish.
COBROWSE_END_REASON Allows Co-browse facts to be described based on reasons for Co-browse sessions to finish.
COBROWSE_FACT Allows to describe a web page visit shared by an agent and a customer during a Co-browse session.
COBROWSE_FACT Allows to describe a web page visit shared by an agent and a customer during a Co-browse session.
COBROWSE_FACT Allows to describe a web page visit shared by an agent and a customer during a Co-browse session.
COBROWSE_FACT Allows to describe a web page visit shared by an agent and a customer during a Co-browse session.
COBROWSE_MODE Allows Co-browse facts to be described based on the modes that are used in a Co-browse session.
COBROWSE_MODE Allows Co-browse facts to be described based on the modes that are used in a Co-browse session.
COBROWSE_MODE Allows Co-browse facts to be described based on the modes that are used in a Co-browse session.
COBROWSE_MODE Allows Co-browse facts to be described based on the modes that are used in a Co-browse session.
COBROWSE_PAGE Allows Co-browse session facts to be described based on characteristics of the web pages that are shared during Co-browse sessions.
COBROWSE_PAGE Allows Co-browse session facts to be described based on characteristics of the web pages that are shared during Co-browse sessions.
COBROWSE_PAGE Allows Co-browse session facts to be described based on characteristics of the web pages that are shared during Co-browse sessions.
COBROWSE_PAGE Allows Co-browse session facts to be described based on characteristics of the web pages that are shared during Co-browse sessions.
COBROWSE_USER_AGENT Allows Co-browse facts to be described based on characteristics of the customer's system that is used to view web pages in a Co-browse session.
COBROWSE_USER_AGENT Allows Co-browse facts to be described based on characteristics of the customer's system that is used to view web pages in a Co-browse session.
COBROWSE_USER_AGENT Allows Co-browse facts to be described based on characteristics of the customer's system that is used to view web pages in a Co-browse session.
COBROWSE_USER_AGENT Allows Co-browse facts to be described based on characteristics of the customer's system that is used to view web pages in a Co-browse session.
CONTACT_ATTEMPT_FACT Represents a processing attempt for an outbound campaign contact.
CONTACT_ATTEMPT_FACT Represents a processing attempt for an outbound campaign contact.
CONTACT_ATTEMPT_FACT Represents a processing attempt for an outbound campaign contact.
CONTACT_ATTEMPT_FACT Represents a processing attempt for an outbound campaign contact.
CONTACT_INFO_TYPE Allows facts to be described based on attributes of an outbound campaign contact information type.
CONTACT_INFO_TYPE Allows facts to be described based on attributes of an outbound campaign contact information type.
CONTACT_INFO_TYPE Allows facts to be described based on attributes of an outbound campaign contact information type.
CONTACT_INFO_TYPE Allows facts to be described based on attributes of an outbound campaign contact information type.
CTL_AUDIT_LOG
CTL_AUDIT_LOG
CTL_AUDIT_LOG
CTL_AUDIT_LOG
CTL_ETL_HISTORY
CTL_ETL_HISTORY
CTL_ETL_HISTORY
CTL_ETL_HISTORY
CTL_EXTRACT_HISTORY
CTL_EXTRACT_HISTORY
CTL_EXTRACT_HISTORY
CTL_EXTRACT_HISTORY
CTL_GDPR_HISTORY
CTL_GDPR_HISTORY
CTL_GDPR_HISTORY
CTL_GDPR_HISTORY
CTL_PURGE_HISTORY
CTL_PURGE_HISTORY
CTL_PURGE_HISTORY
CTL_PURGE_HISTORY
CTL_TRANSFORM_HISTORY
CTL_TRANSFORM_HISTORY
CTL_TRANSFORM_HISTORY
CTL_TRANSFORM_HISTORY
CTL_UDE_KEYS_TO_DIM_MAPPING
CTL_UDE_KEYS_TO_DIM_MAPPING
CTL_UDE_KEYS_TO_DIM_MAPPING
CTL_UDE_KEYS_TO_DIM_MAPPING
CTL_UD_TO_UDE_MAPPING
CTL_UD_TO_UDE_MAPPING
CTL_UD_TO_UDE_MAPPING
CTL_UD_TO_UDE_MAPPING
DATE_TIME Allows facts to be described by attributes of a calendar date and 15-minute interval.
DATE_TIME Allows facts to be described by attributes of a calendar date and 15-minute interval.
DATE_TIME Allows facts to be described by attributes of a calendar date and 15-minute interval.
DATE_TIME Allows facts to be described by attributes of a calendar date and 15-minute interval.
DIALING_MODE Allows facts to be described based on attributes of an outbound campaign dialing mode.
DIALING_MODE Allows facts to be described based on attributes of an outbound campaign dialing mode.
DIALING_MODE Allows facts to be described based on attributes of an outbound campaign dialing mode.
DIALING_MODE Allows facts to be described based on attributes of an outbound campaign dialing mode.
GPM_DIM1 Allows Predictive Routing facts to be described based on miscellaneous characteristics of the predictor and routing attempt.
GPM_DIM1 Allows Predictive Routing facts to be described based on miscellaneous characteristics of the predictor and routing attempt.
GPM_DIM1 Allows Predictive Routing facts to be described based on miscellaneous characteristics of the predictor and routing attempt.
GPM_DIM1 Allows Predictive Routing facts to be described based on miscellaneous characteristics of the predictor and routing attempt.
GPM_FACT Represents Predictive Routing events.
GPM_FACT Represents Predictive Routing events.
GPM_FACT Represents Predictive Routing events.
GPM_FACT Represents Predictive Routing events.
GPM_MODEL Allows Predictive Routing facts to be described based on characteristics of the model used to match interactions with routing targets.
GPM_MODEL Allows Predictive Routing facts to be described based on characteristics of the model used to match interactions with routing targets.
GPM_MODEL Allows Predictive Routing facts to be described based on characteristics of the model used to match interactions with routing targets.
GPM_MODEL Allows Predictive Routing facts to be described based on characteristics of the model used to match interactions with routing targets.
GPM_PREDICTOR Allows Predictive Routing facts to be described based on characteristics of the predictor used for scoring.
GPM_PREDICTOR Allows Predictive Routing facts to be described based on characteristics of the predictor used for scoring.
GPM_PREDICTOR Allows Predictive Routing facts to be described based on characteristics of the predictor used for scoring.
GPM_PREDICTOR Allows Predictive Routing facts to be described based on characteristics of the predictor used for scoring.
GPM_RESULT Allows Predictive Routing facts to be described based on characteristics of the Predictive Routing result.
GPM_RESULT Allows Predictive Routing facts to be described based on characteristics of the Predictive Routing result.
GPM_RESULT Allows Predictive Routing facts to be described based on characteristics of the Predictive Routing result.
GPM_RESULT Allows Predictive Routing facts to be described based on characteristics of the Predictive Routing result.
GROUP_ANNEX Stores additional configuration data to support Genesys Interactive Insights capability to control visibility of certain data and reports.
GROUP_ANNEX Stores additional configuration data to support Genesys Interactive Insights capability to control visibility of certain data and reports.
GROUP_ANNEX Stores additional configuration data to support Genesys Interactive Insights capability to control visibility of certain data and reports.
GROUP_ANNEX Stores additional configuration data to support Genesys Interactive Insights capability to control visibility of certain data and reports.
INTERACTION_DESCRIPTOR Allows interaction facts to be described by deployment-specific business attributes that characterize the interaction, such as service type and customer segment.
INTERACTION_DESCRIPTOR Allows interaction facts to be described by deployment-specific business attributes that characterize the interaction, such as service type and customer segment.
INTERACTION_DESCRIPTOR Allows interaction facts to be described by deployment-specific business attributes that characterize the interaction, such as service type and customer segment.
INTERACTION_DESCRIPTOR Allows interaction facts to be described by deployment-specific business attributes that characterize the interaction, such as service type and customer segment.
INTERACTION_FACT Represents interactions from the perspective of a customer experience.
INTERACTION_FACT Represents interactions from the perspective of a customer experience.
INTERACTION_FACT Represents interactions from the perspective of a customer experience.
INTERACTION_FACT Represents interactions from the perspective of a customer experience.
INTERACTION_RESOURCE_FACT Represents a summary of each attempt to handle an interaction. It encompasses the mediation process that is required to offer the interaction to a target handling resource, as well as the activities of that target handling resource.
INTERACTION_RESOURCE_FACT Represents a summary of each attempt to handle an interaction. It encompasses the mediation process that is required to offer the interaction to a target handling resource, as well as the activities of that target handling resource.
INTERACTION_RESOURCE_FACT Represents a summary of each attempt to handle an interaction. It encompasses the mediation process that is required to offer the interaction to a target handling resource, as well as the activities of that target handling resource.
INTERACTION_RESOURCE_FACT Represents a summary of each attempt to handle an interaction. It encompasses the mediation process that is required to offer the interaction to a target handling resource, as well as the activities of that target handling resource.
INTERACTION_RESOURCE_STATE Allows facts to be described by the states of contact center resources, as resources are offered and handle interactions.
INTERACTION_RESOURCE_STATE Allows facts to be described by the states of contact center resources, as resources are offered and handle interactions.
INTERACTION_RESOURCE_STATE Allows facts to be described by the states of contact center resources, as resources are offered and handle interactions.
INTERACTION_RESOURCE_STATE Allows facts to be described by the states of contact center resources, as resources are offered and handle interactions.
INTERACTION_TYPE Allows facts to be described based on interaction type, such as Inbound, Outbound or Internal.
INTERACTION_TYPE Allows facts to be described based on interaction type, such as Inbound, Outbound or Internal.
INTERACTION_TYPE Allows facts to be described based on interaction type, such as Inbound, Outbound or Internal.
INTERACTION_TYPE Allows facts to be described based on interaction type, such as Inbound, Outbound or Internal.
IRF_USER_DATA_CUST_1 Is provided as a sample of a table to store high-cardinality data that comes as deployment-specific, user-defined business attributes that characterize the interaction. By default, this table is not included in the schema.
IRF_USER_DATA_CUST_1 Is provided as a sample of a table to store high-cardinality data that comes as deployment-specific, user-defined business attributes that characterize the interaction. By default, this table is not included in the schema.
IRF_USER_DATA_CUST_1 Is provided as a sample of a table to store high-cardinality data that comes as deployment-specific, user-defined business attributes that characterize the interaction. By default, this table is not included in the schema.
IRF_USER_DATA_CUST_1 Is provided as a sample of a table to store high-cardinality data that comes as deployment-specific, user-defined business attributes that characterize the interaction. By default, this table is not included in the schema.
IRF_USER_DATA_GEN_1 Allows interaction resource facts and, if so configured, mediation segment facts to be described by Genesys-defined (predefined) string attributes that may come attached with interactions.
IRF_USER_DATA_GEN_1 Allows interaction resource facts and, if so configured, mediation segment facts to be described by Genesys-defined (predefined) string attributes that may come attached with interactions.
IRF_USER_DATA_GEN_1 Allows interaction resource facts and, if so configured, mediation segment facts to be described by Genesys-defined (predefined) string attributes that may come attached with interactions.
IRF_USER_DATA_GEN_1 Allows interaction resource facts and, if so configured, mediation segment facts to be described by Genesys-defined (predefined) string attributes that may come attached with interactions.
IRF_USER_DATA_KEYS Allows specification of up to 800 deployment-specific, user-defined string attributes that may come attached with interactions. Use this table to define low-cardinality dimensions if you require storing low-cardinality KVP data for reporting purposes.
IRF_USER_DATA_KEYS Allows specification of up to 800 deployment-specific, user-defined string attributes that may come attached with interactions. Use this table to define low-cardinality dimensions if you require storing low-cardinality KVP data for reporting purposes.
IRF_USER_DATA_KEYS Allows specification of up to 800 deployment-specific, user-defined string attributes that may come attached with interactions. Use this table to define low-cardinality dimensions if you require storing low-cardinality KVP data for reporting purposes.
IRF_USER_DATA_KEYS Allows specification of up to 800 deployment-specific, user-defined string attributes that may come attached with interactions. Use this table to define low-cardinality dimensions if you require storing low-cardinality KVP data for reporting purposes.
IXN_RESOURCE_STATE_FACT Provides detailed interaction-handling state information in the context of an interaction resource fact. It facilitates interval-based reporting for interaction-related resource states.
IXN_RESOURCE_STATE_FACT Provides detailed interaction-handling state information in the context of an interaction resource fact. It facilitates interval-based reporting for interaction-related resource states.
IXN_RESOURCE_STATE_FACT Provides detailed interaction-handling state information in the context of an interaction resource fact. It facilitates interval-based reporting for interaction-related resource states.
IXN_RESOURCE_STATE_FACT Provides detailed interaction-handling state information in the context of an interaction resource fact. It facilitates interval-based reporting for interaction-related resource states.
LDR_CAMPAIGN Allows CX Contact record facts to be described based on characteristics of the outbound campaign.
LDR_CAMPAIGN Allows CX Contact record facts to be described based on characteristics of the outbound campaign.
LDR_CAMPAIGN Allows CX Contact record facts to be described based on characteristics of the outbound campaign.
LDR_CAMPAIGN Allows CX Contact record facts to be described based on characteristics of the outbound campaign.
LDR_DEVICE Allows CX Contact record facts to be described based on device characteristics of the contact list records.
LDR_DEVICE Allows CX Contact record facts to be described based on device characteristics of the contact list records.
LDR_DEVICE Allows CX Contact record facts to be described based on device characteristics of the contact list records.
LDR_DEVICE Allows CX Contact record facts to be described based on device characteristics of the contact list records.
LDR_FACT Describes contact list records that CX Contact reported as unattempted.
LDR_FACT Describes contact list records that CX Contact reported as unattempted.
LDR_FACT Describes contact list records that CX Contact reported as unattempted.
LDR_FACT Describes contact list records that CX Contact reported as unattempted.
LDR_GROUP Allows CX Contact record facts to be described based on the name of the agent group or place group associated with the outbound campaign.
LDR_GROUP Allows CX Contact record facts to be described based on the name of the agent group or place group associated with the outbound campaign.
LDR_GROUP Allows CX Contact record facts to be described based on the name of the agent group or place group associated with the outbound campaign.
LDR_GROUP Allows CX Contact record facts to be described based on the name of the agent group or place group associated with the outbound campaign.
LDR_LIST Allows CX Contact record facts to be described based on characteristics of contact lists.
LDR_LIST Allows CX Contact record facts to be described based on characteristics of contact lists.
LDR_LIST Allows CX Contact record facts to be described based on characteristics of contact lists.
LDR_LIST Allows CX Contact record facts to be described based on characteristics of contact lists.
LDR_POSTAL_CODE Allows CX Contact record facts to be described based on postal code values of contact list records.
LDR_POSTAL_CODE Allows CX Contact record facts to be described based on postal code values of contact list records.
LDR_POSTAL_CODE Allows CX Contact record facts to be described based on postal code values of contact list records.
LDR_POSTAL_CODE Allows CX Contact record facts to be described based on postal code values of contact list records.
LDR_RECORD Allows CX Contact record facts to be described based on contact information type, record type, record status, and disposition.
LDR_RECORD Allows CX Contact record facts to be described based on contact information type, record type, record status, and disposition.
LDR_RECORD Allows CX Contact record facts to be described based on contact information type, record type, record status, and disposition.
LDR_RECORD Allows CX Contact record facts to be described based on contact information type, record type, record status, and disposition.
MEDIATION_SEGMENT_FACT Describes interaction activity with respect to ACD queues, virtual queues, interaction queues, and interaction workbins.
MEDIATION_SEGMENT_FACT Describes interaction activity with respect to ACD queues, virtual queues, interaction queues, and interaction workbins.
MEDIATION_SEGMENT_FACT Describes interaction activity with respect to ACD queues, virtual queues, interaction queues, and interaction workbins.
MEDIATION_SEGMENT_FACT Describes interaction activity with respect to ACD queues, virtual queues, interaction queues, and interaction workbins.
MEDIA_ORIGIN Allows chat session thread facts to be described based on where the session originated.
MEDIA_ORIGIN Allows chat session thread facts to be described based on where the session originated.
MEDIA_ORIGIN Allows chat session thread facts to be described based on where the session originated.
MEDIA_ORIGIN Allows chat session thread facts to be described based on where the session originated.
MEDIA_TYPE Allows facts to be described based on media type, such as Voice.
MEDIA_TYPE Allows facts to be described based on media type, such as Voice.
MEDIA_TYPE Allows facts to be described based on media type, such as Voice.
MEDIA_TYPE Allows facts to be described based on media type, such as Voice.
POST_CALL_SURVEY_DIM_1 Allows interaction resource facts to be described based on the scores assigned by customers.
POST_CALL_SURVEY_DIM_1 Allows interaction resource facts to be described based on the scores assigned by customers.
POST_CALL_SURVEY_DIM_1 Allows interaction resource facts to be described based on the scores assigned by customers.
POST_CALL_SURVEY_DIM_1 Allows interaction resource facts to be described based on the scores assigned by customers.
POST_CALL_SURVEY_DIM_2 Allows interaction resource facts to be described based on post-call survey responses provided by customers.
POST_CALL_SURVEY_DIM_2 Allows interaction resource facts to be described based on post-call survey responses provided by customers.
POST_CALL_SURVEY_DIM_2 Allows interaction resource facts to be described based on post-call survey responses provided by customers.
POST_CALL_SURVEY_DIM_2 Allows interaction resource facts to be described based on post-call survey responses provided by customers.
POST_CALL_SURVEY_DIM_3 Allows interaction resource facts to be described based on responses provided by customers during post-call survey.
POST_CALL_SURVEY_DIM_3 Allows interaction resource facts to be described based on responses provided by customers during post-call survey.
POST_CALL_SURVEY_DIM_3 Allows interaction resource facts to be described based on responses provided by customers during post-call survey.
POST_CALL_SURVEY_DIM_3 Allows interaction resource facts to be described based on responses provided by customers during post-call survey.
POST_CALL_SURVEY_DIM_4 Allows interaction resource facts to be described based on post-call survey responses provided by customers.
POST_CALL_SURVEY_DIM_4 Allows interaction resource facts to be described based on post-call survey responses provided by customers.
POST_CALL_SURVEY_DIM_4 Allows interaction resource facts to be described based on post-call survey responses provided by customers.
POST_CALL_SURVEY_DIM_4 Allows interaction resource facts to be described based on post-call survey responses provided by customers.
POST_CALL_SURVEY_DIM_5 Allows interaction resource facts to be described based on post-call survey responses provided by customers.
POST_CALL_SURVEY_DIM_5 Allows interaction resource facts to be described based on post-call survey responses provided by customers.
POST_CALL_SURVEY_DIM_5 Allows interaction resource facts to be described based on post-call survey responses provided by customers.
POST_CALL_SURVEY_DIM_5 Allows interaction resource facts to be described based on post-call survey responses provided by customers.
POST_CALL_SURVEY_DIM_6 Allows interaction resource facts to be described based on the post-call survey completion and customer recommendation score.
POST_CALL_SURVEY_DIM_6 Allows interaction resource facts to be described based on the post-call survey completion and customer recommendation score.
POST_CALL_SURVEY_DIM_6 Allows interaction resource facts to be described based on the post-call survey completion and customer recommendation score.
POST_CALL_SURVEY_DIM_6 Allows interaction resource facts to be described based on the post-call survey completion and customer recommendation score.
RECORD_FIELD_GROUP_1 Allows contact attempt facts to be described by deployment-specific outbound campaign calling list field values.
RECORD_FIELD_GROUP_1 Allows contact attempt facts to be described by deployment-specific outbound campaign calling list field values.
RECORD_FIELD_GROUP_1 Allows contact attempt facts to be described by deployment-specific outbound campaign calling list field values.
RECORD_FIELD_GROUP_1 Allows contact attempt facts to be described by deployment-specific outbound campaign calling list field values.
RECORD_FIELD_GROUP_2 Allows contact attempt facts to be described by deployment-specific outbound campaign calling list field values.
RECORD_FIELD_GROUP_2 Allows contact attempt facts to be described by deployment-specific outbound campaign calling list field values.
RECORD_FIELD_GROUP_2 Allows contact attempt facts to be described by deployment-specific outbound campaign calling list field values.
RECORD_FIELD_GROUP_2 Allows contact attempt facts to be described by deployment-specific outbound campaign calling list field values.
RECORD_STATUS Allows facts to be described based on attributes of an outbound campaign record status.
RECORD_STATUS Allows facts to be described based on attributes of an outbound campaign record status.
RECORD_STATUS Allows facts to be described based on attributes of an outbound campaign record status.
RECORD_STATUS Allows facts to be described based on attributes of an outbound campaign record status.
RECORD_TYPE Allows facts to be described based on attributes of an outbound campaign record type.
RECORD_TYPE Allows facts to be described based on attributes of an outbound campaign record type.
RECORD_TYPE Allows facts to be described based on attributes of an outbound campaign record type.
RECORD_TYPE Allows facts to be described based on attributes of an outbound campaign record type.
REQUESTED_SKILL Allows facts to be described based on a combination of requested skills and minimum skill proficiencies.
REQUESTED_SKILL Allows facts to be described based on a combination of requested skills and minimum skill proficiencies.
REQUESTED_SKILL Allows facts to be described based on a combination of requested skills and minimum skill proficiencies.
REQUESTED_SKILL Allows facts to be described based on a combination of requested skills and minimum skill proficiencies.
REQUESTED_SKILL_COMBINATION Allows facts to be described by a single string field that represents the full combination of requested skills and proficiencies.
REQUESTED_SKILL_COMBINATION Allows facts to be described by a single string field that represents the full combination of requested skills and proficiencies.
REQUESTED_SKILL_COMBINATION Allows facts to be described by a single string field that represents the full combination of requested skills and proficiencies.
REQUESTED_SKILL_COMBINATION Allows facts to be described by a single string field that represents the full combination of requested skills and proficiencies.
RESOURCE_ Allows facts to be described based on the attributes of contact center resources.
RESOURCE_ Allows facts to be described based on the attributes of contact center resources.
RESOURCE_ Allows facts to be described based on the attributes of contact center resources.
RESOURCE_ Allows facts to be described based on the attributes of contact center resources.
RESOURCE_ANNEX Stores additional configuration data for configuration objects of type Person.
RESOURCE_ANNEX Stores additional configuration data for configuration objects of type Person.
RESOURCE_ANNEX Stores additional configuration data for configuration objects of type Person.
RESOURCE_ANNEX Stores additional configuration data for configuration objects of type Person.
RESOURCE_GROUP_COMBINATION Allows facts to be described based on the membership of resources in a combination of resource groups.
RESOURCE_GROUP_COMBINATION Allows facts to be described based on the membership of resources in a combination of resource groups.
RESOURCE_GROUP_COMBINATION Allows facts to be described based on the membership of resources in a combination of resource groups.
RESOURCE_GROUP_COMBINATION Allows facts to be described based on the membership of resources in a combination of resource groups.
RESOURCE_STATE Allows facts to be described by the states of the contact center resources.
RESOURCE_STATE Allows facts to be described by the states of the contact center resources.
RESOURCE_STATE Allows facts to be described by the states of the contact center resources.
RESOURCE_STATE Allows facts to be described by the states of the contact center resources.
RESOURCE_STATE_REASON Allows facts to be described by the state reason of the associated agent resource.
RESOURCE_STATE_REASON Allows facts to be described by the state reason of the associated agent resource.
RESOURCE_STATE_REASON Allows facts to be described by the state reason of the associated agent resource.
RESOURCE_STATE_REASON Allows facts to be described by the state reason of the associated agent resource.
ROUTING_TARGET Allows facts to be described by routing targets that are selected by the router.
ROUTING_TARGET Allows facts to be described by routing targets that are selected by the router.
ROUTING_TARGET Allows facts to be described by routing targets that are selected by the router.
ROUTING_TARGET Allows facts to be described by routing targets that are selected by the router.
SDR_ACTIVITIES_FACT Records activities that the user encountered while the call was being processed by the Application.
SDR_ACTIVITIES_FACT Records activities that the user encountered while the call was being processed by the Application.
SDR_ACTIVITIES_FACT Records activities that the user encountered while the call was being processed by the Application.
SDR_ACTIVITIES_FACT Records activities that the user encountered while the call was being processed by the Application.
SDR_ACTIVITY Allows SDR facts to be described based on the activities in the application session.
SDR_ACTIVITY Allows SDR facts to be described based on the activities in the application session.
SDR_ACTIVITY Allows SDR facts to be described based on the activities in the application session.
SDR_ACTIVITY Allows SDR facts to be described based on the activities in the application session.
SDR_APPLICATION Allows SDR facts to be described based on the attributes of the Designer application.
SDR_APPLICATION Allows SDR facts to be described based on the attributes of the Designer application.
SDR_APPLICATION Allows SDR facts to be described based on the attributes of the Designer application.
SDR_APPLICATION Allows SDR facts to be described based on the attributes of the Designer application.
SDR_BOTS_FACT Represents bot activity during interaction flows orchestrated by Genesys Designer applications.
SDR_BOTS_FACT Represents bot activity during interaction flows orchestrated by Genesys Designer applications.
SDR_CALL_DISPOSITION Allows SDR facts to be described based on the disposition of the interaction.
SDR_CALL_DISPOSITION Allows SDR facts to be described based on the disposition of the interaction.
SDR_CALL_DISPOSITION Allows SDR facts to be described based on the disposition of the interaction.
SDR_CALL_DISPOSITION Allows SDR facts to be described based on the disposition of the interaction.
SDR_CALL_TYPE Allows SDR facts to be described based on the call type.
SDR_CALL_TYPE Allows SDR facts to be described based on the call type.
SDR_CALL_TYPE Allows SDR facts to be described based on the call type.
SDR_CALL_TYPE Allows SDR facts to be described based on the call type.
SDR_CUST_ATRIBUTES Allows SDR facts to be described based on attributes attached to SDR for reporting purposes.
SDR_CUST_ATRIBUTES Allows SDR facts to be described based on attributes attached to SDR for reporting purposes.
SDR_CUST_ATRIBUTES Allows SDR facts to be described based on attributes attached to the SDR for reporting purposes.
SDR_CUST_ATRIBUTES Allows SDR facts to be described based on attributes attached to SDR for reporting purposes.
SDR_CUST_ATRIBUTES_FACT Records attribute values that applications attach to SDR for reporting purposes.
SDR_CUST_ATRIBUTES_FACT Records attribute values that applications attach to SDR for reporting purposes.
SDR_CUST_ATRIBUTES_FACT Records attribute values that applications attach to SDR for reporting purposes.
SDR_CUST_ATRIBUTES_FACT Records attribute values that applications attach to SDR for reporting purposes.
SDR_ENTRY_POINT Allows SDR facts to be described based on the DNIS.
SDR_ENTRY_POINT Allows SDR facts to be described based on the DNIS.
SDR_ENTRY_POINT Allows SDR facts to be described based on the DNIS.
SDR_ENTRY_POINT Allows SDR facts to be described based on the DNIS.
SDR_EXIT_POINT Allows SDR facts to be described based on the exit point of the self-service application.
SDR_EXIT_POINT Allows SDR facts to be described based on the exit point of the self-service application.
SDR_EXIT_POINT Allows SDR facts to be described based on the exit point of the self-service application.
SDR_EXIT_POINT Allows SDR facts to be described based on the exit point of the self-service application.
SDR_EXT_HTTP_REST Allows SDR facts to be described based on the URLs invoked for external HTTP requests.
SDR_EXT_HTTP_REST Allows SDR facts to be described based on the URLs invoked for external HTTP requests.
SDR_EXT_HTTP_REST Allows SDR facts to be described based on the URLs invoked for external HTTP requests.
SDR_EXT_HTTP_REST Allows SDR facts to be described based on the URLs invoked for external HTTP requests.
SDR_EXT_REQUEST Allows SDR facts to be described based on attributes of external service requests.
SDR_EXT_REQUEST Allows SDR facts to be described based on attributes of external service requests.
SDR_EXT_REQUEST Allows SDR facts to be described based on attributes of external service requests.
SDR_EXT_REQUEST Allows SDR facts to be described based on attributes of external service requests.
SDR_EXT_REQUEST_FACT Represents a particular invocation of an external service.
SDR_EXT_REQUEST_FACT Represents a particular invocation of an external service.
SDR_EXT_REQUEST_FACT Represents a particular invocation of an external service.
SDR_EXT_REQUEST_FACT Represents a particular invocation of an external service.
SDR_EXT_REQUEST_OUTCOME Allows SDR facts to be described based on the outcome of external service requests.
SDR_EXT_REQUEST_OUTCOME Allows SDR facts to be described based on the outcome of external service requests.
SDR_EXT_REQUEST_OUTCOME Allows SDR facts to be described based on the outcome of external service requests.
SDR_EXT_REQUEST_OUTCOME Allows SDR facts to be described based on the outcome of external service requests.
SDR_EXT_SERVICE_OUTCOME Allows SDR facts to be described based on the outcome of custom services.
SDR_EXT_SERVICE_OUTCOME Allows SDR facts to be described based on the outcome of custom services.
SDR_EXT_SERVICE_OUTCOME Allows SDR facts to be described based on the outcome of custom services.
SDR_EXT_SERVICE_OUTCOME Allows SDR facts to be described based on the outcome of custom services.
SDR_GEO_LOCATION Allows SDR facts to be described based on the geographical location of the data center.
SDR_GEO_LOCATION Allows SDR facts to be described based on the geographical location of the data center.
SDR_GEO_LOCATION Allows SDR facts to be described based on the geographical location of the data center.
SDR_GEO_LOCATION Allows SDR facts to be described based on the geographical location of the data center.
SDR_INPUT Allows SDR facts to be described based on the input block.
SDR_INPUT Allows SDR facts to be described based on the input block.
SDR_INPUT Allows SDR facts to be described based on the input block.
SDR_INPUT Allows SDR facts to be described based on the input block.
SDR_INPUT_OUTCOME Allows SDR facts to be described based on the outcome of the caller's voice or DTMF input.
SDR_INPUT_OUTCOME Allows SDR facts to be described based on the outcome of the caller's voice or DTMF input.
SDR_INPUT_OUTCOME Allows SDR facts to be described based on the outcome of the caller's voice or DTMF input.
SDR_INPUT_OUTCOME Allows SDR facts to be described based on the outcome of the caller's voice or DTMF input.
SDR_LANGUAGE Allows SDR facts to be described based on the language in which the call was conducted.
SDR_LANGUAGE Allows SDR facts to be described based on the language in which the call was conducted.
SDR_LANGUAGE Allows SDR facts to be described based on the language in which the call was conducted.
SDR_LANGUAGE Allows SDR facts to be described based on the language in which the call was conducted.
SDR_MESSAGE Allows SDR facts to be described based on the prompt messages that were used.
SDR_MESSAGE Allows SDR facts to be described based on the prompt messages that were used.
SDR_MESSAGE Allows SDR facts to be described based on the prompt messages that were used.
SDR_MESSAGE Allows SDR facts to be described based on the prompt messages that were used.
SDR_MILESTONE Allows SDR facts to be described based on the milestones that the user reached.
SDR_MILESTONE Allows SDR facts to be described based on the milestones that the user reached.
SDR_MILESTONE Allows SDR facts to be described based on the milestones that the user reached.
SDR_MILESTONE Allows SDR facts to be described based on the milestones that the user reached.
SDR_SESSION_FACT Represents caller activity in an SDR application.
SDR_SESSION_FACT Represents caller activity in an SDR application.
SDR_SESSION_FACT Represents caller activity in an SDR application.
SDR_SESSION_FACT Represents caller activity in an SDR application.
SDR_SURVEY_ANSWERS Enables SDR facts to be described based on answers to questions in the post-call survey.
SDR_SURVEY_ANSWERS Enables SDR facts to be described based on answers to questions in the post-call survey.
SDR_SURVEY_ANSWERS Enables SDR facts to be described based on answers to questions in the post-call survey.
SDR_SURVEY_ANSWERS Enables SDR facts to be described based on answers to questions in the post-call survey.
SDR_SURVEY_FACT Represents post-call survey activity in an SDR application.
SDR_SURVEY_FACT Represents post-call survey activity in an SDR application.
SDR_SURVEY_FACT Represents post-call survey activity in an SDR application.
SDR_SURVEY_FACT Represents post-call survey activity in an SDR application.
SDR_SURVEY_I1 Allows SDR facts to be described based on responses to survey questions IQ1-IQ5.
SDR_SURVEY_I1 Allows SDR facts to be described based on responses to survey questions IQ1-IQ5.
SDR_SURVEY_I1 Allows SDR facts to be described based on responses to survey questions IQ1-IQ5.
SDR_SURVEY_I1 Allows SDR facts to be described based on responses to survey questions IQ1-IQ5.
SDR_SURVEY_I2 Allows SDR facts to be described based on responses to survey questions IQ6-IQ10.
SDR_SURVEY_I2 Allows SDR facts to be described based on responses to survey questions IQ6-IQ10.
SDR_SURVEY_I2 Allows SDR facts to be described based on responses to survey questions IQ6-IQ10.
SDR_SURVEY_I2 Allows SDR facts to be described based on responses to survey questions IQ6-IQ10.
SDR_SURVEY_QUESTIONS Enables SDR facts to be described based on questions in the post-call survey.
SDR_SURVEY_QUESTIONS Enables SDR facts to be described based on questions in the post-call survey.
SDR_SURVEY_QUESTIONS Enables SDR facts to be described based on questions in the post-call survey.
SDR_SURVEY_QUESTIONS Enables SDR facts to be described based on questions in the post-call survey.
SDR_SURVEY_QUESTIONS_I1 Allows SDR facts to be described based on custom survey questions IQ1-IQ5.
SDR_SURVEY_QUESTIONS_I1 Allows SDR facts to be described based on custom survey questions IQ1-IQ5.
SDR_SURVEY_QUESTIONS_I1 Allows SDR facts to be described based on custom survey questions IQ1-IQ5.
SDR_SURVEY_QUESTIONS_I1 Allows SDR facts to be described based on custom survey questions IQ1-IQ5.
SDR_SURVEY_QUESTIONS_I2 Allows SDR facts to be described based on custom survey questions IQ6-IQ10.
SDR_SURVEY_QUESTIONS_I2 Allows SDR facts to be described based on custom survey questions IQ6-IQ10.
SDR_SURVEY_QUESTIONS_I2 Allows SDR facts to be described based on custom survey questions IQ6-IQ10.
SDR_SURVEY_QUESTIONS_I2 Allows SDR facts to be described based on custom survey questions IQ6-IQ10.
SDR_SURVEY_QUESTIONS_S1 Allows SDR facts to be described based on custom survey questions SQ1-SQ5.
SDR_SURVEY_QUESTIONS_S1 Allows SDR facts to be described based on custom survey questions SQ1-SQ5.
SDR_SURVEY_QUESTIONS_S1 Allows SDR facts to be described based on custom survey questions SQ1-SQ5.
SDR_SURVEY_QUESTIONS_S1 Allows SDR facts to be described based on custom survey questions SQ1-SQ5.
SDR_SURVEY_QUESTIONS_S2 Allows SDR facts to be described based on custom survey questions SQ6-SQ10.
SDR_SURVEY_QUESTIONS_S2 Allows SDR facts to be described based on custom survey questions SQ6-SQ10.
SDR_SURVEY_QUESTIONS_S2 Allows SDR facts to be described based on custom survey questions SQ6-SQ10.
SDR_SURVEY_QUESTIONS_S2 Allows SDR facts to be described based on custom survey questions SQ6-SQ10.
SDR_SURVEY_S1 Allows SDR facts to be described based on responses to survey questions SQ1-SQ5.
SDR_SURVEY_S1 Allows SDR facts to be described based on responses to survey questions SQ1-SQ5.
SDR_SURVEY_S1 Allows SDR facts to be described based on responses to survey questions SQ1-SQ5.
SDR_SURVEY_S1 Allows SDR facts to be described based on responses to survey questions SQ1-SQ5.
SDR_SURVEY_S2 Allows SDR facts to be described based on responses to survey questions SQ6-SQ10.
SDR_SURVEY_S2 Allows SDR facts to be described based on responses to survey questions SQ6-SQ10.
SDR_SURVEY_S2 Allows SDR facts to be described based on responses to survey questions SQ6-SQ10.
SDR_SURVEY_S2 Allows SDR facts to be described based on responses to survey questions SQ6-SQ10.
SDR_SURVEY_SCORES Allows SDR facts to be described based on the satisfaction level expressed by survey respondents.
SDR_SURVEY_SCORES Allows SDR facts to be described based on the satisfaction level expressed by survey respondents.
SDR_SURVEY_SCORES Allows SDR facts to be described based on the satisfaction level expressed by survey respondents.
SDR_SURVEY_SCORES Allows SDR facts to be described based on the satisfaction level expressed by survey respondents.
SDR_SURVEY_STATUS Allows SDR facts to be described based on survey status.
SDR_SURVEY_STATUS Allows SDR facts to be described based on survey status.
SDR_SURVEY_STATUS Allows SDR facts to be described based on survey status.
SDR_SURVEY_STATUS Allows SDR facts to be described based on survey status.
SDR_SURVEY_TRANSCRIPT_FACT Captures transcriptions of voice messages left during survey.
SDR_SURVEY_TRANSCRIPT_FACT Captures transcriptions of voice messages left during survey.
SDR_SURVEY_TRANSCRIPT_FACT Captures transcriptions of voice messages left during survey.
SDR_SURVEY_TRANSCRIPT_FACT Captures transcriptions of voice messages left during survey.
SDR_USER_INPUT Allows SDR facts to be described based on the type of user input — voice or DTMF.
SDR_USER_INPUT Allows SDR facts to be described based on the type of user input — voice or DTMF.
SDR_USER_INPUT Allows SDR facts to be described based on the type of user input — voice or DTMF.
SDR_USER_INPUT Allows SDR facts to be described based on the type of user input — voice or DTMF.
SDR_USER_INPUTS_FACT Represents user input activity in an SDR session.
SDR_USER_INPUTS_FACT Represents user input activity in an SDR session.
SDR_USER_INPUTS_FACT Represents user input activity in an SDR session.
SDR_USER_INPUTS_FACT Represents user input activity in an SDR session.
SDR_USER_MILESTONE_FACT Identifies the milestones that the user encountered.
SDR_USER_MILESTONE_FACT Identifies the milestones that the user encountered.
SDR_USER_MILESTONE_FACT Identifies the milestones that the user encountered.
SDR_USER_MILESTONE_FACT Identifies the milestones that the user encountered.
SM_MEDIA_NEUTRAL_STATE_FACT Represents agent resource states, summarized across all media.
SM_MEDIA_NEUTRAL_STATE_FACT Represents agent resource states, summarized across all media.
SM_MEDIA_NEUTRAL_STATE_FACT Represents agent resource states, summarized across all media.
SM_MEDIA_NEUTRAL_STATE_FACT Represents agent resource states, summarized across all media.
SM_RES_SESSION_FACT Represents agent resource media sessions from login to logout, summarized to the media type.
SM_RES_SESSION_FACT Represents agent resource media sessions from login to logout, summarized to the media type.
SM_RES_SESSION_FACT Represents agent resource media sessions from login to logout, summarized to the media type.
SM_RES_SESSION_FACT Represents agent resource media sessions from login to logout, summarized to the media type.
SM_RES_STATE_FACT Represents agent resource states, summarized to the media type.
SM_RES_STATE_FACT Represents agent resource states, summarized to the media type.
SM_RES_STATE_FACT Represents agent resource states, summarized to the media type.
SM_RES_STATE_FACT Represents agent resource states, summarized to the media type.
SM_RES_STATE_REASON_FACT Represents agent resource state reasons, summarized to the media type.
SM_RES_STATE_REASON_FACT Represents agent resource state reasons, summarized to the media type.
SM_RES_STATE_REASON_FACT Represents agent resource state reasons, summarized to the media type.
SM_RES_STATE_REASON_FACT Represents agent resource state reasons, summarized to the media type.
STG_IDB_FK_VIOLATION Stores information about errors that Genesys Info Mart encounters during transformation of configuration data.
STG_IDB_FK_VIOLATION Stores information about errors that Genesys Info Mart encounters during transformation of configuration data.
STG_IDB_FK_VIOLATION Stores information about errors that Genesys Info Mart encounters during transformation of configuration data.
STG_IDB_FK_VIOLATION Stores information about errors that Genesys Info Mart encounters during transformation of configuration data.
STG_TRANSFORM_DISCARDS Stores information about interactions that were discarded because of errors that Genesys Info Mart encountered during data transformation.
STG_TRANSFORM_DISCARDS Stores information about interactions that were discarded because of errors that Genesys Info Mart encountered during data transformation.
STG_TRANSFORM_DISCARDS Stores information about interactions that were discarded because of errors that Genesys Info Mart encountered during data transformation.
STG_TRANSFORM_DISCARDS Stores information about interactions that were discarded because of errors that Genesys Info Mart encountered during data transformation.
STRATEGY Allows facts to be described by the associated routing strategy or IVR application.
STRATEGY Allows facts to be described by the associated routing strategy or IVR application.
STRATEGY Allows facts to be described by the associated routing strategy or IVR application.
STRATEGY Allows facts to be described by the associated routing strategy or IVR application.
TECHNICAL_DESCRIPTOR Allows facts to be described by the role of the associated contact center resource and the technical result of the association.
TECHNICAL_DESCRIPTOR Allows facts to be described by the role of the associated contact center resource and the technical result of the association.
TECHNICAL_DESCRIPTOR Allows facts to be described by the role of the associated contact center resource and the technical result of the association.
TECHNICAL_DESCRIPTOR Allows facts to be described by the role of the associated contact center resource and the technical result of the association.
TIME_ZONE Allows facts to be described based on attributes of a time zone.
TIME_ZONE Allows facts to be described based on attributes of a time zone.
TIME_ZONE Allows facts to be described based on attributes of a time zone.
TIME_ZONE Allows facts to be described based on attributes of a time zone.
USER_DATA_CUST_DIM_1 Is provided as a sample of a table to store deployment-specific, user-defined, low-cardinality dimensions based on data that come attached with interactions. By default, this table is not included in the schema.
USER_DATA_CUST_DIM_1 Is provided as a sample of a table to store deployment-specific, user-defined, low-cardinality dimensions based on data that come attached with interactions. By default, this table is not included in the schema.
USER_DATA_CUST_DIM_1 Is provided as a sample of a table to store deployment-specific, user-defined, low-cardinality dimensions based on data that come attached with interactions. By default, this table is not included in the schema.
USER_DATA_CUST_DIM_1 Is provided as a sample of a table to store deployment-specific, user-defined, low-cardinality dimensions based on data that come attached with interactions. By default, this table is not included in the schema.
USER_DATA_GEN_DIM_1 Reserved for internal use.
USER_DATA_GEN_DIM_1 Reserved for internal use.
USER_DATA_GEN_DIM_2 Reserved for internal use.
USER_DATA_GEN_DIM_2 Reserved for internal use.
WORKBIN Allows facts to be described based on the type and owner of the workbin instance, such as an agent, a place, or a group thereof.
WORKBIN Allows facts to be described based on the type and owner of the workbin instance, such as an agent, a place, or a group thereof.
WORKBIN Allows facts to be described based on the type and owner of the workbin instance, such as an agent, a place, or a group thereof.
WORKBIN Allows facts to be described based on the type and owner of the workbin instance, such as an agent, a place, or a group thereof.
GCX_AGENT_PLACE This table stores information about the associations between agents and places, including terminated associations, such as when an agent's assignment to a place is removed.
GCX_AGENT_PLACE This table stores information about the associations between agents and places, including terminated associations, such as when an agent's assignment to a place is removed.
GCX_CAMPGROUP_INFO This table stores information about the associations between campaigns and agent or place groups, including terminated associations, such as when an agent group is removed from a campaign.
GCX_CAMPGROUP_INFO This table stores information about the associations between campaigns and agent or place groups, including terminated associations, such as when an agent group is removed from a campaign.
GCX_CAMPLIST_INFO This table stores information about the associations between calling lists and campaigns, including terminated associations, such as when a calling list is removed from a campaign.
GCX_CAMPLIST_INFO This table stores information about the associations between calling lists and campaigns, including terminated associations, such as when a calling list is removed from a campaign.
GCX_ENDPOINT_PLACE This table stores information about the associations between endpoints (DNs) and places, including terminated associations, such as when an endpoint is removed from a place.
GCX_ENDPOINT_PLACE This table stores information about the associations between endpoints (DNs) and places, including terminated associations, such as when an endpoint is removed from a place.
GCX_FORMAT_FIELD This table stores information about the associations between Formats and Fields, including terminated associations.
GCX_FORMAT_FIELD This table stores information about the associations between Formats and Fields, including terminated associations.
GCX_GROUP_AGENT This table stores information about the associations between agents and agent groups, including terminated associations, such as when an agent is removed from an agent group.
GCX_GROUP_AGENT This table stores information about the associations between agents and agent groups, including terminated associations, such as when an agent is removed from an agent group.
GCX_GROUP_ENDPOINT This table stores information about the associations between endpoints (DNs) and DN groups, including terminated associations such as when a DN is removed from a DN group.
GCX_GROUP_ENDPOINT This table stores information about the associations between endpoints (DNs) and DN groups, including terminated associations such as when a DN is removed from a DN group.
GCX_GROUP_PLACE This table stores information about the associations between places and Place Groups, including terminated associations, such as when a Place is removed from a Place Group.
GCX_GROUP_PLACE This table stores information about the associations between places and Place Groups, including terminated associations, such as when a Place is removed from a Place Group.
GCX_GROUP_ROUTEDN This table stores information about the associations of Agent/Place/DN Groups to Route DNs, including terminated associations.
GCX_GROUP_ROUTEDN This table stores information about the associations of Agent/Place/DN Groups to Route DNs, including terminated associations.
GCX_LIST_TREATMENT This table stores information about the associations between treatments and calling lists, including terminated associations, such as when the application of a treatment is removed from a calling list.
GCX_LIST_TREATMENT This table stores information about the associations between treatments and calling lists, including terminated associations, such as when the application of a treatment is removed from a calling list.
GCX_LOGIN_INFO This table stores information about the associations of agent to agent logins, including terminated associations.
GCX_LOGIN_INFO This table stores information about the associations of agent to agent logins, including terminated associations.
GCX_OBJTABLE_RECORD This table stores information about associations between Objective Tables and- Enumerator Values, including terminated associations.
GCX_OBJTABLE_RECORD This table stores information about associations between Objective Tables and- Enumerator Values, including terminated associations.
GCX_SKILL_LEVEL This table stores information about the associations between agents and skills, including terminated associations, such as when the assignment of a skill is removed from agent configuration.
GCX_SKILL_LEVEL This table stores information about the associations between agents and skills, including terminated associations, such as when the assignment of a skill is removed from agent configuration.
GCX_SUBCODE This table stores information about associations of Action Codes to Subcodes, including terminated associations.
GCX_SUBCODE This table stores information about associations of Action Codes to Subcodes, including terminated associations.
GC_ACTION_CODE This table stores information about the configuration of Action Code objects.
GC_ACTION_CODE This table stores information about the configuration of Action Code objects.
GC_AGENT This table describes information about the configuration of Person (Agent) objects.
GC_AGENT This table describes information about the configuration of Person (Agent) objects.
GC_ANNEX This table stores information about changes to certain configuration options configured on the Annex tabs of certain object types.
GC_ANNEX This table stores information about changes to certain configuration options configured on the Annex tabs of certain object types.
GC_APPLICATION This table stores information about the configuration of Application objects.
GC_APPLICATION This table stores information about the configuration of Application objects.
GC_ATTR_VALUE This table stores information about the configuration of Enumerator Value (Attribute Value) objects.
GC_ATTR_VALUE This table stores information about the configuration of Enumerator Value (Attribute Value) objects.
GC_BUS_ATTRIBUTE This tables stores information about configuration of Enumerator (Business Attribute) objects.
GC_BUS_ATTRIBUTE This tables stores information about configuration of Enumerator (Business Attribute) objects.
GC_CALLING_LIST This table stores information about the configuration of Calling List objects.
GC_CALLING_LIST This table stores information about the configuration of Calling List objects.
GC_CAMPAIGN This table stores information about the configuration of Campaign objects.
GC_CAMPAIGN This table stores information about the configuration of Campaign objects.
GC_ENDPOINT This table stores configuration information about endpoints, including DNs, scripts, and agent places.
GC_ENDPOINT This table stores configuration information about endpoints, including DNs, scripts, and agent places.
GC_FIELD This table stores information about the configuration of Field objects.
GC_FIELD This table stores information about the configuration of Field objects.
GC_FILTER This table stores information about the configuration of Filter objects.
GC_FILTER This table stores information about the configuration of Filter objects.
GC_FOLDER This table stores information about the configuration of Folder objects.
GC_FOLDER This table stores information about the configuration of Folder objects.
GC_FORMAT This table stores information about the configuration of Format objects.
GC_FORMAT This table stores information about the configuration of Format objects.
GC_GROUP This table stores information about agent group, place group, and DN group configuration objects.
GC_GROUP This table stores information about agent group, place group, and DN group configuration objects.
GC_IVR This table stores information about the configuration of the IVR objects.
GC_IVR This table stores information about the configuration of the IVR objects.
GC_IVRPORT This table stores information about the configuration of IVR Port objects.
GC_IVRPORT This table stores information about the configuration of IVR Port objects.
GC_LOGIN This table contains information about configuration of Agent Login objects.
GC_LOGIN This table contains information about configuration of Agent Login objects.
GC_OBJ_TABLE This table contains information about configuration of Objective Table objects.
GC_OBJ_TABLE This table contains information about configuration of Objective Table objects.
GC_PLACE This table contains information about configuration of Place objects.
GC_PLACE This table contains information about configuration of Place objects.
GC_SCRIPT This table contains information about configuration of Script objects.
GC_SCRIPT This table contains information about configuration of Script objects.
GC_SKILL This table contains information about configuration of Skill objects.
GC_SKILL This table contains information about configuration of Skill objects.
GC_SWITCH This table contains information about configuration of Switch objects.
GC_SWITCH This table contains information about configuration of Switch objects.
GC_TABLE_ACCESS This table contains information about configuration of Table Access objects.
GC_TABLE_ACCESS This table contains information about configuration of Table Access objects.
GC_TENANT The table stores information about Tenant configuration objects.
GC_TENANT The table stores information about Tenant configuration objects.
GC_TIME_ZONE This table stores information about the configuration of Time Zone objects.
GC_TIME_ZONE This table stores information about the configuration of Time Zone objects.
GC_TREATMENT This table stores information about the configuration of Treatment objects.
GC_TREATMENT This table stores information about the configuration of Treatment objects.
GC_VOICE_PROMPT This table stores information about the configuration of Voice Prompt objects.
GC_VOICE_PROMPT This table stores information about the configuration of Voice Prompt objects.
GM_F_USERDATA This table contains information about predefined logical keys in the attached data of multimedia interactions. The data stored in this table is initially populated when the interaction is created. Starting in release 8.1.514.06, the table can be updated by data received in EventPropertiesChanged.
GM_F_USERDATA This table contains information about predefined logical keys in the attached data of multimedia interactions. The data store in this table corresponds to the data available after interaction creation.
GM_L_USERDATA This table contains information about predefined logical keys in the attached data of multimedia interactions. The data store in this table corresponds to the data available after interaction termination.
GM_L_USERDATA This table contains information about predefined logical keys in the attached data of multimedia interactions. The data store in this table corresponds to the data available after interaction termination.
GOX_Chain_Call The records in this table reflect the relationship between voice calls (refer to table G_CALL in the Core Schema of IDB) and Chain processing records (refer to table GO_Chain in this schema).
GOX_Chain_Call The records in this table reflect the relationship between voice calls (refer to table G_CALL in the Core Schema of IDB) and Chain processing records (refer to table GO_Chain in this schema).
GO_CampProp_Hist This table contains the history of Campaign property changes during the campaign processing attempt. Records are inserted into this table when ICON receives information about campaign property changes from OCS. Records in this table are never updated or deleted
GO_CampProp_Hist This table contains the history of Campaign property changes during the campaign processing attempt. Records are inserted into this table when ICON receives information about campaign property changes from OCS. Records in this table are never updated or deleted
GO_Campaign This table contains current information about a Campaign, as reported by OCS. Records are inserted into this table when the first OCSD event that is related to campaign processing attempts is received from OCS. The record is updated each time that information about changes to Campaign state or Campaign properties are received from OCS
GO_Campaign This table contains current information about a Campaign, as reported by OCS. Records are inserted into this table when the first OCSD event that is related to campaign processing attempts is received from OCS. The record is updated each time that information about changes to Campaign state or Campaign properties are received from OCS
GO_CampaignHistory This table contains the history of Campaign state changes and campaign property changes that occurred during a campaign processing attempt. Records are inserted into this table when the campaign state changes or when ICON receives information about campaign property changes from OCS. Records in this table are never updated or deleted.
GO_CampaignHistory This table contains the history of Campaign state changes and campaign property changes that occurred during a campaign processing attempt. Records are inserted into this table when the campaign state changes or when ICON receives information about campaign property changes from OCS. Records in this table are never updated or deleted.
GO_Chain This table contains current information about chains, as reported by OCS. A record is inserted at the time ICON receives the first notification about Chain processing from OCS. The record is updated when there is a change of state of the chain.
GO_Chain This table contains current information about chains, as reported by OCS. A record is inserted at the time ICON receives the first notification about Chain processing from OCS. The record is updated when there is a change of state of the chain.
GO_ChainRec_hist This table contains the history of the chain/record processing, as reported by OCS. Changes to the chain state during chain processing result in the creation of a new record in this table. The record is inserted when information about chain state received from OCS. Records are never updated or deleted in this table.
GO_ChainRec_hist This table contains the history of the chain/record processing, as reported by OCS. Changes to the chain state during chain processing result in the creation of a new record in this table. The record is inserted when information about chain state received from OCS. Records are never updated or deleted in this table.
GO_Custom_Fields This table contains information about the content of the custom-defined fields for storage in ICON.
GO_Custom_Fields This table contains information about the content of the custom-defined fields for storage in ICON.
GO_FieldHist This table contains information about the history of the field changes in the records, as reported by OCS, during chain processing.
GO_FieldHist This table contains information about the history of the field changes in the records, as reported by OCS, during chain processing.
GO_Metrics This table contains the current and latest values of pre-calculated OCS metrics. Records are inserted at the time ICON receives metric information. The information includes the specified type the first time that the combination of objects is specified. The record is updated each time ICON receives changes to metric data.
GO_Metrics This table contains the current and latest values of pre-calculated OCS metrics. Records are inserted at the time ICON receives metric information. The information includes the specified type the first time that the combination of objects is specified. The record is updated each time ICON receives changes to metric data.
GO_Record This table contains information about the content of the records as reported by OCS (mandatory fields only). Records are inserted into this table at the time the loading of the record is reported by OCS. Records contain current and last values of the fields. Records are updated when any mandatory field changes.
GO_Record This table contains information about the content of the records as reported by OCS (mandatory fields only). Records are inserted into this table at the time the loading of the record is reported by OCS. Records contain current and last values of the fields. Records are updated when any mandatory field changes.
GO_Sec_FieldHist This table contains information about the history of changes to fields that are configured as protected, as reported by OCS during chain processing.
GO_Sec_FieldHist This table contains information about the history of changes to fields that are configured as protected, as reported by OCS during chain processing.
GO_Secure_Fields This table contains information regarding the content of the custom defined fields that are configured to be stored in ICON. They are configured as protected fields. Records are inserted into this table when the load of the record is reported by OCS. The records contain current and last values of the fields. Records are updated at the time that a field changes.
GO_Secure_Fields This table contains information regarding the content of the custom defined fields that are configured to be stored in ICON. They are configured as protected fields. Records are inserted into this table when the load of the record is reported by OCS. The records contain current and last values of the fields. Records are updated at the time that a field changes.
GSYS_DNPRemoteLocation This table contains information about the remote locations involved in an interaction.
GSYS_DNPRemoteLocation This table contains information about the remote locations involved in an interaction.
GSYS_SYSPROCINFO This is an internal table exclusively for ICON use. Please do not modify records in this table or this table's structure.
GSYS_SYSPROCINFO This is an internal table exclusively for ICON use. Please do not modify records in this table or this table's structure.
GS_AGENT_STAT This table contains the duration of agent state metrics. The unique identifier of the record is the combination of the LoginSessionID, EndPointID, and QueueID fields. Whether ICON writes to this table is determined by the setting of one or more configuration options in the [filter-data] section.
GS_AGENT_STAT This table contains the duration of agent state metrics. The unique identifier of the record is the combination of the LoginSessionID, EndPointID, and QueueID fields. Whether ICON writes to this table is determined by the setting of one or more configuration options in the [filter-data] section.
GS_AGENT_STAT_WM This table contains the duration of agent workmode metrics. The unique identifier of the record is the combination of the LoginSessionID, EndPointID, and QueueID fields. Whether ICON writes to this table is determined by the setting of one or more configuration options in the [filter-data] section.
GS_AGENT_STAT_WM This table contains the duration of agent workmode metrics. The unique identifier of the record is the combination of the LoginSessionID, EndPointID, and QueueID fields. Whether ICON writes to this table is determined by the setting of one or more configuration options in the [filter-data] section.
GX_SESSION_ENDPOINT This table contains records that reflect the associations between endpoints and the login session. Whether ICON writes to this table is determined by the setting of one or more configuration options in the [filter-data] section.
GX_SESSION_ENDPOINT This table contains records that reflect the associations between endpoints and the login session. Whether ICON writes to this table is determined by the setting of one or more configuration options in the [filter-data] section.
G_AGENT_STATE_HISTORY This table contains detailed information about state changes during the agent's login session.
G_AGENT_STATE_HISTORY This table contains detailed information about state changes during the agent's login session.
G_AGENT_STATE_RC The agent states reason codes. Records are inserted when either a hardware or software reason code finishes on an agent's state. Whether ICON writes to this table is determined by the setting of one or more configuration options in the [filter-data] section.
G_AGENT_STATE_RC The agent states reason codes. Records are inserted when either a hardware or software reason code finishes on an agent's state. Whether ICON writes to this table is determined by the setting of one or more configuration options in the [filter-data] section.
G_AGENT_STATE_RC_A The active Agent state reason codes.
G_AGENT_STATE_RC_A The active Agent state reason codes.
G_CALL This table contains information regarding the latest state of the interaction, according to information received from either the T-Server or Interaction Server applications.
G_CALL This table contains information regarding the latest state of the interaction, according to information received from either the T-Server or Interaction Server applications.
G_CALL_ACTIVE This table contains information regarding the latest state of the interaction, according to information received from either the T-Server or Interaction Server applications.
G_CALL_ACTIVE This table contains information regarding the latest state of the interaction, according to information received from either the T-Server or Interaction Server applications.
G_CALL_HISTORY This table contains chronological information on all of the states of voice or multimedia interactions, according to data received from T-Server or Interaction Server.
G_CALL_HISTORY This table contains chronological information on all of the states of voice or multimedia interactions, according to data received from T-Server or Interaction Server.
G_CALL_STAT This table contains information regarding voice call statistics, which are summarized upon completion of the call.
G_CALL_STAT This table contains information regarding voice call statistics, which are summarized upon completion of the call.
G_CALL_USERDATA This table stores the principal information regarding user data that is attached to voice call interactions.
G_CALL_USERDATA This table stores the principal information regarding user data that is attached to voice call interactions.
G_CALL_USERDATA_CUST1 This table stores additional custom-attribute information regarding the user data that is attached to call interactions.
G_CALL_USERDATA_CUST1 This table stores additional custom-attribute information regarding the user data that is attached to call interactions.
G_CALL_USERDATA_CUST2 This table contains additional custom-attribute information regarding the user data that is attached to the call interactions.
G_CALL_USERDATA_CUST2 This table contains additional custom-attribute information regarding the user data that is attached to the call interactions.
G_CALL_USERDATA_CUST The table contains custom-attribute information about user data attached to call interactions.
G_CALL_USERDATA_CUST The table contains custom-attribute information about user data attached to call interactions.
G_CUSTOM_DATA_P This table contains principal information about user data that is attached to a voice call interaction. This information originates from T-Server's EventUserEvent TEvents.
G_CUSTOM_DATA_P This table contains principal information about user data that is attached to a voice call interaction. This information originates from T-Server's EventUserEvent TEvents.
G_CUSTOM_DATA_S This table records the changes to the user data that is associated with a voice call.
G_CUSTOM_DATA_S This table records the changes to the user data that is associated with a voice call.
G_CUSTOM_STATES This table contains detailed information about an agent's state changes during his or her login session.
G_CUSTOM_STATES This table contains detailed information about an agent's state changes during his or her login session.
G_DB_PARAMETERS This table contains information regarding some of the configuration parameters (such as the database schema version) that are used by ICON.
G_DB_PARAMETERS This table contains information regarding some of the configuration parameters (such as the database schema version) that are used by ICON.
G_DICTIONARY This table contains a set of values for every enumeration class that is defined in the G_DICT_TYPE table.
G_DICTIONARY This table contains a set of values for every enumeration class that is defined in the G_DICT_TYPE table.
G_DICT_TYPE This table contains information regarding the classes of the enumeration types referenced in IDB tables.
G_DICT_TYPE This table contains information regarding the classes of the enumeration types referenced in IDB tables.
G_DND_HISTORY This table stores information about the activation of the Do Not Disturb (DND) feature within an agent's session.
G_DND_HISTORY This table stores information about the activation of the Do Not Disturb (DND) feature within an agent's session.
G_DSS_CFG_PROVIDER The control table for the cfg role, which stores configuration-related information. The data source is Configuration Server.
G_DSS_CFG_PROVIDER The control table for the cfg role, which stores configuration-related information. The data source is Configuration Server.
G_DSS_GCC_PROVIDER The control table for the gcc role, which stores interaction-related and party-related information. The data sources are T-Server and Interaction Server.
G_DSS_GCC_PROVIDER The control table for the gcc role, which stores interaction-related and party-related information. The data sources are T-Server and Interaction Server.
G_DSS_GLS_PROVIDER The control table for the gls role, which stores data that pertains to agent states and agent login sessions. The data sources are T-Server and Interaction Server.
G_DSS_GLS_PROVIDER The control table for the gls role, which stores data that pertains to agent states and agent login sessions. The data sources are T-Server and Interaction Server.
G_DSS_GOS_PROVIDER The control table for the gos role, which stores data that pertains to outbound calls and campaigns. The data source is Outbound Contact Server (OCS).
G_DSS_GOS_PROVIDER The control table for the gos role, which stores data that pertains to outbound calls and campaigns. The data source is Outbound Contact Server (OCS).
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.
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.
G_IR This table contains information regarding the latest state of the interaction, according to the information supplied by a specific provider such as T-Server, Interaction Server, or Outbound Contact Server.
G_IR This table contains information regarding the latest state of the interaction, according to the information supplied by a specific provider such as T-Server, Interaction Server, or Outbound Contact Server.
G_IR_ACTIVE This table contains information regarding the latest state of the interaction, according to the information supplied by a specific provider such as T-Server, Interaction Server, or Outbound Contact Server.
G_IR_ACTIVE This table contains information regarding the latest state of the interaction, according to the information supplied by a specific provider such as T-Server, Interaction Server, or Outbound Contact Server.
G_IR_HISTORY This table contains information regarding all states, in chronological order, of the interaction, according to the information supplied by the specific provider, such as T-Server, Interaction Server, or the Outbound Contact Server.
G_IR_HISTORY This table contains information regarding all states, in chronological order, of the interaction, according to the information supplied by the specific provider, such as T-Server, Interaction Server, or the Outbound Contact Server.
G_IS_LINK This table contains information regarding the latest state of the intersite link. An intersite link allows you to connect the information regarding two calls that originated on two different sites.
G_IS_LINK This table contains information regarding the latest state of the intersite link. An intersite link allows you to connect the information regarding two calls that originated on two different sites.
G_IS_LINK_HISTORY This table contains information regarding all of the states of the intersite link, in chronological order as derived from data supplied by T-Server.
G_IS_LINK_HISTORY This table contains information regarding all of the states of the intersite link, in chronological order as derived from data supplied by T-Server.
G_LOGIN_SESSION This table contains information about agent login sessions. ICON inserts a record upon the creation of an agent login session. ICON updates records, by marking them as deleted, at the time that the agent's login session finishes.
G_LOGIN_SESSION This table contains information about agent login sessions. ICON inserts a record upon the creation of an agent login session. ICON updates records, by marking them as deleted, at the time that the agent's login session finishes.
G_LOG_ATTRS This table stores attributes about the messages stored in the G_LOG_MESSAGES table.
G_LOG_ATTRS This table stores attributes about the messages stored in the G_LOG_MESSAGES table.
G_LOG_GETIDRANGEREQ An internal table that Solution Control Interface (SCI) uses for selecting log records. Refer to Framework documentation for information about SCI and Message Server.
G_LOG_GETIDRANGEREQ An internal table that Solution Control Interface (SCI) uses for selecting log records. Refer to Framework documentation for information about SCI and Message Server.
G_LOG_MESSAGES This table stores messages from the stored procedures about merge operations, purge operations, and stuck calls.
G_LOG_MESSAGES This table stores messages from the stored procedures about merge operations, purge operations, and stuck calls.
G_PARTY This table contains information regarding the latest state of the party involved in an interaction according to information received from T-Server or Interaction Server.
G_PARTY This table contains information regarding the latest state of the party involved in an interaction according to information received from T-Server or Interaction Server.
G_PARTY_HISTORY This table contains information regarding all the states, in chronological order, of the interaction party, according to information received from the T-Server or Interaction Server application.
G_PARTY_HISTORY This table contains information regarding all the states, in chronological order, of the interaction party, according to information received from the T-Server or Interaction Server application.
G_PARTY_STAT This table contains information regarding party statistics which are summarized upon termination of the party.
G_PARTY_STAT This table contains information regarding party statistics which are summarized upon termination of the party.
G_PROV_CONTROL This table contains information about the counters that ICON uses to populate the GSYS_SEQ and the GSYS_USEQ fields in all IDB tables. The counters are updated with configured reservation.
G_PROV_CONTROL This table contains information about the counters that ICON uses to populate the GSYS_SEQ and the GSYS_USEQ fields in all IDB tables. The counters are updated with configured reservation.
G_ROUTE_RESULT This table contains information regarding the results of the routing of a specific interaction, according to the information passed from the Universal Routing Server through either the T-Server or Interaction Server application.
G_ROUTE_RESULT This table contains information regarding the results of the routing of a specific interaction, according to the information passed from the Universal Routing Server through either the T-Server or Interaction Server application.
G_ROUTE_RES_VQ_HIST This table contains information about the use of virtual queues in interaction processing, according to the data passed from the Universal Routing Server through the T-Server or Interaction Server application.
G_ROUTE_RES_VQ_HIST This table contains information about the use of virtual queues in interaction processing, according to the data passed from the Universal Routing Server through the T-Server or Interaction Server application.
G_SAMPLE_CUST_ADATA This sample table stores attached call data from a custom attached data dispatcher.
G_SAMPLE_CUST_ADATA This sample table stores attached call data from a custom attached data dispatcher.
G_SECURE_USERDATA_HISTORY This table records the changes in the UserData attribute of TEvents associated with voice calls, the UserData attribute of Interaction Server events for all types of multimedia interactions, and the isOnline attribute of events associated with chat sessions. In addition, ICON may record the change history of the Reasons and Extensions attributes of voice interactions as well as any other attributes of an interaction that are not recorded in the G_CALL_HISTORY and the G_PARTY_HISTORY table, if configured to gather data from T-Server or Interaction Server.
G_SECURE_USERDATA_HISTORY This table records the changes in the UserData attribute of TEvents associated with voice calls, the UserData attribute of Interaction Server events for all types of multimedia interactions, and the isOnline attribute of events associated with chat sessions. In addition, ICON may record the change history of the Reasons and Extensions attributes of voice interactions as well as any other attributes of an interaction that are not recorded in the G_CALL_HISTORY and the G_PARTY_HISTORY table, if configured to gather data from T-Server or Interaction Server.
G_SYNC_CONTROL This table contains information about the last events stored by different ICON instances. This information is used during the HA synchronization.
G_SYNC_CONTROL This table contains information about the last events stored by different ICON instances. This information is used during the HA synchronization.
G_TIMECODE This table expands the timecode values, referenced in other tables as *_TCODE, into specific time value entities, such as month name, day of the week, day of the month, and so on. The table should be pre-populated before using it.
G_TIMECODE This table expands the timecode values, referenced in other tables as *_TCODE, into specific time value entities, such as month name, day of the week, day of the month, and so on. The table should be pre-populated before using it.
G_USERDATA_HISTORY This table records the changes in the UserData attribute of TEvents associated with voice calls, the UserData attribute of Interaction Server events for all types of multimedia interactions, and the isOnline attribute of events associated with chat sessions. In addition, ICON may record the change history of the Reasons and Extensions attributes of voice interactions as well as any other attributes of an interaction that are not recorded in the G_CALL_HISTORY and the G_PARTY_HISTORY table, if configured to gather data from T-Server or Interaction Server.
G_USERDATA_HISTORY This table records the changes in the UserData attribute of TEvents associated with voice calls, the UserData attribute of Interaction Server events for all types of multimedia interactions, and the isOnline attribute of events associated with chat sessions. In addition, ICON may record the change history of the Reasons and Extensions attributes of voice interactions as well as any other attributes of an interaction that are not recorded in the G_CALL_HISTORY and the G_PARTY_HISTORY table, if configured to gather data from T-Server or Interaction Server.
G_VIRTUAL_QUEUE This table contains information about the use of virtual queues in interaction processing, according to the data passed from the Universal Routing Server through the T-Server application.
G_VIRTUAL_QUEUE This table contains information about the use of virtual queues in interaction processing, according to the data passed from the Universal Routing Server through the T-Server application.
AGR_SCFG This internal table stores the thresholds that are associated with the handling of contact center interactions.
AGR_SCFG This internal table stores the thresholds that are associated with the handling of contact center interactions.
AGR_SCFG This internal table stores the thresholds that are associated with the handling of contact center interactions.
AGR_SCFG This internal table stores the thresholds that are associated with the handling of contact center interactions.
AGR_TIME_RANGE RAA populates this table; however, RAA uses the boundaries that are defined by options in the [agg-gim-thld-QUEUE-ABN] and [agg-gim-thld-QUEUE-ACC] sections for computation of STI measures.
AGR_TIME_RANGE RAA populates this table; however, RAA uses the boundaries that are defined by options in the [agg-gim-thld-QUEUE-ABN] and [agg-gim-thld-QUEUE-ACC] sections for computation of STI measures.
AGR_TIME_RANGE RAA populates this table; however, RAA uses the boundaries that are defined by options in the [agg-gim-thld-QUEUE-ABN] and [agg-gim-thld-QUEUE-ACC] sections for computation of STI measures.
AGR_TIME_RANGE RAA populates this table; however, RAA uses the boundaries that are defined by options in the [agg-gim-thld-QUEUE-ABN] and [agg-gim-thld-QUEUE-ACC] sections for computation of STI measures.
AGT_AGENT_CAMPAIGN_HOUR Agent rollup of interaction handling based on the campaign from which interactions originated.
AGT_AGENT_CAMPAIGN_HOUR Agent rollup of interaction handling based on the campaign from which interactions originated.
AGT_AGENT_CAMPAIGN_HOUR Agent rollup of interaction handling based on the campaign from which interactions originated.
AGT_AGENT_CAMPAIGN_HOUR Agent rollup of interaction handling based on the campaign from which interactions originated.
AGT_AGENT_GRP_HOUR Agent group rollup of interaction handling based on key business attributes, such as customer segment, service type, and service subtype.
AGT_AGENT_GRP_HOUR Agent group rollup of interaction handling based on key business attributes, such as customer segment, service type, and service subtype.
AGT_AGENT_GRP_HOUR Agent group rollup of interaction handling based on key business attributes, such as customer segment, service type, and service subtype.
AGT_AGENT_GRP_HOUR Agent group rollup of interaction handling based on key business attributes, such as customer segment, service type, and service subtype.
AGT_AGENT_HOUR Rollup of agent handling of interactions, based on key business attributes such as customer segment, service type, and service subtype.
AGT_AGENT_HOUR Rollup of agent handling of interactions, based on key business attributes such as customer segment, service type, and service subtype.
AGT_AGENT_HOUR Rollup of agent handling of interactions, based on key business attributes such as customer segment, service type, and service subtype.
AGT_AGENT_HOUR Rollup of agent handling of interactions, based on key business attributes such as customer segment, service type, and service subtype.
AGT_AGENT_QUEUE_HOUR Rollup of interaction-handling activities of agent resources who received interactions that were distributed from ACD queues, Virtual queues, Interaction queues, and Workbins.
AGT_AGENT_QUEUE_HOUR Rollup of interaction-handling activities of agent resources who received interactions that were distributed from ACD queues, Virtual queues, Interaction queues, and Workbins.
AGT_AGENT_QUEUE_HOUR Rollup of interaction-handling activities of agent resources who received interactions that were distributed from ACD queues, Virtual queues, Interaction queues, and Workbins.
AGT_AGENT_QUEUE_HOUR Rollup of interaction-handling activities of agent resources who received interactions that were distributed from ACD queues, Virtual queues, Interaction queues, and Workbins.
AGT_BGS_SESSION_HOUR This disposition-based aggregate table provides a rollup of interactions associated with Bot Gateway Server (BGS) interactions.
AGT_BGS_SESSION_HOUR This disposition-based aggregate table provides a rollup of interactions associated with Bot Gateway Server (BGS) interactions.
AGT_BGS_SESSION_HOUR This disposition-based aggregate table provides a rollup of interactions associated with Bot Gateway Server (BGS) interactions.
AGT_BGS_SESSION_HOUR This disposition-based aggregate table provides a rollup of interactions associated with Bot Gateway Server (BGS) interactions.
AGT_BGS_SESSION_HOUR This disposition-based aggregate table provides a rollup of interactions associated with Bot Gateway Server (BGS) interactions.
AGT_CALLBACK_HOUR Rollup of interactions associated with callbacks.
AGT_CALLBACK_HOUR Rollup of interactions associated with callbacks.
AGT_CALLBACK_HOUR Rollup of interactions associated with callbacks.
AGT_CALLBACK_HOUR Rollup of interactions associated with callbacks.
AGT_CAMPAIGN_HOUR Rollup of interactions generated by a particular campaign.
AGT_CAMPAIGN_HOUR Rollup of interactions generated by a particular campaign.
AGT_CAMPAIGN_HOUR Rollup of interactions generated by a particular campaign.
AGT_CAMPAIGN_HOUR Rollup of interactions generated by a particular campaign.
AGT_CHAT_AGENT_GRP_HOUR This aggregate table provides a rollup of interactions associated with agent participation in asyncronous (Async) Chat Server sessions (multimedia interactions), organized by agent group.
AGT_CHAT_AGENT_GRP_HOUR This aggregate table provides a rollup of interactions associated with agent participation in asyncronous (Async) Chat Server sessions (multimedia interactions), organized by agent group.
AGT_CHAT_AGENT_GRP_HOUR This aggregate table provides a rollup of interactions associated with agent participation in asyncronous (Async) Chat Server sessions (multimedia interactions), organized by agent group.
AGT_CHAT_AGENT_GRP_HOUR This aggregate table provides a rollup of interactions associated with agent participation in asyncronous (Async) Chat Server sessions (multimedia interactions), organized by agent group.
AGT_CHAT_AGENT_HOUR This aggregate table provides a rollup of interactions associated with agent participation in asyncronous (Async) Chat Server sessions (multimedia interactions).
AGT_CHAT_AGENT_HOUR This aggregate table provides a rollup of interactions associated with agent participation in asyncronous (Async) Chat Server sessions (multimedia interactions).
AGT_CHAT_AGENT_HOUR This aggregate table provides a rollup of interactions associated with agent participation in asyncronous (Async) Chat Server sessions (multimedia interactions).
AGT_CHAT_AGENT_HOUR This aggregate table provides a rollup of interactions associated with agent participation in asyncronous (Async) Chat Server sessions (multimedia interactions).
AGT_CHAT_STATS_HOUR This disposition-based aggregate table provides a rollup of interactions associated with chat interactions. The same columns and column descriptions apply to other AGT_CHAT_STATS_* tables.
AGT_CHAT_STATS_HOUR This disposition-based aggregate table provides a rollup of interactions associated with chat interactions. The same columns and column descriptions apply to other AGT_CHAT_STATS_* tables.
AGT_CHAT_STATS_HOUR This disposition-based aggregate table provides a rollup of interactions associated with chat interactions. The same columns and column descriptions apply to other AGT_CHAT_STATS_* tables.
AGT_CHAT_STATS_HOUR This disposition-based aggregate table provides a rollup of interactions associated with chat interactions. The same columns and column descriptions apply to other AGT_CHAT_STATS_* tables.
AGT_CHAT_THREAD_HOUR This disposition-based aggregate table provides a summary of thread-related interactions.
AGT_CHAT_THREAD_HOUR This disposition-based aggregate table provides a summary of thread-related interactions.
AGT_CHAT_THREAD_HOUR This disposition-based aggregate table provides a summary of thread-related interactions.
AGT_CHAT_THREAD_HOUR This disposition-based aggregate table provides a summary of thread-related interactions.
AGT_CHAT_THREAD_STATS_HOUR This disposition-based aggregate table provides a summary of thread-related interactions.
AGT_COBROWSE_AGENT_HOUR This aggregate table provides a rollup of agent participation in Voice and Chat interactions that include Co-browse sessions.
AGT_COBROWSE_AGENT_HOUR This aggregate table provides a rollup of agent participation in Voice and Chat interactions that include Co-browse sessions.
AGT_COBROWSE_AGENT_HOUR This aggregate table provides a rollup of agent participation in Voice and Chat interactions that include Co-browse sessions.
AGT_COBROWSE_AGENT_HOUR This aggregate table provides a rollup of agent participation in Voice and Chat interactions that include Co-browse sessions.
AGT_ID_FCR_HOUR Rollup of resource interaction-handling activities for interactions that are assigned a specific business attribute, such as customer segment, business result, service type, and service subtype.
AGT_ID_FCR_HOUR Rollup of resource interaction-handling activities for interactions that are assigned a specific business attribute, such as customer segment, business result, service type, and service subtype.
AGT_ID_FCR_HOUR Rollup of resource interaction-handling activities for interactions that are assigned a specific business attribute, such as customer segment, business result, service type, and service subtype.
AGT_ID_FCR_HOUR Rollup of resource interaction-handling activities for interactions that are assigned a specific business attribute, such as customer segment, business result, service type, and service subtype.
AGT_ID_HOUR Rollup of resource interaction-handling activities for interactions that are assigned a specific business attribute, such as customer segment, business result, service type, and service subtype.
AGT_ID_HOUR Rollup of resource interaction-handling activities for interactions that are assigned a specific business attribute, such as customer segment, business result, service type, and service subtype.
AGT_ID_HOUR Rollup of resource interaction-handling activities for interactions that are assigned a specific business attribute, such as customer segment, business result, service type, and service subtype.
AGT_ID_HOUR Rollup of resource interaction-handling activities for interactions that are assigned a specific business attribute, such as customer segment, business result, service type, and service subtype.
AGT_I_AGENT_HOUR Rollup of an agent’s handling of interactions.
AGT_I_AGENT_HOUR Rollup of an agent’s handling of interactions.
AGT_I_AGENT_HOUR Rollup of an agent’s handling of interactions.
AGT_I_AGENT_HOUR Rollup of an agent’s handling of interactions.
AGT_I_MN_SESS_STATE_HOUR Rollup of summarized agent session states.
AGT_I_MN_SESS_STATE_HOUR Rollup of summarized agent session states.
AGT_I_MN_SESS_STATE_HOUR Rollup of summarized agent session states.
AGT_I_MN_SESS_STATE_HOUR Rollup of summarized agent session states.
AGT_I_SESS_STATE_HOUR Rollup of summarized agent session states.
AGT_I_SESS_STATE_HOUR Rollup of summarized agent session states.
AGT_I_SESS_STATE_HOUR Rollup of summarized agent session states.
AGT_I_SESS_STATE_HOUR Rollup of summarized agent session states.
AGT_I_STATE_RSN_HOUR Rollup of hardware- and software-related reasons for summarized agent states on voice devices.
AGT_I_STATE_RSN_HOUR Rollup of hardware- and software-related reasons for summarized agent states on voice devices.
AGT_I_STATE_RSN_HOUR Rollup of hardware- and software-related reasons for summarized agent states on voice devices.
AGT_I_STATE_RSN_HOUR Rollup of hardware- and software-related reasons for summarized agent states on voice devices.
AGT_I_STATE_RSN_HOUR Rollup of hardware- and software-related reasons for summarized agent states on voice devices.
AGT_QUEUE_ABN_HOUR Rollup of interactions that were abandoned within an ACD queue, Virtual queue, Interaction queue, or Workbin.
AGT_QUEUE_ABN_HOUR Rollup of interactions that were abandoned within an ACD queue, Virtual queue, Interaction queue, or Workbin.
AGT_QUEUE_ABN_HOUR Rollup of interactions that were abandoned within an ACD queue, Virtual queue, Interaction queue, or Workbin.
AGT_QUEUE_ABN_HOUR Rollup of interactions that were abandoned within an ACD queue, Virtual queue, Interaction queue, or Workbin.
AGT_QUEUE_ACC_AGENT_HOUR Rollup of interactions that were accepted by agents after having been distributed from an ACD queue, Virtual queue, Interaction queue, or Workbin.
AGT_QUEUE_ACC_AGENT_HOUR Rollup of interactions that were accepted by agents after having been distributed from an ACD queue, Virtual queue, Interaction queue, or Workbin.
AGT_QUEUE_ACC_AGENT_HOUR Rollup of interactions that were accepted by agents after having been distributed from an ACD queue, Virtual queue, Interaction queue, or Workbin.
AGT_QUEUE_ACC_AGENT_HOUR Rollup of interactions that were accepted by agents after having been distributed from an ACD queue, Virtual queue, Interaction queue, or Workbin.
AGT_QUEUE_GRP_HOUR Rollup of contact center activities from the perspective of queue-type devices through which interactions pass.
AGT_QUEUE_GRP_HOUR Rollup of contact center activities from the perspective of queue-type devices through which interactions pass.
AGT_QUEUE_GRP_HOUR Rollup of contact center activities from the perspective of queue-type devices through which interactions pass.
AGT_QUEUE_GRP_HOUR Rollup of contact center activities from the perspective of queue-type devices through which interactions pass.
AGT_QUEUE_HOUR Rollup of contact center activities from the perspective of queue-type devices through which interactions pass.
AGT_QUEUE_HOUR Rollup of contact center activities from the perspective of queue-type devices through which interactions pass.
AGT_QUEUE_HOUR Rollup of contact center activities from the perspective of queue-type devices through which interactions pass.
AGT_QUEUE_HOUR Rollup of contact center activities from the perspective of queue-type devices through which interactions pass.
AGT_SDR_ACTIVITY_HOUR This table contains a record of the activities that the user encountered while the call was being processed by the Application. A new row is added for each activity. The same columns and column descriptions apply to other AGT_SDR_ACTIVITY_* tables.
AGT_SDR_ACTIVITY_HOUR This table contains a record of the activities that the user encountered while the call was being processed by the Application. A new row is added for each activity. The same columns and column descriptions apply to other AGT_SDR_ACTIVITY_* tables.
AGT_SDR_ACTIVITY_HOUR This table contains a record of the activities that the user encountered while the call was being processed by the Application. A new row is added for each activity. The same columns and column descriptions apply to other AGT_SDR_ACTIVITY_* tables.
AGT_SDR_ACTIVITY_HOUR This table contains a record of the activities that the user encountered while the call was being processed by the Application. A new row is added for each activity. The same columns and column descriptions apply to other AGT_SDR_ACTIVITY_* tables.
AGT_SDR_BOT_HOUR This disposition-based aggregate table provides a rollup of interactions involving bots, and associated with Designer applications.
AGT_SDR_BOT_HOUR This disposition-based aggregate table provides a rollup of interactions involving bots, and associated with Designer applications.
AGT_SDR_SESSION_HOUR This table describes caller activity within an SDR session. The same columns and column descriptions apply to other AGT_SDR_SESSION_* tables.
AGT_SDR_SESSION_HOUR This table describes caller activity within an SDR session. The same columns and column descriptions apply to other AGT_SDR_SESSION_* tables.
AGT_SDR_SESSION_HOUR This table describes caller activity within an SDR session. The same columns and column descriptions apply to other AGT_SDR_SESSION_* tables.
AGT_SDR_SESSION_HOUR This table describes caller activity within an SDR session. The same columns and column descriptions apply to other AGT_SDR_SESSION_* tables.
AGT_SDR_SESS_BLOCK_HOUR This table describes caller activity within an SDR session. The same columns and column descriptions apply to other AGT_SDR_SESS_BLOCK_* tables.
AGT_SDR_SESS_BLOCK_HOUR This table describes caller activity within an SDR session. The same columns and column descriptions apply to other AGT_SDR_SESS_BLOCK_* tables.
AGT_SDR_SESS_BLOCK_HOUR This table describes caller activity within an SDR session. The same columns and column descriptions apply to other AGT_SDR_SESS_BLOCK_* tables.
AGT_SDR_SESS_BLOCK_HOUR This table describes caller activity within an SDR session. The same columns and column descriptions apply to other AGT_SDR_SESS_BLOCK_* tables.
AGT_SDR_SESS_MILESTONE_HOUR This table describes caller activity within an SDR session. The same columns and column descriptions apply to other AGT_SDR_SESS_BLOCK_* tables.
AGT_SDR_SESS_MILESTONE_HOUR This table describes caller activity within an SDR session. The same columns and column descriptions apply to other AGT_SDR_SESS_BLOCK_* tables.
AGT_SDR_SESS_MILESTONE_HOUR This table describes caller activity within an SDR session. The same columns and column descriptions apply to other AGT_SDR_SESS_BLOCK_* tables.
AGT_SDR_SESS_MILESTONE_HOUR This table describes caller activity within an SDR session. The same columns and column descriptions apply to other AGT_SDR_SESS_BLOCK_* tables.
AGT_SDR_SURVEY_ANS_HOUR This table contains a record of survey answer data. The same columns and column descriptions apply to other AGT_SDR_SURVEY_ANS_* tables.
AGT_SDR_SURVEY_ANS_HOUR This table contains a record of survey answer data. The same columns and column descriptions apply to other AGT_SDR_SURVEY_ANS_* tables.
AGT_SDR_SURVEY_ANS_HOUR This table contains a record of survey answer data. The same columns and column descriptions apply to other AGT_SDR_SURVEY_ANS_* tables.
AGT_SDR_SURVEY_ANS_HOUR This table contains a record of survey answer data. The same columns and column descriptions apply to other AGT_SDR_SURVEY_ANS_* tables.
AGT_SDR_SURVEY_HOUR This table contains a record of survey data. The same columns and column descriptions apply to other AGT_SDR_SURVEY_* tables.
AGT_SDR_SURVEY_HOUR This table contains a record of survey data. The same columns and column descriptions apply to other AGT_SDR_SURVEY_* tables.
AGT_SDR_SURVEY_HOUR This table contains a record of survey data. The same columns and column descriptions apply to other AGT_SDR_SURVEY_* tables.
AGT_SDR_SURVEY_HOUR This table contains a record of survey data. The same columns and column descriptions apply to other AGT_SDR_SURVEY_* tables.
Comments or questions about this documentation? Contact us for support!