Results for “ben_prtt_prem_pk”

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

Overview

BEN_PRTT_PREM_F is a core data table within the Oracle E-Business Suite Advanced Benefits (BEN) module. It stores the premium amounts calculated for a participant's enrollment in a compensation object. In the Advanced Benefits processing model, when an enrollment result is produced for a participant, the benefits engine evaluates the applicable rate structures and derives the cost that the participant (and any associated contributors) must pay for that coverage. BEN_PRTT_PREM_F is the persistent store for those calculated premium results.

The table resides in the BEN schema and is documented as valid in both EBS 12.1.1 and 12.2.2. It carries a 50-column physical definition, with the majority of columns reserved as descriptive flexfield segments (PPE_ATTRIBUTE1 through PPE_ATTRIBUTE30) and standard WHO/audit columns. From a Data Vault modeling perspective, the ETRM heuristic classifies this object as a link, because it resolves relationships between a participant enrollment record and the underlying rates or compensation objects that drive the premium calculation. This classification is a modeling suggestion; in a normalized EBS context the table behaves as a transactional fact-like child of the enrollment result.

Key Information Stored

The table is anchored by a composite primary key defined by the unique index BEN_PRTT_PREM_PK, comprising PRTT_PREM_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE. PRTT_PREM_ID is the surrogate identifier for a single premium record; the two date columns provide the datetracked validity window that EBS date-tracking conventions require, enabling historical and future-dated premium rows.

• PRTT_PREM_ID — surrogate primary key for the premium record.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — validity window bound to the primary key and governing date-tracked queries.
• ACTL_PREM_ID — reference to the actual premium entity associated with this calculated result.
• PRTT_ENRT_RSLT_ID — the participant enrollment result to which this premium pertains, the principal business link.
• PER_IN_LER_ID — foreign key to BEN_PER_IN_LER, identifying the participant's life event / enrollment relationship record.
• BUSINESS_GROUP_ID — foreign key to HR_ALL_ORGANIZATION_UNITS, scoping the row to a specific business group.
• STD_PREM_VAL — the standardized premium value calculated for the enrollment.
• STD_PREM_UOM — the unit of measure associated with the standardized premium value.
• PPE_ATTRIBUTE_CATEGORY and PPE_ATTRIBUTE1–30 — descriptive flexfield context and segment values for customer-extensible data.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the OAF/BC4J layer.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — concurrent program context identifying the process that created or last updated the row.

Common Use Cases and Queries

Typical usage centers on benefits cost reporting, payroll deduction reconciliation, and life-event auditing. A common pattern joins the premium row to its enrollment result and participant record to produce a per-participant cost statement, filtered by the effective date window:

• Reporting calculated premiums per participant for a given plan year: filter on SYSDATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE.
• Reconciling enrollment results against calculated premiums by joining PRTT_ENRT_RSLT_ID to the enrollment result table.
• Auditing which concurrent process generated a premium row using REQUEST_ID and PROGRAM_ID.
• Extracting customer-configured flexfield data via PPE_ATTRIBUTE_CATEGORY and the PPE_ATTRIBUTE segments.

A representative query pattern:

SELECT p.PRTT_PREM_ID, p.STD_PREM_VAL, p.STD_PREM_UOM FROM BEN.BEN_PRTT_PREM_F p WHERE p.PRTT_ENRT_RSLT_ID = :enrt_rslt_id AND TRUNC(SYSDATE) BETWEEN p.EFFECTIVE_START_DATE AND p.EFFECTIVE_END_DATE;

Related Objects

The documented foreign keys establish the primary relationships for this table:

• BEN_PER_IN_LER — joined on PER_IN_LER_ID; holds the participant life-event/enrollment relationship to which the premium belongs.
• HR_ALL_ORGANIZATION_UNITS — joined on BUSINESS_GROUP_ID; provides business group context.
• BEN_PRTT_ENRT_RSLT_F — the enrollment result table linked through PRTT_ENRT_RSLT_ID, the parent of the premium calculation.
• BEN_ACTL_PREM_F — related actual premium definition referenced by ACTL_PREM_ID.
• BEN_PRTT_PREM_PK — the unique index enforcing the composite primary key.

These relationships position BEN_PRTT_PREM_F as the calculation output stage between enrollment results and downstream payroll or billing processing, where the standardized premium values are consumed.