Results for “ws_val”

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

Overview

BENBV_CWB_PERSON_RATES_V is a read-only view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the Oracle Advanced Benefits (BEN) product family and, as its description states, captures person rates for Compensation Workbench. The view exposes the workforce compensation figures recorded against each person for a given compensation event, including worksheet values, eligibility and statutory salary, other and total compensation, recommendations, and the budget amounts copied to the worksheet and reserve pools.

Because it is a read-only view, it serves strictly as a reporting and integration surface. It presents the salary, worksheet, and budget data that workbench administrators and line managers review and approve, while the transactional edits themselves occur in the Compensation Workbench application flow. The naming convention with the _V suffix follows the standard Oracle BI Publisher / BIS view pattern: the BENBV_ prefix indicates a Benefits BI view intended for downstream reporting use rather than for direct DML.

Underlying Base Objects

The view is defined over the base table BEN_CWB_PERSON_RATES, which is exposed in the FROM clause through a synonym, aliased as CWB. The view text is a straightforward projection of all significant columns from this base table, augmented by lookup decoding and derivation logic. No joins, outer joins, or aggregations are present, so the row cardinality of the view matches that of BEN_CWB_PERSON_RATES for the selected predicates.

Two supporting packages are referenced in the SELECT list. BEN_BIS_UTILS supplies the functions GET_GROUP_PL_NAME and GET_GROUP_OIPL_NAME, which resolve the group or organization plan name in effect at the compensation occurrence date (LF_EVT_OCRD_DT) for the primary and organization-level plans (PL_ID, OIPL_ID) and their group variants. The HR_BIS package supplies BIS_DECODE_LOOKUP, which translates the BEN_INELG_RSN lookup code for ineligibility reasons and the YES_NO code for the eligibility flag into their display meanings. The view is created WITH READ ONLY.

Key Columns

• PERSON_RATE_ID — Primary identifier for the person rate row.
• PERSON_ID, ASSIGNMENT_ID — The employee and assignment to which the rate applies.
• LF_EVT_OCRD_DT — Life event / compensation occurrence date, used as the effective date for plan name derivation.
• WS_VAL, WS_MN_VAL, WS_MX_VAL, WS_INCR_VAL — Worksheet value and its minimum, maximum, and increment constraints. This is the column set queried by users searching for ws_mn_val.
• ELIG_SAL_VAL, STAT_SAL_VAL, OTH_COMP_VAL, TOT_COMP_VAL — Eligible salary, statutory salary, other compensation, and total compensation.
• REC_VAL, REC_MN_VAL, REC_MX_VAL, REC_INCR_VAL — Recommended award value and its bounds.
• COPY_DIST_BDGT_VAL, COPY_WS_BDGT_VAL, COPY_RSRV_VAL — Budget amounts copied to distribution, worksheet, and reserve, with corresponding _MN_VAL, _MX_VAL, _INCR_VAL, and issued (_ISS_VAL, _ISS_DATE) columns.
• ELIG_FLAG, INELIG_RSN_CD — Eligibility indicator and decoded ineligibility reason.
• COMP_POSTING_DATE, WS_RT_START_DATE — Posting and worksheet rate start dates.
• WHO columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE) for audit tracking.

Common Use Cases and Queries

This view is typically used for reporting on compensation worksheet results, validating budget allocation, and auditing eligibility outcomes. The following examples reflect the most frequent patterns.

• Listing worksheet values with constraints for a person: SELECT person_id, ws_val, ws_mn_val, ws_mx_val FROM apps.benbv_cwb_person_rates_v WHERE person_id = :p_person_id;
• Checking copied worksheet budget against issued budget: SELECT person_id, copy_ws_bdgt_val, copy_ws_bdgt_iss_val FROM apps.benbv_cwb_person_rates_v WHERE lf_evt_ocrd_dt BETWEEN :p_from AND :p_to;
• Auditing ineligible persons with decoded reasons and plan names: SELECT person_id, inelig_rsn_cd, elig_flag FROM apps.benbv_cwb_person_rates_v WHERE inelig_rsn_cd IS NOT NULL;
• Reconciling total compensation: comparing elig_sal_val, oth_comp_val, and tot_comp_val for a compensation cycle.

Because the view invokes BEN_BIS_UTILS and HR_BIS functions per row, queries should be filtered by person, plan, or date to limit function call overhead. All queries should target APPS.BENBV_CWB_PERSON_RATES_V and treat the view as read-only.