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. (The Info Mart database in Cloud deployments is not multi-language.) THIS BULLET DISPLAYS ONLY IN THE MSSQL AND CLOUD PDMs.
Table IRF_USER_DATA_CUST_1
Description
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
| Column | Data Type | P | M | F | DV |
|---|---|---|---|---|---|
| INTERACTION_RESOURCE_ID | Oracle: NUMBER(19) MSSQL: numeric(19) PostgreSQL: numeric(19) |
X | X | X | |
| START_DATE_TIME_KEY | Oracle: NUMBER(10) MSSQL: int PostgreSQL: integer |
X | X | ||
| TENANT_KEY | Oracle: NUMBER(10) MSSQL: int PostgreSQL: integer |
X | X | ||
| CREATE_AUDIT_KEY | Oracle: NUMBER(19) MSSQL: numeric(19) PostgreSQL: numeric(19) |
X | X | -1 | |
| UPDATE_AUDIT_KEY | Oracle: NUMBER(19) MSSQL: numeric(19) PostgreSQL: numeric(19) |
X | X | 0 | |
| CUSTOM_DATA_1 through CUSTOM_DATA_16 | Oracle: VARCHAR2(1024 CHAR) MSSQL: varchar(1024)/nvarchar(1024) PostgreSQL: varchar(1024) |
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 IRF 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.
CUSTOM_DATA_1 through CUSTOM_DATA_16
Modified: 8.5.007 (data types for CUSTOM_DATA_1 through CUSTOM_DATA_16 were extended from 255 to 1024 characters, as defined now in the user-data template script, make_gim_UDE_template*.sql); 8.5.005.09 (data types for the CUSTOM_DATA_13 through CUSTOM_DATA_16 columns in the make_gim_UDE_template.sql script, which used to provide examples of date/time and numeric data types and default values, were changed to character data types).
Stores the value of a certain user-data key. The name of this column, which is configurable and typically matches the user-data key name, may differ in your deployment. If a default value is configured, it is stored when a KVP is missing for an interaction.
These fields are an example for character-type KVP values. In principle, these fields support character, date/time, or numeric values. The exact data type is specified in the script that you use when creating the custom user data table.
For date/time data types, the format in which Genesys Info Mart stores date/time values is yyyy-mm-ddThh24:mi:ss.ff; if the KVP value that you want to store is not in this format, you must also specify a conversion expression in the script. (The conversion expression is stored in the CTL_UD_TO_UDE_MAPPING.CONVERT_EXPRESSION field.)
Index List
| CODE | U | C | Description |
|---|---|---|---|
| I_IRF_USER_DATA_CUST_1_SDT | Improves access time, based on the Start Date Time key. |
Index I_IRF_USER_DATA_CUST_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.
References
The summary List of References will include the following entries for this table or view:
| Child Table/View | Child Table/View Column | Parent Table/View | Parent Table/View Column |
|---|---|---|---|
| IRF_USER_DATA_CUST_1 | CREATE_AUDIT_KEY | CTL_AUDIT_LOG | AUDIT_KEY |
| IRF_USER_DATA_CUST_1 | INTERACTION_RESOURCE_ID | INTERACTION_RESOURCE_FACT | INTERACTION_RESOURCE_ID |
| IRF_USER_DATA_CUST_1 | MEDIATION_SEGMENT_ID (referenced as INTERACTION_RESOURCE_ID) | MEDIATION_SEGMENT_FACT | MEDIATION_SEGMENT_ID |
| IRF_USER_DATA_CUST_1 | START_DATE_TIME_KEY | DATE_TIME | DATE_TIME_KEY |
| IRF_USER_DATA_CUST_1 | TENANT_KEY | TENANT | TENANT_KEY |
| IRF_USER_DATA_CUST_1 | UPDATE_AUDIT_KEY | CTL_AUDIT_LOG | AUDIT_KEY |