Results for “crs_rlovr_procg_cd”

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

Overview

BENBV_BNFT_POOL_RLOVR_RQMT_V is a read-only Oracle EBS Advanced Benefits (BEN) view owned by the APPS schema. It presents benefit pool rollover requirement definitions, describing the plans or options within plans — and any associated restrictions — into which excess amounts from a benefit pool may be rolled over and subsequently applied as contributions. The view is a business-layer presentation object built on the BEN_BNFT_POOL_RLOVR_RQMT_F base table, combining descriptive flexfield support, lookup code decoding, and row-level security through the business group security profile. Its primary role is to expose rollover rule configuration in a form suitable for concurrent reports, extract programs, and integration interfaces without requiring direct access to the underlying table or its lookup decoding logic.

Underlying Base Objects

The view is defined over two documented referenced objects. The principal source is BEN_BNFT_POOL_RLOVR_RQMT_F (referenced as a synonym), the entity table holding pool rollover requirement records. The secondary reference is the HR_BIS package, invoked through HR_BIS.BIS_DECODE_LOOKUP and HR_BIS.GET_SEC_PROFILE_BG_ID. The WHERE clause applies business group security by restricting rows to BPR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, BPR.BUSINESS_GROUP_ID), and the definition terminates with WITH READ ONLY. A view-level descriptive flexfield is exposed via the literal column '_DF:BEN:BEN_BNFT_POOL_RLOVR_RQMT_F:BPR', instructing Oracle EBS forms and reports to resolve the flexfield context against the base table.

Key Columns

• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — Date-tracked validity of the rollover requirement record.
• VAL_RNDG_RL — Rounding rule identifier applied to rollover values; the column directly referenced in user searches such as "val_rndg_rl". VAL_RNDG_CD and VAL_RNDG_ supply the lookup code and its decoded display value.
• PCT_RNDG_RL / PCT_RNDG_CD — Equivalent rounding configuration applied to rollover percentages.
• RLOVR_VAL_INCRMT_NUM, RLOVR_VAL_RL, MN_RLOVR_VAL, MX_RLOVR_VAL — Value-based rollover controls: increment, rule, minimum, and maximum amounts.
• PCT_RLOVR_INCRMT_NUM, MN_RLOVR_PCT_NUM, MX_RLOVR_PCT_NUM — Percentage-based rollover increment, minimum, and maximum.
• MX_PCT_TTL_CRS_CN_ROLL_NUM — Maximum percentage of total cost that may be rolled.
• PRTT_ELIG_RLOVR_RL — Rule governing pro-ration of eligible rollover amounts.
• CRS_RLOVR_PROCG_CD — Carryover processing code with decoded value.
• NO_MN/MX_RLOVR_*_DFND_FLAG — Yes/No flags indicating whether minimum or maximum bounds are defined.
• BNFT_POOL_RLOVR_RQMT_ID, BUSINESS_GROUP_ID, ACTY_BASE_RT_ID, BNFT_PRVDR_POOL_ID — Primary and foreign key identifiers linking the requirement to its activity base rate and benefit provider pool.
• WHO columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE for audit.

Common Use Cases and Queries

Typical usage includes auditing rollover configuration for a benefit pool, verifying rounding rules before open enrollment, and feeding extract interfaces. Because the view enforces business group security, a session's security profile determines visible rows.

List active rollover requirements for a pool:

SELECT bprvrq.BNFT_POOL_RLOVR_RQMT_ID, bprvrq.VAL_RNDG_RL, bprvrq.VAL_RNDG_CD, bprvrq.MX_RLOVR_VAL FROM apps.BENBV_BNFT_POOL_RLOVR_RQMT_V bprvrq WHERE bprvrq.BNFT_PRVDR_POOL_ID = :p_pool_id AND SYSDATE BETWEEN bprvrq.EFFECTIVE_START_DATE AND bprvrq.EFFECTIVE_END_DATE;

Identify requirements using a specific value rounding rule:

SELECT bprvrq.BNFT_POOL_RLOVR_RQMT_ID, bprvrq.VAL_RNDG_RL FROM apps.BENBV_BNFT_POOL_RLOVR_RQMT_V bprvrq WHERE bprvrq.VAL_RNDG_RL = :p_rndg_rl;

Joins are frequently made to BEN_BNFT_PRVDR_POOL and activity base rate tables using BNFT_PRVDR_POOL_ID and ACTY_BASE_RT_ID to resolve pool names and rate definitions for reporting.