Results for “rt_typ_cd”

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

Overview

BEN_ENRT_OVERRIDE_RATES_V is an APPS-owned view within the Oracle Advanced Benefits (BEN) module. It presents a flattened, session-aware representation of override rate definitions that participants, or the enrollment process, may apply during a benefits enrollment transaction. The view derives its name from the concept of an enrollment override rate — a stored rate value on an activity base rate record that supersedes the standard calculated rate when certain enrollment conditions are met.

In the Oracle EBS 12.1.1 and 12.2.2 data models, this view functions primarily as a reporting and integration surface. Rather than exposing the entire base rate table with its numerous administrative and validation attributes, it filters and reshapes the rows into the column set expected by enrollment processing logic and downstream interfaces. The view supplies the RT_VAL (rate value) column, which is frequently referenced by runtime rate evaluation and by external integrations that must confirm the effective override rate for a given plan, program, or option. Because the view joins to FND_SESSIONS and restricts rows by the EFFECTIVE_DATE of the current session, its output is inherently context-sensitive and reflects the date and business context active in the user's session.

Underlying Base Objects

The view is defined over two documented base objects, both referenced through APPS synonyms:

• BEN_ACTY_BASE_RT_F — the activity base rates table, which stores the rate definitions, including the value in VAL (aliased to RT_VAL), rate type and usage codes, and the assignment and display flags that determine whether the rate may be overridden at enrollment.
• FND_SESSIONS — the framework session table, joined on SESSION_ID = USERENV('SESSIONID') to obtain the session's EFFECTIVE_DATE, which is then compared against the effective date range of the base rate row.

The join is an inner join to the current session, meaning the view returns only rows whose effective period contains the session's effective date. Several columns are populated by literal values or constants rather than from a base column, including ANN_RT_VAL, CMCD_RT_VAL, and RT_OVRIDN_FLAG, which is hard-coded to 'Y' to signal that every returned row represents an override rate.

Key Columns

• RT_VAL — the override rate value, sourced from BEN_ACTY_BASE_RT_F.VAL. This is the column most frequently searched and referenced by runtime logic and reporting.
• RT_TYP_CD / TX_TYP_CD / BNFT_RT_TYP_CD / MLT_CD — rate type, tax type, benefit rate type, and multiplier codes that classify how the value should be interpreted.
• RT_STRT_DT / RT_END_DT — the effective window of the rate; the start date is taken from the session effective date and the end date is fixed at 31-DEC-4712.
• RT_OVRIDN_FLAG — always 'Y', confirming the override nature of the row.
• DSPLY_ON_ENRT_FLAG — controls whether the rate is surfaced to the participant during enrollment.
• ELCTNS_MADE_DT — aliases the session effective date, representing when election processing is considered to occur.
• ACTY_BASE_RT_ID, INPUT_VALUE_ID, ELEMENT_TYPE_ID — identifiers linking the rate to its activity base rate, input value, and payroll element.
• PL_ID, OIPL_ID, PGM_ID, PLIP_ID, PTIP_ID, OIPLIP_ID — plan, option-in-plan, program, plan-in-program, and related hierarchy identifiers.
• BUSINESS_GROUP_ID — the owning business group.

Common Use Cases and Queries

The view is typically queried to retrieve override rate values for a specific plan or program during enrollment analysis, to validate which rates are available for override, or to feed downstream rate calculation and integration routines. The filter conditions in the view text exclude flexible credits (RT_USG_CD <> 'FLXCR') and require either ENTR_VAL_AT_ENRT_FLAG = 'Y' or ASN_ON_ENRT_FLAG = 'Y', so results are limited to rates eligible for entry or assignment during enrollment.

A representative query retrieving override rates for a plan:

• SELECT rt_typ_cd, rt_val, rt_strt_dt, pl_id
• FROM ben_enrt_override_rates_v
• WHERE pl_id = :p_plan_id
• AND business_group_id = :p_business_group_id;

A query listing only rates displayed during enrollment:

• SELECT acty_base_rt_id, rt_typ_cd, rt_val
• FROM ben_enrt_override_rates_v
• WHERE dsply_on_enrt_flag = 'Y';

Because the view depends on the session effective date, callers must ensure a valid FND session context exists before querying; otherwise no rows are returned. This behavior also means the same query can yield different results depending on the effective date set in the user's session, a characteristic that must be accounted for in any automated integration or batch process.