Search Results ghr_noa_families_pk




Overview
Explore in AI Chat

Overview

The GHR_NOA_FAMILIES 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. Its primary function is to establish and manage the relationships between Nature of Actions (NOAs) and Families. In the context of US federal personnel actions, a Nature of Action is a standardized code that defines a specific type of personnel transaction, such as a promotion or reassignment. The table serves as a critical junction, defining which Families—logical groupings of related NOAs—are associated with a given NOA. This association is fundamental for enforcing business rules, streamlining transaction processing, and ensuring data integrity within the federal personnel management lifecycle.

Key Information Stored

The table's structure is defined by a composite primary key, ensuring a unique relationship between its two core columns. The NATURE_OF_ACTION_ID column stores the unique identifier for a specific personnel action code, linking to the GHR_NATURE_OF_ACTIONS table. The NOA_FAMILY_CODE column stores the code for a logical grouping of NOAs, linking to the GHR_FAMILIES table. Together, these columns form the primary key (GHR_NOA_FAMILIES_PK). The table does not typically store extensive descriptive data; its value lies in the integrity of these relationships, which are enforced by foreign key constraints to their respective parent tables.

Common Use Cases and Queries

This table is primarily used for validation, reporting, and configuration. A common operational use case is during the initiation of a personnel action: the system can validate that a selected NOA belongs to an expected Family for a given process. For reporting and analysis, queries often join this table to retrieve meaningful descriptions. For instance, to list all NOAs within a specific family for a report or a setup screen, one might use a query such as:

  • SELECT f.FAMILY_NAME, n.NOA_NUMBER, n.DESCRIPTION
  • FROM GHR_NOA_FAMILIES nf,
  • GHR_FAMILIES f,
  • GHR_NATURE_OF_ACTIONS n
  • WHERE nf.NOA_FAMILY_CODE = f.FAMILY_CODE
  • AND nf.NATURE_OF_ACTION_ID = n.NATURE_OF_ACTION_ID
  • AND f.FAMILY_CODE = 'SEP'; -- Separation family, for example

System administrators use this table when configuring or updating the set of valid NOAs available for different transaction types within the federal HR framework.

Related Objects

The GHR_NOA_FAMILIES table sits at the center of a key relationship between two major reference tables, as defined by its foreign key constraints. The GHR_FAMILIES table is the parent for the NOA_FAMILY_CODE column, storing the definition and description of each Family. The GHR_NATURE_OF_ACTIONS table is the parent for the NATURE_OF_ACTION_ID column, serving as the master list of all valid personnel action codes with their detailed attributes. This table is also likely referenced by various GHR application forms, concurrent programs, and APIs that process personnel actions, ensuring any transaction uses a NOA appropriate for its intended business context based on Family membership.