Search Results ben_enrt_rt

Overview

The BEN_ENRT_RT table is a core data object within the Oracle E-Business Suite Advanced Benefits (BEN) module. It serves as the primary repository for storing enrollment rate information. This table is fundamental to the benefits administration process, as it holds the calculated or defined rates associated with an employee's specific benefit elections. These rates are critical for determining costs, contributions, and coverage levels for benefits such as insurance plans, savings programs, and other elective offerings. The table's integrity is maintained by its primary key and its relationships with other central benefits tables, ensuring that rate data is accurately linked to the corresponding enrollment and eligibility decisions.

Key Information Stored

The table's central identifier is the ENRT_RT_ID column, which is the primary key. Key relational columns establish links to other critical benefits entities. The ENRT_BNFT_ID column foreign key references the BEN_ENRT_BNFT table, tying the rate directly to a specific enrolled benefit instance. The ELIG_PER_ELCTBL_CHC_ID column links to the BEN_ELIG_PER_ELCTBL_CHC table, connecting the rate to the underlying eligibility profile and electable choice that authorized the enrollment. A notable self-referencing relationship exists via the SPCL_RT_ENRT_RT_ID column, which points to another record within the same BEN_ENRT_RT table, potentially used to model special rates, overrides, or tiered rate structures based on a base rate.

Common Use Cases and Queries

This table is central to benefits reporting and cost analysis. Common operational and analytical queries involve joining BEN_ENRT_RT to enrollment and person tables to generate summaries of employee contributions or employer costs. For instance, a query to list rates for active enrollments might join BEN_ENRT_RT to BEN_ENRT_BNFT and then to PER_ALL_PEOPLE_F. Another critical use case is during the benefits calculation engine's runtime, where rates are fetched and applied based on enrollment keys. Troubleshooting enrollment issues often involves tracing from a person's election back to the rate records stored here to validate calculations. Sample SQL patterns frequently start with a SELECT from BEN_ENRT_RT, filtered by ENRT_BNFT_ID or joined via ELIG_PER_ELCTBL_CHC_ID to understand the rate context.

Related Objects

BEN_ENRT_RT is a hub within the Benefits schema, with several key dependencies. The primary foreign key relationships, as documented, are with:

• BEN_ELIG_PER_ELCTBL_CHC: Links the rate to the eligibility and election definition.
• BEN_ENRT_BNFT: Links the rate to the specific enrolled benefit record.
• BEN_ENRT_RT (self-reference): For special rate hierarchies.

Furthermore, this table is likely referenced by various Benefits views that aggregate enrollment data for end-user reporting and inquiry forms. It is also integral to the data models of key APIs and public interfaces used for benefits enrollment and life event processing.