Search Results pa_compensation_details_pk

Overview

The PA_COMPENSATION_DETAILS_ALL table is a core transactional table within the Oracle E-Business Suite Projects module (PA). It serves as the central repository for storing detailed compensation information for hourly employees. Its primary role is to define and maintain the cost rates for employees and to link them to specific compensation rule sets. This data is fundamental for accurate project costing, labor cost distribution, and financial planning, as it determines the cost applied to employee hours charged to projects and tasks.

Key Information Stored

The table's structure is designed to associate an employee with a cost rate and a compensation rule set within a specific organization and date range. As indicated by its primary key, the table uniquely identifies records by a combination of PERSON_ID, START_DATE_ACTIVE, and ORG_ID. This allows for maintaining historical rate changes. Key columns include PERSON_ID (the employee), START_DATE_ACTIVE and END_DATE_ACTIVE (defining the validity period of the rate), ORG_ID (the operating unit), and COMPENSATION_RULE_SET. The COMPENSATION_RULE_SET column is a foreign key linking to the PA_COMPENSATION_RULE_SETS table, which defines the specific rules for calculating compensation. Other columns typically store the hourly cost rate(s) and markup percentages.

Common Use Cases and Queries

This table is critical for payroll integration, project accounting, and cost analysis. Common operational and reporting scenarios include validating an employee's current cost rate for a given project, auditing historical rate changes, and generating cost accrual reports. A typical query would retrieve the active compensation detail for a specific employee and organization.

• Sample Query: Find Active Compensation Details for an Employee
  SELECT person_id, start_date_active, end_date_active, compensation_rule_set
FROM pa.pa_compensation_details_all
WHERE person_id = 12345
AND org_id = 100
AND sysdate BETWEEN start_date_active AND NVL(end_date_active, sysdate+1);
• Use Case: Project Costing Engine
  The Projects module references this table when calculating the cost of labor transactions posted from Oracle Time & Labor (OTL) or other sources, applying the defined rates to hours worked.

Related Objects

The table has defined relationships with other key objects in the Projects schema. As per the provided metadata, its primary foreign key relationship is with the PA_COMPENSATION_RULE_SETS table via the COMPENSATION_RULE_SET column. This table is also heavily referenced by various project costing APIs and views that consolidate compensation data for reporting. While not listed in the excerpt, it is commonly joined to HR person tables (like PER_ALL_PEOPLE_F) for employee details and to financial tables for cost distribution. The PA_COMPENSATION_DETAILS_PK primary key ensures data integrity for these relationships.