Search Results ben_ptip_f




Overview
Explore in AI Chat

Overview

BEN_PTIP_F is a core configuration table within the Oracle Advanced Benefits (BEN) module. Its name expands to "Plan Type in Program," and it functions as the intersection definition that binds a Plan Type (such as Medical, Life, or Disability) to a specific Benefits Program. Each row establishes the rules, eligibility controls, enrollment behaviors, and coverage parameters that govern how a plan type behaves for participants enrolled in a given program. In Oracle EBS 12.1.1 and 12.2.2, this is a dated (non-FND) table using effective dating, meaning every configuration change creates a new versioned row bounded by EFFECTIVE_START_DATE and EFFECTIVE_END_DATE.

The heuristic Data Vault classification mined from the foreign key structure is standalone. From a modeling perspective, this suggests BEN_PTIP_F behaves as an independent, self-contained entity rather than a pure hub, link, or satellite. It carries its own surrogate key, its own effective-dated lifecycle, and a wide set of descriptive attributes, making it closer in pattern to a versioned reference/config entity than to a traditional transactional link.

Key Information Stored

The table is defined with 109 columns. The primary key is BEN_PTIP_F_PK, composed of PTIP_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE. PTIP_ID is the surrogate identifier; the combination of PTIP_ID with the two date columns forms the unique business-key candidate documented in the metadata.

Common Use Cases and Queries

Consultants and developers query BEN_PTIP_F to audit, extract, or extend benefit program configuration. A typical effective-dated lookup resolves the active row for a program and plan type:

  • Extract active plan-type-in-program rows for a business group using WHERE PTIP_STAT_CD = 'A' and SYSDATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE.
  • Join to plan-type and program tables via PL_TYP_ID and PGM_ID to produce a configuration report for benefit administrators.
  • Reconcile DFF segments (CTP_ATTRIBUTE1–30) against custom flexfield definitions for reporting or data migration.
  • Compare effective-dated versions between 12.1.1 and 12.2.2 during upgrades by filtering on EFFECTIVE_START_DATE bands.
  • Drive enrollment diagnostics by checking ENRT_MTHD_CD and ENRT_RL values against participant election data.

Related Objects

BEN_PTIP_F references and is referenced by several core Advanced Benefits objects. The most significant include:

Because BEN_PTIP_F is versioned and standalone, any integration or extension must respect its effective-dating model and use the OBJECT_VERSION_NUMBER for concurrent update protection.