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

Table MEDIATION_SEGMENT_FACT

In addition to changes to the audit-, time-, and purging-related fields, certain fields in this table were retired because of underlying changes in the model.

7.6 Column Name	8.x Changes
	Type of Change	Description/Recommendation	New Table.Column
MEDIATION_SEGMENT_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_TENANT_DATE_TIME_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.
CREATE_AUDIT_KEY	Changed	See Database Schema Changes Overview.
UPDATE_AUDIT_KEY	Changed	See Database Schema Changes Overview.
TENANT_KEY	No Change
INTERACTION_TYPE_KEY	No Change
MEDIA_TYPE_KEY	No Change
TECHNICAL_DESCRIPTOR_KEY	No Change
RESOURCE_KEY	No Change
RESOURCE_GROUP_COMBINATION_KEY	No Change
INTERACTION_ID	No Change
MEDIA_SERVER_IXN_GUID	No Change
MEDIATION_GUID	No Change
MEDIATION_SEGMENT_COUNT	Retired
TOTAL_DURATION	Replaced	If the result is Cleared or Abandoned, calculate as MEDIATION_DURATION. If the result is Diverted, calculate as MEDIATION_DURATION + TARGET_IRF.RING_DURATION + TARGET_IRF.CONS_RCV_RING_DURATION + TARGET_IRF.POST_CONS_XFER_RING_DURATION + TARGET_IRF.CONF_JOIN_RING_DURATION.
MEDIATION_DURATION	No Change
TARGET_IXN_SEGMENT_ID	Retired
TARGET_SEG_FACT_EXT_KEY	Retired
TARGET_IXN_RESOURCE_ID	No Change
TARGET_RES_FACT_EXT_KEY	Retired
TARGET_RESOURCE_KEY	Replaced	Use IRF.RESOURCE_KEY for the target IRF.
TARGET_RES_GROUP_COMBO_KEY	Replaced	Use IRF.RESOURCE_GROUP_COMBINATION_KEY for the target IRF.
TARGET_MEDIA_RESOURCE_KEY	Replaced	Use IRF.MEDIA_RESOURCE_KEY for the target IRF.
TARGET_PLACE_KEY	Replaced	Use IRF.PLACE_KEY for the target IRF.
SHORT_ABANDONED_FLAG	No Change
ANSWER_THRESHOLD	No Change
MET_THRESHOLD_FLAG	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.
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	Retired	See Database Schema Changes Overview.