Search Results ghr_mass_salary_criteria




Overview
Explore in AI Chat

Overview

The GHR_MASS_SALARY_CRITERIA table is a core data object within the US Federal Human Resources (GHR) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as a supporting table for the mass salary adjustment process, a critical administrative function for federal personnel management. Its primary role is to store the specific, additional selection criteria that define which employees are included in a broader mass salary action. While a parent mass salary record defines the general parameters of an adjustment, this table holds the granular filtering rules, enabling precise targeting of employee populations based on attributes such as pay plan.

Key Information Stored

The table's structure is designed to link criteria to a parent action and store key qualifying attributes. The primary identifier is the MASS_SALARY_CRITERIA_ID column. The most critical foreign key is MASS_SALARY_ID, which ties each criteria record to its parent mass salary action defined in the GHR_MASS_SALARIES table. A central column for defining criteria is PAY_PLAN, which references the GHR_PAY_PLANS table. This allows the mass salary action to be filtered to employees under specific federal pay plans (e.g., General Schedule (GS), Senior Executive Service (ES)). Other columns, implied by the table's purpose, would typically store additional filter conditions, such as occupational series, grade, or organization, to further refine the employee selection set for the salary adjustment.

Common Use Cases and Queries

This table is central to executing and auditing legislated or agency-wide federal pay adjustments. A common operational use case is the annual General Schedule pay increase, where a mass salary action is created with criteria specifying the "GS" pay plan. For reporting and validation, administrators frequently query this table to verify the scope of an action. A typical SQL pattern retrieves all criteria for a specific mass salary action for review:

  • SELECT pay_plan, [other_criteria_columns] FROM hr.ghr_mass_salary_criteria WHERE mass_salary_id = <action_id>;

Another critical query joins to the GHR_MASS_SALARIES table to produce a summary report of all pending or historical mass actions and their associated targeting criteria, ensuring proper audit trails and compliance.

Related Objects

The GHR_MASS_SALARY_CRITERIA table exists within a tightly integrated schema. Its primary relationship is with the GHR_MASS_SALARIES table, enforced by the foreign key on MASS_SALARY_ID. It is a child table to GHR_MASS_SALARIES, meaning multiple criteria records can belong to a single mass salary action. Furthermore, it has a referential relationship with the GHR_PAY_PLANS table via the PAY_PLAN column, ensuring that only valid, predefined federal pay plans are used as selection criteria. In practice, data in this table is populated and managed through the GHR application's dedicated forms and processes for defining mass salary actions, rather than via direct SQL manipulation.