Search Results cct_teleset_types_pk

Overview

CCT_TELESET_TYPES is a configuration table owned by the CCT (Telephony Manager) schema in Oracle E-Business Suite. As stated in the ETRM documentation, the table "specifies the characteristics of a particular type of telesets." It therefore functions as the master definition of telephony device types available for use within the Telephony Manager module, providing the template of functional attributes — line capacity, button configuration, ring-through behavior, and feature sets — that governs how individual telesets are provisioned and operated.

From a Data Vault modeling perspective, the mined foreign key structure classifies this table as hub-leaning. Its role as a parent of CCT_TELESETS and its stable, keyed identity (the TELESET_TYPE_ID surrogate) support modeling the object as a hub, with its descriptive attributes (name, line count, feature flags) handled as satellite attributes. In Oracle EBS 12.1.1 and 12.2.2 the table is registered as VALID and is part of the standard CCT product installation.

Key Information Stored

The table contains 31 documented columns in the 12.2.2 physical schema. The most significant are:

• TELESET_TYPE_ID — the surrogate primary key, defined by constraint CCT_TELESET_TYPES_PK. This value is propagated to child records in CCT_TELESETS.
• TELESET_NAME — the descriptive name used to present the teleset type to users and in setups.
• TELESET_TYPE — the classifying code that distinguishes one teleset type from another.
• NUMBER_OF_LINE — the number of lines supported by the device type.
• BUTTON_CONFIG_NUMBER — the button layout associated with the teleset model.
• TELESET_FEATURE — the supported feature set for the device type.
• RING_THROUGH — controls ring-through behavior for the teleset type.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, enforcing multi-org/security-group access control.
• CONTEXT and ATTRIBUTE1 through ATTRIBUTE15 — the standard EBS flexfield (Descriptive Flexfield) columns for extensible attributes.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard WHO audit columns.
• OBJECT_VERSION_NUMBER — optimistic locking version for concurrent update control.
• F_DELETEDFLAG — soft-delete / logical delete indicator.

None of the documented indexes beyond the primary key are provided; TELESET_NAME and TELESET_TYPE are the typical business-key candidates for lookup.

Common Use Cases and Queries

Typical scenarios include validating which teleset types are defined, reporting lines-per-device, and joining type-level attributes to individually provisioned telesets.

• List all active teleset types:
  SELECT TELESET_TYPE_ID, TELESET_NAME, TELESET_TYPE, NUMBER_OF_LINE FROM CCT.CCT_TELESET_TYPES WHERE F_DELETEDFLAG = 0;
• Join type to provisioned telesets:
  SELECT t.TELESET_NAME, s.* FROM CCT.CCT_TELESET_TYPES t, CCT.CCT_TELESETS s WHERE t.TELESET_TYPE_ID = s.TELESET_TYPE_ID;
• Feature/ring-through reporting filtered by RING_THROUGH or TELESET_FEATURE for configuration audits.
• Security-group scoped lookups joining SECURITY_GROUP_ID to FND_SECURITY_GROUPS for access-restricted reports.

Related Objects

• CCT_TELESETS — the principal child table; CCT_TELESETS.TELESET_TYPE_ID references CCT_TELESET_TYPES.TELESET_TYPE_ID.
• FND_SECURITY_GROUPS — referenced via CCT_TELESET_TYPES.SECURITY_GROUP_ID.
• CCT_TELESET_TYPES_PK — the primary key constraint used in joins and lookups.
• Standard EBS flexfield and WHO audit infrastructure that consumes CONTEXT, ATTRIBUTE1–ATTRIBUTE15, and the audit/version columns.

Because the teleset type underpins teleset provisioning, changes to this table directly affect downstream telephony configuration in the CCT module.