Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - CCT Tables and Views

TABLE - CCT.CCT_ADDRESS_BOOKS

TABLE - CCT.CCT_AGENT_INDEXES

TABLE - CCT.CCT_AGENT_RECORDS

TABLE - CCT.CCT_AGENT_RT_STATS

TABLE - CCT.CCT_CLASSIFICATIONS

TABLE - CCT.CCT_CLASSIFICATION_RULES

TABLE - CCT.CCT_CLASSIPROC_PARAMS

TABLE - CCT.CCT_EVENTS

TABLE - CCT.CCT_INTERACTION_DEFS

TABLE - CCT.CCT_INTERACTION_KEYS

TABLE - CCT.CCT_IVR_CUSTOMER_COLS

TABLE - CCT.CCT_IVR_DATA_LABELS

TABLE - CCT.CCT_IVR_MAPS

TABLE - CCT.CCT_IVR_MON_PORTRECORDS

TABLE - CCT.CCT_IVR_MON_SERVICES

TABLE - CCT.CCT_IVR_SERVICES

TABLE - CCT.CCT_LINES

TABLE - CCT.CCT_MEDIA_ITEMS

TABLE - CCT.CCT_MIDDLEWARES

TABLE - CCT.CCT_MIDDLEWARE_PARAMS

TABLE - CCT.CCT_MIDDLEWARE_TYPES

TABLE - CCT.CCT_MIDDLEWARE_VALUES

TABLE - CCT.CCT_PARAMETER_INFOS

TABLE - CCT.CCT_ROUTES

TABLE - CCT.CCT_ROUTE_PARAMS

TABLE - CCT.CCT_ROUTE_PARAMTYPES

TABLE - CCT.CCT_ROUTING_FILTERS

TABLE - CCT.CCT_ROUTING_RESULTS

TABLE - CCT.CCT_ROUTING_SERVERS

TABLE - CCT.CCT_SERVER_RT_STATS

TABLE - CCT.CCT_STATIC_ROUTES

TABLE - CCT.CCT_TELESETS

TABLE - CCT.CCT_TELESET_TYPES

TABLE - CCT.CCT_TEMPAGENTS

VIEW - APPS.CCT_MIDDLEWARES_V

Table: CCT_ADDRESS_BOOKS

Primary Key: CCT_CAB_PK

1. ADDRESS_BOOK_ID

Primary Key: CCT_CAB_UK1

1. AGENT_ID

Comments

Address Books table for Agent Soft Phone

Columns

[top of page]

CCT.CCT_ADDRESS_BOOKS does not reference any database object

CCT.CCT_ADDRESS_BOOKS is referenced by following:

CCT

VIEW - CCT_ADDRESS_BOOKS#

[top of page]

Table: CCT_AGENT_INDEXES

Primary Key: CCT_CAI_PK

1. AGENT_INDEX

Primary Key: CCT_CAI_UK

1. MCM_SVR_ID
2. AGENT_ID

Comments

Agent Indexes table.

Columns

[top of page]

CCT.CCT_AGENT_INDEXES does not reference any database object

CCT.CCT_AGENT_INDEXES is referenced by following:

CCT

VIEW - CCT_AGENT_INDEXES#

[top of page]

Table: CCT_AGENT_RECORDS

Primary Key: CCT_CAR_PK

1. AGENT_RECORD_ID

Comments

This table keeps track of some agent summary stats. Record is INSERTed when an agent logs out.

Indexes

Columns

[top of page]

CCT.CCT_AGENT_RECORDS does not reference any database object

CCT.CCT_AGENT_RECORDS is referenced by following:

CCT

VIEW - CCT_AGENT_RECORDS#

[top of page]

Table: CCT_AGENT_RT_STATS

Primary Key: CCT_CAS_PK

1. AGENT_RT_STAT_ID

Comments

This table keeps tracked of logged in agents.

Indexes

Columns

[top of page]

CCT.CCT_AGENT_RT_STATS does not reference any database object

CCT.CCT_AGENT_RT_STATS is referenced by following:

CCT

VIEW - CCT_AGENT_RT_STATS#

[top of page]

Table: CCT_CLASSIFICATIONS

Primary Key: CCT_CCL_PK

1. CLASSIFICATION_ID

