Jump to: navigation, search

RESOURCE_ Table

This table allows facts to be described based on the attributes of the associated agent. Data in this table is updated by synchronization with RESOURCE_ table from Genesys Info Mart. Unlike the source table (in Genesys Info Mart), only data about agents is stored here.

Column Data Type Description
RESOURCE_KEY int The surrogate key, inherited from the Genesys Info Mart database.
TENANT_KEY int The surrogate key, inherited from the Genesys Info Mart database.
CREATE_AUDIT_KEY bigint The surrogate key, inherited from the Genesys Info Mart database.
UPDATE_AUDIT_KEY bigint The surrogate key, inherited from the Genesys Info Mart database.
SWITCH_DBID int The database identifier assigned to the switch by Configuration Server (the DBID of the switch), for the switch identified in the SWITCH_NAME field.
SWITCH_NAME nvarchar(255) The switch name on which the queue, routing point, or IVR DN is configured. It provides a natural hierarchy for queues, routing points, or IVR DNs that are configured on the same switch.
IVR_NAME nvarchar(255) The IVR name on which the IVR DN is configured. It provides a natural hierarchy for IVR DNs that are configured on the same IVR.
RESOURCE_TYPE nvarchar(255) The resource type. This field is set to the following value:
  • Agent
RESOURCE_TYPE_CODE nvarchar(32) The code of the resource type. This field is set to the following value:
  • AGENT
RESOURCE_SUBTYPE nvarchar(255) The detailed resource type. The following list of permissible values presents the resource subtypes in the following format:
  • Agent
    • Agent
    • Person
RESOURCE_NAME nvarchar(255) The user name of the agent as specified in the Person object's properties in the Configuration Database.
AGENT_FIRST_NAME nvarchar(64) This value is the first name of the agent, as specified in the Person object's properties in the Configuration Database.
AGENT_LAST_NAME nvarchar(64) This value is the last name of the agent, as specified in the Person object's properties in the Configuration Database.
EMPLOYEE_ID nvarchar(255) The employee ID of an agent resource, as it appears in the contact center configuration.
EXTERNAL_RESOURCE_ID nvarchar(255) The employee ID of an agent, as it appears in an external human resource application. This field is reserved for future use.
RESOURCE_CFG_DBID int The database identifier for the agent object in the contact center configuration.
RESOURCE_CFG_TYPE_ID int The contact center configuration integer type that is associated with agent object.
RESOURCE_ALIAS nvarchar(255) This field inherited from the Genesys Info Mart database.
NETWORK_RESOURCE_FLAG int This field inherited from the Genesys Info Mart database.
GMT_START_TIME timestamp The GMT-equivalent date and time at which the resource was added to ICON DB, which can differ from the date and time at which the resource was actually added to contact center configuration.
GMT_END_TIME timestamp The GMT-equivalent date and time at which the resource was removed from contact center configuration.
PURGE_FLAG int This field is reserved.
This page was last edited on July 6, 2021, at 16:10.
Comments or questions about this documentation? Contact us for support!