Search Results ben_cmbn_ptip_f




Overview
Explore in AI Chat

Overview

BEN_CMBN_PTIP_F is a table in the BEN (Advanced Benefits) schema within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the combinations of plan types that participate in a benefit program which may provide credits to enrolling participants. In Oracle Advanced Benefits, a program (PGM) can group plan types together, and where those plan types are eligible to generate credits for a participant, the specific combination is recorded in this table. This enables the credit calculation engine to determine whether a given participant's enrollment across a set of plan types qualifies for a credit within a particular program.

The table is a date-tracked (effective-dated) entity. The columns EFFECTIVE_START_DATE and EFFECTIVE_END_DATE form part of the primary key, which supports the "F" suffix convention used throughout BEN for date-effective tables. The heuristic Data Vault classification mined from the foreign-key structure is standalone, meaning the table is not heavily linked to parent entities through enforced foreign keys and may be modeled as an independent hub or reference structure rather than a dependent satellite.

Key Information Stored

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

  • CMBN_PTIP_ID — Surrogate identifier for the combination of plan types within a program. It is the first component of the primary key BEN_CMBN_PTIP_F_PK.
  • EFFECTIVE_START_DATE and EFFECTIVE_END_DATE — Date-effective range defining the validity window of the combination. Together with CMBN_PTIP_ID they form the composite primary key and the unique business-key candidate.
  • NAME — Descriptive name of the plan type combination.
  • BUSINESS_GROUP_ID — Identifies the business group (enterprise) that owns the record.
  • PGM_ID — The benefit program to which the plan type combination belongs; this is the principal operational foreign key linking to the program definition.
  • CBP_ATTRIBUTE_CATEGORY and CBP_ATTRIBUTE1 through CBP_ATTRIBUTE30 — The standard Oracle descriptive flexfield (DFF) structure, allowing customers to extend the entity with additional context-sensitive attributes.
  • OBJECT_VERSION_NUMBER — Used by the Oracle Application Framework for optimistic locking during concurrent updates.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — Standard WHO audit columns tracking record creation and modification.

Common Use Cases and Queries

Typical reporting and data validation scenarios include identifying which plan type combinations are active for a given program on a specific date, and auditing credit-eligible configurations. A representative query retrieves current combinations for a program:

  • SELECT CMBN_PTIP_ID, NAME, PGM_ID FROM BEN.BEN_CMBN_PTIP_F WHERE PGM_ID = :pgm_id AND TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
  • Reconstructing historical configurations by querying a past effective date range, useful for payback and credit audits.
  • Joining to BEN_PGM_F on PGM_ID to retrieve the parent program name and business group context.
  • Extracting DFF values from CBP_ATTRIBUTE_CATEGORY and CBP_ATTRIBUTE1–30 for downstream integrations.

Related Objects

  • BEN_PGM_F — Parent benefit program definition, joined on PGM_ID.
  • BEN_CMBN_PTIP_PT_F — Child table mapping each combination to its constituent plan types.
  • BEN_PTIP_F — Plan type definitions referenced by the combination.
  • BEN_PGM_PTIP_F — Associates plan types with programs and is adjacent in the credit-eligibility model.
  • HCM/BEN credit calculation APIs — Packages such as BEN_CREDIT_CALC that consume these combinations during enrollment processing.