CONTACT_ATTEMPT_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 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.