RESOURCE_
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 | |||||||
---|---|---|---|---|---|---|---|---|
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!