INTERACTION_ RESOURCE_FACT

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.

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.