Results for “ben_prnt_chld”

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

Overview

APPS.BEN_ACTY_BASE_RT_D is a view in the Oracle E-Business Suite (EBS) Benefits (BEN) module, valid in releases 12.1.1 and 12.2.2. Its name follows the standard BEN naming convention: a "_D" suffix denotes a "descriptive" or denormalized view that resolves internal lookup codes into human-readable meanings. Physically, it is defined over the base table BEN_ACTY_BASE_RT_F, exposing activity base rate and activity type definitions together with decoded meaning columns. Note that the view status is marked "Oracle Internal Use Only": Oracle Corporation does not support direct access to this object except from standard Oracle Applications programs.

The object is especially relevant to the search term blw_mn_elcn_alwd_meaning. That string corresponds to the view column BLW_MN_ELCN_ALWD_MEANING, which is the decoded "meaning" for the "Below Minimum Election Allowed" attribute on the activity base rate record. The descriptive view supplies this value as text rather than the underlying code, which is why users search for it when reporting on or troubleshooting election rules.

Underlying Base Objects

The documented base objects referenced by the view are:

• BEN_ACTY_BASE_RT_F (accessed via a synonym) — the principal Benefits activity base rate table, holding effective-dated rows for activity base rates and activity types.
• FND_USER (accessed via a synonym) — used to resolve the LAST_UPDATED_BY "who" column to a user.
• HR_GENERAL (package) — the standard HR utility package used for decoding lookups and translating internal codes into meanings.

The relationship is a straightforward projection: the view selects from BEN_ACTY_BASE_RT_F and applies HR_GENERAL decoding to produce the various MEANING columns. It is effective-dated, so each logical record may appear in multiple rows across EFFECTIVE_START_DATE and EFFECTIVE_END_DATE.

Key Columns

• ROW_ID — ROWID identifying the underlying row.
• ACTY_BASE_RT_ID — primary key of the activity base rate.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — the effective dating window for the record.
• ACTY_TYP_MEANING — decoded activity type.
• NAME — activity base rate name.
• RT_TYP_MEANING, BNFT_RT_TYP_MEANING, TX_TYP_MEANING — decoded rate type, benefit rate type, and tax type.
• USE_TO_CALC_NET_FLX_CR_MEANING, PRDCT_FLX_CR_WHEN_ELIG_MEANING — how the rate participates in flex credit calculations.
• ASN_ON_ENRT_MEANING, DSPLY_ON_ENRT_MEANING — whether the activity is assigned/displayed during enrollment.
• ABV_MX_ELCN_VAL_ALWD_MEANING / BLW_MN_ELCN_ALWD_MEANING — whether elections above the maximum or below the minimum are permitted.
• PARNT_CHLD_MEANING, USE_CALC_ACTY_BS_RT_MEANING, ALWS_CHG_MEANING, ELE_ENTRY_VAL_MEANING, NO_STD_RT_USED_MEANING, RT_MLT_MEANING — additional rule flags (parent/child relationships, change allowance, element entry validation, no-standard-rate usage, rate multiplier).
• PAY_RATE_GRADE_RULE_ID, ELEMENT_DET_RL, CURRENCY_DET_CD — element determination rule and currency determination references.
• LAST_UPDATE_DATE, LAST_UPDATED_BY — standard "who" audit columns.

Common Use Cases and Queries

The view is typically used for reporting on benefit activity rates without joining each lookup. Because it is internal, use should be restricted to diagnostics and DBA-level inquiry rather than custom production code. A typical query retrieving a specific record's election rules is:

• SELECT acty_base_rt_id, name, acty_typ_meaning, blw_mn_elcn_alwd_meaning, abv_mx_elcn_val_alwd_meaning FROM apps.ben_acty_base_rt_d WHERE acty_base_rt_id = :p_id;
• SELECT name, blw_mn_elcn_alwd_meaning FROM apps.ben_acty_base_rt_d WHERE TRUNC(SYSDATE) BETWEEN effective_start_date AND effective_end_date;

To find the code behind a displayed meaning, join to BEN_ACTY_BASE_RT_F on ACTY_BASE_RT_ID and the date columns and read the raw flag, since the "_D" view intentionally masks it.