Jump to: navigation, search

INTERACTION_ RESOURCE_FACT

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 INTERACTION_RESOURCE_FACT table and the fields in the Info Mart 8.x schema.

Table INTERACTION_RESOURCE_FACT

In addition to changes to the audit-, time-, and purging-related fields, certain fields in this table were retired to eliminate duplicates.

7.6 Column Name 8.x Changes
Type of Change
Description/Recommendation
New Table.Column
INTERACTION_RESOURCE_ID No Change
GMT_ENTERPRISE_DATE_KEY Retired See Changes to Time-Related Tables and Fields.
GMT_TENANT_DATE_KEY Retired See Changes to Time-Related Tables and Fields.
GMT_TIME_OF_DAY_KEY Retired See Changes to Time-Related Tables and Fields.
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.
STD_ENTERPRISE_TIME_OF_DAY_KEY Retired See Changes to Time-Related Tables and Fields.
STD_TENANT_START_DATE_TIME_KEY Retired See Changes to Time-Related Tables and Fields.
STD_TENANT_END_DATE_TIME_KEY Retired See Changes to Time-Related Tables and Fields.
STD_TENANT_TIME_OF_DAY_KEY Retired See Changes to Time-Related Tables and Fields.
TENANT_KEY No Change
INTERACTION_TYPE_KEY No Change
MEDIA_TYPE_KEY No Change
TECHNICAL_DESCRIPTOR_KEY No Change
MEDIA_RESOURCE_KEY No Change
RESOURCE_KEY No Change
RESOURCE_GROUP_COMBINATION_KEY No Change
PLACE_KEY No Change
STRATEGY_KEY No Change
ROUTING_TARGET_KEY No Change
REQUESTED_SKILL_KEY No Change
INTERACTION_DESCRIPTOR_KEY Moved The INTERACTION_RESOURCE_FACT and INTERACTION_DESCRIPTOR tables are joined by using the foreign keys in the IRF_USER_DATA_KEYS table. IRF_USER_DATA_KEYS.INTERACTION_DESCRIPTOR_KEY
CUSTOMER_KEY Retired The CUSTOMER table has been retired. CUSTOMER_ID is stored in IRF_USER_DATA_GEN_1, which is joined to INTERACTION_RESOURCE_FACT by using IRF_USER_DATA_GEN_1.INTERACTION_RESOURCE_ID. IRF_USER_DATA_GEN_1.CUSTOMER_ID
USER_DATA_KEY Replaced The USER_DATA table has been retired. Custom user data is stored in custom user data tables, which are joined to INTERACTION_RESOURCE_FACT by using the foreign keys in the IRF_USER_DATA_KEYS table. See Changes to User Data Tables and Fields.
USER_DATA_2_KEY Replaced The USER_DATA_2 table has been retired. Custom user data is stored in custom user data tables, which are joined to INTERACTION_RESOURCE_FACT by using the foreign keys in the IRF_USER_DATA_KEYS table. See Changes to User Data Tables and Fields.
CREATE_AUDIT_KEY Changed See Database Schema Changes Overview.
UPDATE_AUDIT_KEY Changed See Database Schema Changes Overview.
INTERACTION_ID No Change
ROOT_INTERACTION_ID Retired
IXN_RES_FACT_EXT_KEY Retired
RES_PREVIOUS_DT_STATE_KEY Retired
RES_PREVIOUS_SM_STATE_KEY No Change
RES_PREVIOUS_SM_STATE_FACT_KEY No Change
PRIMARY_IXN_SEGMENT_ID Retired
LAST_RP_RESOURCE_KEY No Change
LAST_QUEUE_RESOURCE_KEY No Change
LAST_IVR_RESOURCE_KEY No Change
MEDIATION_SEGMENT_ID No Change
MEDIATION_RESOURCE_KEY No Change
MEDIATION_START_DATE_TIME_KEY No Change
GMT_START_TIME Retired See Changes to Time-Related Tables and Fields.
GMT_END_TIME Retired See Changes to Time-Related Tables and Fields.
STD_ENTERPRISE_START_TIME Retired See Changes to Time-Related Tables and Fields.
STD_ENTERPRISE_END_TIME Retired See Changes to Time-Related Tables and Fields.
STD_TENANT_START_TIME Retired See Changes to Time-Related Tables and Fields.
STD_TENANT_END_TIME Retired See Changes to Time-Related Tables and Fields.
INTERACTION_RESOURCE_ORDINAL Changed Reserved.
FIRST_SVC_OR_ABN_FLAG Replaced INTERACTION_RESOURCE_FACT.IRF_ANCHOR
LAST_INTERACTION_RESOURCE Changed Reserved.
INTERACTION_SEGMENT_COUNT Retired
TOTAL_DURATION Replaced Can be calculated as END_TS-START_TS (if END_TS>0).
LEAD_CLIP_DURATION No Change
TRAIL_CLIP_DURATION No Change
ROUTING_POINT_COUNT Retired
ROUTING_POINT_DURATION No Change
QUEUE_COUNT Retired
QUEUE_DURATION No Change
IVR_PORT_COUNT Retired
IVR_PORT_DURATION No Change
HANDLE_COUNT No Change
CUSTOMER_HANDLE_COUNT No Change
PREVIOUS_MEDIATION_DURATION No Change
MEDIATION_DURATION No Change
MEDIATION_COUNT No Change
REQUESTED_SKILL_COUNT Replaced REQUESTED_SKILL_COMBINATION.SKILL COUNT
MATCHED_SKILL_COUNT Retired
BASELINE_SERVICE_OBJECTIVE Replaced BASELINE_SERVICE_OBJECTIVE is stored as SERVICE_OBJECTIVE in the IRF_USER_DATA_GEN_1 table, which is joined to INTERACTION_RESOURCE_FACT by using IRF_USER_DATA_GEN_1.INTERACTION_RESOURCE_ID. IRF_USER_DATA_GEN_1.SERVICE_OBJECTIVE
MET_SERVICE_OBJECTIVE_FLAG No Change
SHORT_ABANDONED_FLAG No Change
CONFERENCE_INITIATED_COUNT Changed The field doesn't exist in release 8.0, but it is restored in 8.1.
CONFERENCE_JOINED_COUNT Replaced Replaced with IRF.CONF_JOIN_RING_COUNT. Use the value of 1 if CONF_JOIN_TALK_COUNT + CONF_JOIN_RING_COUNT > 1.
CONSULT_INITIATED_COUNT Replaced Replaced with IRF.CONS_INIT_DIAL_COUNT. To receive this value, count the IRF rows with Technical Role set to InitiatedConsult.
CONSULT_RECEIVED_COUNT Replaced Replaced with IRF.CONS_RCV_TALK_COUNT. The 7.6 logic considered any answered consultation call as received. Thus, use the value of 1 if CONS_RCV_TALK_COUNT > 0 and 0 otherwise.
CASE_ID Replaced CASE_ID is stored in IRF_USER_DATA_GEN_1, which is joined to INTERACTION_RESOURCE_FACT by using IRF_USER_DATA_GEN_1.INTERACTION_RESOURCE_ID. IRF_USER_DATA_GEN_1.CASE_ID
USER_DATA_1 Replaced User data is stored in IRF_USER_DATA_GEN_1 and custom user data tables. See Changes to User Data Tables and Fields.
USER_DATA_2 Replaced User data is stored in IRF_USER_DATA_GEN_1 and custom user data tables. See Changes to User Data Tables and Fields.
USER_DATA_3 Replaced User data is stored in IRF_USER_DATA_GEN_1 and custom user data tables. See Changes to User Data Tables and Fields.
USER_DATA_4 Replaced User data is stored in IRF_USER_DATA_GEN_1 and custom user data tables. See Changes to User Data Tables and Fields.
USER_DATA_5 Replaced User data is stored in IRF_USER_DATA_GEN_1 and custom user data tables. See Changes to User Data Tables and Fields.
USER_DATA_6 Replaced User data is stored in IRF_USER_DATA_GEN_1 and custom user data tables. See Changes to User Data Tables and Fields.
USER_DATA_7 Replaced User data is stored in IRF_USER_DATA_GEN_1 and custom user data tables. See Changes to User Data Tables and Fields.
USER_DATA_8 Replaced User data is stored in IRF_USER_DATA_GEN_1 and custom user data tables. See Changes to User Data Tables and Fields.
USER_DATA_9 Replaced User data is stored in IRF_USER_DATA_GEN_1 and custom user data tables. See Changes to User Data Tables and Fields.
USER_DATA_10 Replaced User data is stored in IRF_USER_DATA_GEN_1 and custom user data tables. See Changes to User Data Tables and Fields.
USER_DATA_11 Replaced User data is stored in IRF_USER_DATA_GEN_1 and custom user data tables. See Changes to User Data Tables and Fields.
USER_DATA_12 Replaced User data is stored in IRF_USER_DATA_GEN_1 and custom user data tables. See Changes to User Data Tables and Fields.
USER_DATA_13 Replaced User data is stored in IRF_USER_DATA_GEN_1 and custom user data tables. See Changes to User Data Tables and Fields.
USER_DATA_14 Replaced User data is stored in IRF_USER_DATA_GEN_1 and custom user data tables. See Changes to User Data Tables and Fields.
USER_DATA_15 Replaced User data is stored in IRF_USER_DATA_GEN_1 and custom user data tables. See Changes to User Data Tables and Fields.
USER_DATA_16 Replaced User data is stored in IRF_USER_DATA_GEN_1 and custom user data tables. See Changes to User Data Tables and Fields.
USER_DATA_17 Replaced User data is stored in IRF_USER_DATA_GEN_1 and custom user data tables. See Changes to User Data Tables and Fields.
USER_DATA_18 Replaced User data is stored in IRF_USER_DATA_GEN_1 and custom user data tables. See Changes to User Data Tables and Fields.
USER_DATA_19 Replaced User data is stored in IRF_USER_DATA_GEN_1 and custom user data tables. See Changes to User Data Tables and Fields.
USER_DATA_20 Replaced User data is stored in IRF_USER_DATA_GEN_1 and custom user data tables. See Changes to User Data Tables and Fields.
ACTIVE_FLAG None
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 April 5, 2013, at 15:24.
Comments or questions about this documentation? Contact us for support!