Results for “budget_percent”

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

Overview

APPS.BEN_CWB_REPT_COMP_COMPARISON_V is a reporting view in the Oracle EBS Advanced Benefits (OLTP) Compensation Workbench module. It consolidates Compensation Workbench allocation activity into a manager-facing comparison report, presenting, per managerial hierarchy node and enrollment period, the population of eligible employees, the number who received a valued allocation, allocated totals, and the resulting budget utilization. The view is a pure reporting construct: it exposes no base tables for DML and is intended for use by concurrent programs, Oracle Reports/XML Publisher layouts, and ad hoc SQL against the APPS schema.

The user-facing name of the report associated with this view is "Compare," and the search string "Compare -6.2 And -3.7" corresponds to report/version parameters in the Compensation Workbench reporting family rather than a column or predicate within the view itself. The numeric suffixes denote delivered report or patch-version identifiers used when selecting the "Compare" comparison output in the Concurrent Programs and Request submission flow.

Underlying Base Objects

The view is defined over the following documented objects:

• BEN_PIL_ELCTBL_CHC_POPL — eligible population rows (manager and employee nodes).
• BEN_ELIG_PER_ELCTBL_CHC — eligible-per-electable-choice rows, filtered by elig_flag = 'Y'.
• BEN_CWB_HRCHY — the Compensation Workbench manager/employee hierarchy with lvl_num.
• BEN_ENRT_PERD — enrollment periods; supplies asnd_lf_evt_dt and enrt_perd_id.
• BEN_ENRT_RT and BEN_ACTY_BASE_RT_F — allocation amounts and rate units.
• BEN_PL_F, BEN_OPT_F, BEN_OIPL_F — plan, option, and option-in-plan metadata, including prsvr_bdgt_cd and nip_pl_uom.
• BEN_PER_IN_LER — person-in-legal-entity relationships.
• PER_ALL_PEOPLE_F — person names and manager identifiers.
• PER_BUSINESS_GROUPS_PERF — legislation code (country).
• HR_LOOKUPS — rate-unit meaning lookup values.

The defining query is an inline aggregation over these objects, using correlated subqueries against hrchy.lvl_num to count eligible employees at level 0 versus deeper levels.

Key Columns

• asnd_lf_evt_dt — assigned life event date of the enrollment period.
• manager_id, manager_name, manager_full_name — manager/person identifiers and formatted names.
• plan_name — concatenation of plan and option names.
• country — legislation code from the business group.
• eligible_employees — count of eligible persons for the hierarchy node.
• eligible_emps_w_val — count of eligible employees with a valued allocation.
• pct_w_val — percentage of eligible employees with a value, rounded to one decimal.
• total_allocated — sum of allocated amounts.
• units / rate_units — allocation currency or unit of measure (via HR_LOOKUPS).
• average_allocated — total allocated divided by employees with value.
• budget — budget amount, derived from prsvr_bdgt_cd (amount or percentage × eligible salaries).
• unused_budget — budget minus total allocated.
• enrt_perd_id — enrollment period identifier.

Common Use Cases and Queries

Typical usage is budget-versus-allocation analysis per manager and plan, and coverage reporting (how many eligible employees received an award).

SELECT manager_name, plan_name, country,
       eligible_employees, eligible_emps_w_val, pct_w_val,
       total_allocated, units, average_allocated,
       budget, unused_budget
FROM   apps.ben_cwb_rept_comp_comparison_v
WHERE  enrt_perd_id = :p_enrt_perd_id
ORDER  BY manager_name, plan_name;

A coverage query identifies nodes where allocations lag eligibility:

SELECT manager_name, plan_name, pct_w_val, unused_budget
FROM   apps.ben_cwb_rept_comp_comparison_v
WHERE  pct_w_val < 100
ORDER  BY pct_w_val;

Because the view is secured and highly aggregated, joins back to PER_ALL_PEOPLE_F or BEN_PL_F should be performed using the exposed identifiers (manager_id, enrt_perd_id), and queries should always filter on an enrollment period to avoid full hierarchical scans.