MMEDIA_IXN_FACT_EXT

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

Table MMEDIA_IXN_FACT_EXT

This extension table for multimedia data has been removed from the 8.x schema. Instead, the INTERACTION_RESOURCE_FACT table now stores multimedia data in the same fields as those that are used for voice data. Although exact replacements are not available in many cases, recommendations below suggest how to obtain 8.x metrics that are similar to those in your 7.6 reports.

7.6 Column Name	8.x Changes
	Type of Change	Description/Recommendation	New Table.Column
MMEDIA_IXN_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.
MEDIA_SERVER_GMT_START_TIME	Retired	See Changes to Time-Related Tables and Fields.
MEDIA_SERVER_IXN_ONLINE_FLAG	Replaced	The information provided by this field is closely related to MEDIA_TYPE.IS_ONLINE (join to MEDIA_TYPE using the MEDIA_TYPE_KEY value from the INTERACTION_FACT.MEDIA_TYPE_KEY).
FROM_DOMAIN	Replaced	The value can be derived from INTERACTION_FACT.SOURCE_ADDRESS. The domain name is the portion of the source address following the last "@" symbol.
SUBJECT	Replaced		INTERACTION_FACT.SUBJECT
CONTACT_ID	Retired
TOTAL_TRANSFER_COUNT	Replaced	Can be calculated from the sum of the count of child IRF records that have technical descriptor keys with TECHNICAL_RESULT_CODE='TRANSFERRED'.
TOTAL_CONSULT_COUNT	Replaced	Can be calculated from the sum of the count of child IRF records that have technical descriptor keys with RESOURCE_ROLE_CODE='INITIATEDCONSULT'.
TOTAL_CONSULT_DURATION	Replaced	Can be calculated from the sum of the durations of child IRF records with technical descriptor keys with RESOURCE_ROLE_CODE='INITIATEDCONSULT'.
TOTAL_CONFERENCE_COUNT	Replaced	Can be calculated from the sum of the count of child IRF records that have technical descriptor keys with RESOURCE_ROLE_CODE='INCONFERENCE'.
TOTAL_CONFERENCE_DURATION	Replaced	Can be calculated from the sum of the durations of child IRF records that have technical descriptor keys with RESOURCE_ROLE_CODE='INCONFERENCE'.
ANSWERED_BY_AGENT_FLAG	Replaced	The value can be calculated as follows: For Online MediaType (using MEDIA_TYPE.IS_ONLINE as described above): if there is a child IRF record that has IRF_ANCHOR = 1 and HANDLE_COUNT = 1 and if the RESOURCE_KEY has RESOURCE_TYPE = 'AGENT', then AnsweredByAgent is true; otherwise, it is false. For Offline MediaType: if there is a child IRF record that has IRF_ANCHOR = 2 and if INTERACTION_RESOURCE_FACT.INTERACTION_TYPE_KEY has INTERACTION_SUBTYPE_CODE = 'OUTBOUNDREPLY', then AnsweredByAgent is true; otherwise, it is false.
TRANSFERRED_BY_AGENT_FLAG	Replaced	The value can be calculated as follows: If there is a child IRF record that has IRF_ANCHOR = 1 and HANDLE_COUNT = 1 and if the RESOURCE_KEY has RESOURCE_TYPE = 'AGENT', and the technical descriptor key for this record has TECHNICAL_RESULT_CODE = 'TRANSFERRED', then TransferredByAgent is true; otherwise, it is false. This field indicates whether the first agent who was connected to the interaction transferred the interaction to another resource.
WEBFORM_FLAG	Retired
AUTO_RESPONSE_FLAG	Replaced	The value can be calculated as follows: This field only applies to offline MediaType (using MEDIA_TYPE.IS_ONLINE=0, as described above). If there is a child IRF record with IRF_ANCHOR = 2 and INTERACTION_RESOURCE_FACT.INTERACTION_TYPE_KEY has INTERACTION_SUBTYPE_CODE = 'OUTBOUNDAUTORESPONSE', then AUTO_RESPONSE_FLAG is true; otherwise, it is false.
AUTO_RESPONSE_NAME	Retired
AUTO_ACK_FLAG	Replaced	The value can be calculated as follows: This field only applies to offline MediaType (using MEDIA_TYPE.IS_ONLINE=0, as described above). If there is a child IRF record with IRF_ANCHOR = 2 and if INTERACTION_RESOURCE_FACT.INTERACTION_TYPE_KEY has INTERACTION_SUBTYPE_CODE = 'OUTBOUNDACKNOWLEDGEMENT', then AUTO_ACK_FLAG is true; otherwise, it is false.
AUTO_ACK_NAME	Retired
ABANDONED_BY_CUSTOMER_FLAG	Retired
DURATION_BEFORE_ABANDON	Retired
ACTIVE_FLAG	Retired
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.