Search Results ghr_nature_of_actions

Overview

The GHR_NATURE_OF_ACTIONS table is a core reference data table within the Oracle E-Business Suite US Federal Human Resources (GHR) module. It serves as the master repository for Nature of Action (NOA) codes, which are standardized identifiers used to classify personnel actions within the US federal government. These codes are critical for defining and processing personnel transactions, such as appointments, promotions, reassignments, and separations, ensuring compliance with federal reporting requirements like those for the Office of Personnel Management (OPM). The table's primary key, GHR_NATURE_OF_ACTIONS_PK, uniquely identifies each code and is extensively referenced throughout the GHR schema to maintain data integrity and enforce business rules related to personnel actions.

Key Information Stored

The central column in this table is NATURE_OF_ACTION_ID, the primary key populated by a sequence. While the provided metadata does not list all columns, a typical implementation includes fields such as NATURE_OF_ACTION_CODE (the alphanumeric NOA code), DESCRIPTION, EFFECTIVE_DATE, and ENABLED_FLAG. The table stores the valid list of codes that can be applied to personnel actions, forming the basis for transaction processing, workflow routing, and regulatory reporting within the federal HR lifecycle.

Common Use Cases and Queries

This table is primarily used for validation, reporting, and as a lookup source. Common scenarios include validating a NOA code entered on a personnel action request, generating reports of actions by type, and populating list of values (LOVs) in the application's user interface. A fundamental query involves joining this table to transaction tables to retrieve descriptive information for codes. For example, to list personnel actions with their NOA descriptions, a query would join to GHR_PA_REQUESTS:

• SELECT pr.request_number, noa.nature_of_action_code, noa.description FROM ghr_pa_requests pr, ghr_nature_of_actions noa WHERE pr.first_noa_id = noa.nature_of_action_id;

Administrative queries to audit or maintain the code list are also common, such as selecting all active NOA codes for a given date.

Related Objects

The GHR_NATURE_OF_ACTIONS table has a primary integration role, as evidenced by its numerous foreign key relationships. The following tables reference it via the NATURE_OF_ACTION_ID column or specific derivatives, enforcing that personnel actions use valid, predefined codes:

• GHR_DUAL_ACTIONS: References the table twice for FIRST_NOA_ID and SECOND_NOA_ID.
• GHR_MASS_AWARDS: References via NATURE_OF_ACTION_ID.
• GHR_NOAC_LAS, GHR_NOAC_REMARKS, GHR_NOA_FAMILIES: Reference for code-specific attributes and groupings.
• GHR_PA_HISTORY, GHR_PA_REQUESTS, GHR_PA_ROUTING_HISTORY: Core transaction tables that link to one or two NOA codes (e.g., FIRST_NOA_ID, SECOND_NOA_ID, NATURE_OF_ACTION_ID) to classify the personnel action being processed or recorded.