Foreign Keys to this table:

Comments

Classifications table.

Indexes

Columns

[top of page]

CCT.CCT_CLASSIFICATIONS does not reference any database object

CCT.CCT_CLASSIFICATIONS is referenced by following:

CCT

VIEW - CCT_CLASSIFICATIONS#

[top of page]

Table: CCT_CLASSIFICATION_RULES

Primary Key: CCT_CCR_PK

1. CLASSIFICATION_RULE_ID

Foreign Keys from this table:

Comments

Classification Rules table.

Indexes

Columns

[top of page]

CCT.CCT_CLASSIFICATION_RULES does not reference any database object

CCT.CCT_CLASSIFICATION_RULES is referenced by following:

CCT

VIEW - CCT_CLASSIFICATION_RULES#

[top of page]

Table: CCT_CLASSIPROC_PARAMS

Primary Key: CCT_CPA_PK

1. CLASSIPROC_PARAM_ID

Comments

Classification Procedure Paramters table.

Indexes

Columns

[top of page]

CCT.CCT_CLASSIPROC_PARAMS does not reference any database object

CCT.CCT_CLASSIPROC_PARAMS is referenced by following:

CCT

VIEW - CCT_CLASSIPROC_PARAMS#

[top of page]

Table: CCT_EVENTS

Primary Key: CCT_EVENTS_PK

1. EVENT_ID

Comments

This table holds every event that the OTM throws internally.

Indexes

Columns

[top of page]

CCT.CCT_EVENTS does not reference any database object

CCT.CCT_EVENTS is referenced by following:

CCT

VIEW - CCT_EVENTS#

[top of page]

Table: CCT_INTERACTION_DEFS

Primary Key: CCT_INTERACTION_DEFS_PK

1. INTERACTION_DEF_ID

Comments

Call Center Interaction definitions table.

Columns

[top of page]

CCT.CCT_INTERACTION_DEFS does not reference any database object

CCT.CCT_INTERACTION_DEFS is referenced by following:

CCT

VIEW - CCT_INTERACTION_DEFS#

[top of page]

Table: CCT_INTERACTION_KEYS

Primary Key: CCT_INTERACTION_KEYS_PK

1. INTERACTION_KEY_ID

Foreign Keys to this table:

Comments

This table lists the predefined Interaction keys for OA Prefs Admin Screen.

Indexes

Columns

[top of page]

CCT.CCT_INTERACTION_KEYS does not reference any database object

CCT.CCT_INTERACTION_KEYS is referenced by following:

CCT

VIEW - CCT_INTERACTION_KEYS#

[top of page]

Table: CCT_IVR_CUSTOMER_COLS

Comments

IVR Customer Columns table.

Columns

[top of page]

CCT.CCT_IVR_CUSTOMER_COLS does not reference any database object

CCT.CCT_IVR_CUSTOMER_COLS is referenced by following:

CCT

VIEW - CCT_IVR_CUSTOMER_COLS#

[top of page]

Table: CCT_IVR_DATA_LABELS

Comments

IVR Data Labels table

Columns

[top of page]

CCT.CCT_IVR_DATA_LABELS does not reference any database object

CCT.CCT_IVR_DATA_LABELS is referenced by following:

CCT

VIEW - CCT_IVR_DATA_LABELS#

[top of page]

Table: CCT_IVR_MAPS

Primary Key: CCT_IVR_MAPS_PK

1. IVR_MAP_ID

Foreign Keys from this table:

Comments

This table maps IVR variable names to CCT Interaction Keys

Indexes

Columns

[top of page]

CCT.CCT_IVR_MAPS does not reference any database object

CCT.CCT_IVR_MAPS is referenced by following:

CCT

VIEW - CCT_IVR_MAPS#

[top of page]

Table: CCT_IVR_MON_PORTRECORDS

Comments

IVR Monitor Port Records table.

Columns

[top of page]

CCT.CCT_IVR_MON_PORTRECORDS does not reference any database object

CCT.CCT_IVR_MON_PORTRECORDS is referenced by following:

CCT

VIEW - CCT_IVR_MON_PORTRECORDS#

[top of page]

Table: CCT_IVR_MON_SERVICES

Comments

IVR Monitor Services table.

Columns

