Jump to: navigation, search

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


This page was last edited on March 27, 2013, at 22:43.
blog comments powered by Disqus