Search Results ghr_pay_plans

Overview

The GHR_PAY_PLANS table is a core reference table within the US Federal Human Resources (GHR) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the master repository for defining and managing pay plans, which are fundamental classification structures used by U.S. federal government agencies to categorize employee compensation. A pay plan, such as "GS" for General Schedule or "ES" for Senior Executive Service, defines the legal authority, pay structure, and rules governing an employee's salary. This table is essential for ensuring accurate payroll processing, position classification, and personnel actions within the federal HR framework, acting as a primary source for validation and data integrity across numerous GHR transactions.

Key Information Stored

While the provided metadata does not list specific columns, the table's primary key is the PAY_PLAN column, which stores the unique code identifying each pay plan (e.g., 'GS', 'WG', 'ES'). A critical column indicated by the foreign key relationships is EQUIVALENT_PAY_PLAN. This column likely establishes relationships between different pay plans, possibly for the purpose of conversions, comparisons, or service calculations. Other columns typically found in such reference tables would include a description (e.g., 'GENERAL SCHEDULE'), effective dates, and potentially attributes controlling pay administration rules. The table's structure enforces referential integrity, ensuring that pay plan codes used throughout the system are valid and defined.

Common Use Cases and Queries

This table is central to numerous operational and reporting functions. Common use cases include validating pay plan entries during personnel action (GHR_PA_REQUESTS) creation, defining criteria for mass salary adjustments (GHR_MASS_SALARY_CRITERIA), and supporting position description (PD) classifications. A fundamental query would retrieve all active pay plans for a lookup list: SELECT pay_plan, description FROM ghr_pay_plans WHERE SYSDATE BETWEEN effective_start_date AND effective_end_date ORDER BY pay_plan;. Another typical query involves finding the equivalent pay plan for a given code, which is crucial for certain personnel actions: SELECT equivalent_pay_plan FROM ghr_pay_plans WHERE pay_plan = 'GS';. Reporting often involves joining this table to personnel or position data to analyze workforce distribution by pay plan.

Related Objects

As per the documented foreign keys, GHR_PAY_PLANS has integral relationships with several key GHR tables. It is directly referenced by:

• GHR_PA_REQUESTS: Stores the FROM_PAY_PLAN and TO_PAY_PLAN for personnel actions involving a change in pay plan.
• GHR_PD_CLASSIFICATIONS: Links a position description's classification to a specific PAY_PLAN.
• GHR_MASS_SALARY_CRITERIA: Uses PAY_PLAN as a selection criterion for bulk salary updates.
• GHR_PAY_PLAN_WAITING_PERIODS: Defines service waiting periods associated with a specific PAY_PLAN.

Furthermore, the table has a self-referencing foreign key on EQUIVALENT_PAY_PLAN, indicating a hierarchical or relational structure within the pay plan definitions themselves.