Search Results noa_family_code

Overview

The HR.GHR_FAMILIES table is a core reference table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Global Human Resources (GHR) module. Its primary function is to categorize and group different Nature of Actions (NOA) based on shared operational and data characteristics. This grouping is essential for standardizing and streamlining the processing of Personnel Action (PA) Requests. The table defines families that share common processing methods, logic for updating HR records, required items for HR updates, or information types for capturing supplementary PA Request data. By serving as a central lookup, it enforces consistency and reduces redundancy in the configuration of complex personnel transactions.

Key Information Stored

The table's structure is designed to define the family's key and its specific classification. The primary column, NOA_FAMILY_CODE (VARCHAR2(30)), is the unique identifier and primary key for each family. The NAME column (VARCHAR2(100)) provides a descriptive title. The table's purpose is further refined by four critical flag columns, each indicating a specific grouping criterion: PROC_METHOD_FLAG signifies families sharing processing methods; UPDATE_HR_FLAG (inferred from truncated metadata) indicates shared HR update logic; REQUIRED_FLAG denotes families with common required items for HR updates; and PA_INFO_TYPE_FLAG identifies families used for grouping PA Request extra information types. These flags determine how a given family is applied within various GHR processes.

Common Use Cases and Queries

This table is predominantly used for setup, reporting, and as a foreign key constraint in transactional tables. Common scenarios include validating configuration for a new Nature of Action or generating reference lists for application forms. A typical query retrieves all families used for a specific purpose, such as identifying all processing method families:

• SELECT noa_family_code, name FROM hr.ghr_families WHERE proc_method_flag = 'Y' ORDER BY name;

Another frequent use is joining with transactional tables like GHR_PA_REQUESTS to report on actions by family:

• SELECT f.name, COUNT(*) FROM hr.ghr_pa_requests p, hr.ghr_families f WHERE p.noa_family_code = f.noa_family_code GROUP BY f.name;

It is also central to understanding the configuration of a specific NOA through its relationship with the GHR_NOA_FAMILIES table.

Related Objects

HR.GHR_FAMILIES is a pivotal parent table referenced by numerous key objects in the GHR schema. Its primary key, NOA_FAMILY_CODE, is a foreign key in several important tables, establishing critical data integrity. Major dependent objects include the transactional GHR_PA_REQUESTS table and the configuration tables GHR_NOA_FAMILIES and GHR_DUAL_ACTIONS. It is also referenced by processing method tables (GHR_NOA_FAM_PROC_METHODS, GHR_DUAL_PROC_METHODS), information type tables (GHR_PA_REQUEST_INFO_TYPES), and the routing history table (GHR_PA_ROUTING_HISTORY). This extensive network of foreign key relationships underscores its role as a fundamental classification entity within the GHR data model.