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

Table CTL_UDE_KEYS_TO_DIM_MAPPING

Description


In partitioned databases, this table is not partitioned.


This table provides information for mapping user-data KVPs that are stored as dimensions to facts that are stored in the INTERACTION_RESOURCE_FACT table. The mapping table is populated with a special script during the Genesys Info Mart deployment and can be updated when user-data storage requirements change. Each row defines mapping between the primary key of a dimension table and a foreign key in the IRF_USER_DATA_KEYS table.

Column List

Legend

Column Data Type P M F DV

DIM_TABLE_NAME

varchar(30) X X

DIM_TABLE_PK_NAME

varchar(30) X

UDE_KEY_NAME

varchar(30) X

DIM_TABLE_NAME

The name of the dimension table that stores user data.

DIM_TABLE_PK_NAME

The name of the primary key column in the dimension table that stores user data.

UDE_KEY_NAME

The name of the foreign key column in the IRF_USER_DATA_KEYS table.


Index List

CODE U C Description

I_UDE_KEYS_TO_D_M_KN

X A constraint that enforces unique mapping for each user-data dimension table.

Index I_UDE_KEYS_TO_D_M_KN

Field Sort Comment
UDE_KEY_NAME Ascending

No subject area information available.

 

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on 29 August 2016, at 14:53.