RESOURCE_

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.

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.