Search Results ben_prtt_prem_f

Overview

The BEN_PRTT_PREM_F table is a core data object within the Oracle E-Business Suite Advanced Benefits (BEN) module, specifically in releases 12.1.1 and 12.2.2. It functions as a fact table that stores the calculated premium amounts for a participant's enrollment in a compensation object. The table is date-tracked, meaning it maintains a historical record of premium calculations over time, which is essential for accurate benefits administration, auditing, and retroactive processing. Its primary role is to serve as the system of record for all premium-related financial data generated during enrollment and life event processing.

Key Information Stored

The table's structure is designed to capture the essential details of a premium calculation. The primary key is a composite of PRTT_PREM_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE, which uniquely identifies a specific premium record and its period of validity. Key columns include PRTT_PREM_ID, the unique system identifier for the premium record, and the EFFECTIVE_START_DATE and EFFECTIVE_END_DATE that define its temporal validity. The table also holds foreign key columns that provide critical context: BUSINESS_GROUP_ID links the premium to the specific business group (HR_ALL_ORGANIZATION_UNITS), enforcing multi-org security, and PER_IN_LER_ID establishes a direct relationship to the participant's life event record (BEN_PER_IN_LER), connecting the premium to the specific enrollment transaction that triggered its calculation.

Common Use Cases and Queries

This table is central to financial reporting and reconciliation within Benefits. Common use cases include generating premium statements for participants or carriers, auditing enrollment costs, and supporting payroll deduction interfaces. A typical reporting query would join BEN_PRTT_PREM_F to BEN_PER_IN_LER and person tables to list premiums by employee and life event. For current premium calculations, queries must filter on SYSDATE between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE. Analysts also frequently aggregate data from this table by business group, plan type, or time period to analyze benefits program costs. Troubleshooting often involves querying this table with a specific PER_IN_LER_ID to verify the premium outcome of a processed enrollment.

Related Objects

The BEN_PRTT_PREM_F table has documented foreign key relationships with other critical EBS objects, which are essential for constructing accurate joins in reports and integrations.

• HR_ALL_ORGANIZATION_UNITS: Joined via BUSINESS_GROUP_ID. This relationship secures data by business group and allows reporting within an organizational context.
• BEN_PER_IN_LER: Joined via PER_IN_LER_ID. This is the most critical operational relationship, linking the calculated premium directly back to the participant's life event record that generated it, providing full traceability from enrollment action to financial result.