Search Results ben_bnft_prvdd_ldgr_f

Overview

The BEN_BNFT_PRVDD_LDGR_F table is a core transactional object within the Oracle E-Business Suite Advanced Benefits (BEN) module, specifically for versions 12.1.1 and 12.2.2. It functions as the benefit pool ledger, tracking the allocation, consumption, and balance of benefit entitlements for participants. This table is essential for managing defined contribution or flexible spending account (FSA) style benefits where a participant has a finite pool of resources (e.g., monetary credits, hours) to allocate across various benefit options. Its role is to maintain a precise, auditable history of all transactions affecting a participant's benefit pool over time, supporting the complex calculations and reporting required for benefits administration.

Key Information Stored

The table is structured as an effective-dated (date-tracked) table, a standard Oracle EBS design for maintaining historical data. The primary key uniquely identifies a ledger entry across time using the combination of BNFT_PRVDD_LDGR_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE. Key columns include the unique identifier (BNFT_PRVDD_LDGR_ID), the effective date range columns for historical tracking, and the PER_IN_LER_ID foreign key column. This foreign key links each ledger entry to a specific participant's life event record (in BEN_PER_IN_LER), which is the enrollment transaction that triggered the pool creation or modification. Other typical columns in such a ledger table—though not explicitly listed in the provided metadata—would include fields for the benefit pool type, initial allocation amount, consumed amount, current balance, and transaction codes.

Common Use Cases and Queries

This table is central to reporting on benefit utilization and performing audits. A common use case is generating a statement of benefits for an employee, showing their initial allocation, any elections made, and the remaining balance. Another critical scenario is during the enrollment process, where the system must query this ledger to validate that a participant's new election does not exceed their available pool balance. A typical reporting query would join BEN_BNFT_PRVDD_LDGR_F to BEN_PER_IN_LER and person tables to analyze pool usage by employee, organization, or benefit type. For current balances, queries filter on SYSDATE between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE. Data fixes or adjustments to a participant's benefits would also involve inserting or updating records in this ledger table.

Related Objects

The primary documented relationship for this table is its foreign key dependency on the BEN_PER_IN_LER table. This relationship is fundamental, as every ledger entry is tied to a specific participant life event record that drove the transaction.

• BEN_PER_IN_LER: The BEN_BNFT_PRVDD_LDGR_F table references this table via the foreign key column PER_IN_LER_ID. This join connects ledger entries to the specific enrollment event (Life Event Record) for a person.

While not listed in the provided metadata, this ledger table would also have logical relationships to core benefits definition tables (like BEN_PL_F for plans) and the person tables (PER_ALL_PEOPLE_F). It is also a likely source for key benefits reporting views within the module.