Search Results ben_enrt_rt_ctfn




Overview
Explore in AI Chat

Overview

BEN_ENRT_RT_CTFN is a transactional table in the Oracle Advanced Benefits (BEN) module that stores certification requirements associated with enrollment rates. In Oracle EBS 12.1.1 and 12.2.2, benefits administrators often require employees to provide supporting documentation — such as a marriage certificate, dependent birth certificate, or proof of student status — before a specific enrollment rate can be assigned or processed. This table captures those certification requirements at the enrollment rate level, linking each rate to the type of certification demanded and whether the certification is mandatory.

From a data modeling perspective, the mined Data Vault classification for this object is standalone, which suggests it functions as a satellite-style record holding descriptive attributes about a certification requirement tied to a parent enrollment rate. It is not a true hub because it does not represent an independent business entity key; instead, it hangs off the enrollment rate through the ENRT_RT_ID foreign key.

Key Information Stored

The table contains 46 documented columns. The most operationally significant are:

The documented unique index BEN_ENRT_RT_CTFN_PK on ENRT_RT_CTFN_ID serves as the business-key candidate for this table.

Common Use Cases and Queries

Typical reporting scenarios include determining which rates require certification, validating that required certifications exist before enrollment is finalized, and reconciling certifications per plan or program. A representative query joining to the parent rate table:

  • SELECT c.ENRT_RT_CTFN_ID, c.ENRT_RT_ID, c.ENRT_CTFN_TYP_CD, c.RQD_FLAG FROM BEN.BEN_ENRT_RT_CTFN c WHERE c.BUSINESS_GROUP_ID = :p_bg_id AND c.RQD_FLAG = 'Y';
  • SELECT c.* FROM BEN.BEN_ENRT_RT_CTFN c, BEN.BEN_ENRT_RT r WHERE c.ENRT_RT_ID = r.ENRT_RT_ID AND r.ENRT_RT_ID = :p_rate_id;

Because RQD_FLAG and ENRT_CTFN_TYP_CD are frequently filtered, indexed access paths on the ENRT_RT_ID foreign key column are important for performance in these joins.

Related Objects

The table sits within the BEN schema and participates in a relatively narrow relationship footprint:

  • BEN_ENRT_RT — Parent object; joined via ENRT_RT_ID. This is the primary and only documented foreign key relationship.
  • BEN_ENRT_RT_CTFN_PK — The unique index enforcing the surrogate primary key.
  • Benefits enrollment APIs — PL/SQL packages that preside over enrollment processing consult this table to enforce certification prerequisites.
  • Flexfield definition views — The ERC_ATTRIBUTE columns are surfaced through standard descriptive flexfield views for reporting.
  • Concurrent program reports — Audit and certification compliance reports read this table alongside BEN_ENRT_RT and related enrollment tables.

Given the standalone classification, integrators should treat BEN_ENRT_RT_CTFN as a dependent child record whose lifecycle is governed by the parent enrollment rate.