Search Results ghr_mass_awards




Overview
Explore in AI Chat

Overview

The GHR_MASS_AWARDS 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 serves as the primary repository for storing the master definition and details of a Mass Award transaction. In the context of US federal personnel management, a Mass Award is a bulk personnel action used to apply a common award, such as a within-grade increase or a bonus, to a large group of employees who meet specific eligibility criteria. This table functions as the central transactional header, enabling the efficient and standardized processing of these widespread personnel actions across a federal agency.

Key Information Stored

The table's structure is designed to capture the essential administrative and control data for a Mass Award. Its primary key is the MASS_AWARD_ID, a unique system-generated identifier for each mass award transaction. A critical foreign key relationship exists via the NATURE_OF_ACTION_ID column, which links to the GHR_NATURE_OF_ACTIONS table. This link defines the specific type of personnel action (e.g., "Within Grade Increase") being performed en masse. While the provided metadata does not list all columns, typical data stored would include control information such as the award's effective date, status (e.g., 'DRAFT', 'SUBMITTED', 'PROCESSED'), creation date, and the identifier of the user who initiated the action. This header record is then associated with detailed criteria and employee lists in related tables.

Common Use Cases and Queries

The primary use case is the creation, management, and reporting of bulk personnel awards. Administrators use front-end GHR forms to define a Mass Award, which creates a record in this table. Common reporting and audit queries involve joining this header table with its related criteria and assignment tables. For example, to list all processed mass awards of a specific type within a date range, a query might join GHR_MASS_AWARDS with GHR_NATURE_OF_ACTIONS. To audit a specific award's details, one would typically query this table by MASS_AWARD_ID and join to GHR_MASS_AWARD_CRITERIA_VALS to see the eligibility rules applied, and then to assignment-level tables to see the resulting individual personnel actions generated for each employee.

SELECT gma.mass_award_id, gma.effective_date, gnoa.nature_of_action
FROM hr.ghr_mass_awards gma,
     hr.ghr_nature_of_actions gnoa
WHERE gma.nature_of_action_id = gnoa.nature_of_action_id
AND gma.status = 'PROCESSED'
AND gma.effective_date BETWEEN :p_start_date AND :p_end_date;

Related Objects

GHR_MASS_AWARDS is centrally connected to several key objects in the GHR schema. It has a direct foreign key dependency on the GHR_NATURE_OF_ACTIONS table to define the action type. Conversely, it is referenced as a parent table by GHR_MASS_AWARD_CRITERIA_VALS, which stores the specific eligibility criteria (e.g., grade, step, service dates) defined for the mass award. The mass award process ultimately generates individual personnel actions; therefore, this table is also logically related to core HR transaction tables like PER_ALL_ASSIGNMENTS_F through downstream processing. Any custom reports or integrations involving mass award data will typically start with this table as the root.