Search Results ghr_mass_award_criteria_vals




Overview
Explore in AI Chat

Overview

The GHR_MASS_AWARD_CRITERIA_VALS table is a core data structure 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 transactional repository for the specific values used to define employee selection criteria during the creation and execution of Mass Awards. A Mass Award is a process that facilitates the bulk granting of awards, such as bonuses or recognition, to a group of employees who meet a defined set of conditions. This table is essential for storing the concrete parameters (e.g., specific job codes, grade levels, or date ranges) that are applied against the predefined criteria columns, enabling the system to accurately identify the targeted employee population for the award distribution.

Key Information Stored

The table's primary purpose is to link a specific Mass Award definition to its detailed selection criteria. Its key columns, as indicated by the metadata, include the surrogate primary key MASS_AWARD_CRITERIA_VAL_ID. The two critical foreign key columns establish its relationships: MASS_AWARD_ID links the criteria value to a specific award batch defined in the GHR_MASS_AWARDS table, and MASS_AWARD_CRITERIA_COL_ID links to the GHR_MASS_AWARD_CRITERIA_COLS table, which defines the type of criteria being used (e.g., PERSON_ID, GRADE, STEP). The table likely contains one or more value columns (such as CRITERIA_VALUE, FROM_VALUE, TO_VALUE) to store the actual data used for filtering, though their specific names are not detailed in the provided excerpt. Each record effectively represents one criterion-value pair for a Mass Award.

Common Use Cases and Queries

The primary use case is supporting the backend logic for the Mass Awards process. When a user defines or runs a Mass Award, the system queries this table to retrieve all criteria values associated with that award ID to build the employee selection logic. Common reporting and audit queries involve joining this table to its parent tables to understand the selection parameters of historical awards. A typical SQL pattern for verification would be:

  • SELECT mav.mass_award_id, mac.column_name, mav.criteria_value
  • FROM hr.ghr_mass_award_criteria_vals mav,
  • hr.ghr_mass_award_criteria_cols mac
  • WHERE mav.mass_award_criteria_col_id = mac.mass_award_criteria_col_id
  • AND mav.mass_award_id = :p_award_id;

This retrieves all criteria values for a given award, which is crucial for troubleshooting or compliance reporting.

Related Objects

GHR_MASS_AWARD_CRITERIA_VALS is centrally connected to two other key tables via foreign key constraints, forming a critical hierarchy for the Mass Awards functionality. The GHR_MASS_AWARDS table is the parent, storing the header-level information for each Mass Award batch (e.g., award type, effective date, status). The GHR_MASS_AWARD_CRITERIA_COLS table is the reference master, defining the allowable criteria types that can be used for employee selection. This table acts as the junction that populates those criteria definitions with specific instance values for a particular award. Any data migration, interface, or custom report concerning Mass Awards criteria must interact with this table and its defined relationships.