Search Results ghr_pay_plan_waiting_periods

Overview

The table GHR_PAY_PLAN_WAITING_PERIODS is a core data structure within the Oracle E-Business Suite US Federal Human Resources (GHR) module. It is owned by the HR schema and is valid for both releases 12.1.1 and 12.2.2. As defined in the ETRM, its primary function is to define the waiting period associated with specific Pay Plans. In the context of US federal personnel management, a Pay Plan is a classification system for employee compensation (e.g., General Schedule, Senior Executive Service). This table stores the rules governing the mandatory time an employee must serve at a particular step within a Pay Plan before becoming eligible for a step increase, which is a critical component of the federal government's standardized compensation and career progression framework.

Key Information Stored

The table's structure, as indicated by its primary and foreign key constraints, is designed to enforce data integrity for waiting period rules. The primary key is a composite key on the PAY_PLAN and FROM_STEP columns, ensuring a unique waiting period definition for each step within a given Pay Plan. The PAY_PLAN column is a foreign key referencing the GHR_PAY_PLANS table, linking the waiting period rule to a valid, defined Pay Plan. The FROM_STEP column identifies the specific step level from which the waiting period is measured. While the explicit column list is not fully detailed in the provided metadata, typical data would include the WAITING_PERIOD_IN_MONTHS (or similar) column to store the duration, and potentially a TO_STEP column indicating the target step after the period is served. The table's design centralizes these administrative rules for consistent application across personnel actions.

Common Use Cases and Queries

This table is primarily accessed during background processes for eligibility determination and compensation planning. A common use case is the automated batch process that identifies employees eligible for a within-grade step increase (WGI). The system would join employee records from tables like PER_ALL_PEOPLE_F and GHR_POSITIONS to this table via the Pay Plan to calculate if the service time at the current step meets or exceeds the defined waiting period. A typical reporting query would retrieve the waiting period schedule for audit or HR policy management.

• Sample Query to List All Waiting Period Rules:
  SELECT pay_plan, from_step, waiting_period_months
  FROM hr.ghr_pay_plan_waiting_periods
  ORDER BY pay_plan, from_step;
• Sample Query for Eligibility Logic:
  The table would be referenced in a larger PL/SQL function or view that compares an employee's service computation date for their current step against the waiting period defined for their Pay Plan and step in this table.

Related Objects

The table has defined, integral relationships with other GHR objects, forming part of the Federal HR data model. As per the metadata, its primary relationship is enforced via a foreign key constraint (GHR_PAY_PLAN_WAITING_PERIODS.PAY_PLAN) to the GHR_PAY_PLANS table, which holds the master list of valid Pay Plans. This table is also likely referenced by various GHR APIs and forms that manage Pay Plan definitions and step increase processing. While not listed in the brief excerpt, it would be a key lookup table for any program unit or view responsible for calculating tenure or step increase eligibility, potentially interfacing with core HR tables like PER_ALL_ASSIGNMENTS_F to determine an employee's current step and Pay Plan.