Search Results performance_rating




Overview
Explore in AI Chat

Overview

APPS.BEN_CWB_PPAUD_DOWNLOAD_V is a reporting view in the Oracle E-Business Suite Advanced Benefits (Oracle Benefits) module, specifically within the Compensation Workbench (CWB) functional area. The view exposes a flattened, download-oriented result set drawn from the Compensation Workbench report detail table, presenting employee compensation worksheet line information in a column layout suited for extraction to spreadsheets, flat files, or downstream integration processes. Its name — incorporating the "PPAUD" (post-processing audit) and "DOWNLOAD" tokens — indicates that it is intended to support audit and reconciliation activities performed after a Compensation Workbench processing cycle, and to provide the data set required by administrators who download plan and option allocations for review.

The view is defined in the APPS schema and is available across Oracle EBS 12.1.1 and 12.2.2. Because it is a view rather than a table, it holds no data of its own and inherits the security, indexing, and performance characteristics of its underlying base object. Access is governed by the standard APPS schema grants and any custom responsibility or menu assignments configured at the site.

Underlying Base Objects

The view is defined over a single documented base object: BEN_CWB_RPT_DETAIL, referenced through a SYNONYM in the APPS schema. BEN_CWB_RPT_DETAIL is the Compensation Workbench report detail table, which stores the individual line-level records generated for a compensation worksheet — employee identity, plan and option assignment, allocated amounts and units, performance ratings, and any error or warning messages produced during processing. The view performs no joins in its documented definition, so it is a direct projection with a filter and sort applied. The filter excludes sentinel rows by requiring that NVL(person_rate_id, 0) is not equal to -9999, which removes placeholder or non-applicable records. The result set is ordered by full_name ascending, producing a name-sequenced output suitable for human-readable review.

Key Columns

  • employee_name (full_name) — the full name of the employee whose compensation line is reported.
  • employee_number — the employee's assigned number, used for reconciliation against HR records.
  • business_group_name — the business group context for the record.
  • manager_name — the manager associated with the employee's compensation worksheet.
  • plan_name / option_name — the compensation plan and the specific option or component within that plan.
  • amount / units — the allocated monetary amount and unit quantity for the line.
  • performance_rating — the performance rating value carried on the worksheet line. This column is the target of the search term "performance_rating" and is the primary mechanism by which performance data is surfaced through this view for audit and download purposes.
  • assignment_changed (assignment_changed_flag) — indicates whether the underlying assignment changed relative to the worksheet, a key audit signal.
  • error_message (error_or_warning_text) — the error or warning text raised during processing for the line.
  • person_rate_id — the identifier linking the row to the person rate record; also the column used in the view's exclusion filter.
  • benefit_action_id — the benefit action context associated with the record.

Common Use Cases and Queries

Typical usage centers on post-processing audit: administrators query the view to confirm that allocations were written correctly, that performance ratings were captured, and that no rows carry error or warning text. A representative audit query retrieves employees with unresolved messages:

  • SELECT employee_name, employee_number, plan_name, option_name, amount, units, performance_rating, error_message FROM apps.ben_cwb_ppaud_download_v WHERE error_message IS NOT NULL;
  • SELECT employee_name, performance_rating, amount, units FROM apps.ben_cwb_ppaud_download_v WHERE plan_name LIKE :plan ORDER BY employee_name;
  • SELECT * FROM apps.ben_cwb_ppaud_download_v WHERE assignment_changed = 'Y';

For download scenarios, the ordered result set can be consumed directly by concurrent programs, BI Publisher reports, or external extraction tools, with the ORDER BY full_name guaranteeing deterministic sequencing. Because the view is unindexed beyond the base table's structures, large-volume extracts should be constrained by business group, plan, or benefit action to limit the scan on BEN_CWB_RPT_DETAIL.