Results for “extra_input_value_id”

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

Overview

BEN.BEN_EXTRA_INPUT_VALUES is a table within the Oracle Advanced Benefits (BEN) module. It stores extra input values associated with a standard rate. In Oracle EBS 12.1.1 and 12.2.2, rates used by benefits plan configurations—such as those attached to activity base rates—can be defined with ancillary inputs beyond the primary numeric rate. This table persists those supplementary inputs, capturing textual values, return variable names, and a wide set of descriptive attributes. Its role is to complete the definition of a rate by holding the additional parameters that plan processing, eligibility, or rate calculation logic may consume.

From a data-modeling perspective, the mined relationship metadata classifies BEN_EXTRA_INPUT_VALUES as standalone with a heuristic Data Vault classification of standalone. This should be read as a modeling suggestion rather than a validated warehouse design: the table carries its own surrogate key and does not exhibit a strong foreign-key dependency chain in the documented structure, which means it may be treated as a self-contained satellite-like entity. The single documented unique index, BEN_EXTRA_INPUT_VALUES_PK on EXTRA_INPUT_VALUE_ID, confirms the primary key and no other business-key candidate is documented.

Key Information Stored

The table exposes 44 documented columns. The most significant are:

• EXTRA_INPUT_VALUE_ID — surrogate primary key, uniquely identifying each extra input value row.
• ACTY_BASE_RT_ID — identifier linking the record to the activity base rate context it supplements.
• INPUT_VALUE_ID — identifier for the input value referenced by the row.
• INPUT_TEXT — the textual payload of the extra input value.
• RETURN_VAR_NAME — the return variable name associated with this input, used in rate or formula processing.
• UPD_WHEN_ELE_ENDED_CD — a code controlling update behavior when the related element ends.
• BUSINESS_GROUP_ID — the multi-tenant/operating-unit style discriminator standard to BEN tables.
• EIV_ATTRIBUTE_CATEGORY and EIV_ATTRIBUTE1 through EIV_ATTRIBUTE30 — the descriptive flexfield (DFF) attribute segment, providing extensible, customer-configured metadata.
• Audit columns: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE, and optimistic locking via OBJECT_VERSION_NUMBER.

The surrogate key is distinct from any business key; no alternate unique index is documented beyond the primary key, so business meaning flows through ACTY_BASE_RT_ID, INPUT_VALUE_ID, and the attribute columns rather than a separate unique constraint.

Common Use Cases and Queries

Typical applications include auditing the supplemental inputs behind a standard rate, validating DFF attribute usage, and reporting on rate configuration for benefits plans. A representative query retrieves all extra inputs for a given activity base rate:

• SELECT EXTRA_INPUT_VALUE_ID, ACTY_BASE_RT_ID, INPUT_VALUE_ID, INPUT_TEXT, RETURN_VAR_NAME FROM BEN.BEN_EXTRA_INPUT_VALUES WHERE ACTY_BASE_RT_ID = :p_base_rt_id;
• Filtering by business group for multi-organization reporting: WHERE BUSINESS_GROUP_ID = :p_bg_id.
• Inspecting DFF data: SELECT EIV_ATTRIBUTE_CATEGORY, EIV_ATTRIBUTE1, EIV_ATTRIBUTE2 FROM BEN.BEN_EXTRA_INPUT_VALUES WHERE EXTRA_INPUT_VALUE_ID = :p_id;
• Trending configuration changes using LAST_UPDATE_DATE and LAST_UPDATED_BY.

These patterns support reconciliation of rate definitions and troubleshooting of benefits calculation discrepancies.

Related Objects

Because the documented FK structure marks this table as standalone, joins are driven primarily by the ACTY_BASE_RT_ID and INPUT_VALUE_ID columns rather than by enforced constraints. Significant related objects include:

• BEN_ACTY_BASE_RATES — the activity base rates that this table supplements, joined on ACTY_BASE_RT_ID.
• BEN_BENFIT_RATES / rate definition tables — parent rate configurations.
• BEN_INPUT_VALUES — the input value definitions referenced by INPUT_VALUE_ID.
• FND_FLEX_VALUES / FND_FLEX_VALUE_SETS — for interpreting DFF attribute category values.
• FND_LOOKUPS — for decoding UPD_WHEN_ELE_ENDED_CD.
• Standard BEN audit and version objects relying on OBJECT_VERSION_NUMBER.