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

Description: Address Books table for Agent Soft Phone
Primary Key: CCT_CAB_PK
  1. ADDRESS_BOOK_ID
Primary Key: CCT_CAB_UK1
  1. AGENT_ID

[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

Description: Agent Indexes table.
Primary Key: CCT_CAI_PK
  1. AGENT_INDEX
Primary Key: CCT_CAI_UK
  1. MCM_SVR_ID
  2. AGENT_ID

[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

Description: This table keeps track of some agent summary stats. Record is INSERTed when an agent logs out.
Primary Key: CCT_CAR_PK
  1. AGENT_RECORD_ID

[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

Description: This table keeps tracked of logged in agents.
Primary Key: CCT_CAS_PK
  1. AGENT_RT_STAT_ID

[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

Description: Classifications table.
Primary Key: CCT_CCL_PK
  1. CLASSIFICATION_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CCT_CLASSIFICATION_RULES.CLASSIFICATION_ID CCT_CLASSIFICATIONS

[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

Description: Classification Rules table.
Primary Key: CCT_CCR_PK
  1. CLASSIFICATION_RULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CCT_CLASSIFICATION_RULES.CLASSIFICATION_ID CCT_CLASSIFICATIONS

[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

Description: Classification Procedure Paramters table.
Primary Key: CCT_CPA_PK
  1. CLASSIPROC_PARAM_ID

[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

Description: This table holds every event that the OTM throws internally.
Primary Key: CCT_EVENTS_PK
  1. EVENT_ID

[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

Description: Call Center Interaction definitions table.
Primary Key: CCT_INTERACTION_DEFS_PK
  1. INTERACTION_DEF_ID

[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

Description: This table lists the predefined Interaction keys for OA Prefs Admin Screen.
Primary Key: CCT_INTERACTION_KEYS_PK
  1. INTERACTION_KEY_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CCT_IVR_MAPS.INTERACTION_KEY_ID CCT_INTERACTION_KEYS

[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

Description: IVR Customer Columns table.

[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

Description: IVR Data Labels table

[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

Description: This table maps IVR variable names to CCT Interaction Keys
Primary Key: CCT_IVR_MAPS_PK
  1. IVR_MAP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CCT_IVR_MAPS.INTERACTION_KEY_ID CCT_INTERACTION_KEYS

[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

Description: IVR Monitor Port Records table.

[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

Description: IVR Monitor Services table.

[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

Description: IVR Services table.

[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

Description: This table keeps track of each line's extension/classification.
Primary Key: CCT_LINES_PK
  1. LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CCT_LINES.TELESET_ID CCT_TELESETS

[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

Description: Call Center Media Item table.
Primary Key: CCT_CMI_PK
  1. MEDIA_ITEM_ID
Primary Key: CCT_CMI_UK1
  1. MCM_SVR_ID
  2. QUEUE_SEQ_NUM

[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

Description: This table is for holding information needed for interfacing with the switch's middleware.
Primary Key: CCT_MIDDLEWARES_PK
  1. MIDDLEWARE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CCT_MIDDLEWARES.MIDDLEWARE_TYPE_ID CCT_MIDDLEWARE_TYPES
Foreign Keys to this table:
Foreign Key Column Foreign Table
CCT_MIDDLEWARE_VALUES.MIDDLEWARE_ID CCT_MIDDLEWARES

[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

Description: This table specifies the specific middleware parameters a middleware needs.
Primary Key: CCT_MIDDLEWARE_PARAMS_PK
  1. MIDDLEWARE_PARAM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CCT_MIDDLEWARE_PARAMS.MIDDLEWARE_TYPE_ID CCT_MIDDLEWARE_TYPES
Foreign Keys to this table:
Foreign Key Column Foreign Table
CCT_MIDDLEWARE_VALUES.MIDDLEWARE_PARAM_ID CCT_MIDDLEWARE_PARAMS

[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

Description: This table lists each middleware type, such as PROSPECT_ASPECT or OPENTEL.
Primary Key: CCT_CMT_PK
  1. MIDDLEWARE_TYPE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CCT_MIDDLEWARES.MIDDLEWARE_TYPE_ID CCT_MIDDLEWARE_TYPES
CCT_MIDDLEWARE_PARAMS.MIDDLEWARE_TYPE_ID CCT_MIDDLEWARE_TYPES

[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

Description: This table holds the parameter values of each defined middleware id
Primary Key: CCT_CMV_PK
  1. MIDDLEWARE_VALUE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CCT_MIDDLEWARE_VALUES.MIDDLEWARE_ID CCT_MIDDLEWARES
CCT_MIDDLEWARE_VALUES.MIDDLEWARE_PARAM_ID CCT_MIDDLEWARE_PARAMS

[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

Description: This table is for sql layer parameter info caching.
Primary Key: CCT_PARAMETER_INFOS_PK
  1. PARAMETER_INFO_ID

[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

Description: Route table.
Primary Key: CCT_CR_PK
  1. ROUTE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CCT_ROUTE_PARAMS.ROUTE_ID CCT_ROUTES
CCT_STATIC_ROUTES.ROUTE_ID CCT_ROUTES

[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

Description: Route Parameters Table is used to define parameters for Database Procedures and for Route Rules
Primary Key: CCT_CRP_PK
  1. ROUTE_PARAM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CCT_ROUTE_PARAMS.ROUTE_ID CCT_ROUTES

[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

Description: Route Parameter Types table.
Primary Key: CCT_CRPAR_PK
  1. ROUTE_PARAMTYPE_ID

[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

Description: This table is used to store temporarily the Routing filters for the interaction
Primary Key: CCT_RF_PK
  1. ROUTING_FILTER_ID

[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

Description: This table is used to the store the workflow routing results
Primary Key: CCT_ROUTING_RESULTS_PK
  1. ROUTING_RESULT_ID

[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

Description: Routing Servers table.
Primary Key: CCT_CRS_PK
  1. ROUTE_SERVER_ID

[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

Description: Server Real Time Statistics table
Primary Key: CCT_CSS_PK
  1. SERVER_RT_STAT_ID

[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

Description: This table is used to store the Route Destinations
Primary Key: CCT_CSR_PK
  1. STATIC_ROUTE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CCT_STATIC_ROUTES.ROUTE_ID CCT_ROUTES

[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

Description: This table defines a hardware teleset characteristics.
Primary Key: CCT_TELESETS_PK
  1. TELESET_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CCT_TELESETS.TELESET_TYPE_ID CCT_TELESET_TYPES
Foreign Keys to this table:
Foreign Key Column Foreign Table
CCT_LINES.TELESET_ID CCT_TELESETS

[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

Description: This table specifies the characteristics of a particular type of telesets.
Primary Key: CCT_TELESET_TYPES_PK
  1. TELESET_TYPE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CCT_TELESETS.TELESET_TYPE_ID CCT_TELESET_TYPES

[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

Description: This table is used by the Routing Server Workflow definitions to keep track of the Agents returned by the nodes
Primary Key: CCT_TEMPAGENTS_PK
  1. TEMPAGNET_ID

[top of page]

CCT.CCT_TEMPAGENTS does not reference any database object

CCT.CCT_TEMPAGENTS is referenced by following:

CCT
VIEW - CCT_TEMPAGENTS#

[top of page]

View: CCT_MIDDLEWARES_V

[top of page]

APPS.CCT_MIDDLEWARES_V references the following:

APPS
SYNONYM - CCT_MIDDLEWARES
APPS.CCT_MIDDLEWARES_V is referenced by following:

APPS
VIEW - JTF_RS_RESOURCE_VALUES_VL

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract