Jump to: navigation, search

partitioning-interval-size-gidb-ocs

Section: gim-etl
Default Value: 86400 or partitioning-interval-size-gidb
Valid Values: Any positive integer
Changes Take Effect: At the next run of Job_MaintainGIM
Dependencies: None
Introduced: 8.1.402.07

Specifies the size of partitions, in seconds, for partitioned GIDB tables that store Outbound Contact–related data. When this option is set, Job_MaintainGIM creates partitions of the specified size in the Info Mart database in preparation for future ETL cycles. If the option is not specified, the value of partitioning-interval-size-gidb, which has a default value of 24 hours (86400 seconds), is used.

In PostgreSQL deployments, Genesys recommends setting the size of GIDB table partitions to one week (604800 seconds).

more...

partitioning-interval-size-gidb-mm

Section: gim-etl
Default Value: 86400 or partitioning-interval-size-gidb
Valid Values: Any positive integer
Changes Take Effect: At the next run of Job_MaintainGIM
Dependencies: None
Introduced: 8.1.402.07

Specifies the size of partitions, in seconds, for partitioned GIDB tables that store multimedia interaction data. When this option is set, Job_MaintainGIM creates partitions of the specified size in the Info Mart database in preparation for future ETL cycles. If the option is not specified, the value of partitioning-interval-size-gidb, which has a default value of 24 hours (86400 seconds), is used. Genesys recommends increasing the size of GIDB partitions for multimedia interactions, which typically live longer than voice interactions but generate a smaller volume of data.

In PostgreSQL deployments, Genesys recommends setting the size of GIDB table partitions to one week (604800 seconds).

more...

Active Switching Matrix

Also known as ASM. An active component of switching hubs that rapidly switch packets from port to port by allocating memory.



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

populate-mm-ixnqueue-facts

Section: gim-etl-populate
Default Value: false
Valid Values: true, false
Changes Take Effect: On the next ETL cycle
Dependencies: None

Enables or disables the population of eServices/Multimedia Interaction Queue activity to the MSF table. Genesys Info Mart uses this value for all configured eServices/Multimedia Interaction Queues, unless you configure an option that has the same name on an individual Script object for a specific Interaction Queue in the interface you use for configuration.

  • false—The placement of an interaction in an Interaction Queue will not be represented in the MSF table.
  • true—The placement of an interaction in an Interaction Queue will be represented in the MSF table.

Starting with release 8.5.003, Genesys Info Mart always creates an MSF record for the first Interaction Queue that an inbound interaction enters, regardless of the setting of this option.

more...

populate-thread-facts

Section: gim-etl-populate
Default Value: false
Valid Values: true, false
Changes Take Effect: At the next run of Job_TransformGIM
Dependencies: None
Introduced: 8.5.001

Enables or disables the population of thread-related metrics in the ANCHOR_FLAGS dimension in multimedia deployments.

more...

What's New in the Documentation

