Results for “ultimate_low_limit_rule”

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

Overview

BEN_VRBL_RT_PRFL_D is a reporting view owned by the APPS schema in Oracle E-Business Suite Advanced Benefits (BEN). It exposes the variable rate profile definitions stored in the BEN_VRBL_RT_PRFL_F base table, transforming coded identifier columns into user-facing decoded values and resolving foreign key references into readable names. The view is designed to present the configuration of variable rates that drive benefit calculations, including eligibility, coverage, tax treatment, and rounding behavior.

Its primary function is to provide a human-readable, denormalized projection of the variable rate profile entity. Rather than requiring report authors and integrators to join to the lookup and formula tables themselves, BEN_VRBL_RT_PRFL_D performs the decode and formula-name resolution inline. This makes it a convenient source for extracting configuration data for auditing, migration, and integration with downstream payroll or benefits systems.

Underlying Base Objects

The view is defined over BEN_VRBL_RT_PRFL_F as its driving table, combined with several supporting objects via outer joins. Lookup code columns are translated through the HR_GENERAL.DECODE_LOOKUP function against Flexfield/lookup types, including BEN_ACTY_TYP, BEN_RT_TYP, BEN_TX_TYP, BEN_RT_TRTMT, BEN_ACTY_REF_PERD, BEN_STAT, BEN_VRBL_USG, and BEN_RNDG. Operator values are resolved conditionally using DECODE on VRBL_USG_CD, selecting the appropriate multiplier lookup type (BEN_MLT, BEN_CVG_MLT, or BEN_ACTL_PREM_MLT).

Four formula references are resolved through outer joins to FF_FORMULAS_F, supplying the names of the value calculation rule, the rounding rule, and the ultimate upper and lower limit rules. The LAST_UPDATED_BY column is resolved to a user name via FND_USER. The ETRM metadata also lists BEN_OIPL_F, BEN_OPT_F, BEN_PL_F, BEN_PL_TYP_F, and BEN_PL_TYP_OPT_TYP_F as referenced base objects, which support the plan and option-level context associated with rate profiles.

Key Columns

• VRBL_RT_PRFL_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE — primary identifier and effective dating of the profile.
• ACTIVITY_TYPE, OPERATOR, COVERAGE_OPERATOR, TAX_TYPE, TREATMENT, REFERENCE_PERIOD — decoded lookup values describing how the variable rate is applied and treated.
• CALCULATION_METHOD, VALUE, VALUE_RULE — the calculated value and its associated formula.
• INCREMENT_VALUE, DEFAULT_VALUE, MAX_VALUE, MIN_VALUE — enrollment boundaries for the rate.
• ROUNDING_CODE — decoded from BEN_RNDG, indicating the rounding strategy (for example, nearest cent or rounding up), which directly answers searches for "rounding_rule".
• ROUNDING_RULE — the name of the formula that performs the rounding, resolved from FF_FORMULAS_F via RNDG_RL.
• ULTIMATE_HIGH_LIMIT_VALUE, ULTIMATE_LOW_LIMIT_VALUE, ULTIMATE_HIGH_LIMIT_RULE, ULTIMATE_LOW_LIMIT_RULE — ultimate cap and floor values together with their rule names.
• STATUS, USAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY — lifecycle and audit information.

Common Use Cases and Queries

Typical uses include auditing the rounding configuration applied to a variable rate, verifying the formula attached to a rate profile, and extracting rate definitions for reconciliation or migration. A representative query to inspect rounding behavior follows:

SELECT VRBL_RT_PRFL_ID, NAME, ROUNDING_CODE, ROUNDING_RULE, VALUE_RULE, STATUS FROM APPS.BEN_VRBL_RT_PRFL_D WHERE ROUNDING_RULE IS NOT NULL AND SYSDATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE ORDER BY NAME;

To review the full calculation profile for a given rate, restrict by VRBL_RT_PRFL_ID and select the value, limits, and treatment columns. Because the view joins FND_USER and FF_FORMULAS_F with outer joins, profiles lacking a formula assignment or user record remain visible, which assists in identifying incomplete configurations.