[top of page]

CCT.CCT_IVR_MON_SERVICES does not reference any database object

CCT.CCT_IVR_MON_SERVICES is referenced by following:

CCT

VIEW - CCT_IVR_MON_SERVICES#

[top of page]

Table: CCT_IVR_SERVICES

Comments

IVR Services table.

Columns

[top of page]

CCT.CCT_IVR_SERVICES does not reference any database object

CCT.CCT_IVR_SERVICES is referenced by following:

CCT

VIEW - CCT_IVR_SERVICES#

[top of page]

Table: CCT_LINES

Primary Key: CCT_LINES_PK

1. LINE_ID

Foreign Keys from this table:

Comments

This table keeps track of each line's extension/classification.

Indexes

Columns

[top of page]

CCT.CCT_LINES does not reference any database object

CCT.CCT_LINES is referenced by following:

CCT

VIEW - CCT_LINES#

[top of page]

Table: CCT_MEDIA_ITEMS

Primary Key: CCT_CMI_PK

1. MEDIA_ITEM_ID

Primary Key: CCT_CMI_UK1

1. MCM_SVR_ID
2. QUEUE_SEQ_NUM

Comments

Call Center Media Item table.

Indexes

Columns

[top of page]

CCT.CCT_MEDIA_ITEMS does not reference any database object

CCT.CCT_MEDIA_ITEMS is referenced by following:

CCT

VIEW - CCT_MEDIA_ITEMS#

[top of page]

Table: CCT_MIDDLEWARES

Primary Key: CCT_MIDDLEWARES_PK

1. MIDDLEWARE_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

This table is for holding information needed for interfacing with the switch's middleware.

Indexes

Columns

[top of page]

CCT.CCT_MIDDLEWARES does not reference any database object

CCT.CCT_MIDDLEWARES is referenced by following:

CCT

VIEW - CCT_MIDDLEWARES#

[top of page]

Table: CCT_MIDDLEWARE_PARAMS

Primary Key: CCT_MIDDLEWARE_PARAMS_PK

1. MIDDLEWARE_PARAM_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

This table specifies the specific middleware parameters a middleware needs.

Indexes

Columns

[top of page]

CCT.CCT_MIDDLEWARE_PARAMS does not reference any database object

CCT.CCT_MIDDLEWARE_PARAMS is referenced by following:

CCT

VIEW - CCT_MIDDLEWARE_PARAMS#

[top of page]

Table: CCT_MIDDLEWARE_TYPES

Primary Key: CCT_CMT_PK

1. MIDDLEWARE_TYPE_ID

Foreign Keys to this table:

Comments

This table lists each middleware type, such as PROSPECT_ASPECT or OPENTEL.

Indexes

Columns

[top of page]

CCT.CCT_MIDDLEWARE_TYPES does not reference any database object

CCT.CCT_MIDDLEWARE_TYPES is referenced by following:

CCT

VIEW - CCT_MIDDLEWARE_TYPES#

[top of page]

Table: CCT_MIDDLEWARE_VALUES

Primary Key: CCT_CMV_PK

1. MIDDLEWARE_VALUE_ID

Foreign Keys from this table:

Comments

This table holds the parameter values of each defined middleware id

Indexes

Columns

[top of page]

CCT.CCT_MIDDLEWARE_VALUES does not reference any database object

CCT.CCT_MIDDLEWARE_VALUES is referenced by following:

CCT

VIEW - CCT_MIDDLEWARE_VALUES#

[top of page]

Table: CCT_PARAMETER_INFOS

Primary Key: CCT_PARAMETER_INFOS_PK

1. PARAMETER_INFO_ID

Comments

This table is for sql layer parameter info caching.

Indexes

Columns

[top of page]

CCT.CCT_PARAMETER_INFOS does not reference any database object

CCT.CCT_PARAMETER_INFOS is referenced by following:

CCT

VIEW - CCT_PARAMETER_INFOS#

[top of page]

Table: CCT_ROUTES

Primary Key: CCT_CR_PK

1. ROUTE_ID

Foreign Keys to this table:

Comments

Route table.

Indexes

Columns

[top of page]

CCT.CCT_ROUTES does not reference any database object

CCT.CCT_ROUTES is referenced by following:

CCT

VIEW - CCT_ROUTES#

[top of page]

Table: CCT_ROUTE_PARAMS

Primary Key: CCT_CRP_PK

1. ROUTE_PARAM_ID

Foreign Keys from this table:

Comments

Route Parameters Table is used to define parameters for Database Procedures and for Route Rules

Indexes

Columns

[top of page]

CCT.CCT_ROUTE_PARAMS does not reference any database object

CCT.CCT_ROUTE_PARAMS is referenced by following:

CCT

VIEW - CCT_ROUTE_PARAMS#

[top of page]

Table: CCT_ROUTE_PARAMTYPES

Primary Key: CCT_CRPAR_PK

1. ROUTE_PARAMTYPE_ID

Comments

Columns

[top of page]

CCT.CCT_ROUTE_PARAMTYPES does not reference any database object

CCT.CCT_ROUTE_PARAMTYPES is referenced by following:

CCT

VIEW - CCT_ROUTE_PARAMTYPES#

[top of page]

Table: CCT_ROUTING_FILTERS

Primary Key: CCT_RF_PK

1. ROUTING_FILTER_ID

Comments

This table is used to store temporarily the Routing filters for the interaction

Indexes

Columns

[top of page]

CCT.CCT_ROUTING_FILTERS does not reference any database object

CCT.CCT_ROUTING_FILTERS is referenced by following:

CCT

VIEW - CCT_ROUTING_FILTERS#

[top of page]

Table: CCT_ROUTING_RESULTS

Primary Key: CCT_ROUTING_RESULTS_PK

1. ROUTING_RESULT_ID

Comments

This table is used to the store the workflow routing results

Indexes

Columns

[top of page]

CCT.CCT_ROUTING_RESULTS does not reference any database object

CCT.CCT_ROUTING_RESULTS is referenced by following:

CCT

VIEW - CCT_ROUTING_RESULTS#

[top of page]

Table: CCT_ROUTING_SERVERS

Primary Key: CCT_CRS_PK

1. ROUTE_SERVER_ID

Comments

Columns

[top of page]

CCT.CCT_ROUTING_SERVERS does not reference any database object

CCT.CCT_ROUTING_SERVERS is referenced by following:

CCT

VIEW - CCT_ROUTING_SERVERS#

[top of page]

Table: CCT_SERVER_RT_STATS

Primary Key: CCT_CSS_PK

1. SERVER_RT_STAT_ID

Comments

Server Real Time Statistics table

Columns

[top of page]

CCT.CCT_SERVER_RT_STATS does not reference any database object

CCT.CCT_SERVER_RT_STATS is referenced by following:

CCT

VIEW - CCT_SERVER_RT_STATS#

[top of page]

Table: CCT_STATIC_ROUTES

Primary Key: CCT_CSR_PK

1. STATIC_ROUTE_ID

Foreign Keys from this table:

Comments

This table is used to store the Route Destinations

Indexes

Columns

[top of page]

CCT.CCT_STATIC_ROUTES does not reference any database object

CCT.CCT_STATIC_ROUTES is referenced by following:

CCT

VIEW - CCT_STATIC_ROUTES#

[top of page]

Table: CCT_TELESETS

Primary Key: CCT_TELESETS_PK

1. TELESET_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

This table defines a hardware teleset characteristics.

Indexes

Columns

[top of page]

CCT.CCT_TELESETS does not reference any database object

CCT.CCT_TELESETS is referenced by following:

CCT

VIEW - CCT_TELESETS#

[top of page]

Table: CCT_TELESET_TYPES

Primary Key: CCT_TELESET_TYPES_PK

1. TELESET_TYPE_ID

Foreign Keys to this table:

Comments

This table specifies the characteristics of a particular type of telesets.

Indexes

Columns

[top of page]

CCT.CCT_TELESET_TYPES does not reference any database object

CCT.CCT_TELESET_TYPES is referenced by following:

CCT

VIEW - CCT_TELESET_TYPES#

[top of page]

Table: CCT_TEMPAGENTS

Primary Key: CCT_TEMPAGENTS_PK

1. TEMPAGNET_ID

Comments

This table is used by the Routing Server Workflow definitions to keep track of the Agents returned by the nodes

Indexes

Columns