Search Results cn_payment_worksheets_all




Overview
Explore in AI Chat

Overview

The CN_PAYMENT_WORKSHEETS_ALL table is a core transactional data store within the Oracle E-Business Suite (EBS) Incentive Compensation (CN) module. It functions as the central repository for payment worksheet data, which is the detailed, calculated output generated for each sales representative during a compensation payrun. The table's role is to hold the final, aggregated compensation figures—including earnings, deductions, taxes, and net pay—that are calculated based on processed transactions and plan rules before final payment generation. Its "ALL" suffix indicates it is a multi-organization enabled table, storing data across operating units, which is a standard architectural pattern in Oracle EBS 12.1.1 and 12.2.2.

Key Information Stored

While the provided metadata does not list specific columns, the table's primary key and foreign key relationships define its critical data elements. The PAYRUN_ID and SALESREP_ID columns together form the primary key, uniquely identifying a payment worksheet for a specific representative within a specific payrun cycle. Foreign key relationships indicate the table stores a CONVERT_TO_TYPE_ID, linking to credit types for currency or unit conversions, and a CREDIT_CONV_FCT_ID, linking to the specific conversion factor applied. Typical columns in such a worksheet table would include summarized amounts for total credits, calculated commissions, adjustments, withholding amounts, net pay, and payment status flags, providing a complete financial snapshot for the pay period.

Common Use Cases and Queries

This table is primarily accessed for auditing payrun results, troubleshooting payment discrepancies, and generating detailed compensation statements. A common reporting query involves joining to the CN_PAYRUNS_ALL table to analyze worksheet data by payrun period and status. For example, to retrieve the net payment details for all sales representatives in a completed payrun, a query would filter on the payrun identifier and relevant amount columns. Support personnel often query this table using the SALESREP_ID to investigate an individual's payment history across multiple periods. The data is also foundational for custom reports that aggregate earnings by team, region, or product line, typically requiring joins to salesperson and organizational tables via the SALESREP_ID.

Related Objects

The CN_PAYMENT_WORKSHEETS_ALL table maintains integral relationships with other key Incentive Compensation tables, as documented by its foreign keys:

  • CN_PAYRUNS_ALL: Joined via PAYRUN_ID. This is the master table defining the payrun period, status, and processing parameters.
  • CN_CREDIT_TYPES_ALL_B: Joined via CONVERT_TO_TYPE_ID. This table defines the target credit type (e.g., currency) for any conversions applied in the worksheet.
  • CN_CREDIT_CONV_FCTS_ALL: Joined via CREDIT_CONV_FCT_ID. This table supplies the specific conversion rate or factor used for calculating monetary equivalents in the worksheet.

These relationships ensure data integrity and provide the necessary context for the calculated amounts stored in each payment worksheet record.