Jump to: navigation, search

STRATEGY

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

Table STRATEGY

In addition to the changes in this table associated with the audit-, time-, and purging-related fields, other columns in this table have changed as described below.

7.6 Column Name 8.x Changes
Type of Change
Description/Recommendation
New Table.Column
STRATEGY_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.
STRATEGY_TYPE Changed The IVRApplication value has been discontinued as obsolete.
STRATEGY_TYPE_CODE Changed The IVRAPPLICATION value has been discontinued as obsolete.
STRATEGY_NAME No Change
STRATEGY_RESULT Retired
STRATEGY_RESULT_CODE Retired
STRATEGY_OUTCOME Retired
STRATEGY_OUTCOME_CODE Retired
RESULT_REASON 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.


This page was last edited on July 17, 2020, at 16:05.
blog comments powered by Disqus