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.
Description: | Address Books table for Agent Soft Phone |
---|
Address Books table for Agent Soft Phone
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ADDRESS_BOOK_ID | NUMBER | Y | Address Book Unique ID | |
AGENT_ID | NUMBER | Agent Id/Resource ID. | ||
CONTACT_POINT_ID | NUMBER | Contact Point Id: Foreign key to HZ_Contacts. | ||
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfields Structure Defining Column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
LAST_UPDATE_DATE | DATE | Standard who column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
CREATION_DATE | DATE | Standard who column | ||
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
CCT.CCT_ADDRESS_BOOKS does not reference any database object
CCT.CCT_ADDRESS_BOOKS is referenced by following:
Description: | Agent Indexes table. |
---|
Agent Indexes table.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AGENT_ID | NUMBER | Y | agent's resource id | |
MCM_SVR_ID | NUMBER | (15) | Y | MCM Server Id. |
AGENT_INDEX | NUMBER | Y | Agent Index Unique ID | |
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfields Structure Defining Column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
CREATION_DATE | DATE | Standard who column | ||
LAST_UPDATE_DATE | DATE | Standard who column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
CCT.CCT_AGENT_INDEXES does not reference any database object
CCT.CCT_AGENT_INDEXES is referenced by following:
Description: | This table keeps track of some agent summary stats. Record is INSERTed when an agent logs out. |
---|
This table keeps track of some agent summary stats. Record is INSERTed when an agent logs out.
Index | Type | Tablespace | Column |
---|---|---|---|
CCT_CAR_U1 | UNIQUE | APPS_TS_TX_IDX |
AGENT_ID
LOGIN_TIME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AGENT_RECORD_ID | NUMBER | Y | OTM. Unique ID. | |
AGENT_ID | NUMBER | COPY. From CCT_AGENT. | ||
LOGIN_TIME | DATE | OTM. Agent Login time. | ||
LOGOUT_TIME | DATE | OTM. Agent Logout time. | ||
OTM_ID | NUMBER | Y | COPY. OTM agent logged into | |
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfields Structure Defining Column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
AGENT_INDEX | NUMBER | Y | Standard who column | |
CREATION_DATE | DATE | Standard who column | ||
LAST_UPDATE_DATE | DATE | Standard who column | ||
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
CCT.CCT_AGENT_RECORDS does not reference any database object
CCT.CCT_AGENT_RECORDS is referenced by following:
Description: | This table keeps tracked of logged in agents. |
---|
This table keeps tracked of logged in agents.
Index | Type | Tablespace | Column |
---|---|---|---|
CCT_AGENTID_U1 | UNIQUE | APPS_TS_TX_IDX | AGENT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AGENT_RT_STAT_ID | NUMBER | Y | Agent RT Stat Unique ID, also used as a unique reference for an agent | |
AGENT_ID | NUMBER | Y | Stores Resource_ID of the Agent | |
CLIENT_ID | NUMBER | Y | COPY. From CCT_CLIENT. Client agent is using. | |
AVAILABLE | VARCHAR2 | (1) | OTM. T/F; T if agent is logged i | |
MCM_ID | NUMBER | Y | COPY. From CCT_OTM. OTM agent is logged into. | |
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfields Structure Defining Column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
GET_WORK | VARCHAR2 | (1) | Is Ready to Get Work | |
HAS_CALL | VARCHAR2 | (1) | Is agent on a call | |
MEDIA_TYPE | NUMBER | (8) | Media Type | |
APP_ID | NUMBER | (15) | App Id | |
RESP_ID | NUMBER | (15) | Responsibility Id | |
FND_USER_ID | NUMBER | (15) | Foreign Key to FND_USERS if the Agent is not defined in JTF_Resource but only a FND USEr | |
EMPLOYEE_ID | NUMBER | (15) | Foreign Key to HR_Employees if the Agent is not defined in JTF_Resource but only a HR Employee | |
PREFERRED_DEVICE_ID | NUMBER | (15) | Foreign key to CCT_AGENT_PREFERRED_DEVICES table, stores the preferred device id used by an agent |
CCT.CCT_AGENT_RT_STATS does not reference any database object
CCT.CCT_AGENT_RT_STATS is referenced by following:
Description: | Classifications table. |
---|
Foreign Key Column | Foreign Table |
---|---|
CCT_CLASSIFICATION_RULES.CLASSIFICATION_ID | CCT_CLASSIFICATIONS |
Classifications table.
Index | Type | Tablespace | Column |
---|---|---|---|
CCT_CLASS_LASTUPDATE_N2 | NONUNIQUE | APPS_TS_TX_IDX | LAST_UPDATE_DATE |
CCT_CLASS_TYPE_N1 | NONUNIQUE | APPS_TS_TX_IDX | TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CLASSIFICATION_ID | NUMBER | (15) | Y | Classification Unique ID. |
TYPE | VARCHAR2 | (32) | Type of Classification : Literal/Database Procedure | |
DBURL | VARCHAR2 | (256) | Database URL for the Classification | |
CLASSIFICATION | VARCHAR2 | (64) | Classification Name | |
TIME_OUT | NUMBER | Time Out for the Queue based on this Classification | ||
ROUTE_ID | NUMBER | Foreign key to Route Id | ||
DB_DRIVER | VARCHAR2 | (256) | This is used to define non oracle DB drivers | |
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfields Structure Defining Column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
CREATED_BY | NUMBER | Standard who column | ||
CREATION_DATE | DATE | Standard who column | ||
LAST_UPDATE_DATE | DATE | Standard who column | ||
LAST_UPDATED_BY | NUMBER | Standard who column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard who column | ||
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | OBJECT_VERSION_NUMBER for AOM web access | |
F_DELETEDFLAG | VARCHAR2 | (240) | Deleted Flag | |
CLASSIFICATION_VALUE_ID | NUMBER | (15) | Classification Value ID - Foreign Key | |
CUSTOM_RULE | VARCHAR2 | (1996) | For Future Use. | |
ISENABLED | VARCHAR2 | (5) | Enabled / Disabled flag. | |
PRIORITY | NUMBER | (15) | Not used. | |
RULE_CHAINING | VARCHAR2 | (32) | Rule Chaning: AND, OR, CUSTOM chains. | |
LOOKUP_TYPE | VARCHAR2 | (256) | customer lookup type |
CCT.CCT_CLASSIFICATIONS does not reference any database object
CCT.CCT_CLASSIFICATIONS is referenced by following:
Description: | Classification Rules table. |
---|
Foreign Key Column | Foreign Table |
---|---|
CCT_CLASSIFICATION_RULES.CLASSIFICATION_ID | CCT_CLASSIFICATIONS |
Classification Rules table.
Index | Type | Tablespace | Column |
---|---|---|---|
CCT_CLASSRULES_LASTUPDATE_N2 | NONUNIQUE | APPS_TS_TX_IDX | LAST_UPDATE_DATE |
CCT_CLASS_ID_N1 | NONUNIQUE | APPS_TS_TX_IDX | CLASSIFICATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CLASSIFICATION_ID | NUMBER | Y | Classification id | |
CLASSIFICATION_RULE_ID | NUMBER | Y | classification Rule Unique ID. | |
KEY | VARCHAR2 | (64) | Key for the Classification Rule | |
VALUE | VARCHAR2 | (64) | Value for the Classification Rule | |
OPERATION | VARCHAR2 | (20) | Operator for the Classification Rule | |
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfields Structure Defining Column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
CREATED_BY | NUMBER | Standard who column | ||
CREATION_DATE | DATE | Standard who column | ||
LAST_UPDATE_DATE | DATE | Standard who column | ||
LAST_UPDATED_BY | NUMBER | Standard who column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard who column | ||
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | OBJECT_VERSION_NUMBER for AOM web access | |
F_DELETEDFLAG | VARCHAR2 | (1) | F_DELETEDFLAG for AOM web access |
CCT.CCT_CLASSIFICATION_RULES does not reference any database object
CCT.CCT_CLASSIFICATION_RULES is referenced by following:
Description: | Classification Procedure Paramters table. |
---|
Classification Procedure Paramters table.
Index | Type | Tablespace | Column |
---|---|---|---|
CCT_CLASSPROC_CLASSID_N1 | NONUNIQUE | APPS_TS_TX_IDX | CLASSIFICATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CLASSIPROC_PARAM_ID | NUMBER | Y | Classiproc Param Unique ID | |
CLASSIFICATION_RULE_ID | NUMBER | Classification Rule Id. | ||
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfields Structure Defining Column | |
CLASSIFICATION_ID | NUMBER | Y | Classification Id. | |
KEY | VARCHAR2 | (64) | Parameter for the Database Procedure | |
VALUE | VARCHAR2 | (64) | Value for the Parameter | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
OPERATION | VARCHAR2 | (20) | Operation. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
CREATION_DATE | DATE | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
CCT.CCT_CLASSIPROC_PARAMS does not reference any database object
CCT.CCT_CLASSIPROC_PARAMS is referenced by following:
Description: | This table holds every event that the OTM throws internally. |
---|
This table holds every event that the OTM throws internally.
Index | Type | Tablespace | Column |
---|---|---|---|
CCT_EVENTID_U1 | UNIQUE | APPS_TS_TX_IDX | EVENT_ID |
CCT_OTMID_N1 | NONUNIQUE | APPS_TS_TX_IDX | OTM_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EVENT_ID | NUMBER | Y | OTM. Unique record id. | |
OTM_ID | NUMBER | Y | COPY. The OTM ID that generated this event | |
NAME | VARCHAR2 | (32) | OTM. The name of the event | |
AGENT_ATG_NUMBER | VARCHAR2 | (32) | COPY. The ID of the Agent Object involved. | |
LINE_INDEX | NUMBER | (2) | COPY. From CCT_LINE. Idx referring to the Line Object | |
LINE_INDEX_2 | NUMBER | (2) | COPY. From CCT_LINE. Idx of 2nd Line Object involved | |
ORIGIN | VARCHAR2 | (32) | OTM. Originating phone number. | |
DESTINATION | VARCHAR2 | (32) | OTM. Destination Phone Number. | |
CLASSIFICATION | VARCHAR2 | (128) | OTM. Specific error/comment classification. | |
EXTENSION | VARCHAR2 | (32) | COPY. Extension number used. From CCT_AGENT/CCT_LINE | |
LINE_IDENTIFICATION | VARCHAR2 | (32) | OTM. Actual name of Line of LINE_INDEX | |
LINE_IDENTIFICATION_2 | VARCHAR2 | (32) | OTM. Actual name of Line2 of LINE_INDEX_2 | |
CALL_IDENTIFICATION | VARCHAR2 | (128) | OTM. OTM Call ID. | |
TIME_DATE | DATE | OTM. Time stamp of the event | ||
TIME_MILLISECOND | VARCHAR2 | (3) | OTM. milliseconds part of time stamp | |
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfields Structure Defining Column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
CCT.CCT_EVENTS does not reference any database object
CCT.CCT_EVENTS is referenced by following:
Description: | Call Center Interaction definitions table. |
---|
Call Center Interaction definitions table.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTERACTION_DEF_ID | VARCHAR2 | (240) | Y | Interaction Def Unique ID. |
SERVER_GROUP_ID | VARCHAR2 | (240) | Id to server group | |
DEFAULT_SCREENPOP_TYPE | VARCHAR2 | (240) | Default Screen pop type | |
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfields Structure Defining Column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
CCT.CCT_INTERACTION_DEFS does not reference any database object
CCT.CCT_INTERACTION_DEFS is referenced by following:
Description: | This table lists the predefined Interaction keys for OA Prefs Admin Screen. |
---|
Foreign Key Column | Foreign Table |
---|---|
CCT_IVR_MAPS.INTERACTION_KEY_ID | CCT_INTERACTION_KEYS |
This table lists the predefined Interaction keys for OA Prefs Admin Screen.
Index | Type | Tablespace | Column |
---|---|---|---|
CCT_INTERACTIONKEYID_U1 | UNIQUE | APPS_TS_SEED | INTERACTION_KEY_ID |
CCT_INTERACTIONKEY_U2 | UNIQUE | APPS_TS_SEED | INTERACTION_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTERACTION_KEY_ID | NUMBER | Y | GUI. Unique ID. | |
DATA_TYPE | VARCHAR2 | (32) | Y | Not used in this release |
INTERACTION_KEY | VARCHAR2 | (32) | USER. Interaction key name | |
FLAG | VARCHAR2 | (32) | XTRA. For future expansion | |
DESCRIPTION | VARCHAR2 | (256) | USER. Description of the key/value pair | |
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfields Structure Defining Column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
PRIORITY | NUMBER | (15) | Priority of the Interaction Key | |
IVR_MAP_ENABLED | VARCHAR2 | (1) | Indicates if this Interaction Key is enalbed for use in IVR | |
ROUTING_ENABLED | VARCHAR2 | (1) | Indicates if interaction key is enabled for Routing & Classification | |
SOFTPHONE_ENABLED | VARCHAR2 | (1) | Indicates if interaction key is enabled for softphone |
CCT.CCT_INTERACTION_KEYS does not reference any database object
CCT.CCT_INTERACTION_KEYS is referenced by following:
Description: | IVR Customer Columns table. |
---|
IVR Customer Columns table.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COLUMN_NAME | VARCHAR2 | (30) | Y | Column Name. |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
CCT.CCT_IVR_CUSTOMER_COLS does not reference any database object
CCT.CCT_IVR_CUSTOMER_COLS is referenced by following:
Description: | IVR Data Labels table |
---|
IVR Data Labels table
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
IVRSERVERNAME | VARCHAR2 | (32) | Y | IVR Server DCE Name. |
IVRDATAPOS | NUMBER | (4) | Y | IVR Data Position. |
IVRDATALABEL | VARCHAR2 | (132) | Y | IVR Data Label |
IVRDATALEN | NUMBER | (4) | Y | IVR Data Length. |
VTT_FIELD_NAME | VARCHAR2 | (30) | VTT Field name. | |
DB_FIELD_NAME | VARCHAR2 | (50) | Database Field name. | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
CCT.CCT_IVR_DATA_LABELS does not reference any database object
CCT.CCT_IVR_DATA_LABELS is referenced by following:
Description: | This table maps IVR variable names to CCT Interaction Keys |
---|
Foreign Key Column | Foreign Table |
---|---|
CCT_IVR_MAPS.INTERACTION_KEY_ID | CCT_INTERACTION_KEYS |
This table maps IVR variable names to CCT Interaction Keys
Index | Type | Tablespace | Column |
---|---|---|---|
CCT_IVRMAPID_U1 | UNIQUE | APPS_TS_TX_IDX | IVR_MAP_ID |
CCT_CALL_IVR_N2 | NONUNIQUE | APPS_TS_TX_IDX |
SERVER_GROUP_ID
MW_ROUTE_POINT_ID |
CCT_CALL_IVR_N4 | NONUNIQUE | APPS_TS_TX_IDX |
IVR_VAR_NAME
SERVER_GROUP_ID |
CCT_INTERACTION_KEY_ID_N2 | NONUNIQUE | APPS_TS_TX_IDX | INTERACTION_KEY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
IVR_MAP_ID | NUMBER | Y | GUI. Unique ID. | |
SEQUENCE | NUMBER | (2) | Not used in this release | |
IVR_VAR_NAME | VARCHAR2 | (32) | Y | USER. IVR variable name |
INTERACTION_KEY_ID | NUMBER | Y | COPY. From CCT_INTERACTION_KEYS. | |
SERVER_GROUP_ID | NUMBER | Y | COPY. From CCT_CALL_CENTER table. | |
FLAG | VARCHAR2 | (32) | XTRA. For future expansion | |
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfields Structure Defining Column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | OBJECT_VERSION_NUMBER for AOM web access | |
F_DELETEDFLAG | VARCHAR2 | (1) | F_DELETEDFLAG for AOM web access | |
MW_ROUTE_POINT_ID | NUMBER | (15) | foreign Key to CCT_MW_ROUTE_POINTS table | |
MIDDLEWARE_ID | NUMBER | (15) | Middleware Id |
CCT.CCT_IVR_MAPS does not reference any database object
CCT.CCT_IVR_MAPS is referenced by following:
Description: | IVR Monitor Port Records table. |
---|
IVR Monitor Port Records table.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXTENSION | VARCHAR2 | (5) | Y | Extension Number. |
PORTTABLENAME | VARCHAR2 | (32) | Y | Port Table Name. |
IVRSERVERNAME | VARCHAR2 | (32) | Y | IVR Server DCE Name. |
MONSERVERNAME | VARCHAR2 | (32) | Y | IVR Monitor Server DCE Name. |
PORTNAME | VARCHAR2 | (10) | Port Name | |
PORTSTATUS | NUMBER | (2) | Port Status | |
PBXNAME | VARCHAR2 | (30) | PBX Name | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
CCT.CCT_IVR_MON_PORTRECORDS does not reference any database object
CCT.CCT_IVR_MON_PORTRECORDS is referenced by following:
Description: | IVR Monitor Services table. |
---|
IVR Monitor Services table.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
IVRSERVERNAME | VARCHAR2 | (32) | Y | IVR Server DCE Name. |
MONSERVERNAME | VARCHAR2 | (32) | Y | IVR Monitor Server DCE Name. |
CTILOGICALID | VARCHAR2 | (128) | CTI Link Logical Id DCE. | |
CTINETWORKTYPE | VARCHAR2 | (128) | CTI Link Network Type | |
CTISERVERNAME | VARCHAR2 | (128) | CTI Server Name | |
MONTCPIPDLLNAME | VARCHAR2 | (32) | IVR MonitorTCP/IP DLL Name | |
MONCTIDLLNAME | VARCHAR2 | (32) | IVR Monitor CTI DLL Name. | |
MONAPPHOSTNAME | VARCHAR2 | (128) | IVR Monitor Application Host Name. | |
MONPORTTABLENAME | VARCHAR2 | (32) | IVR Monitor Port Table Name. | |
MONACTIVETHRESHOLD | NUMBER | (4) | IVR Monitor Active Threshold. | |
MONAPPPORT | NUMBER | (4) | IVR Monitor Application Port | |
MONHOSTNAMELEN | NUMBER | (5) | IVR Monitor Host Name Length | |
MONHOSTNAMEDATAPOS | NUMBER | (5) | IVR Monitor Host Name Data Position. | |
MONPORTDATAPOS | NUMBER | (5) | IVR Monitor Port Data Position. | |
MONKEYDATASIZE | NUMBER | (5) | IVR Monitor Key Data Size. | |
MONRECVDATASIZE | NUMBER | (4) | IVR Monitor Receive Data Size | |
MONLISTENPORT | NUMBER | (5) | IVR Monitor listener Port. | |
MONPERIODICALCLEANUPTIME | NUMBER | (5) | IVR Monitor Periodical Cleanup Time | |
MONRECVDATATHREAD | NUMBER | (5) | IVR Monitor Receive Data Thread. | |
MONRETDATAFLAG | NUMBER | (4) | IVR Monitor Return Data Flag. | |
MONRETDATAPOS | NUMBER | (5) | IVR Monitor Return Data Position. | |
MONRETDATASIZE | NUMBER | (5) | IVR Monitor Return Data Size. | |
MONTOTALPORT | NUMBER | (5) | IVR Monitor Total Port | |
MONTRANSLOWTHRESHOLD | NUMBER | (4) | IVR Monitor Trans Low Threshold. | |
MONTRANSHIGHTHRESHOLD | NUMBER | (4) | IVR Monitor Trans High Threshold. | |
MONFINISHTHRESHOLD | NUMBER | (4) | IVR Monitor Finish Threshold. | |
MONMAXMESSAGEDELAY | NUMBER | (4) | IVR Monitor Max Message Delay. | |
MONVERSAPBXTYPE | NUMBER | (2) | IVR Monitor Versa PBX Type. | |
MONPBXTYPE | VARCHAR2 | (32) | IVR Monitor PBX Type. | |
MONPORTLEN | NUMBER | (5) | IVR Monitor Port Length. | |
MONMSGCLTIME | NUMBER | (5) | IVR Monitor MSGCL Time. | |
MONCONSTIME | NUMBER | (4) | IVR Monitor Cons Time. | |
MONRESTARTTIME | NUMBER | (4) | IVR Monitor Restart Time. | |
MONRETRYLIMIT | NUMBER | (5) | MON Retry Limit. | |
MAXIVR | NUMBER | (5) | MAX IVR. | |
USEUUID | NUMBER | (1) | USEUUID. | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
CCT.CCT_IVR_MON_SERVICES does not reference any database object
CCT.CCT_IVR_MON_SERVICES is referenced by following:
Description: | IVR Services table. |
---|
IVR Services table.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
IVRSERVERNAME | VARCHAR2 | (32) | Y | IVR Server DCE Name. |
IVRDATAPURGETIME | NUMBER | (4) | IVR Data Purge Time. | |
IVRDATASEPARATOR | VARCHAR2 | (1) | IVR Data Separator | |
IVRRECVDATASIZE | NUMBER | (4) | IVR Receive Data Size | |
IVRHASHKEYPOS | NUMBER | (4) | IVR Hash Key Position | |
IVRHASHKEYSIZE | NUMBER | (4) | IVR Hash Key Size | |
IVRTRANSLOGFILEPATH | VARCHAR2 | (132) | IVR Transfer Log File Path. | |
IVRBACKUPPATH | VARCHAR2 | (132) | IVR Backup Path | |
IVRMESSAGEKEYPOS | NUMBER | (5) | IVR Message Key Position. | |
IVRRUNTCPIPFLAG | NUMBER | (1) | IVR Run TCP/IP Flag. | |
IVRLISTENPORT | NUMBER | (5) | IVR Listener Port. | |
IVRRECVTHREADNUM | NUMBER | (2) | IVR RECV Thread Number | |
RUNWITHMONITOR | NUMBER | (1) | Run With IVR Monitor. | |
IVRMAX | NUMBER | (2) | IVR Max | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
CCT.CCT_IVR_SERVICES does not reference any database object
CCT.CCT_IVR_SERVICES is referenced by following:
Description: | This table keeps track of each line's extension/classification. |
---|
Foreign Key Column | Foreign Table |
---|---|
CCT_LINES.TELESET_ID | CCT_TELESETS |
This table keeps track of each line's extension/classification.
Index | Type | Tablespace | Column |
---|---|---|---|
CCT_LINE_ID_U1 | UNIQUE | APPS_TS_TX_IDX | LINE_ID |
CCT_TEL_ID_N1 | NONUNIQUE | APPS_TS_TX_IDX | TELESET_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LINE_ID | NUMBER | Y | GUI. Unique ID. | |
LINE_NAME | VARCHAR2 | (32) | XTRA. A random name. | |
LINE_INDEX | NUMBER | (2) | USER. For Softphone GUI. | |
LINE_PURPOSE | VARCHAR2 | (32) | USER. e.g. External, Internal, ACD | |
EXTENSION | VARCHAR2 | (32) | USER. The extension at this line. | |
TELESET_ID | NUMBER | Y | COPY. Foreign key to CCT_TELESET table. | |
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfields Structure Defining Column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | OBJECT_VERSION_NUMBER for AOM web access | |
F_DELETEDFLAG | VARCHAR2 | (1) | F_DELETEDFLAG for AOM web access | |
CANONICAL_PHONE_NUMBER | VARCHAR2 | (30) | Canonical Phone Number |
CCT.CCT_LINES does not reference any database object
CCT.CCT_LINES is referenced by following:
Description: | Call Center Media Item table. |
---|
Call Center Media Item table.
Index | Type | Tablespace | Column |
---|---|---|---|
SYS_IL0000082219C00015$$ | UNIQUE | APPS_TS_TX_DATA | |
CCT_MI_CLASSIFICATION_N3 | NONUNIQUE | APPS_TS_TX_IDX | CLASSIFICATION |
CCT_MI_MCM_SVR_ID_N2 | NONUNIQUE | APPS_TS_TX_IDX | MCM_SVR_ID |
CCT_MI_MEDIA_ITEM_ID_N1 | NONUNIQUE | APPS_TS_TX_IDX | MEDIA_ITEM_ID |
CCT_MI_MEDIA_TYPE_N4 | NONUNIQUE | APPS_TS_TX_IDX | MEDIA_TYPE |
CCT_MI_SOURCE_ID_N5 | NONUNIQUE | APPS_TS_TX_IDX | SOURCE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SOURCE_ID | VARCHAR2 | (256) | original media id | |
MEDIA_ITEM_ID | NUMBER | Y | Media Item unique IDmedia item id from Interaction History | |
MEDIA_TYPE | NUMBER | (8) | Y | Media Type. |
QUEUE_SEQ_NUM | NUMBER | Y | sequence number used by MCM Queue | |
STATUS | NUMBER | (8) | Y | status used by MCM |
MCM_SVR_ID | NUMBER | (15) | Y | MCM server ID |
CLASSIFICATION | VARCHAR2 | (256) | Y | Classification |
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfields Structure Defining Column | |
FROM_ADDRESS | VARCHAR2 | (512) | from or ani. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
TO_ADDRESS | VARCHAR2 | (512) | to or dnis. | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ROUTE_RESULT | VARCHAR2 | (2000) | compressed route result. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
DATA | BLOB | (4000) | the serialized object. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
COMPRESSED | VARCHAR2 | (4) | Compressed | |
RAWDATA | RAW | (2000) | Raw Data | |
SERVER_GROUP_ID | NUMBER | (15) | Server Group ID | |
QUEUE_POSITION | NUMBER | (15) | QUEUE POSITION | |
JIT_STATUS | VARCHAR2 | (16) | Jit Status | |
JIT_ERR_CODE | NUMBER | (15) | Jit Error Code |
CCT.CCT_MEDIA_ITEMS does not reference any database object
CCT.CCT_MEDIA_ITEMS is referenced by following:
Description: | This table is for holding information needed for interfacing with the switch's middleware. |
---|
Foreign Key Column | Foreign Table |
---|---|
CCT_MIDDLEWARES.MIDDLEWARE_TYPE_ID | CCT_MIDDLEWARE_TYPES |
Foreign Key Column | Foreign Table |
---|---|
CCT_MIDDLEWARE_VALUES.MIDDLEWARE_ID | CCT_MIDDLEWARES |
This table is for holding information needed for interfacing with the switch's middleware.
Index | Type | Tablespace | Column |
---|---|---|---|
CCT_MIDDLEWAREID_U1 | UNIQUE | APPS_TS_TX_IDX | MIDDLEWARE_ID |
CCT_CALL_CONFIG_N2 | NONUNIQUE | APPS_TS_TX_IDX |
SERVER_GROUP_ID
CONFIG_NAME |
CCT_MIDDLEWARE_TYPE_ID_N1 | NONUNIQUE | APPS_TS_TX_IDX | MIDDLEWARE_TYPE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MIDDLEWARE_ID | NUMBER | Y | Middleware Unique ID. | |
SERVER_GROUP_ID | NUMBER | Y | COPY. Foreign key to CCT_CALL_CENTER table | |
CONFIG_NAME | VARCHAR2 | (128) | Y | USER. User defined Name |
MIDDLEWARE_IP_ADDRESS | VARCHAR2 | (128) | USER. DNS Name or IP Address of middleware server | |
MIDDLEWARE_PORT | NUMBER | (5) | USER. IP Port for middleware server | |
EXTRA1 | NUMBER | (6) | Expansion column | |
EXTRA2 | NUMBER | (6) | Expansion column | |
EXTRA3 | NUMBER | (6) | Expansion column | |
EXTRA4 | VARCHAR2 | (128) | Expansion column | |
EXTRA5 | VARCHAR2 | (128) | Expansion column | |
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfields Structure Defining Column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
MIDDLEWARE_TYPE_ID | NUMBER | Y | COPY. Foreign key to CCT_MIDDLEWARE_TYPE table | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | OBJECT_VERSION_NUMBER for AOM web access | |
F_DELETEDFLAG | VARCHAR2 | (1) | F_DELETEDFLAG for AOM web access |
CCT.CCT_MIDDLEWARES does not reference any database object
CCT.CCT_MIDDLEWARES is referenced by following:
Description: | This table specifies the specific middleware parameters a middleware needs. |
---|
Foreign Key Column | Foreign Table |
---|---|
CCT_MIDDLEWARE_PARAMS.MIDDLEWARE_TYPE_ID | CCT_MIDDLEWARE_TYPES |
Foreign Key Column | Foreign Table |
---|---|
CCT_MIDDLEWARE_VALUES.MIDDLEWARE_PARAM_ID | CCT_MIDDLEWARE_PARAMS |
This table specifies the specific middleware parameters a middleware needs.
Index | Type | Tablespace | Column |
---|---|---|---|
CCT_MIDDLEWARE_PARAMS_ID_U1 | UNIQUE | APPS_TS_SEED | MIDDLEWARE_PARAM_ID |
CCT_MID_NAME_U2 | UNIQUE | APPS_TS_SEED |
MIDDLEWARE_TYPE_ID
NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MIDDLEWARE_PARAM_ID | NUMBER | Y | GUI. Unique key. | |
NAME | VARCHAR2 | (32) | USER. Name of the parameter | |
TYPE | VARCHAR2 | (32) | USER. Data type of the parameter | |
LENGTH | VARCHAR2 | (32) | USER. Length of the parameter value | |
DOMAIN_LOOKUP_TYPE | VARCHAR2 | (32) | This is a foreign key to fnd_lookup_types to be used for list of values for this parameter | |
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfields Structure Defining Column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column | |
MIDDLEWARE_TYPE_ID | NUMBER | Y | COPY. Foreign key to CCT_MIDDLEWARE_TYPE | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
OBJECT_VERSION_NUMBER | NUMBER | OBJECT_VERSION_NUMBER for AOM web access | ||
F_DELETEDFLAG | VARCHAR2 | (1) | F_DELETEDFLAG for AOM web access | |
ORDERING_SEQUENCE | NUMBER | (15) | Sequence in which to order Parameters in Web Administration UI |
CCT.CCT_MIDDLEWARE_PARAMS does not reference any database object
CCT.CCT_MIDDLEWARE_PARAMS is referenced by following:
Description: | This table lists each middleware type, such as PROSPECT_ASPECT or OPENTEL. |
---|
Foreign Key Column | Foreign Table |
---|---|
CCT_MIDDLEWARES.MIDDLEWARE_TYPE_ID | CCT_MIDDLEWARE_TYPES |
CCT_MIDDLEWARE_PARAMS.MIDDLEWARE_TYPE_ID | CCT_MIDDLEWARE_TYPES |
This table lists each middleware type, such as PROSPECT_ASPECT or OPENTEL.
Index | Type | Tablespace | Column |
---|---|---|---|
CCT_MIDDLEWARE_TYPE_ID_U1 | UNIQUE | APPS_TS_SEED | MIDDLEWARE_TYPE_ID |
CCT_MIDDLEWARE_TYPE_U2 | UNIQUE | APPS_TS_SEED | MIDDLEWARE_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MIDDLEWARE_TYPE_ID | NUMBER | Y | GUI. Unique middleware type id. | |
MIDDLEWARE_TYPE | VARCHAR2 | (32) | USER. Middleware type name. | |
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfields Structure Defining Column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
CCT.CCT_MIDDLEWARE_TYPES does not reference any database object
CCT.CCT_MIDDLEWARE_TYPES is referenced by following:
Description: | This table holds the parameter values of each defined middleware id |
---|
Foreign Key Column | Foreign Table |
---|---|
CCT_MIDDLEWARE_VALUES.MIDDLEWARE_ID | CCT_MIDDLEWARES |
CCT_MIDDLEWARE_VALUES.MIDDLEWARE_PARAM_ID | CCT_MIDDLEWARE_PARAMS |
This table holds the parameter values of each defined middleware id
Index | Type | Tablespace | Column |
---|---|---|---|
CCT_MIDDLEWARE_VALUES_ID_U1 | UNIQUE | APPS_TS_TX_IDX | MIDDLEWARE_VALUE_ID |
CCT_MWAREPARAMID_VALUES_N2 | NONUNIQUE | APPS_TS_TX_IDX |
MIDDLEWARE_ID
MIDDLEWARE_PARAM_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MIDDLEWARE_VALUE_ID | NUMBER | Y | GUI. Unique ID for this record. | |
VALUE | VARCHAR2 | (256) | USER. Value of this parameter | |
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfields Structure Defining Column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
MIDDLEWARE_PARAM_ID | NUMBER | Y | Middleware Param Id. | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column | |
MIDDLEWARE_ID | NUMBER | Y | COPY. Which middleware is this value for? | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | OBJECT_VERSION_NUMBER for AOM web access | |
F_DELETEDFLAG | VARCHAR2 | (1) | F_DELETEDFLAG for AOM web access | |
NAME | VARCHAR2 | (240) | Backward compatibility Column for 3i |
CCT.CCT_MIDDLEWARE_VALUES does not reference any database object
CCT.CCT_MIDDLEWARE_VALUES is referenced by following:
Description: | This table is for sql layer parameter info caching. |
---|
This table is for sql layer parameter info caching.
Index | Type | Tablespace | Column |
---|---|---|---|
CCT_PARAMETER_INFO_ID_U1 | UNIQUE | APPS_TS_TX_IDX | PARAMETER_INFO_ID |
CCT_PROC_NUM_ARG_U2 | UNIQUE | APPS_TS_TX_IDX |
PROCEDURE_NAME
NUMBER_OF_ARG ARGUMENT_SEQ |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARAMETER_INFO_ID | NUMBER | Y | Unique ID | |
PROCEDURE_NAME | VARCHAR2 | (32) | Y | Proc name |
NUMBER_OF_ARG | NUMBER | (6) | Y | For overloaded procedures |
ARGUMENT_SEQ | NUMBER | (6) | Y | For correct order of argument list |
IN_OUT_TYPE | NUMBER | (11) | Need to store Java int (including '-' sign) | |
DATA_TYPE | NUMBER | (11) | Y | Java int |
SCALE | NUMBER | (6) | scale if this arg is a number | |
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfields Structure Defining Column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
CCT.CCT_PARAMETER_INFOS does not reference any database object
CCT.CCT_PARAMETER_INFOS is referenced by following:
Description: | Route table. |
---|
Foreign Key Column | Foreign Table |
---|---|
CCT_ROUTE_PARAMS.ROUTE_ID | CCT_ROUTES |
CCT_STATIC_ROUTES.ROUTE_ID | CCT_ROUTES |
Route table.
Index | Type | Tablespace | Column |
---|---|---|---|
CCT_ROUTES_LASTUPDATE_N2 | NONUNIQUE | APPS_TS_TX_IDX | LAST_UPDATE_DATE |
CCT_ROUTES_N1 | NONUNIQUE | APPS_TS_TX_IDX | ROUTE_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROUTE_ID | NUMBER | Y | Route Unique ID | |
DESCRIPTION | VARCHAR2 | (256) | Description of the Route | |
NAME | VARCHAR2 | (64) | Name of the Route | |
ROUTE_TYPE | VARCHAR2 | (16) | Type of Route : Static or Dynamic | |
DBURL | VARCHAR2 | (256) | Database URL for Non Oracle Applications Database | |
DEFAULT_ROUTE | VARCHAR2 | (64) | Default Route Destination: A Static or Dynamic Group | |
LAST_UPDATE_DATE | DATE | Standard who column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
CREATION_DATE | DATE | Standard who column | ||
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
PRIORITY | NUMBER | Priority of the Route | ||
DB_DRIVER | VARCHAR2 | (256) | This is used to define non oracle DB drivers | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | OBJECT_VERSION_NUMBER for AOM web access | |
F_DELETEDFLAG | VARCHAR2 | (1) | F_DELETEDFLAG for AOM web access | |
TIME_OUT | NUMBER | (15) | Route Time out | |
ACTIVE_MODE | VARCHAR2 | (16) | Active Mode |
CCT.CCT_ROUTES does not reference any database object
CCT.CCT_ROUTES is referenced by following:
Description: | Route Parameters Table is used to define parameters for Database Procedures and for Route Rules |
---|
Foreign Key Column | Foreign Table |
---|---|
CCT_ROUTE_PARAMS.ROUTE_ID | CCT_ROUTES |
Route Parameters Table is used to define parameters for Database Procedures and for Route Rules
Index | Type | Tablespace | Column |
---|---|---|---|
CCT_ROUTEPARA_LASTUPDATE_N2 | NONUNIQUE | APPS_TS_TX_IDX | LAST_UPDATE_DATE |
CCT_ROUTE_PARAMS_N1 | NONUNIQUE | APPS_TS_TX_IDX | ROUTE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROUTE_PARAM_ID | NUMBER | Y | Route Param Unique ID. | |
ROUTE_ID | NUMBER | Y | Foreign key to Route ID | |
CLASSIFICATION_ID | NUMBER | Unique Classification ID | ||
PARAM | VARCHAR2 | (32) | Name of the parameter | |
DATATYPE | VARCHAR2 | (16) | Datatype of the Parameter | |
DIRECTION | VARCHAR2 | (6) | Direction of the parameter: IN, OUT, IN OUT | |
SEQUENCE | NUMBER | Sequence of the parameter in the Procedure | ||
VALUE | VARCHAR2 | (128) | Value for the parameter | |
LAST_UPDATE_DATE | DATE | Standard who column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
CREATION_DATE | DATE | Standard who column | ||
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | OBJECT_VERSION_NUMBER for AOM web access | |
F_DELETEDFLAG | VARCHAR2 | (1) | F_DELETEDFLAG for AOM web access | |
OPERATION | VARCHAR2 | (32) | Operation condition |
CCT.CCT_ROUTE_PARAMS does not reference any database object
CCT.CCT_ROUTE_PARAMS is referenced by following:
Description: | Route Parameter Types table. |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROUTE_PARAMTYPE_ID | NUMBER | Y | ||
TYPE | VARCHAR2 | (16) | ||
SETMETHOD | VARCHAR2 | (64) | ||
GETMETHOD | VARCHAR2 | (240) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
CONTEXT | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
SECURITY_GROUP_ID | NUMBER |
CCT.CCT_ROUTE_PARAMTYPES does not reference any database object
CCT.CCT_ROUTE_PARAMTYPES is referenced by following:
Description: | This table is used to store temporarily the Routing filters for the interaction |
---|
This table is used to store temporarily the Routing filters for the interaction
Index | Type | Tablespace | Column |
---|---|---|---|
CCT_RF_CALL_ID_N1 | NONUNIQUE | APPS_TS_TX_IDX | CALL_ID |
CCT_RF_FILTER_TYPE_N2 | NONUNIQUE | APPS_TS_TX_IDX | FILTER_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROUTING_FILTER_ID | NUMBER | Y | Routing Filter Unique ID | |
FILTER_TYPE | VARCHAR2 | (32) | Type of the Routing Filter | |
CALL_ID | NUMBER | Call ID for the Filter | ||
LAST_UPDATE_DATE | DATE | Standard who column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
CREATION_DATE | DATE | Standard who column | ||
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfields Structure Defining Column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
CCT.CCT_ROUTING_FILTERS does not reference any database object
CCT.CCT_ROUTING_FILTERS is referenced by following:
Description: | This table is used to the store the workflow routing results |
---|
This table is used to the store the workflow routing results
Index | Type | Tablespace | Column |
---|---|---|---|
CCT_RR_CALL_ID_N1 | NONUNIQUE | APPS_TS_TX_IDX | CALL_ID |
CCT_RR_ITEMKEY_N2 | NONUNIQUE | APPS_TS_TX_IDX | ITEMKEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CALL_ID | VARCHAR2 | (240) | Call ID of the route request | |
ITEMKEY | VARCHAR2 | (240) | Workflow Item key | |
AGENT_ID | VARCHAR2 | (32) | Resource ID | |
SORT_NUM | NUMBER | The sorting order | ||
ROUTING_RESULT_ID | NUMBER | Y | Routing Result Unique ID | |
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfields Structure Defining Column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
CREATION_DATE | DATE | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
CCT.CCT_ROUTING_RESULTS does not reference any database object
CCT.CCT_ROUTING_RESULTS is referenced by following:
Description: | Routing Servers table. |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROUTE_SERVER_ID | NUMBER | Y | ||
ROUTE_SERVER_NAME | VARCHAR2 | (256) | ||
DNS_NAME | VARCHAR2 | (64) | ||
IPADDRES | VARCHAR2 | (64) | ||
PORT | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
CONTEXT | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
SECURITY_GROUP_ID | NUMBER |
CCT.CCT_ROUTING_SERVERS does not reference any database object
CCT.CCT_ROUTING_SERVERS is referenced by following:
Description: | Server Real Time Statistics table |
---|
Server Real Time Statistics table
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SERVER_RT_STAT_ID | NUMBER | Y | Server RT Stat Unique ID. | |
HOST_NAME | VARCHAR2 | (256) | Host Name. | |
IPADDRES | VARCHAR2 | (64) | IP Address. | |
PORT | NUMBER | Port Number. | ||
PUBLISHED_NAME | VARCHAR2 | (256) | RMI published name. | |
SERVER_TYPE | VARCHAR2 | (64) | server type ( OIM , Routing , Email ) | |
SERVER_ID | NUMBER | Server Id. | ||
CONNECTED_AGENTS | VARCHAR2 | (256) | Number of agents connected to OTM/server. | |
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfields Structure Defining Column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
LAST_UPDATE_DATE | DATE | Standard who column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
CREATION_DATE | DATE | Standard who column | ||
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
CCT.CCT_SERVER_RT_STATS does not reference any database object
CCT.CCT_SERVER_RT_STATS is referenced by following:
Description: | This table is used to store the Route Destinations |
---|
Foreign Key Column | Foreign Table |
---|---|
CCT_STATIC_ROUTES.ROUTE_ID | CCT_ROUTES |
This table is used to store the Route Destinations
Index | Type | Tablespace | Column |
---|---|---|---|
CCT_SR_ROUTE_ID_N1 | NONUNIQUE | APPS_TS_TX_IDX | ROUTE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROUTE_ID | NUMBER | Y | Foreign key to Route ID | |
STATIC_ROUTE_ID | NUMBER | Y | Static Route Unique ID. | |
DESTINATION | VARCHAR2 | (64) | Destination for the Route | |
DESCRIPTION | VARCHAR2 | (256) | Description for the Destination | |
LAST_UPDATE_DATE | DATE | Standard who column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
CREATION_DATE | DATE | Standard who column | ||
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | OBJECT_VERSION_NUMBER for AOM web access | |
F_DELETEDFLAG | VARCHAR2 | (1) | F_DELETEDFLAG for AOM web access |
CCT.CCT_STATIC_ROUTES does not reference any database object
CCT.CCT_STATIC_ROUTES is referenced by following:
Description: | This table defines a hardware teleset characteristics. |
---|
Foreign Key Column | Foreign Table |
---|---|
CCT_TELESETS.TELESET_TYPE_ID | CCT_TELESET_TYPES |
Foreign Key Column | Foreign Table |
---|---|
CCT_LINES.TELESET_ID | CCT_TELESETS |
This table defines a hardware teleset characteristics.
Index | Type | Tablespace | Column |
---|---|---|---|
CCT_TELESET_ID_U1 | UNIQUE | APPS_TS_TX_IDX | TELESET_ID |
CCT_CALL_TELE_N1 | NONUNIQUE | APPS_TS_TX_IDX |
TELESET_NAME
SERVER_GROUP_ID TELESET_HARDWARE_NUMBER |
CCT_HARD_CALL_ID_N2 | NONUNIQUE | APPS_TS_TX_IDX |
TELESET_HARDWARE_NUMBER
SERVER_GROUP_ID TELESET_TYPE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TELESET_ID | NUMBER | Y | GUI. Unique ID | |
TELESET_NAME | VARCHAR2 | (32) | USER. User defined name | |
TELESET_HARDWARE_NUMBER | VARCHAR2 | (32) | USER. Hardware ID of the teleset | |
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfields Structure Defining Column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
SERVER_GROUP_ID | NUMBER | Y | COPY. Call Center ID | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
TELESET_TYPE_ID | NUMBER | Y | COPY. From CCT_TELESET_TYPE table | |
CREATION_DATE | DATE | Y | Standard who column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | OBJECT_VERSION_NUMBER for AOM web access | |
F_DELETEDFLAG | VARCHAR2 | (1) | F_DELETEDFLAG for AOM web access | |
MIDDLEWARE_ID | NUMBER | Y | Middleware Unique ID. | |
BRIDGE_EXTN | VARCHAR2 | (1) | Bridge Extn |
CCT.CCT_TELESETS does not reference any database object
CCT.CCT_TELESETS is referenced by following:
Description: | This table specifies the characteristics of a particular type of telesets. |
---|
Foreign Key Column | Foreign Table |
---|---|
CCT_TELESETS.TELESET_TYPE_ID | CCT_TELESET_TYPES |
This table specifies the characteristics of a particular type of telesets.
Index | Type | Tablespace | Column |
---|---|---|---|
CCT_TELESET_TYPE_ID_N1 | NONUNIQUE | APPS_TS_SEED | TELESET_TYPE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TELESET_TYPE_ID | NUMBER | Y | GUI. Unique ID | |
TELESET_NAME | VARCHAR2 | (32) | User defined teleset name | |
NUMBER_OF_LINE | NUMBER | (2) | USER. Number of lines the teleset supprots | |
BUTTON_CONFIG_NUMBER | VARCHAR2 | (32) | XTRA. ID of button configuration | |
TELESET_FEATURE | VARCHAR2 | (32) | XTRA. Teleset features (32 field flag) | |
TELESET_TYPE | VARCHAR2 | (32) | Y | USER. Type name (e.g. ASPECT, MERIDIAN) |
RING_THROUGH | VARCHAR2 | (1) | USER. T/F; Let ACD calls ring through to teleset? | |
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfields Structure Defining Column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
OBJECT_VERSION_NUMBER | NUMBER | OBJECT_VERSION_NUMBER for AOM web access | ||
F_DELETEDFLAG | VARCHAR2 | (1) | F_DELETEDFLAG for AOM web access |
CCT.CCT_TELESET_TYPES does not reference any database object
CCT.CCT_TELESET_TYPES is referenced by following:
Description: | This table is used by the Routing Server Workflow definitions to keep track of the Agents returned by the nodes |
---|
This table is used by the Routing Server Workflow definitions to keep track of the Agents returned by the nodes
Index | Type | Tablespace | Column |
---|---|---|---|
CCT_TA_FILTER_TYPE_N1 | NONUNIQUE | APPS_TS_TX_IDX |
CALL_ID
FILTER_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AGENT_ID | VARCHAR2 | (32) | The resource ID returned by a workflow node | |
CALL_ID | VARCHAR2 | (240) | The call ID corresponding to the Route request | |
FILTER_TYPE | VARCHAR2 | (40) | The kind of filter used to return the Agent set | |
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfields Structure Defining Column | |
TEMPAGNET_ID | NUMBER | Y | Tempagent Unique ID. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
CREATION_DATE | DATE | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
CCT.CCT_TEMPAGENTS does not reference any database object
CCT.CCT_TEMPAGENTS is referenced by following:
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTERACTION_CENTER_ID | NUMBER | Y | Interaction Center Id. | |
CONFIG_NAME | VARCHAR2 | (128) | Y | Configuration Name. |
PARAM_TYPE | VARCHAR2 | (40) | Parameter Name. | |
VALUE_TYPE | VARCHAR2 | (40) | Value Type. |
|
|
Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |