Jump to: navigation, search

In the Column List:

  • P = Primary key
  • M = Mandatory field
  • 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.

Table IRF_USER_DATA_GEN_1

Description

Modified: 8.5.015.19 (PRODUCER_BATCH_ID added); 8.5.015.14 (GVP_SESSION_ID added); 8.5.011.18 (GSW_CALL_TYPE added); 8.5.003 (in Oracle, fields with VARCHAR data types use explicit CHAR character-length semantics); 8.5.001 (CREATE_AUDIT_KEY and UPDATE_AUDIT_KEY added)

In partitioned databases, this table is partitioned.


IRF_USER_DATA_GEN_1 allows interaction resource facts and mediation segment facts to be described by Genesys-defined (predefined) string attributes that may come attached with interactions. You cannot change the name of this table or the names of the table columns.

The table stores high-cardinality data for a set of predefined KVPs that are associated with interactions. (The Revenue and Satisfaction KVPs are also included in this table although the associated attributes are not currently predefined in Genesys Configuration Database.) Each row describes a combination of user-defined custom attributes that characterize the interaction. A new row is issued for each new interaction resource fact. If the DN-level [gim-etl].link-msf-userdata configuration option or, starting with release 8.5.003 the application-level link-msf-userdata-voice or link-msf-userdata-mm configuration options are specified, a new row is also issued for each new mediation segment fact, to store the user data for an interaction that is in mediation. The values are populated from user data (attached data or UserEvent-based KVP data) according to a propagation rule, configurable for each column.

Tip
To assist you in preparing supplementary documentation, click the following link to download a comma-separated text file containing information such as the data types and descriptions for all columns in this table: Download a CSV file.

Hint: For easiest viewing, open the downloaded CSV file in Excel and adjust settings for column widths, text wrapping, and so on as desired. Depending on your browser and other system settings, you might need to save the file to your desktop first.

Column List

Legend

Column Data Type P M F DV
INTERACTION_RESOURCE_ID numeric(19) X X X
START_DATE_TIME_KEY int X X
TENANT_KEY int X X
CREATE_AUDIT_KEY numeric(19) X X -1
UPDATE_AUDIT_KEY numeric(19) X X 0
CASE_ID varchar(255)/nvarchar(255)
CUSTOMER_ID varchar(255)/nvarchar(255)
SERVICE_OBJECTIVE varchar(255)/nvarchar(255)
REVENUE varchar(255)/nvarchar(255)
SATISFACTION varchar(255)/nvarchar(255)
IPURPOSE varchar(10)/nvarchar(10)
GSW_CALL_ATTEMPT_GUID varchar(50)
SERVICE_ID varchar(255)
SERVICE_START_TS int
GSW_CALL_TYPE varchar(255)
GVP_SESSION_ID varchar(255)
PRODUCER_BATCH_ID numeric(19)

INTERACTION_RESOURCE_ID

A reference either to an INTERACTION_RESOURCE_FACT record or, if storage of mediation user data is configured, to a MEDIATION_SEGMENT_FACT record. This is the primary key of this table.

START_DATE_TIME_KEY

Identifies the start of a 15-minute interval in which the IRF or MSF resource's participation in the interaction began. The value of this field is identical to the START_DATE_TIME_KEY value in the IRF or MSF record that is identified by the INTERACTION_RESOURCE_ID value. This value can be used to enable local indexes with partitioning.

TENANT_KEY

The surrogate key that is used to join the TENANT dimension to the fact tables, to indicate the tenant of the IRF resource. The value of this field is identical to the value that is in the corresponding INTERACTION_RESOURCE_FACT record. This value can be used to restrict data access.

CREATE_AUDIT_KEY

Introduced: Release 8.5.001
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

Introduced: Release 8.5.001
The surrogate key used to join to the CTL_AUDIT_LOG dimension. 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.

CASE_ID

The case ID, as it appears in an external case management application. This column enables linkage between Genesys Info Mart and third-party applications, and the values may be useful for repeat-caller analysis.

CUSTOMER_ID

The customer ID, as it appears in an external CRM application. It enables Genesys Info Mart tables to be joined to external data mart tables. This column enables linkage between Genesys Info Mart and third-party applications, and the values may be useful to calculate metrics of the "per customer" type.

SERVICE_OBJECTIVE

The maximum elapsed time, in seconds, before the customer should receive service. For voice interactions, this is measured from the interaction start time to the time that an agent resource or self-service IVR should answer the call. For multimedia, this is the time from the start time of the interaction to the time that an agent resource, or AutoResponse Strategy, should start to handle (accept) the interaction.

REVENUE

The amount of revenue generated for a customer interaction.

SATISFACTION

The numerical customer-satisfaction score for the customer interaction.

IPURPOSE

The flag that indicates how to classify an IVR. A value of 1 (Self-Service) indicates that the IVR is considered to be a handling resource; a value of 0 indicates that the IVR is considered to be a mediation resource. This field's value is ignored for non-IVR parties.

GSW_CALL_ATTEMPT_GUID

Stores the GSW_CALL_ATTEMPT_GUID call attempt ID that is assigned by OCS. This value allows you to associate interaction details with contact attempt details using the following references:

  • IRF_USER_DATA_GEN_1.GSW_CALL_ATTEMPT_GUID = CONTACT_ATTEMPT_FACT.CALL_ATTEMPT_ID
  • IRF_USER_DATA_GEN_1.INTERACTION_RESOURCE_ID = INTERACTION_RESOURCE_FACT.INTERACTION_RESOURCE_ID

SERVICE_ID

Introduced: Release 8.1.402
In deployments that have been configured to support reporting on Genesys Callback, this field reports the ID of the callback service request. Depending on the scenario, the value equals the ID of the Genesys Mobile Services (GMS) service instance or ID of the Orchestration Server (ORS) session.

SERVICE_START_TS

Introduced: Release 8.1.402
For the callback service identified in the SERVICE_ID field, the UTC timestamp when the callback service started. This value represents either the time of the callback request or the time that the callback offer was played, depending on deployment.

GSW_CALL_TYPE

Introduced: Release 8.5.011.18
Stores the GSW_CALL_TYPE value that is attached by OCS or, for SIP Cluster call flows where recording and monitoring of outbound calls can be disabled, by SIP Server.

GVP_SESSION_ID

Introduced: Release 8.5.015.14
Reserved for internal use.

PRODUCER_BATCH_ID

Introduced: Release 8.5.015.19
Reserved for internal use.

Index List

CODE U C Description
I_IRF_USER_DATA_GEN_1_SDT Improves access time, based on the Start Date Time key.

Index I_IRF_USER_DATA_GEN_1_SDT

Field Sort Comment
START_DATE_TIME_KEY Ascending

Subject Areas

  • 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.
This page was last edited on October 2, 2020, at 12:23.
Comments or questions about this documentation? Contact us for support!