CCT — Telephony Manager
34 documented tables · 1 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
CCT_MIDDLEWARE_TYPES |
This table lists each middleware type, such as PROSPECT_ASPECT or OPENTEL. | hub-leaning |
CCT_ROUTES |
Route table. | hub-leaning |
CCT_TELESET_TYPES |
This table specifies the characteristics of a particular type of telesets. | hub-leaning |
CCT_INTERACTION_KEYS |
This table lists the predefined Interaction keys for OA Prefs Admin Screen. | hub-leaning |
CCT_CLASSIFICATIONS |
Classifications table. | hub-leaning |
CCT_TELESETS |
This table defines a hardware teleset characteristics. | satellite-leaning |
CCT_MIDDLEWARE_PARAMS |
This table specifies the specific middleware parameters a middleware needs. | satellite-leaning |
CCT_MIDDLEWARES |
This table is for holding information needed for interfacing with the switch's middleware. | satellite-leaning |
CCT_AGENT_INDEXES |
Agent Indexes table. | standalone |
CCT_ROUTING_RESULTS |
This table is used to the store the workflow routing results | standalone |
CCT_CLASSIPROC_PARAMS |
Classification Procedure Paramters table. | standalone |
CCT_MEDIA_ITEMS |
Call Center Media Item table. | standalone |
CCT_LINES |
This table keeps track of each line's extension/classification. | satellite-leaning |
CCT_EVENTS |
This table holds every event that the OTM throws internally. | standalone |
CCT_ROUTING_SERVERS |
Routing Servers table. | standalone |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
CCT_INTERACTIONKEYS_PUB |
PUB | 0 | 10 packages |
CCT_COLLECTION_UTIL_PUB |
PUB | 5 | 9 packages |
CCT_IH_PUB |
PUB | 1 | 4 packages |
CCT_MEDIA_TYPES_PUB |
PUB | 1 | 2 packages |
CCT_QDE_PUB |
PUB | 7 | 2 packages |
CCT_HEX_UTIL_PUB |
PUB | 2 | 1 packages |
CCT_CUSTOM_LOOKUP_PUB |
PUB | 1 | 1 packages |
CCT_DEFAULT_LOOKUP_PUB |
PUB | 1 | 1 packages |
CCT_AQ_PUB |
PUB | 7 | 1 packages |
CCT_JTFRESOURCEROUTING_PUB |
PUB | 9 | 1 packages |