Search Results ghr_mass_transfer_criteria




Overview
Explore in AI Chat

Overview

The GHR_MASS_TRANSFER_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 designed to store supplemental, conditional rules or qualifiers associated with a mass personnel transfer action. In the context of federal HR operations, a mass transfer is a bulk personnel action affecting multiple employees. This table enables the system to define and persist specific selection criteria beyond the basic action parameters, ensuring that the mass transfer process adheres to complex federal workforce management rules and targets the correct employee population.

Key Information Stored

The table's primary purpose is to link criteria to a specific mass transfer action. The documented structure highlights two critical columns. The primary key, MASS_TRANSFER_CRITERIA_ID, uniquely identifies each criteria record. The foreign key column, MASS_TRANSFER_ID, establishes the essential link to the parent mass transfer definition stored in the GHR_MASS_TRANSFERS table. While the provided metadata does not list all columns, typical criteria columns in such a table would include fields to capture conditions based on attributes like employee assignment details (e.g., organization, location, position), employment terms, or other federal-specific descriptors. These criteria are used to programmatically select which employee records are included in the mass action.

Common Use Cases and Queries

The primary use case is the execution and auditing of mass transfer actions within a federal agency. For example, an HR specialist may initiate a mass transfer to move all employees from a closing office to a new facility. The specific criteria (e.g., "All employees in Organization ID X at Location ID Y") would be stored in this table. Common queries involve joining to the parent table to review the criteria for a specific action or to identify all actions using a particular criterion. A sample reporting query would be:

  • SELECT m.transfer_name, c.* FROM ghr_mass_transfers m, ghr_mass_transfer_criteria c WHERE m.mass_transfer_id = c.mass_transfer_id AND m.status = 'PENDING';

This retrieves all stored criteria for mass transfer actions that are currently pending, aiding in validation and approval workflows.

Related Objects

The table has a documented, direct foreign key relationship with the GHR_MASS_TRANSFERS table, which serves as the master record for the mass transfer action itself. The relationship is defined as follows:

  • Foreign Key From: GHR_MASS_TRANSFER_CRITERIA.MASS_TRANSFER_ID
  • References Primary Key In: GHR_MASS_TRANSFERS table.

This relationship is critical; every record in GHR_MASS_TRANSFER_CRITERIA must be associated with a single, valid parent record in GHR_MASS_TRANSFERS. The integrity of this link ensures that criteria are not orphaned and are always contextualized within a defined personnel action. Other related objects would likely include the underlying employee assignment tables (such as PER_ALL_ASSIGNMENTS_F) that the criteria logic evaluates against during the mass transfer process.