Search Results ghr_noa_fam_proc_methods_pk

Overview

The table GHR_NOA_FAM_PROC_METHODS is a core intersection entity within the US Federal Human Resources (GHR) module of Oracle E-Business Suite 12.1.1 and 12.2.2. It functions as a critical mapping table that establishes the permissible relationships between personnel action (PA) data fields and Notice of Action (NOA) families. Its primary role is to define which specific processing methods (represented by PA data fields) are applicable to a given family of personnel actions. This configuration is essential for enforcing business rules and ensuring the correct data is captured and processed during federal personnel transactions, such as appointments, promotions, or separations.

Key Information Stored

The table's structure is defined by a composite primary key, which enforces the uniqueness of the relationship it stores. The key columns are:

• NOA_FAMILY_CODE: A foreign key referencing the GHR_FAMILIES table. This code identifies a specific grouping or family of personnel actions that share common processing characteristics.
• PA_DATA_FIELD_ID: A foreign key referencing the GHR_PA_DATA_FIELDS table. This identifier points to a specific personnel action data field, which represents a processing method or a piece of data required for actions within the associated family.

Each record in this table signifies that a particular PA_DATA_FIELD_ID is valid and required for processing personnel actions belonging to the specified NOA_FAMILY_CODE.

Common Use Cases and Queries

This table is primarily used for configuration validation and dynamic form generation within the GHR module. A common use case is to determine all required data fields when initiating a new personnel action of a specific type. For instance, to retrieve all processing methods associated with the 'S' (Service History) family, a query would join to the descriptive tables:

• SELECT f.FAMILY_NAME, pdf.DATA_FIELD_NAME FROM HR.GHR_NOA_FAM_PROC_METHODS map JOIN HR.GHR_FAMILIES f ON map.NOA_FAMILY_CODE = f.FAMILY_CODE JOIN HR.GHR_PA_DATA_FIELDS pdf ON map.PA_DATA_FIELD_ID = pdf.PA_DATA_FIELD_ID WHERE map.NOA_FAMILY_CODE = 'S';

Conversely, to find which action families utilize a specific data field, the join can be reversed. This table is also central to backend validation routines that check if a submitted personnel action contains all mandatory data elements as defined by its family's mapped methods.

Related Objects

GHR_NOA_FAM_PROC_METHODS sits at the intersection of two key master tables in the GHR schema, as defined by its foreign key constraints:

• GHR_FAMILIES: Related via the column GHR_NOA_FAM_PROC_METHODS.NOA_FAMILY_CODE. This table contains the master list of personnel action families (e.g., Appointment, Promotion, Separation).
• GHR_PA_DATA_FIELDS: Related via the column GHR_NOA_FAM_PROC_METHODS.PA_DATA_FIELD_ID. This table defines the individual data fields or processing methods available for use across all personnel actions.

The table itself is secured by the primary key constraint GHR_NOA_FAM_PROC_METHODS_PK on the combination of NOA_FAMILY_CODE and PA_DATA_FIELD_ID. It is a foundational object for any process or report that requires understanding the linkage between an action's category and its required data elements.