Jump to: navigation, search

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

Table SM_RES_STATE_REASON_FACT

In addition to the changes in this table associated with the audit-, time-, and purging-related fields, population of this table has changed to include active agent state reasons as well as completed state reasons. The PRIMARY_MEDIA_RESOURCE_KEY column has been discontinued and population of the TOTAL_DURATION and ACTIVE_FLAG columns has also changed. To achieve compatibility with the Info Mart 7.6 reports, adjust the database queries to include the completed agent state reasons only (those with ACTIVE_FLAG=0).

7.6 Column Name 8.x Changes
Type of Change
Description/Recommendation
New Table.Column
SM_RES_STATE_REASON_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.
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_START_DATE_TIME_KEY Retired See Changes to Time-Related Tables and Fields.
STD_TENANT_END_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.
RESOURCE_STATE_KEY No Change
RESOURCE_STATE_REASON_KEY No Change
MEDIA_TYPE_KEY No Change
RESOURCE_KEY No Change
RESOURCE_GROUP_COMBINATION_KEY No Change
PRIMARY_MEDIA_RESOURCE_KEY Replaced Can be obtained from SM_RES_STATE_FACT using SM_RES_STATE_FACT_KEY.
SM_RES_SESSION_FACT_KEY No Change
SM_RES_STATE_FACT_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.
TOTAL_DURATION Changed Use the TOTAL_DURATION value from the facts where ACTIVE_FLAG=0.
LEAD_CLIP_DURATION No Change
TRAIL_CLIP_DURATION No Change
ACTIVE_FLAG Changed Is populated for active states in release 8.x.
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 July 17, 2020, at 16:05.
blog comments powered by Disqus