Search Results cct_tel_id_n1

Overview

CCT.CCT_LINES is a table in the CCT (Contact Center Telephony) schema of Oracle E-Business Suite, used to store and manage telephony line configuration data for the Oracle Contact Center / Telephony Manager module. The table tracks each individual line's extension, purpose, classification, and associated descriptive flexfield information. It is part of the telephony infrastructure that supports softphone functionality, ACD (Automatic Call Distribution) configurations, and extension management within an Oracle EBS environment running on either 12.1.1 or 12.2.2.

The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, and it maintains two indexes: a unique index (CCT_LINE_ID_U1) on LINE_ID and a non-unique index (CCT_TEL_ID_N1) on TELESET_ID. The table is registered as VALID in the FND Design Data repository under the CCT schema.

Based on the heuristic Data Vault classification derived from its foreign key structure, this table leans toward a satellite classification. It contains descriptive attributes (line name, purpose, extension) that describe a business entity (a teleset line), with its primary key and foreign key relationships anchoring it to parent entities rather than acting as a pure hub or link. This classification serves as a modeling suggestion for data warehouse or analytical integration efforts.

Key Information Stored

The table contains 31 documented columns. The most significant are:

• LINE_ID (NUMBER, Mandatory) — The surrogate primary key and unique identifier for each line. This is the column backed by the CCT_LINE_ID_U1 unique index, which the user searched for. It serves as the single-column business-key candidate for row-level identification.
• LINE_NAME (VARCHAR2, 32) — A descriptive name for the line, described as a random name used internally.
• LINE_INDEX (NUMBER) — An ordering or positional index used by the Softphone GUI to sequence lines.
• LINE_PURPOSE (VARCHAR2, 32) — Classifies the line type, such as External, Internal, or ACD.
• EXTENSION (VARCHAR2, 32) — The telephony extension assigned to the line.
• TELESET_ID (NUMBER) — A foreign key referencing the CCT_TELESETS table, linking each line to its parent teleset. This column is indexed by CCT_TEL_ID_N1.
• CONTEXT (VARCHAR2, 30) — The descriptive flexfield structure defining column, enabling extensible attribute support.
• ATTRIBUTE1 through ATTRIBUTE15 (VARCHAR2, 150 each) — Descriptive flexfield segment columns for storing user-defined data.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard WHO columns for auditing record creation and modification history.
• SECURITY_GROUP_ID (NUMBER) — Foreign key to FND_SECURITY_GROUPS, enforcing multi-tenant or organizational data isolation.
• OBJECT_VERSION_NUMBER — Supports optimistic locking during concurrent updates.
• CANONICAL_PHONE_NUMBER — Stores the normalized phone number representation for the line.
• F_DELETEDFLAG — A soft-delete indicator used to logically mark records as removed without physical deletion.

Common Use Cases and Queries

Typical use cases include querying all lines associated with a specific teleset, identifying ACD-configured lines, or reporting on extension assignments across a contact center deployment.

• Retrieve lines by teleset: SELECT l.line_id, l.line_name, l.extension, l.line_purpose FROM cct.cct_lines l WHERE l.teleset_id = :teleset_id; — This leverages the CCT_TEL_ID_N1 non-unique index.
• Look up a specific line by its primary key: SELECT * FROM cct.cct_lines WHERE line_id = :line_id; — Uses the unique index CCT_LINE_ID_U1.
• Filter by purpose: SELECT line_id, extension, line_name FROM cct.cct_lines WHERE line_purpose = 'ACD';
• Flexfield-based reporting: Query on ATTRIBUTE columns for user-defined classifications or integration points.
• Security-restricted access: Join on SECURITY_GROUP_ID to enforce data visibility rules in multi-org configurations.

These queries are useful for telephony administrators, reporting analysts, and integration developers building custom dashboards or data extracts.

Related Objects

The following objects are most significant in relation to CCT.CCT_LINES:

• CCT.CCT_TELESETS — The parent teleset table. CCT_LINES.TELESET_ID references this table, establishing a master-detail relationship between telesets and their lines.
• FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID, this table controls data security and access isolation.
• FND_DESCR_FLEX_COL_USAGE and FND_DESCR_FLEX_CONTEXTS — Define the descriptive flexfield structure referenced by the CONTEXT column.
• CCT_LINES_PK — The primary key constraint defined on LINE_ID, enforcing uniqueness at the database level.
• CCT_LINE_ID_U1 — The unique index on LINE_ID, referenced in the user's search.
• CCT_TEL_ID_N1 — The non-unique index on TELESET_ID, supporting join and filter operations.

Integration with Oracle Telephony Manager and Softphone GUI components depends on this table for line resolution and routing decisions, making it a foundational object within the CCT schema.