Jump to: navigation, search

RESOURCE_

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

Table RESOURCE_

In addition to the changes in this table associated with the audit-, time-, and purging-related fields, the value stored in the RESOURCE_NAME column has changed.

7.6 Column Name 8.x Changes
Type of Change
Description/Recommendation
New Table.Column
RESOURCE_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.
SWITCH_NAME No Change
IVR_NAME No Change
RESOURCE_TYPE No Change
RESOURCE_TYPE_CODE No Change
RESOURCE_SUBTYPE No Change
RESOURCE_NAME Changed For an agent resource, the field stores a user name only. Use a combination of RESOURCE_.RESOURCE_NAME, RESOURCE_.AGENT_FIRST_NAME, and RESOURCE_.AGENT_LAST_NAME.
EMPLOYEE_ID No Change
EXTERNAL_RESOURCE_ID No Change
RESOURCE_CFG_DBID No Change
RESOURCE_CFG_TYPE_ID No Change
RESOURCE_ALIAS No Change
NETWORK_RESOURCE_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.
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.
Comments or questions about this documentation? Contact us for support!