Search Results pay_plan

Overview

The HR.GHR_PAY_PLANS table is a core reference data table within the Oracle E-Business Suite (EBS) Federal Human Resources (GHR) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master repository for defining distinct pay plan codes used in the classification and compensation of U.S. federal government positions and employees. The table's primary role is to establish and maintain the valid pay plans within the system, which are critical for defining salary structures, processing personnel actions, and determining eligibility for within-grade increases (WGI). Its status as a seed data table, stored in the APPS_TS_SEED tablespace, underscores its function as a foundational configuration object upon which transactional data relies.

Key Information Stored

The table's structure is designed to capture both the pay plan definition and its operational rules. The primary columns include:

• PAY_PLAN (VARCHAR2, PK): The unique identifier or code for the pay plan (e.g., GS, GM, ES).
• DESCRIPTION (VARCHAR2(80)): A textual description of the pay plan.
• EQUIVALENT_PAY_PLAN (VARCHAR2): A self-referencing foreign key column that links to another PAY_PLAN code, establishing equivalency relationships between different plans for certain business rules.
• MAXIMUM_STEP (VARCHAR2(30)): Defines the highest step attainable within this specific pay plan.
• WGI_ENABLED_FLAG (VARCHAR2): A critical control flag indicating whether positions or employees under this pay plan are eligible for Within-Grade Increases.
• Standard WHO Columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN): Audit columns tracking the creation and modification history of each record.

Common Use Cases and Queries

This table is central to configuration and validation processes. A common use case is the setup and maintenance of pay plan master data during system implementation or periodic updates. It is also frequently referenced in validation logic for personnel actions (GHR_PA_REQUESTS) to ensure the 'from' and 'to' pay plans are valid. For reporting, it is joined to transactional tables to provide descriptive context. A typical query retrieves all active pay plans with their WGI eligibility status:

SELECT PAY_PLAN, DESCRIPTION, EQUIVALENT_PAY_PLAN, MAXIMUM_STEP, WGI_ENABLED_FLAG FROM HR.GHR_PAY_PLANS ORDER BY PAY_PLAN;

Another common pattern involves self-joining the table to resolve equivalent pay plans for business logic: SELECT P1.PAY_PLAN, P1.DESCRIPTION, P2.PAY_PLAN AS EQUIVALENT_PLAN_CODE FROM HR.GHR_PAY_PLANS P1 LEFT JOIN HR.GHR_PAY_PLANS P2 ON P1.EQUIVALENT_PAY_PLAN = P2.PAY_PLAN;

Related Objects

As documented in the foreign key relationships, HR.GHR_PAY_PLANS is a key parent table referenced by several other GHR transactional and setup tables. These relationships enforce data integrity across the module:

• Self-Reference: GHR_PAY_PLANS.EQUIVALENT_PAY_PLAN → GHR_PAY_PLANS.PAY_PLAN
• GHR_MASS_SALARY_CRITERIA: References PAY_PLAN to define criteria for mass salary updates.
• GHR_PAY_PLAN_WAITING_PERIODS: References PAY_PLAN to define waiting periods associated with specific plans.
• GHR_PA_REQUESTS: Referenced twice, for FROM_PAY_PLAN and TO_PAY_PLAN, tracking pay plan changes in personnel actions.
• GHR_PD_CLASSIFICATIONS: References PAY_PLAN within position description classification data.