Jump to: navigation, search

VOICE_RES_FACT_EXT

Important.png Please be aware that the formulas and recommendations have not been validated internally prior to the initial release of this document. They are to be treated as results of theoretical analysis and a good starting point for re-orienting the 7.6 database queries towards the Info Mart 8.1 database.
DevGuide2.png Purpose: To provide compatibility references between the columns in the 7.6 VOICE_RES_FACT_EXT table and the fields in the Info Mart 8.x schema.

Table VOICE_RES_FACT_EXT

This voice extension table has been removed from the Info Mart database schema as obsolete. The majority of fields have been moved to the INTERATION_RESOURCE_FACT table; certain fields were retired, however, this data can be retrieved as described below.

7.6 Column Name 8.x Changes
Type of Change
Description/Recommendation
New Table.Column
VOICE_RES_FACT_EXT_KEY Retired
STD_ENTERPRISE_DATE_KEY Retired See Changes to Time-Related Tables and Fields.
STD_TENANT_DATE_KEY Retired See Changes to Time-Related Tables and Fields.
DIAL_COUNT Moved INTERACTION_RESOURCE_FACT.DIAL_COUNT
DIAL_DURATION Moved INTERACTION_RESOURCE_FACT.DIAL_DURATION
RING_COUNT Replaced 8.x values might differ from 7.6 because the population algorithm has changed for consultation calls. INTERACTION_RESOURCE_FACT.RING_COUNT
RING_DURATION Replaced 8.x values might differ from 7.6 because the population algorithm has changed for consultation calls. INTERACTION_RESOURCE_FACT.RING_DURATION
TALK_COUNT Replaced 8.x values might differ from 7.6 because the population algorithm has changed for consultation calls. INTERACTION_RESOURCE_FACT.TALK_COUNT
TALK_DURATION Replaced 8.x values might differ from 7.6 because the population algorithm has changed for consultation calls. INTERACTION_RESOURCE_FACT.TALK_DURATION
HOLD_COUNT Replaced 8.x values might differ from 7.6 because the population algorithm has changed for consultation calls. INTERACTION_RESOURCE_FACT.HOLD_COUNT
HOLD_DURATION Replaced 8.x values might differ from 7.6 because the population algorithm has changed for consultation calls. INTERACTION_RESOURCE_FACT.HOLD_DURATION
AFTER_CALL_WORK_COUNT Moved INTERACTION_RESOURCE_FACT.AFTER_CALL_WORK_COUNT
AFTER_CALL_WORK_DURATION Moved INTERACTION_RESOURCE_FACT.AFTER_CALL_WORK_DURATION
CUSTOMER_DIAL_COUNT Replaced 8.x values might differ from 7.6 because the population algorithm has changed to associate a customer with a particular party. INTERACTION_RESOURCE_FACT.CUSTOMER_DIAL_COUNT
CUSTOMER_DIAL_DURATION Replaced 8.x values might differ from 7.6 because the population algorithm has changed to associate a customer with a particular party. INTERACTION_RESOURCE_FACT.CUSTOMER_DIAL_DURATION
CUSTOMER_RING_COUNT Replaced 8.x values might differ from 7.6 because the population algorithm has changed to associate a customer with a particular party. INTERACTION_RESOURCE_FACT.CUSTOMER_RING_COUNT
CUSTOMER_RING_DURATION Replaced 8.x values might differ from 7.6 because the population algorithm has changed to associate a customer with a particular party. INTERACTION_RESOURCE_FACT.CUSTOMER_RING_DURATION
CUSTOMER_TALK_COUNT Replaced 8.x values might differ from 7.6 because the population algorithm has changed to associate a customer with a particular party. INTERACTION_RESOURCE_FACT.CUSTOMER_TALK_COUNT
CUSTOMER_TALK_DURATION Replaced 8.x values might differ from 7.6 because the population algorithm has changed to associate a customer with a particular party. INTERACTION_RESOURCE_FACT.CUSTOMER_TALK_DURATION
CUSTOMER_HOLD_COUNT Replaced 8.x values might differ from 7.6 because the population algorithm has changed to associate a customer with a particular party. INTERACTION_RESOURCE_FACT.CUSTOMER_HOLD_COUNT
CUSTOMER_HOLD_DURATION Replaced 8.x values might differ from 7.6 because the population algorithm has changed to associate a customer with a particular party. INTERACTION_RESOURCE_FACT.CUSTOMER_HOLD_DURATION
CUSTOMER_ACW_COUNT Replaced 8.x values might differ from 7.6 because the population algorithm has changed to associate a customer with a particular party. INTERACTION_RESOURCE_FACT.CUSTOMER_ACW_COUNT
CUSTOMER_ACW_DURATION Replaced 8.x values might differ from 7.6 because the population algorithm has changed to associate a customer with a particular party. INTERACTION_RESOURCE_FACT.CUSTOMER_ACW_DURATION
POST_CONS_XFER_TALK_COUNT Replaced 8.x values might differ from 7.6 because the population algorithm has changed for consultation calls. INTERACTION_RESOURCE_FACT.POST_CONS_XFER_TALK_COUNT
POST_CONS_XFER_TALK_DURATION Replaced 8.x values might differ from 7.6 because the population algorithm has changed for consultation calls. INTERACTION_RESOURCE_FACT.POST_CONS_XFER_TALK_DURATION
POST_CONS_XFER_HOLD_COUNT Replaced 8.x values might differ from 7.6 because the population algorithm has changed for consultation calls. INTERACTION_RESOURCE_FACT.POST_CONS_XFER_HOLD_COUNT
POST_CONS_XFER_HOLD_DURATION Replaced 8.x values might differ from 7.6 because the population algorithm has changed for consultation calls. INTERACTION_RESOURCE_FACT.POST_CONS_XFER_HOLD_DURATION
CONF_INIT_TALK_COUNT Moved INTERACTION_RESOURCE_FACT.CONF_INIT_TALK_COUNT
CONF_INIT_TALK_DURATION Moved INTERACTION_RESOURCE_FACT.CONF_INIT_TALK_DURATION
CONF_INIT_HOLD_COUNT Moved INTERACTION_RESOURCE_FACT.CONF_INIT_HOLD_COUNT
CONF_INIT_HOLD_DURATION Moved INTERACTION_RESOURCE_FACT.CONF_INIT_HOLD_DURATION
CONF_JOIN_RING_COUNT Moved INTERACTION_RESOURCE_FACT.CONF_JOIN_RING_COUNT
CONF_JOIN_RING_DURATION Moved INTERACTION_RESOURCE_FACT.CONF_JOIN_RING_DURATION
CONF_JOIN_TALK_COUNT Moved INTERACTION_RESOURCE_FACT.CONF_JOIN_TALK_COUNT
CONF_JOIN_TALK_DURATION Moved INTERACTION_RESOURCE_FACT.CONF_JOIN_TALK_DURATION
CONF_JOIN_HOLD_COUNT Moved INTERACTION_RESOURCE_FACT.CONF_JOIN_HOLD_COUNT
CONF_JOIN_HOLD_DURATION Moved INTERACTION_RESOURCE_FACT.CONF_JOIN_HOLD_DURATION
CONS_INIT_DIAL_COUNT Moved INTERACTION_RESOURCE_FACT.CONS_INIT_DIAL_COUNT
CONS_INIT_DIAL_DURATION Moved INTERACTION_RESOURCE_FACT.CONS_INIT_DIAL_DURATION
CONS_INIT_TALK_COUNT Moved INTERACTION_RESOURCE_FACT.CONS_INIT_TALK_COUNT
CONS_INIT_TALK_DURATION Moved INTERACTION_RESOURCE_FACT.CONS_INIT_TALK_DURATION
CONS_INIT_HOLD_COUNT Moved INTERACTION_RESOURCE_FACT.CONS_INIT_HOLD_COUNT
CONS_INIT_HOLD_DURATION Moved INTERACTION_RESOURCE_FACT.CONS_INIT_HOLD_DURATION
CONS_RCV_RING_COUNT Replaced 8.x values might differ from 7.6 because the population algorithm has changed for consultation calls. INTERACTION_RESOURCE_FACT.CONS_RCV_RING_COUNT
CONS_RCV_RING_DURATION Replaced 8.x values might differ from 7.6 because the population algorithm has changed for consultation calls. INTERACTION_RESOURCE_FACT.CONS_RCV_RING_DURATION
CONS_RCV_TALK_COUNT Replaced 8.x values might differ from 7.6 because the population algorithm has changed for consultation calls. INTERACTION_RESOURCE_FACT.CONS_RCV_TALK_COUNT
CONS_RCV_TALK_DURATION Replaced 8.x values might differ from 7.6 because the population algorithm has changed for consultation calls. INTERACTION_RESOURCE_FACT.CONS_RCV_TALK_DURATION
CONS_RCV_HOLD_COUNT Replaced 8.x values might differ from 7.6 because the population algorithm has changed for consultation calls. INTERACTION_RESOURCE_FACT.CONS_RCV_HOLD_COUNT
CONS_RCV_HOLD_DURATION Replaced 8.x values might differ from 7.6 because the population algorithm has changed for consultation calls. INTERACTION_RESOURCE_FACT.CONS_RCV_HOLD_DURATION
CONS_RCV_ACW_COUNT Moved INTERACTION_RESOURCE_FACT.CONS_RCV_ACW_COUNT
CONS_RCV_ACW_DURATION Moved INTERACTION_RESOURCE_FACT.CONS_RCV_ACW_DURATION
TEXT_TO_SPEECH_COUNT Retired Can be configured to store relevant user data in a custom user data table, so that this value could be obtained at IRF level.
SPEECH_RECOGNITION_COUNT Retired Can be configured to store relevant user data in a custom user data table, so that this value could be obtained at IRF level.
AGENT_TO_AGENT_CONS_COUNT Replaced 8.x values might differ from 7.6 because the population algorithm has changed to exclude hold and it only includes the time when both agent are connected to the call. INTERACTION_RESOURCE_FACT.AGENT_TO_AGENT_CONS_COUNT
AGENT_TO_AGENT_CONS_DURATION Replaced 8.x values might differ from 7.6 because the population algorithm has changed to exclude hold and it only includes the time when both agent are connected to the call. INTERACTION_RESOURCE_FACT.AGENT_TO_AGENT_CONS_DURATION
ACTIVE_FLAG Moved INTERACTION_RESOURCE_FACT.ACTIVE_FLAG
GMT_ROW_CREATED_TIME Retired See Changes to Time-Related Tables and Fields.
GMT_ROW_UPDATED_TIME Retired See Changes to Time-Related Tables and Fields.
PURGE_FLAG Changed See Database Schema Changes Overview.


This page was last edited on March 27, 2013, at 22:49.
blog comments powered by Disqus