Jump to: navigation, search

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

Table CONTACT_ATTEMPT_FACT

The 8.x schema separates interaction attributes from contact attempt attributes, moving interaction-specific data to the INTERACTION_RESOURCE_FACT table. Data from CONTACT_ATTEMPT_FACT can be combined with data from INTERACTION_RESOURCE_FACT by using common identifiers in INTERACTION_FACT. To obtain interaction data for a call that was dialed, left join CONTACT_ATTEMPT_FACT to INTERACTION_FACT on CONTACT_ATTEMPT_FACT.CALLID=INTERACTION_FACT.MEDIA_SERVER_IXN_GUID, and inner join INTERACTION_FACT to INTERACTON_RESOURCE_FACT on INTERACTION_FACT.INTERACTION_ID=INTERACTION_RESOURCE_FACT. Note that one CONTACT_ATTEMPT_FACT may have multiple IRF records.

7.6 Column Name 8.x Changes
Type of Change
Description/Recommendation
New Table.Column
CONTACT_ATTEMPT_FACT_KEY No Change
TENANT_KEY No Change
CREATE_AUDIT_KEY Changed See Database Schema Changes Overview.
UPDATE_AUDIT_KEY Changed See Database Schema Changes Overview.
MEDIA_TYPE_KEY 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_TIME_OF_DAY_KEY Retired See Changes to Time-Related Tables and Fields.
LOCAL_ENTERPRISE_DATE_KEY Retired See Changes to Time-Related Tables and Fields.
LOCAL_TENANT_DATE_KEY Retired See Changes to Time-Related Tables and Fields.
LOCAL_TIME_OF_DAY_KEY Retired See Changes to Time-Related Tables and Fields.
DIALING_MODE_KEY No Change
RESOURCE_KEY No Change
MEDIA_RESOURCE_KEY Replaced Can be calculated as IRF.MEDIA_RESOURCE_KEY WHERE IRF.INTERACTION_RESOURCE_ORDINAL=1.
PLACE_KEY No Change
CAMPAIGN_KEY No Change
GROUP_KEY No Change
CPD_RESULT_KEY No Change
CALL_RESULT_KEY No Change
RECORD_TYPE_KEY No Change
RECORD_STATUS_KEY No Change
CALLING_LIST_KEY No Change
CONTACT_INFO_TYPE_KEY No Change
TIME_ZONE_KEY No Change
CAMP_GROUP_SESSION_FACT_KEY No Change
INTERACTION_ID Moved Moved to INTERACTION_FACT. INTERACTION_FACT.INTERACTION_ID
RECORD_FIELD_GROUP_1_KEY No Change
RECORD_FIELD_GROUP_2_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.
LOCAL_START_TIME Retired See Changes to Time-Related Tables and Fields.
LOCAL_END_TIME Retired See Changes to Time-Related Tables and Fields.
PREVIEW_COUNT Replaced Can be calculated based on DIALING_MODE_KEY. Equals 1 if DIALING_MODE_CODE is ('PREVIEW','PUSH_PREVIEW'); otherwise, it is 0.
PREVIEW_DURATION Replaced If PREVIEW_COUNT equals 1, can be calculated as coalesce(IF.START_TS,CAF.END_TS)-CAF.START_TS.
DIAL_COUNT Replaced Is not available in 8.0. Replacement field is available in release 8.1. CONTACT_ATTEMPT_FACT.CPD_DIAL_COUNT
DIAL_DURATION Replaced Is not available in 8.0. Replacement field is available in release 8.1. CONTACT_ATTEMPT_FACT.CPD_DIAL_DURATION_MS
CPD_COUNT No Change Is not available in 8.0; restored in 8.1.
CPD_DURATION Replaced Is not available in 8.0. Replacement field is available in release 8.1. CONTACT_ATTEMPT_FACT.CPD_DURATION_MS
TRANSFER_COUNT Replaced Is not available in 8.0. Replacement field is available in release 8.1. CONTACT_ATTEMPT_FACT.CPD_TRANSFER_COUNT
TRANSFER_DURATION Replaced Is not available in 8.0. Replacement field is available in release 8.1. CONTACT_ATTEMPT_FACT.CPD_TRANSFER_DURATION_MS
TALK_COUNT Replaced Can be calculated as IRF.TALK_COUNT WHERE IRF.INTERACTION_RESOURCE_ORDINAL=1.
TALK_DURATION Replaced Can be calculated as IRF.TALK_DURATION WHERE IRF.INTERACTION_RESOURCE_ORDINAL=1.
HOLD_COUNT Replaced Can be calculated as IRF.HOLD_COUNT WHERE IRF.INTERACTION_RESOURCE_ORDINAL=1.
HOLD_DURATION Replaced Can be calculated as IRF.HOLD_DURATION WHERE IRF.INTERACTION_RESOURCE_ORDINAL=1.
ACW_COUNT Replaced Can be calculated as IRF.AFTER_CALL_WORK_COUNT WHERE IRF.INTERACTION_RESOURCE_ORDINAL=1.
ACW_DURATION Replaced Can be calculated as IRF.AFTER_CALL_WORK_DURATION WHERE IRF.INTERACTION_RESOURCE_ORDINAL=1.
TOTAL_DURATION Replaced Can be calculated as coalesce(max(IRF.END_TS),CAF.END_TS) - CAF.START_TS.
CALL_ATTEMPT_ID No Change
RECORD_ID No Change
CHAIN_ID No Change
CHAIN_N No Change
CONTACT_INFO No Change
ATTEMPT_ORDINAL No Change
DAILY_FROM_SECONDS No Change
DAILY_UNTIL_SECONDS No Change
CONTACT_DAILY_FROM_TIME No Change
CONTACT_DAILY_UNTIL_TIME No Change
CONTACT_IXN_START_TIME Retired
CONTACT_WITHIN_DAILY_RANGE Retired
DIAL_SCHED_TIME No Change
CONTACT_DIAL_SCHED_TIME No Change
OVERDIAL_FLAG No Change
CONTACT_COMPLETE_FLAG No Change
RPC_FLAG No Change
CONVERSION_FLAG No Change
RECORD_FIELD_1 No Change
RECORD_FIELD_2 No Change
RECORD_FIELD_3 No Change
RECORD_FIELD_4 No Change
RECORD_FIELD_5 No Change
RECORD_FIELD_6 No Change
RECORD_FIELD_7 No Change
RECORD_FIELD_8 No Change
RECORD_FIELD_9 No Change
RECORD_FIELD_10 No Change
RECORD_FIELD_11 No Change
RECORD_FIELD_12 No Change
RECORD_FIELD_13 No Change
RECORD_FIELD_14 No Change
RECORD_FIELD_15 No Change
RECORD_FIELD_16 No Change
RECORD_FIELD_17 No Change
RECORD_FIELD_18 No Change
RECORD_FIELD_19 No Change
RECORD_FIELD_20 No Change
RECORD_FIELD_21 No Change
RECORD_FIELD_22 No Change
RECORD_FIELD_23 No Change
RECORD_FIELD_24 No Change
RECORD_FIELD_25 No Change
RECORD_FIELD_26 No Change
RECORD_FIELD_27 No Change
RECORD_FIELD_28 No Change
RECORD_FIELD_29 No Change
RECORD_FIELD_30 No Change
RECORD_FIELD_31 No Change
RECORD_FIELD_32 No Change
RECORD_FIELD_33 No Change
RECORD_FIELD_34 No Change
RECORD_FIELD_35 No Change
RECORD_FIELD_36 No Change
RECORD_FIELD_37 No Change
RECORD_FIELD_38 No Change
RECORD_FIELD_39 No Change
RECORD_FIELD_40 No Change
ACTIVE_FLAG No Change
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:39.
blog comments powered by Disqus