MCT_CFG_IVR_MAPPINGS

An IVR (Interactive Voice Response) is a call center automated voice system that can take a caller's input. The input is then presented to Contact Center application as key/value pairs. The keys can be any string so they need to be mapped to keys that Screen Pop AM understands. This table maps IVR Keys to Screen Pop Tokens. Each Connector has its own separate set of mappings. Connector = null can be used as a catch all mapping set.

Details

• Schema: FUSION

• Object owner: MCT

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
MCT_CFG_IVR_MAPPINGS_PK	IVR_MAPPING_GUID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
IVR_MAPPING_GUID	VARCHAR2	64		Yes	Primary Key of table
CONN_GUID	VARCHAR2	64			FK to MCT_CFG_CONN_B
IVR_KEY	VARCHAR2	128		Yes	IVR (Interactive Voice Response) Key Name
TOKEN_GUID	VARCHAR2	64		Yes	FK to MCT_CFT_TOKENS_B
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Foreign Keys

Table	Foreign Table	Foreign Key Column
MCT_CFG_IVR_MAPPINGS	mct_cfg_conn_b	IVR_MAPPING_GUID
MCT_CFG_IVR_MAPPINGS	mct_cfg_tokens_b	IVR_MAPPING_GUID

Indexes

Index	Uniqueness	Tablespace	Columns
MCT_CFG_IVR_MAPPINGS_PK	Unique	FUSION_TS_TX_DATA	IVR_MAPPING_GUID
MCT_CFG_IVR_MAPPINGS_U1	Unique	FUSION_TS_TX_DATA	CONN_GUID, IVR_KEY