Results for “base_salary”

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

Overview

The APPS.BEN_CWB_REPT_STOCK_DETAIL_V view is a reporting object within the Oracle Advanced Benefits (BEN) module, delivering the data set behind the Stock Detail Report used by Compensation Workbench (CWB). It consolidates enrollment, rate, plan, eligibility, and person information into a single denormalized structure that reports worksheet stock amounts (typically stock units or monetary allocations granted to employees) broken down by participant, manager chain, job, grade, and plan.

The view is marked VALID in the APPS schema and exists in both Oracle EBS 12.1.1 and 12.2.2. Because Compensation Workbench relies on worksheet-driven allocations, the Stock Detail Report exposes the underlying rate values captured in BEN_PRTT_RT_VAL and BEN_ENRT_RT, joined to the person and hierarchy context needed by compensation administrators. In practice, this view serves as the presentation layer that a concurrent program or BI Publisher report queries rather than as a transactional object.

Underlying Base Objects

Per the ETRM metadata, the view is defined over a broad set of BEN, PER, and HR synonyms and packages. The BEN objects include BEN_PRTT_RT_VAL, BEN_ACTY_BASE_RT_F, BEN_ENRT_RT, BEN_CWB_HRCHY, BEN_ELIG_PER_ELCTBL_CHC, BEN_PER_IN_LER, BEN_PIL_ELCTBL_CHC_POPL, and BEN_PL_F. Person and assignment data come from PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, PER_PAY_PROPOSALS, PER_ASSIGNMENT_EXTRA_INFO, PER_PERSON_TYPES, PER_PERSON_TYPE_USAGES_F, PER_JOBS, PER_JOBS_TL, PER_JOB_DEFINITIONS, PER_GRADES, and PER_GRADES_TL.

Organization and hierarchy context are supplied by HR_ALL_ORGANIZATION_UNITS_TL, HR_ORGANIZATION_UNITS, and HR_LOOKUPS. Logic is embedded through the BENUTILS, HR_API, HR_GENERAL, and HR_SECURITY packages. The heavy use of MAX() aggregations and NVL() on dates such as RT_STRT_DT indicates the view flattens multiple rate rows per participant into one summarized line per stock allocation. HR_SECURITY participation is significant because row-level access is enforced through the security profile of the querying user.

Key Columns

• RT_STRT_DT — Effective start date of the rate, coalesced between the prorated and worksheet rate sources.
• PLAN_NAME — Name of the compensation plan from BEN_PL_F.
• EMP_FULL_NAME / EMP_BRIEF_NAME / EMPNO — Employee display name, short name, and employee number from PER_ALL_PEOPLE_F.
• WS_MGR_FULL_NAME, IMM_MGR_FULL_NAME — Worksheet manager and immediate manager names, with corresponding brief-name columns.
• WS_AMOUNT — Summed stock allocation value, derived from NVL(PRT.RT_VAL, WS_RT.VAL).
• WS_AMOUNT_UNITS — Unit of measure for the amount, from a lookup meaning or the plan's NIP_PL_UOM.
• LEVELS_DOWN — Depth of the employee within the manager hierarchy from BEN_CWB_HRCHY.
• JOB, JOB_SEGMENT1–5, GRADE — Job and grade attributes joined from PER_JOBS_TL, PER_JOB_DEFINITIONS, and PER_GRADES_TL.
• PERSON_ATTRIBUTE1–10 — Descriptive flexfield attributes carried from the person record.
• COMMENTS — Truncated to 35 characters from the enrollment population comments.

Common Use Cases and Queries

The most direct use is to reproduce the Stock Detail Report for a given Compensation Workbench cycle. Administrators filter by person or plan and aggregate the stock amounts by manager or organization. A representative query is:

SELECT empno, emp_brief_name, plan_name, ws_amount, ws_amount_units, job, grade, levels_down FROM apps.ben_cwb_rept_stock_detail_v WHERE rt_strt_dt BETWEEN :p_start AND :p_end ORDER BY ws_mgr_brief_name, emp_brief_name;

Other common patterns include joining to PER_ALL_ASSIGNMENTS_F for supervisory hierarchy reconciliation, or pivoting by PERSON_ATTRIBUTE1–10 to align allocations with custom segmentation. Because the view already applies HR_SECURITY, it is safe to expose in self-service reporting without additional predicates beyond date and plan filters. Note that the embedded BENUTILS.BASIS_TO_PLAN_CONVERSION call means performance depends on the volume of pay proposals per assignment; restricting the date range and plan is recommended for large populations.