CCT Tables (34)
CCT - Telephony Manager — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
CCT_ADDRESS_BOOKS |
25 | Address Books table for Agent Soft Phone |
CCT_AGENT_INDEXES |
25 | Agent Indexes table. |
CCT_AGENT_RECORDS |
28 | This table keeps track of some agent summary stats. Record is INSERTed when an agent logs out. |
CCT_AGENT_RT_STATS |
35 | This table keeps tracked of logged in agents. |
CCT_CLASSIFICATIONS |
37 | Classifications table. |
CCT_CLASSIFICATION_RULES |
29 | Classification Rules table. |
CCT_CLASSIPROC_PARAMS |
28 | Classification Procedure Paramters table. |
CCT_EVENTS |
37 | This table holds every event that the OTM throws internally. |
CCT_INTERACTION_DEFS |
25 | Call Center Interaction definitions table. |
CCT_INTERACTION_KEYS |
31 | This table lists the predefined Interaction keys for OA Prefs Admin Screen. |
CCT_IVR_CUSTOMER_COLS |
2 | IVR Customer Columns table. |
CCT_IVR_DATA_LABELS |
7 | IVR Data Labels table |
CCT_IVR_MAPS |
32 | This table maps IVR variable names to CCT Interaction Keys |
CCT_IVR_MON_PORTRECORDS |
8 | IVR Monitor Port Records table. |
CCT_IVR_MON_SERVICES |
37 | IVR Monitor Services table. |
CCT_IVR_SERVICES |
15 | IVR Services table. |
CCT_LINES |
31 | This table keeps track of each line's extension/classification. |
CCT_MEDIA_ITEMS |
39 | Call Center Media Item table. |
CCT_MIDDLEWARES |
35 | This table is for holding information needed for interfacing with the switch's middleware. |
CCT_MIDDLEWARE_PARAMS |
31 | This table specifies the specific middleware parameters a middleware needs. |
CCT_MIDDLEWARE_TYPES |
24 | This table lists each middleware type, such as PROSPECT_ASPECT or OPENTEL. |
CCT_MIDDLEWARE_VALUES |
29 | This table holds the parameter values of each defined middleware id |
CCT_PARAMETER_INFOS |
29 | This table is for sql layer parameter info caching. |
CCT_ROUTES |
18 | Route table. |
CCT_ROUTE_PARAMS |
17 | Route Parameters Table is used to define parameters for Database Procedures and for Route Rules |
CCT_ROUTE_PARAMTYPES |
26 | Route Parameter Types table. |
CCT_ROUTING_FILTERS |
25 | This table is used to store temporarily the Routing filters for the interaction |
CCT_ROUTING_RESULTS |
27 | This table is used to the store the workflow routing results |
CCT_ROUTING_SERVERS |
27 | Routing Servers table. |
CCT_SERVER_RT_STATS |
30 | Server Real Time Statistics table |
CCT_STATIC_ROUTES |
12 | This table is used to store the Route Destinations |
CCT_TELESETS |
31 | This table defines a hardware teleset characteristics. |
CCT_TELESET_TYPES |
31 | This table specifies the characteristics of a particular type of telesets. |
CCT_TEMPAGENTS |
26 | This table is used by the Routing Server Workflow definitions to keep track of the Agents returned by the nodes |