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
Interaction Concentrator
Also known as ICON. A Genesys product that collects and stores detailed data from various sources in a contact center that is empowered by using Genesys software. Downstream reporting systems can access Interaction Concentrator data in near–real time.
Operating on top of Genesys Framework, the product consists of a server application that is called ICON and a database that is called Interaction Database (IDB). The server receives data from data sources such as Configuration Server, T-Server, or particular Genesys solutions; it then stores this data in IDB by using Genesys DB Server.
Glossary
Outbound Contact Server
Also known as OCS. The core component of the Outbound Contact Solution that provides automated dialing and call progress detection, so that an agent is required only when a customer is connected. OCS also intelligently uses customer data to ensure that campaigns are contacting the right customers, not just a large number of customers.
Glossary
Outbound Contact Solution
Also known as OCS or Outbound Contact. The Genesys solution package that provides Outbound Dialing Plan capabilities, including Campaign Development, Campaign Management, Dialing Plans, and Reporting Templates. OCS supports Preview Dialing, Progressive Dialing, and Predictive Dialing modes. Outbound Contact consists of the following components: Outbound Contact Server (OCS), Outbound Contact Manager (OCM), Call Progress Detection Server (CPD Server), and Call Progress Detection Proxy Server (CPD Proxy Server).
Glossary
Contents
Outbound Contact Data
This page describes how Genesys Info Mart processes Outbound Contact data. It also describes certain Genesys Info Mart requirements for Outbound Contact–related configuration.
Genesys Info Mart and OCS Record Field Data
When support for Outbound Contact details is configured in your deployment, Genesys Info Mart writes data about every outbound contact attempt. Outbound Contact Server (OCS) may attach a number of custom attributes (record fields) to each contact attempt. ICON then stores Record Field data in the GO_FIELDHIST and GO_SEC_FIELDHIST tables in IDB — these IDB tables become the source of the Record Field data for Genesys Info Mart.
For a complete list of the Outbound Contact extension tables in IDB that Genesys Info Mart uses, see IDB Tables Accessed by Genesys Info Mart.
Genesys Info Mart stores Record Field data that is defined in OCS calling lists in several places in the Info Mart database:
- Predefined dimensions, such as Record Type, Record Status, and Contact Info Type. These are mandatory record fields.
- Predefined facts, such as Record ID, Chain ID, Chain N, Dialing From, Dialing Until, and Contact Info. These are mandatory record fields.
- User-defined dimensions, such as the columns in the RECORD_FIELD_GROUP_1 and RECORD_FIELD_GROUP_2 tables. These are nonmandatory record fields.
- User-defined facts, such as RECORD_FIELD_1 through RECORD_FIELD_60 in the CONTACT_ATTEMPT_FACT table. These are nonmandatory record fields.
Predefined and Custom Fields
Some Field objects are populated in the Configuration Database at the time the Configuration Database is created, to represent record fields that are typical in most campaign environments; these fields are referred to as predefined record fields. To reflect the record fields that are typical in campaigns in your specific contact center, you may have to create other Field objects in the Configuration Database; these fields are referred to as user-defined or custom fields.
This division between predefined and custom fields applies to both mandatory and nonmandatory record fields. In other words, some fields that are mandatory from the perspective of Genesys Info Mart are not predefined in the Configuration Database.
Mandatory Record Field Data
The following table shows how Genesys Info Mart uses the data from each mandatory Field object. Some fields map directly to Info Mart table columns, whereas others are used indirectly in calculations.
All the Field objects that are listed in the table require the icon_attribute option in their configuration. You must configure each predefined field and each user-defined field that is expected in the Info Mart database. Proper configuration of the Field objects ensures that ICON stores the field value in a specified table in IDB. For more information about how to configure Field objects so that ICON will store the required Record Field data, see Configuring Field Objects.
Genesys Info Mart requires the ICON application to store mandatory field data in its database, regardless of whether the field maps directly to an Info Mart table column. Genesys Info Mart Server retrieves the field value from IDB and stores the value in a specified field of a specified Info Mart table or uses the value in calculations of other fields. Note that some predefined fields that are used in calculations also require a value that indicates a positive result.
| OCS Mandatory Field Name | Column Name in Info Mart CONTACT_ATTEMPT_FACT Table |
|---|---|
| agent_id | No direct mapping |
| app_id | No direct mapping |
| attempt | ATTEMPT_ORDINAL |
| call_result | No direct mapping |
| call_time | No direct mapping |
| campaign_id | No direct mapping |
| chain_id | CHAIN_ID |
| chain_n | CHAIN_N |
| contact_info | CONTACT_INFO |
| contact_info_type | CONTACT_INFO_TYPE_KEY |
| daily_from | DAILY_FROM_SECONDS DAILY_FROM_TIME CONTACT_DAILY_FROM_TIME |
| daily_till | DAILY_UNTIL_SECONDS DAILY_UNTIL_TIME CONTACT_DAILY_UNTIL_TIME |
| dial_sched_time | DIAL_SCHED_TIME CONTACT_DIAL_SCHED_TIME |
| group_id | No direct mapping |
| record_id | RECORD_ID |
| record_status | RECORD_STATUS_KEY |
| record_type | RECORD_TYPE_KEY |
| switch_id | No direct mapping |
| treatments | No direct mapping |
| tz_dbid | TIME_ZONE_KEY CONTACT_DAILY_FROM_TIME CONTACT_DAILY_UNTIL_TIME CONTACT_DIAL_SCHED_TIME |
For more information about how Genesys Info Mart stores Outbound Contact data, see the Physical Data Model for your RDBMS, as well as Populating Outbound Contact Campaign Activity in the User's Guide.
- IXN_START_TIME
- IXN_START_TIME_KEY
- CONTACT_IXN_START_TIME
- CONTACT_WITHIN_DAILY_RANGE
Nonmandatory (Custom) Record Field Data
Genesys Info Mart can optionally store a limited number of nonmandatory record fields in the following tables:
- CONTACT_ATTEMPT_FACT
- RECORD_FIELD_GROUP_1
- RECORD_FIELD_GROUP_2
The CONTACT_ATTEMPT_FACT table can store up to 60 nonmandatory fields in the following formats:
- 20 integers: NUMBER(10)
- 10 floating-point numbers: NUMBER(14,4)
- 30 strings: VARCHAR(255)
RECORD_FIELD_GROUP_1 and RECORD_FIELD_GROUP_2 each store up to 10 nonmandatory fields (strings).
If you want to report on nonmandatory record fields, you must configure each nonmandatory field properly so that OCS attaches the value of the field, and you must configure ICON to store this field in a designated table. (For more information, see Configuring Field Objects.) In addition to configuring each field similarly to mandatory field configuration, configure options in each Field object to indicate the Genesys Info Mart table and column into which the data should be loaded.
You can use any field that you choose. The data type of the Field object must match the data type of the target Info Mart database table and column. Interaction Concentrator stores all custom field data as strings. The Genesys Info Mart ETL performs all necessary data conversions between strings and other target data types. Each Field object maps to one and only one table and column in the Info Mart database. Nulls are loaded for any unmapped columns in the Info Mart CONTACT_ATTEMPT_FACT table. The Unspecified value is loaded for any unmapped columns in the Info Mart RECORD_FIELD_GROUP_1 and RECORD_FIELD_GROUP_2 tables.
RECORD_FIELD_GROUP_1 and RECORD_FIELD_GROUP_2 column values should be of low cardinality. Storing record fields with high-cardinality values will cause a decrease in the performance for both the ETL and your report queries.
For information about nonmandatory fields that have special meaning for Genesys Info Mart, see Right Person Contacted Record Field and Conversion Record Field. You can also use the Mapping OCS Record Fields Worksheet to plan your mapping of OCS Record Fields to the Info Mart table columns.
Right Person Contacted Record Field
Although Right Person Contacted is not a mandatory field, it has significance to Genesys Info Mart. It can be any Field object that you designate by adding the right_person option to the [default] section of the Annex tab on the Field object. The option value specifies the value of the field when the right person is contacted — for example, TRUE, YES, or 1. If the value of this field matches the configured option value (which is case-insensitive), Genesys Info Mart sets the RPC_FLAG in the CONTACT_ATTEMPT_FACT table to 1. For more information, see Configuring Field Objects.
If you want to report on right person contacted, you must configure ICON to store nonmandatory field data in its database. For information about how to configure ICON to store field data, see Configuring Field Objects.
Conversion Record Field
Although Conversion is not a mandatory field, it has significance to Genesys Info Mart. It can be any Field object that you designate by adding the conversion option to the [default] section of the Annex tab on the Field object. The option value specifies the value of the field when the purpose of the Outbound Contact attempt has been achieved — for example, TRUE, YES, or 1. If the value of this field matches the configured option value (which is case-insensitive), Genesys Info Mart sets the CONVERSION_FLAG in the CONTACT_ATTEMPT_FACT table to 1.
If you want to report on conversion, you must configure ICON to store nonmandatory field data in its database. For information about how to store field data, see Configuring Field Objects.