The following information is new or has changed significantly since earlier versions of this document. The most recent changes appear first.

  • A new page, Summary of Info Mart Schema Changes, summarizes the changes that have occurred in the Info Mart schema since release 8.1. The changes can be sorted or filtered by release, table, column, or type of change (table added, column modified, and so on).
  • The following tables have been added, to support the reporting on chat session and chat bot activity that was introduced in release 8.5.011:
  • The START_DATE_TIME_KEY in the GPM_FACT table was made part of the composite primary key, even in nonpartitioned databases.
  • To cover support for employee General Data Protection Regulation (GDPR) requests introduced in release 8.5.010.16, the descriptions of the CTL_GDPR_HISTORY table and columns have been extended.
  • The UPDATE_AUDIT_KEY column was added to the following tables in release 8.5.010.16:
  • To support GDPR compliance, a description of the CTL_GDPR_HISTORY table has been added.
  • For support of alternative data streams:
  • To extend support for Callback reporting:
    • Two new dimension tables, CALLBACK_DIAL_RESULTS and CALLBACK_DIM_4 have been added. Lists of tables, indexes, and references—including the list of tables included in Data Export—have been updated to include the new tables.
    • The following new columns have been added to the CALLBACK_FACT table:
      CALLBACK_DIAL_RESULTS_KEY
      CALLBACK_DIM_4_KEY
      CUSTOMER_ANI
      DIAL_1_TS through DIAL_5_TS
      EWT_THRESHOLD_WHEN_OFFERED
      EWT_WHEN_LAST_DIAL
      EWT_WHEN_REJECTED
      FIRST_OUT_IXN_ID
      LAST_OUT_IXN_ID
      ORIGINATION_IXN_ID
      ORS_SESSION_ID
      POS_WHEN_LAST_DIAL
      PRIORITY_WHEN_A_CONNECTED
      PRIORITY_WHEN_C_CONNECTED
      PRIORITY_WHEN_CB_ACCEPTED
      SERVICE_END_TS
      WAITED_BEFORE_OFFER_TIME


  • The default value has been removed from GPM_FACT.MESSAGE.
  • To support reporting on Genesys Predictive Routing, descriptions of four new GPM_* tables have been added:

    Lists of tables, indexes, and references—including the list of tables included in Data Export—have been updated to include the new tables.

  • To support reporting on interaction flows that involve applications developed with Genesys Designer, for which support is available in certain Cloud deployments:
  • For Genesys Callback support, descriptions of the following columns have been updated to indicate new, additional values:
  • Description of a new column, USERDATA_FLAG, has been added to the MSF table. The column indicates that user data is attached to the MSF record. This flag facilitates an unambiguous join between the MSF and fact extension tables to retrieve correct user data that is attached during mediation.
  • A new fact table, SM_MEDIA_NEUTRAL_STATE_FACT, has been added to support reporting on media-neutral agent states. (The table has not yet been added to the Facts subject area diagram.)
  • The new user-data propagation rule, IRF_INITIAL, has been added to the list of valid values for the PROPAGATION_RULE column in the CTL_UD_TO_UDE_MAPPING control table.
  • ANCHOR_FLAGS table:
  • A note has been added to the MEDIATION_SEGMENT_FACT (MSF) table description that, starting with release 8.5.003, Genesys Info Mart populates an MSF record for the starting Interaction Queue of an Inbound Interaction, even if populate-mm-ixnqueue-facts is configured to false.
  • INTERACTION_RESOURCE_FACT (IRF) table:
    • Descriptions of two new columns, FOCUS_TIME_COUNT and FOCUS_TIME_DURATION, have been added. These columns enable reporting on the time that a particular interaction has been in focus (that is, actively being processed) on the agent desktop. If data regarding agent's focus time is provided by the agent desktop for this particular interaction, the count is increased in the FOCUS_TIME_COUNT column; otherwise, the value is 0. FOCUS_TIME_DURATION indicates the total time that the agent spent actively processing the interaction, as reported by the agent desktop.
    • Descriptions of two new columns, ASM_COUNT and ASM_ENGAGE_DURATION, have been added. These columns enable reporting on the time that the engaged agent is waiting to be connected to the customer (ASM engage duration) separately from regular talk time. The columns are populated only in Outbound VoIP environments, with Outbound Contact campaigns running in an ASM dialing mode, if the new configuration option, No results, is set to true
    • The ANCHOR_FLAGS_KEY column description has been updated to account for the role this column now plays in indicating which party ended a chat session.
    • Clarification has been added that in release 8.5.004, the name of the IRF_ANCHOR_SENT_TS column (which had been changed from IRF_ANCHOR_DATE_TIME_KEY in release 8.5.003) was further changed to IRF_ANCHOR_TS. The purpose of the column has been expanded. For chat interactions, the column now stores the time when the customer left the chat, or the time when the agent stopped the chat session, if data about the party that ended a chat session is available from Interaction Concentrator.
    • Clarification has been added that in release 8.5.003, the name of the IRF_ANCHOR_DATE_TIME_KEY column was changed to IRF_ANCHOR_SENT_TS. For offline multimedia interactions, this field was populated with the time when the first response left the contact center. This field was populated only if IRF.IRF_ANCHOR had a value of 2. This field was set to NULL for all other IRFs that were associated with the same interaction.
    • The description of a previously reserved column, LAST_INTERACTION_RESOURCE, has been updated. The column is supported for voice interactions in release 8.5.003 and is supported for all media types starting with release 8.5.004. This field is set to 1 for a single IRF out of all IRF records that are associated with a given interaction, to indicate the last resource to enter the interaction. This field is set to 0 for all other IRFs that are associated with the same interaction.
    • CONS_INIT_TALK_COUNT, CONS_RCV_RING_COUNT, CONS_RCV_RING_DURATION, CONS_RCV_TALK_COUNT, and CONS_RCV_TALK_DURATION now also apply to chat consultations.
    • The CUSTOMER_*_COUNT and CUSTOMER_*_DURATION metrics that specifically exclude voice and email consultations (for example, CUSTOMER_RING_COUNT) also exclude chat consultations.
    • A note has been added to CONS_INIT_TALK_DURATION to confirm that, even if CONS_INIT_TALK_COUNT is nonzero, CONS_INIT_TALK_DURATION does not apply to chat consultations to avoid double-counting, because the agent who initiated the consultation continued to be active in the chat with the customer for the whole time.
  • A newly introduced value, Person, has been added to the list of values for the RESOURCE_.RESOURCE_SUBTYPE column.
  • In the INTERACTION_TYPE table, InternalConferenceInvite (and INTERNALCONFERENCEINVITE) have been added to the INTERACTION_SUBTYPE (and INTERACTION_SUBTYPE_CODE) columns.
  • CREATE_AUDIT_KEY and UPDATE_AUDIT_KEY columns have been added in the IRF_USER_DATA_CUST_1, IRF_USER_DATA_GEN_1, and IRF_USER_DATA_KEYS tables.
  • In the TECHNICAL_DESCRIPTOR table, IntroducedTransfer (and INTRODUCEDTRANSFER) have been added to the list of possible values in the RESULT_REASON (and RESULT_REASON_CODE) and ROLE_REASON (and ROLE_REASON_CODE) columns.
  • In the information about Info Mart Partitioning, the GIDB Fact Tables section notes that two options introduced in release 8.1.402.07, partitioning-interval-size-gidb-mm and partitioning-interval-size-gidb-ocs, enable you to tailor partition sizes to suit the characteristics of your deployment, to improve performance.

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on August 18, 2016, at 14:05.