Results for “ttee_person_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

BEN_PL_BNF is an APPS-owned database view within the BEN (Advanced Benefits) product module of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It exposes designation and beneficiary assignment data captured against a participant's enrollment result, presenting one row per plan beneficiary designation record as of the effective date of the current user session. The view is characterized in ETRM as "Retrofitted," indicating that it was re-pointed onto a date-effective (datetrack) base table, BEN_PL_BNF_F, rather than a legacy non-datetracked physical table.

Because the view applies the session-effective-date predicate internally, consumers do not need to supply their own datetrack WHERE clause to obtain the record version in force at the time of the query. This makes BEN_PL_BNF a convenient reporting and integration surface for beneficiary, dependent-designation, and contingent-annuitant information. The column TTEE_PERSON_ID, which is the field the user searched for, is the trustee person identifier carried on the designation record and is central to these reporting scenarios.

Underlying Base Objects

The view is defined over three documented base objects, all referenced through APPS synonyms:

• BEN_PL_BNF_F — the primary datetrack-enabled beneficiary designation table (aliased PBN). It is the outer table in the join and supplies all columns projected by the view, including TTEE_PERSON_ID.
• BEN_PER_IN_LER — the person interest/learner eligibility record (aliased PIL). It is joined with an outer join (+) on PER_IN_LER_ID and BUSINESS_GROUP_ID, and serves to filter out designations whose interest status is 'VOIDD' (voided) or 'BCKDT' (back-dated). Rows with a NULL status, or with no matching BEN_PER_IN_LER row, are retained.
• FND_SESSIONS — the standard EBS session table, used twice in scalar subqueries to retrieve EFFECTIVE_DATE for the current USERENV('SESSIONID'). This drives the effective_start_date/effective_end_date range predicate.

The resulting semantics are therefore a session-aware, status-filtered projection of the current datetracked version of each plan beneficiary designation.

Key Columns

• PL_BNF_ID — primary key of the designation record.
• TTEE_PERSON_ID — trustee person identifier associated with the designation; the subject of the originating search.
• BNF_PERSON_ID — the beneficiary person identifier.
• ORGANIZATION_ID — the organization receiving the designation where the party is an organization rather than a person.
• PRTT_ENRT_RSLT_ID — the participant enrollment result against which the designation was created, linking the row to the enrollment snapshot.
• PRMRY_CNTNGNT_CD — code indicating whether the designation is primary or contingent.
• PCT_DSGD_NUM, AMT_DSGD_VAL, AMT_DSGD_UOM — the percentage, monetary amount, and unit of measure assigned to the designation.
• DSGN_STRT_DT, DSGN_THRU_DT — the designation's own validity window, distinct from the datetrack effective dates.
• EFFECTIVE_START_DATE, EFFECTIVE_END_DATE — datetrack columns resolved to the session effective date.
• PER_IN_LER_ID — the joined person-interest eligibility identifier.
• Standard WHO columns (LAST_UPDATE_DATE, CREATED_BY, CREATION_DATE), REQUEST_ID, PROGRAM_ID and related concurrent-program columns, plus PBN_ATTRIBUTE1 through PBN_ATTRIBUTE30 for descriptive flexfield segments.

Common Use Cases and Queries

Typical uses include beneficiary listing reports per enrollment, validation of trustee assignments, and extracts feeding downstream payroll or carrier interfaces. A representative query returning current designations for a given trustee is:

SELECT PL_BNF_ID, TTEE_PERSON_ID, BNF_PERSON_ID, PRMRY_CNTNGNT_CD, PCT_DSGD_NUM
FROM BEN_PL_BNF
WHERE TTEE_PERSON_ID = :p_person_id;

Because the session predicate is embedded, this returns only the designation version effective on the current FND_SESSIONS effective date. Callers must therefore ensure the session context is initialized; concurrent-program and OAF contexts set it automatically, while ad-hoc SQL run outside a session may receive unexpected date resolution. To return a designation tied to a specific enrollment, filter on PRTT_ENRT_RSLT_ID. To exclude voided or back-dated interests, no additional predicate is required, since the view already applies the PER_IN_LER_STAT_CD exclusion.