Results for “pl_xchg_rate”

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

Overview

BEN_CWB_WS_DOWNLOAD_V is an APPS-owned database view in Oracle E-Business Suite, part of the BEN (Advanced Benefits) product family. It was designed to support the Compensation Workbench (CWB) Worksheet functionality, presenting a denormalized, reporting-friendly projection of person, assignment, hierarchy, and plan-rate data used during compensation cycle processing. The view is central to the CWB Worksheet download process: it consolidates employee attributes, manager hierarchy relationships, and plan-level rate values (salary, eligibility, target compensation, and worksheet amounts) into a single queryable structure so that the Compensation Workbench web service and worksheet interfaces can retrieve plan-related data efficiently without issuing numerous joins to base tables.

The name of the view and its columns (for example, PL_WS_VAL, PL_WS_MIN_VAL, PL_WS_MAX_VAL, PL_WS_INCR_VAL) reflect the "worksheet value" domain, which is the term CWB uses for the monetary figure assigned to an employee within a specific plan during a compensation cycle. The view is validated as VALID and is referenced in ETRM documentation for release 12.1.1 and 12.2.2.

Underlying Base Objects

The view is defined over a substantial set of base objects, as documented in the ETRM metadata. Core data sources include PER_ALL_PEOPLE_F (employee name, supervisor name, years employed, and last-updated-by lookups), PER_ASSIGNMENT_EXTRA_INFO (the CWBRANK information type used to derive ranking), and BEN_CWB_PERSON_INFO (person-level CWB attributes and group membership). Plan and rate information is sourced from BEN_CWB_PERSON_RATES and BEN_CWB_PL_DSGN, which provide the PLRT alias values for salary, eligibility, and worksheet amounts. Hierarchy data comes from BEN_CWB_GROUP_HRCHY, and exchange-rate conversion is handled through BEN_CWB_XCHG and FND_CURRENCIES.

The view also joins to descriptive entities including HR_ALL_ORGANIZATION_UNITS_TL, HR_ALL_POSITIONS_F_TL, HR_LOCATIONS_ALL_TL, PER_GRADES_TL, PER_JOBS_TL, and PER_ASSIGNMENT_STATUS_TYPES_TL for organizational context. Package-level logic is invoked through BENUTILS, BEN_CWB_UTILS, BEN_CWB_WEBADI_UTILS, HR_API, HR_GENERAL, and FND_PROFILE. The use of FND_PROFILE is notable because the employee name column is dynamically selected based on the BEN_DISPLAY_EMPLOYEE_NAME profile option, toggling between custom name, brief name, and full name.

Key Columns

• EMP_NAME / MGR_NAME — Employee and manager display names, selected via the BEN_DISPLAY_EMPLOYEE_NAME profile option.
• RANK — Derived rank value from PER_ASSIGNMENT_EXTRA_INFO where INFORMATION_TYPE = 'CWBRANK', used for worksheet ordering.
• BASE_SALARY — Annualized salary calculated as BASE_SALARY × PAY_ANNULIZATION_FACTOR / NVL(PLANUFACTOR, GRPUFACTOR).
• PL_NAME / PL_XCHG_RATE — Plan name and exchange rate, falling back between person-level and group-level values.
• PL_STAT_SAL_VAL, PL_ELIG_SAL_VAL, PL_TOT_COMP_VAL, PL_OTH_COMP_VAL — Plan rate amounts for statutory, eligibility, total compensation, and other compensation.
• PL_WS_VAL, PL_WS_MIN_VAL, PL_WS_MAX_VAL, PL_WS_INCR_VAL — Worksheet value, minimum, maximum, and increment for the plan.
• PL_WS_LAST_UPD_DATE / PL_WS_LAST_UPD_NAME — Audit columns identifying when and by whom the worksheet value was last modified.
• OPT1_* columns — Values and rates for the first optional plan (OPT1), conditionally populated using NVL2 based on TEMP.OIPL1ID.

Common Use Cases and Queries

Typical usage centers on extracting worksheet data for a compensation cycle, validating plan amounts before upload, or reconciling manager hierarchy and rank ordering. A basic query retrieving worksheet values for employees is:

SELECT emp_name, mrg_name, pl_name, pl_ws_val, pl_ws_last_upd_date
FROM   apps.ben_cwb_ws_download_v
WHERE  pl_name IS NOT NULL;

Because the view exposes many lateral columns, joins to PER_ALL_PEOPLE_F or BEN_CWB_PERSON_INFO are often unnecessary, simplifying downstream reporting. The view is frequently queried from the CWB web service layer and by custom extracts that feed worksheet download templates.