Results for “epr_attribute1”

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

Overview

BEN_ENRT_PREM is the enrollment premium table in the Oracle Advanced Benefits (BEN) module. It stores the premium amounts calculated for a participant's benefit enrollment, capturing the relationship between an enrollment benefit record and the eligible elective choice that drives the premium. This table is central to benefits processing because premium values determine payroll deductions, employer cost calculations, and regulatory reporting for enrolled participants.

In Oracle EBS 12.1.1 and 12.2.2, BEN_ENRT_PREM resides in the BEN schema and is classified as VALID. The table contains 48 documented columns, most of which are attribute columns (EPR_ATTRIBUTE1 through EPR_ATTRIBUTE30) reserved for extensibility. Based on the foreign key structure, the heuristic Data Vault classification for this table is a link — it associates enrollment benefit records (BEN_ENRT_BNFT) with eligible elective choices (BEN_ELIG_PER_ELCTBL_CHC), while carrying descriptive premium measures such as value and unit of measure.

Key Information Stored

The most significant columns in BEN_ENRT_PREM include:

• ENRT_PREM_ID — The surrogate primary key defined by the unique index BEN_ENRT_PREM_PK. This is the sole documented business-key candidate and uniquely identifies each premium row.
• ENRT_BNFT_ID — Foreign key to BEN_ENRT_BNFT, linking the premium to a specific enrollment benefit record.
• ELIG_PER_ELCTBL_CHC_ID — Foreign key to BEN_ELIG_PER_ELCTBL_CHC, identifying the eligible elective choice associated with the premium.
• BUSINESS_GROUP_ID — Foreign key to HR_ALL_ORGANIZATION_UNITS, establishing the business group context and supporting multi-organization data separation.
• ACTL_PREM_ID — Identifier for the actual premium record, used during premium calculation and reconciliation.
• VAL — The premium value or amount stored for the enrollment.
• UOM — The unit of measure associated with the premium value.
• EPR_ATTRIBUTE_CATEGORY and EPR_ATTRIBUTE1–30 — Descriptive flexfield and attribute columns providing extensibility for customer-specific premium attributes.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — Standard WHO audit columns tracking row creation and modification.
• OBJECT_VERSION_NUMBER — Supports optimistic locking for concurrent updates.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Concurrent program and request context columns used for traceability of batch processes that created or updated the row.

Common Use Cases and Queries

Typical scenarios involving BEN_ENRT_PREM include premium reconciliation for payroll, benefits cost reporting, and auditing of enrollment elections. A common query joins enrollment benefits and eligible elective choices to retrieve premiums for a participant:

• Selecting premium rows for a specific enrollment: SELECT ep.enrt_prem_id, ep.val, ep.uom FROM ben.ben_enrt_prem ep WHERE ep.enrt_bnft_id = :p_enrt_bnft_id;
• Joining to eligible elective choices to identify the choice behind each premium: SELECT ep.*, c.* FROM ben.ben_enrt_prem ep, ben.ben_elig_per_elctbl_chc c WHERE ep.elig_per_elctbl_chc_id = c.elig_per_elctbl_chc_id;
• Auditing recent premium changes using audit columns: SELECT * FROM ben.ben_enrt_prem WHERE last_update_date >= :p_since;
• Restricting by business group for multi-organization reporting: ... WHERE business_group_id = :p_bg_id;

These patterns support payroll interface validation, premium variance analysis, and benefits cost forecasting.

Related Objects

The following objects are most significant in relation to BEN_ENRT_PREM:

• BEN_ENRT_BNFT — Parent enrollment benefit table, joined via ENRT_BNFT_ID.
• BEN_ELIG_PER_ELCTBL_CHC — Eligible elective choice table, joined via ELIG_PER_ELCTBL_CHC_ID.
• HR_ALL_ORGANIZATION_UNITS — Business group definition, joined via BUSINESS_GROUP_ID.
• BEN_ENRT_PREM_RBV — A view that references BEN_ENRT_PREM through ENRT_PREM_ID, providing a read-only reporting interface.

Together, these objects form the relational backbone for premium calculation, storage, and reporting within Oracle Advanced Benefits.