Results for “ben_prtt_enrt_rslt_f”

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

Overview

The BEN.BEN_PRTT_ENRT_RSLT_F table is a core data object within the Oracle Advanced Benefits (BEN) module of Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the results of the participant enrollment process, specifically the compensation objects (benefit plans, programs, and options) in which a participant is enrolled. Each row represents an enrollment result record that captures the outcome of eligibility and enrollment processing for a given participant, plan, and effective time period.

The table is owned by the BEN schema and holds 77 documented columns. Its primary key is defined by BEN_PRTT_ENRT_RSLT_F_PK, which is composed of the surrogate identifier together with the effective date range. From a Data Vault modeling perspective, the FK and uniqueness structure suggests this table is satellite-leaning, meaning it is best treated as a descriptive, time-variant satellite attached to a participant-enrollment hub/business key rather than as a pure hub or link. The primary foreign key relationship is from PER_IN_LER_ID to BEN_PER_IN_LER, tying each enrollment result to a person's life event record.

Key Information Stored

The most significant columns capture the identity of the enrollment, its temporal validity, and the benefit objects involved:

• PRTT_ENRT_RSLT_ID — surrogate identifier for the enrollment result; the lead PK column.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — date-effective range; together with the ID these form the unique business-key candidate (index BEN_PRTT_ENRT_RSLT_PK).
• PER_IN_LER_ID — foreign key to BEN_PER_IN_LER, linking the result to the person's life-event record.
• PERSON_ID — the participant to whom the enrollment belongs.
• PL_ID / PL_TYP_ID / PGM_ID / OIPL_ID / PTIP_ID — identifiers for the plan, plan type, program, option-in-plan, and plan-type-in-program context.
• ENRT_CVG_STRT_DT / ENRT_CVG_THRU_DT — coverage start and end dates for the enrollment.
• PRTT_ENRT_RSLT_STAT_CD — status of the enrollment result.
• SSPNDD_FLAG / PRTT_IS_CVRD_FLAG / NO_LNGR_ELIG_FLAG — flags indicating suspension, coverage, and loss of eligibility.
• ENRT_MTHD_CD / ENRT_OVRIDN_FLAG — enrollment method and override indicator.
• BNFT_AMT / BNFT_TYP_CD / UOM — benefit amount, benefit type, and unit of measure where compensation applies.
• LAST_UPDATE_DATE, CREATED_BY, OBJECT_VERSION_NUMBER — standard concurrent/audit and optimistic-locking columns.

Common Use Cases and Queries

This table is typically queried for enrollment reporting, coverage verification, and benefits reconciliation. A common pattern joins it to the life-event table to retrieve a participant's active enrollments:

• Active coverage reporting: select enrollments where the coverage dates bracket the reporting period and PRTT_IS_CVRD_FLAG indicates coverage.
• Suspension and eligibility audits: filter on SSPNDD_FLAG or NO_LNGR_ELIG_FLAG to surface exceptions.
• Point-in-time "as-of" queries using EFFECTIVE_START_DATE and EFFECTIVE_END_DATE for historic enrollment reconstruction.
• Reconciling benefit amounts via BNFT_AMT against payroll or carrier feeds.

A representative join is: SELECT r.* FROM ben.ben_prtt_enrt_rslt_f r, ben.ben_per_in_ler l WHERE r.per_in_ler_id = l.per_in_ler_id AND r.person_id = :person_id.

Related Objects

The most significant related objects, based on the documented foreign key and key structure, include:

• BEN_PER_IN_LER — joined via PER_IN_LER_ID; the primary referenced parent table.
• BEN_PRTT_ENRT_RSLT — the base (non "_F") enrollment result table sharing the same business key.
• Plan, program, and option definition tables referenced by PL_ID, PGM_ID, OIPL_ID, and PTIP_ID.
• Person/assignment tables referenced by PERSON_ID and ASSIGNMENT_ID.
• Benefits enrollment APIs and concurrent processes that write and maintain these result rows during eligibility and enrollment runs.