Results for “ghr_pay_plans”

50+ results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GHR_PAY_PLANS is a core reference table in the Oracle E-Business Suite GHR – US Federal Human Resources product family. It defines the pay plans used throughout the federal HR configuration, acting as the authoritative source for pay plan identifiers that drive salary administration, position classification, personnel action processing, and mass salary adjustments. In Oracle EBS 12.1.1 and 12.2.2, the table resides in the HR schema and is registered as VALID within the ETRM metadata repository.

From a dimensional modeling perspective, the Data Vault classification heuristic derived from the foreign key structure identifies this object as hub-leaning. This suggests GHR_PAY_PLANS functions primarily as a business-key hub, anchored by a stable, unique pay plan identifier rather than serving as a transactional link or descriptive satellite. Its role is to centralize the pay plan dimension that downstream transactional and configuration tables reference through foreign keys.

Key Information Stored

The documented physical schema for 12.2.2 lists 11 columns. The most significant are:

  • PAY_PLAN — The business-key column and the sole component (with the edition column) of the unique index GHR_PAY_PLANS_PK. It is the primary key of the table and the value referenced by dependent tables.
  • DESCRIPTION — Human-readable name/description of the pay plan, used in lookups and reports.
  • EQUIVALENT_PAY_PLAN — Self-referencing column linking a pay plan to an equivalent pay plan record. This supports mappings between schedules that are treated as equivalent for certain federal HR processes, such as conversions and mass actions.
  • MAXIMUM_STEP — Defines the maximum step number available within the pay plan, governing step-based salary progression.
  • WGI_ENABLED_FLAG — Indicates whether Within-Grade Increase processing is enabled for the pay plan, a key control for federal WGI eligibility logic.
  • ZD_EDITION_NAME — The edition/versioning column that, combined with PAY_PLAN, forms the business-key candidate captured in the unique index GHR_PAY_PLANS_PK (PAY_PLAN, ZD_EDITION_NAME).

Standard Oracle WHO columns are also present: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN. These provide the audit trail for row creation and modification but carry no business meaning for pay plan definition.

No dedicated surrogate system-generated ID column is documented; the primary key is the business key itself, reinforced by the edition name. This reinforces the hub classification.

Common Use Cases and Queries

Typical uses include listing active pay plans for a federal agency configuration, validating whether a pay plan supports WGI, finding equivalent pay plans for conversion or mass salary processing, and reporting on step structures. A representative query lists pay plans with their equivalent mapping and WGI status:

  • SELECT PAY_PLAN, DESCRIPTION, EQUIVALENT_PAY_PLAN, MAXIMUM_STEP, WGI_ENABLED_FLAG FROM HR.GHR_PAY_PLANS WHERE WGI_ENABLED_FLAG = 'Y';
  • Join to GHR_PAY_PLAN_WAITING_PERIODS on PAY_PLAN to resolve waiting-period rules per plan.
  • Self-join on EQUIVALENT_PAY_PLAN = PAY_PLAN to resolve equivalence chains.
  • Join to GHR_PD_CLASSIFICATIONS on PAY_PLAN to see which classifications belong to a plan.
  • Join to GHR_PA_REQUESTS on FROM_PAY_PLAN / TO_PAY_PLAN to analyze personnel actions by pay plan transition.

Related Objects

The following objects reference GHR_PAY_PLANS through documented foreign keys:

  • GHR_PAY_PLANS (self-reference) — EQUIVALENT_PAY_PLAN → PAY_PLAN.
  • GHR_MASS_SALARY_CRITERIA — PAY_PLAN → GHR_PAY_PLANS.PAY_PLAN, defining mass salary adjustment criteria.
  • GHR_PAY_PLAN_WAITING_PERIODS — PAY_PLAN → GHR_PAY_PLANS.PAY_PLAN, holding waiting-period configurations.
  • GHR_PA_REQUESTS — FROM_PAY_PLAN and TO_PAY_PLAN → GHR_PAY_PLANS.PAY_PLAN, capturing source and target pay plans on personnel actions.
  • GHR_PD_CLASSIFICATIONS — PAY_PLAN → GHR_PAY_PLANS.PAY_PLAN, associating position classifications with a pay plan.

These relationships confirm GHR_PAY_PLANS as a foundational hub feeding configuration and transactional federal HR processes across Oracle EBS 12.1.1 and 12.2.2.