Search Results per_pay_proposals




Overview
Explore in AI Chat

Overview

The PER_PAY_PROPOSALS table is a core data object within the Oracle E-Business Suite Human Resources (HR) module, specifically in releases 12.1.1 and 12.2.2. It serves as the central repository for recording and managing salary proposals and performance review information linked to employee assignments. This table is integral to the compensation management lifecycle, capturing proposed changes to an employee's remuneration, which may be initiated by events such as promotions, merit increases, or adjustments following a performance review. Its data is critical for approval workflows, historical tracking of compensation changes, and integration with payroll processing.

Key Information Stored

The table's primary key is PAY_PROPOSAL_ID, which uniquely identifies each salary proposal record. Based on the documented foreign key relationships, other critical columns include EVENT_ID, which links the proposal to a specific HR event (like a promotion) in the PER_EVENTS table; BUSINESS_GROUP_ID, which ties the record to the organizational security context via HR_ALL_ORGANIZATION_UNITS; and PERFORMANCE_REVIEW_ID, which associates the salary proposal with a formal assessment in the PER_PERFORMANCE_REVIEWS table. While the full column list is not provided in the excerpt, typical data stored includes the proposed salary amount, change percentage, effective date, approval status, and the assignment identifier (ASSIGNMENT_ID) for the affected employee.

Common Use Cases and Queries

This table is central to compensation reporting and audit processes. Common use cases include generating reports on pending salary proposals for managerial approval, analyzing historical salary progression for employees, and verifying that payroll runs reflect approved changes. A typical query might join PER_PAY_PROPOSALS with PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F to list active proposals for a business group. For performance-linked compensation analysis, a report would join PER_PAY_PROPOSALS with PER_PERFORMANCE_REVIEWS. Developers often interact with this table indirectly via standard HR APIs for creating and updating proposals to maintain data integrity. Sample SQL to find proposals for a specific employee could be:

  • SELECT ppp.* FROM hr.per_pay_proposals ppp, hr.per_all_assignments_f paf WHERE ppp.assignment_id = paf.assignment_id AND paf.person_id = <person_id> AND SYSDATE BETWEEN paf.effective_start_date AND paf.effective_end_date;

Related Objects

As indicated by the foreign keys, PER_PAY_PROPOSALS has strong dependencies on several key HR tables. It is a child table of PER_EVENTS, HR_ALL_ORGANIZATION_UNITS, and PER_PERFORMANCE_REVIEWS. Conversely, it is a parent table to PER_PAY_PROPOSAL_COMPONENTS, which holds the detailed breakdown of the proposed salary (e.g., base pay, allowances). This relationship is crucial for managing complex compensation structures. The table is also referenced by various HRMS views and is manipulated through public Oracle HRMS APIs, which ensure all business rules and validations are applied during transaction processing.