Search Results nature_of_action_id

Overview

The HR.GHR_NATURE_OF_ACTIONS table is a core reference data table within the Oracle E-Business Suite (EBS) Federal Human Resources (GHR) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master repository for Nature of Action (NOA) codes, which are standardized identifiers used to classify the type of personnel action being requested or processed. The table's primary role is to provide a validated list of codes that can be assigned to a Request for Personnel Action (RPA), ensuring consistency and accuracy in tracking appointments, promotions, separations, and other federal personnel transactions. As a seed data table stored in the APPS_TS_SEED tablespace, it is typically populated during implementation and maintained through administrative functions.

Key Information Stored

The table maintains a concise but critical set of columns for managing NOA codes. The primary identifier is the NATURE_OF_ACTION_ID, a system-generated unique number (NUMBER(15)) sourced from the sequence GHR_NATURE_OF_ACTIONS_S. This surrogate key is used for all internal relationships. The business key is the CODE (VARCHAR2(4)), a mandatory four-character alphanumeric field representing the official NOA code. Each code is accompanied by a DESCRIPTION (VARCHAR2(240)), a mandatory textual explanation of the action type. The table's integrity is enforced by the primary key constraint GHR_NATURE_OF_ACTIONS_PK on the NATURE_OF_ACTION_ID column.

Common Use Cases and Queries

This table is primarily referenced for validation, reporting, and data lookup within personnel action workflows. Common operational scenarios include validating a user-entered NOA code during RPA creation, generating lists of available actions for dropdowns, and reporting on the frequency of action types. A typical query to retrieve all active NOA codes for a lookup would be:

• SELECT code, description FROM hr.ghr_nature_of_actions ORDER BY code;

For troubleshooting or analyzing specific personnel requests, one often joins this table to transactional data. For example, to find all RPAs with a specific NOA description:

• SELECT pr.request_number, noa.code, noa.description FROM hr.ghr_pa_requests pr JOIN hr.ghr_nature_of_actions noa ON pr.first_noa_id = noa.nature_of_action_id WHERE noa.description LIKE '%Promotion%';

Related Objects

The GHR_NATURE_OF_ACTIONS table is a central reference point for numerous transactional and setup tables in the GHR module, as evidenced by its foreign key relationships. Key dependent objects include:

• GHR_PA_REQUESTS: References the table via FIRST_NOA_ID and SECOND_NOA_ID to classify the primary and secondary actions for an RPA.
• GHR_PA_HISTORY & GHR_PA_ROUTING_HISTORY: Track the NOA associated with historical and routing steps of personnel actions.
• GHR_DUAL_ACTIONS: Uses FIRST_NOA_ID and SECOND_NOA_ID to define valid pairs of concurrent personnel actions.
• Setup Tables: Referenced by GHR_NOA_FAMILIES, GHR_NOAC_LAS (linking NOA to Legal Authorities), and GHR_NOAC_REMARKS for configuring action properties.
• GHR_MASS_AWARDS: Specifies the NOA for bulk award processing.