Results for “grp_pl_id”

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

Overview

BEN_CWB_SUMM_DIR_REP_V is an APPS-owned database view in the Oracle Advanced Benefits (BEN) module. It is a reporting and integration object that presents compensation workbench summary information organized by direct report, and it is designed specifically to be downloaded through WebADI. In EBS 12.1.1 and 12.2.2 the view serves as the data source that feeds the WebADI worksheet used by managers and compensation administrators to review the summary of allocations for the employees who report to them, and to compare those allocations against budgets and eligibility populations.

The view produces a denormalized, presentation-ready result set. It resolves the manager's group hierarchy, computes totals and percentages, and returns descriptive labels rather than raw identifiers, which makes it suitable for direct consumption by a spreadsheet template without further transformation. Because it is a view and not a table, it always reflects the current transactional state of the underlying workbench summary data.

Underlying Base Objects

The view is defined over a set of APPS synonyms that resolve to the BEN compensation workbench base tables. The documented referenced objects are BEN_CWB_GROUP_HRCHY, BEN_CWB_PERSON_GROUPS, BEN_CWB_PERSON_INFO, BEN_CWB_PL_DSGN, BEN_CWB_SUMMARY, FND_CURRENCIES, HR_LOOKUPS, and the PL/SQL packages BEN_CWB_UTILS, FND_PROFILE, and HR_API. BEN_CWB_SUMMARY supplies the core allocation and eligibility measures; BEN_CWB_GROUP_HRCHY supplies the managerial reporting hierarchy; BEN_CWB_PERSON_INFO supplies person name attributes; BEN_CWB_PERSON_GROUPS and BEN_CWB_PL_DSGN provide group and plan design context; and FND_CURRENCIES and HR_LOOKUPS resolve currency and lookup meanings. FND_PROFILE is used to read the BEN_CWB_PROFILE_DISP_NAME profile option, which controls whether the person name is returned as full name, custom name, or brief name. The query further uses inline aggregation logic that distinguishes direct-report totals from rolled-up totals based on the manager's hierarchy level.

Key Columns

• GRP_LER_ID, GRP_PL_ID, GRP_OIPL_ID — identifiers for the group, plan, and plan option/eligibility grouping under which the summary is reported.
• NAME — the person name, formatted per the BEN_CWB_PROFILE_DISP_NAME profile option (FN, CN, or BRIEF_NAME).
• ELIG_EMP and EMP_RECV — counts of eligible employees and employees who received an allocation.
• PCT_EMP_RECV — percentage of eligible employees who received an allocation, computed as EMP_RECV divided by ELIG_EMP.
• ELIG_SAL — total eligible salary for the reporting group.
• BUDGET — the applicable budget, resolved as ACTMGRBDGT for the top sequence level and BDGT otherwise.
• PCT_OF_BDGT — allocation as a percentage of eligible salary, based on the resolved budget value.
• TOT_ALCT — total allocated amount for the group.
• PL_UOM — the unit of measure for the plan, returned from the currency meaning or the plan UOM. This is the column most commonly referenced by users searching on "pl_uom", and it drives display and formatting of monetary and non-monetary plan values.
• PCT_OF_SAL — total allocation as a percentage of eligible salary.
• AVAILABLE — the remaining budget, calculated as the resolved budget minus TOT_ALCT.
• AVG_ALCT — average allocation per recipient, computed as TOT_ALCT divided by EMP_RECV.

Common Use Cases and Queries

The primary use case is the WebADI download of a manager's direct-report compensation summary. Administrators also use the view for ad hoc reporting and reconciliation of budget versus allocation. A representative query that surfaces the allocation figures with their unit of measure is shown below.

SELECT name, pl_uom, elig_emp, emp_recv,
       pct_emp_recv, budget, tot_alct,
       pct_of_bdgt, available, avg_alct
  FROM apps.ben_cwb_summ_dir_rep_v
 WHERE grp_pl_id = :p_plan_id
 ORDER BY name;

Because PL_UOM conveys whether amounts are stated in currency, hours, or another plan-defined measure, queries that aggregate or compare totals should always carry the column alongside the monetary values to avoid mixing units. A second common pattern filters on the percentage-of-budget column to identify groups approaching or exceeding their budget.

SELECT name, pl_uom, budget, tot_alct, available
  FROM apps.ben_cwb_summ_dir_rep_v
 WHERE pct_of_bdgt > 95
 ORDER BY pct_of_bdgt DESC;

As with all BEN compensation workbench views, queries should be executed with the appropriate APPS security context and the correct effective dates applied to the underlying summary records, since the view inherits the date-effective behavior of BEN_CWB_GROUP_HRCHY and BEN_CWB_SUMMARY.