Results for “ben_cwb_rep_total_comp_v”

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

Overview

BEN_CWB_REP_TOTAL_COMP_V is a reporting view owned by the APPS schema within the Oracle E-Business Suite Advanced Benefits (BEN) module. Its documented status is VALID, and it is defined over the Compensation Workbench (CWB) reporting data model. The view aggregates total compensation figures for employees associated with a manager hierarchy, consolidating base salary, bonus, and stock-based compensation components into a single projected total. It is intended primarily as the data source for Compensation Workbench reporting interfaces — including the Total Compensation statement — where a manager reviews direct-report compensation in a given plan year period.

Because this is a view rather than a table, it carries no independent persistence; every query executes the underlying SQL against the base tables at runtime. This is significant for users searching for a change_date column: views in this family generally expose date tracking columns through their base enrollment and rate tables rather than as a first-class attribute of the view itself.

Underlying Base Objects

The documented metadata lists the following referenced objects, all accessed through APPS synonyms: BEN_CWB_MGR_HRCHY, BEN_ELIG_PER_ELCTBL_CHC, BEN_ENRT_RT, BEN_PER_IN_LER, BEN_PIL_ELCTBL_CHC_POPL, BEN_PL_F, BEN_PL_TYP_F, BEN_PRTT_RT_VAL, BEN_YR_PERD, PER_ALL_PEOPLE_F, and PER_PAY_PROPOSALS.

Structurally, the view joins BEN_ELIG_PER_ELCTBL_CHC to BEN_PL_F and BEN_PL_TYP_F to establish plan context, and restricts BEN_PL_TYP_F.COMP_TYP_CD to 'ICM', 'ICM4', and 'ICM7'. BEN_CWB_MGR_HRCHY supplies the manager-to-employee hierarchy traversal, with LEVELS_DOWN computed from HIER.LVL_NUM. Compensation amounts derive from BEN_ENRT_RT and BEN_PRTT_RT_VAL, with a second aliased pair (ENR2/PRT2) used to resolve stock share values. Employee identification comes from PER_ALL_PEOPLE_F, and proposed salary from PER_PAY_PROPOSALS. BEN_YR_PERD constrains the plan year period.

Key Columns

• EMP_BRIEF_NAME / EMP_FULL_NAME — concatenated employee name from PER_ALL_PEOPLE_F.
• CURRENCY — the unit of measure from BEN_PIL_ELCTBL_CHC_POPL.
• BEG_SALARY — PPP.PROPOSED_SALARY_N at the start of the cycle.
• SALARY_VAL / END_SALARY — aggregated salary component (COMP_TYP_CD 'ICM7') and the resulting ending salary.
• BONUS_VAL — aggregated bonus component ('ICM').
• TOTAL_COMP — ending salary plus bonus, coalesced to zero.
• STOCK_SHARES / STOCK_VAL — stock component ('ICM4'), split by SHR unit of measure versus monetary value.
• MGR_ID_PARAM / PERD_ID_PARAM / LEVELS_DOWN_PARAM — bind-style parameters passed to the underlying report, supplying manager, period, and hierarchy depth.
• LEVELS_DOWN — minimum hierarchy depth, hard-restricted to a single level in this view definition.

Common Use Cases and Queries

The principal use case is feeding the Compensation Workbench total compensation report for a specific manager and plan year. A parameterized extraction resembles:

SELECT emp_brief_name, currency, beg_salary, salary_val, bonus_val, total_comp, stock_shares, stock_val FROM apps.ben_cwb_rep_total_comp_v WHERE mgr_id_param = :p_manager_id AND perd_id_param = :p_period_id;

Analysts reconciling total compensation against enrollment records use the view alongside BEN_ENRT_RT and BEN_PRTT_RT_VAL to trace each component back to its originating rate row. When investigating effective-dated changes — the source of most "change_date" searches — the effective_start_date and effective_end_date columns on BEN_ENRT_RT and BEN_PRTT_RT_VAL provide the auditable timeline, since the view itself does not surface a dedicated change_date. Administrators validating hierarchy output typically compare LEVELS_DOWN across the manager chain, noting that this view deliberately caps traversal at one level below the manager.