Search Results ghr_mass_award_criteria_cols




Overview
Explore in AI Chat

Overview

The GHR_MASS_AWARD_CRITERIA_COLS table is a core data structure within the Oracle E-Business Suite US Federal Human Resources (GHR) module. It functions as a repository for the specific selection criteria items or columns that are defined for use in Mass Awards processes. In the context of US Federal HR operations, Mass Awards are a critical functionality for efficiently applying standardized awards, such as bonuses or recognition, to groups of employees based on a defined set of qualifying conditions. This table stores the master list of these available criteria, such as performance rating, length of service, or pay plan, which can then be configured into specific award rules. Its role is foundational, providing the metadata that defines what attributes can be used to filter and select employee populations for mass award distributions in releases 12.1.1 and 12.2.2.

Key Information Stored

The table's primary purpose is to catalog each distinct criterion available for building a Mass Award selection rule. The central column is MASS_AWARD_CRITERIA_COL_ID, which serves as the unique primary key identifier for each criterion record. While the provided ETRM metadata does not list all columns, typical columns in such a reference table would include a name or code for the criterion (e.g., CRITERIA_COLUMN_NAME), a descriptive title (e.g., DESCRIPTION), and potentially data type information. This structure allows administrators to define a library of valid selection parameters. The table does not store the actual values for employees (e.g., "John Smith's performance rating"); it defines the types of data that can be evaluated.

Common Use Cases and Queries

The primary use case is the setup and administration of Mass Award templates. An HR administrator would reference the available criteria in this table when designing an award that, for instance, targets all employees in a specific agency with a performance rating above a certain threshold. Common reporting and validation queries involve listing all configured criteria for audit purposes or checking dependencies before modifying a criterion. A fundamental sample SQL to retrieve all available selection criteria would be:

  • SELECT mass_award_criteria_col_id, criteria_column_name, description FROM hr.ghr_mass_award_criteria_cols ORDER BY criteria_column_name;

This data is typically accessed via the GHR application's user interface during the Mass Award definition process, rather than through direct ad-hoc queries by end-users.

Related Objects

GHR_MASS_AWARD_CRITERIA_COLS has a direct and essential relationship with the GHR_MASS_AWARD_CRITERIA_VALS table, as indicated by the documented foreign key. While GHR_MASS_AWARD_CRITERIA_COLS defines the *type* of criterion (e.g., "Performance Rating"), the related VALS table stores the specific *instance* and *value* of that criterion for a particular Mass Award rule (e.g., "Rating must be '5 - Outstanding'"). This is a classic parent-child relationship. The table is also intrinsically linked to the broader Mass Awards functionality, likely interacting with base tables like GHR_MASS_AWARDS (which stores the award header information) and is accessed by underlying PL/SQL packages in the GHR module that execute the award selection and distribution logic.