F = Foreign key (where the term is used loosely to indicate a surrogate key reference to a field in another table, not a formal constraint)

DV = Default value

In the Data Type column, varchar/nvarchar means that the data type is varchar except in multi-language databases that use Unicode, in which case the data type is nvarchar. (The Info Mart database in Cloud deployments is not multi-language.)

Contents

Table RESOURCE_

Description

In partitioned databases, this table is not partitioned.

This table allows facts to be described based on the attributes of the associated resource; routing points, queues, IVRs, and agents are all resources. Each row describes one resource. A new row is issued for each configured DN--such as routing point, queue DN, position, extension, IVR DN, and agent--identified by its ID in the contact center configuration. The subtype column specifies the media-specific DN type, while the type column recasts the media-specific DN type as a media-neutral type. For example, External Routing Point, Routing Point, Routing Queues, Service Numbers, and Virtual Routing Point DNs are all considered Routing Points; ACD Queue is considered a Queue. For Genesys eServices/Multimedia, Script objects that represent Interaction Queues and Workbins are considered Queues; Script objects that represent Routing Strategies are considered Routing Points.

Deleting a script, routing point, queue, or another DN and re-creating it under the same name causes a new row to be issued. Changing agent attributes--such as last name, first name, and employee ID--causes an update to an existing row. Deleting an agent and re-creating it with the same attributes causes a new row to be issued.

Note: The Genesys Info Mart ETL does not populate the EXTERNAL_RESOURCE_ID and IVR_NAME columns.

TENANT_KEY

CREATE_AUDIT_KEY

The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data creation. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools—that is, applications that need to identify newly added data.

UPDATE_AUDIT_KEY

The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data update. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools—that is, applications that need to identify recently modified data.

EMPLOYEE_ID

EXTERNAL_RESOURCE_ID

The employee ID of an agent, as it appears in an external human resource application. It enables Genesys Info Mart tables to be joined to external data mart tables. This field is reserved for future use.

Index IDX_RES_TYPE_CODE

Index I_RES_KEY_CFG_DBID

Subject Areas

Contact_Attempt - Represents outbound campaign contact record attempts. An attempt may or may not include dialing.

Interaction_Resource - Represents a summary of each attempt to handle an interaction. It encompasses the mediation process that is required to offer the interaction to a target handling resource, as well as the activities of that target handling resource.

Interaction_Resource_State - Allows facts to be described by the state of the associated agent resource. Each row describes one distinct media-specific agent state.