Results for “std_completion_time”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GHR_NATURE_OF_ACTIONS is a reference (lookup) table owned by the HR schema in Oracle EBS 12.1.1 and 12.2.2. It is delivered as part of the GHR — US Federal Human Resources product family, and its documented purpose is to hold the master list of Nature of Action (NOA) codes used throughout federal HR personnel action processing. In US Federal HR terminology, a Nature of Action is the standardized code that identifies the type of personnel action being taken against an employee (for example, a new appointment, promotion, reassignment, separation, or pay adjustment). This table therefore provides the controlled vocabulary that drives validation, categorization, routing, and historical tracking of personnel actions across the GHR module.

From a dimensional or Data Vault perspective, the mined foreign-key structure suggests a hub-leaning classification. The table holds a stable, uniquely identified business concept (the NOA code) that is referenced by many dependent tables, but it also carries descriptive attributes such as description and completion time. This dual character means it can reasonably be modeled either as a reference/lookup dimension or as a hub with an associated satellite, depending on the enterprise data model in use.

Key Information Stored

The table contains 14 documented columns in the 12.2.2 physical schema. The most significant are:

• NATURE_OF_ACTION_ID — the surrogate primary key (part of GHR_NATURE_OF_ACTIONS_PK) that uniquely identifies each NOA record and serves as the join target for all foreign keys.
• CODE — the business-facing NOA code value; together with the edition column this forms the unique business-key candidate.
• DESCRIPTION — the human-readable explanation of the nature of action.
• STD_COMPLETION_TIME — the standard expected completion time associated with the action type, useful for routing and service-level tracking.
• ORDER_OF_PROCESSING — sequence value controlling the order in which NOAs are processed.
• ENABLED_FLAG — indicates whether the NOA is active and available for selection.
• DATE_FROM / DATE_TO — effective dating that governs the validity window of the code.
• ZD_EDITION_NAME — the editioning column (part of the unique index GHR_NATURE_OF_ACTIONS_PK, which spans NATURE_OF_ACTION_ID and ZD_EDITION_NAME), reflecting Oracle's edition-based redefinition model.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN support standard EBS audit tracking.

Common Use Cases and Queries

Typical uses include populating LOVs for personnel action entry, validating NOA codes on incoming action requests, and driving routing and processing logic. A basic lookup query:

• SELECT nature_of_action_id, code, description FROM ghr_nature_of_actions WHERE enabled_flag = 'Y' AND SYSDATE BETWEEN date_from AND NVL(date_to, SYSDATE);
• Joining to dependent tables such as GHR_PA_HISTORY or GHR_PA_REQUESTS to resolve codes into descriptions for reporting.
• Driving approval routing via GHR_PA_ROUTING_HISTORY and completion-time planning using STD_COMPLETION_TIME.

Related Objects

The table functions as the referenced parent for numerous dependent objects through the NATURE_OF_ACTION_ID key and, in some cases, dual NOA columns:

• GHR_PA_HISTORY (NATURE_OF_ACTION_ID) — historical personnel action records.
• GHR_PA_REQUESTS (FIRST_NOA_ID, SECOND_NOA_ID) — submitted personnel action requests supporting dual actions.
• GHR_PA_ROUTING_HISTORY (NATURE_OF_ACTION_ID, SECOND_NATURE_OF_ACTION_ID) — routing and approval trail.
• GHR_DUAL_ACTIONS (FIRST_NOA_ID, SECOND_NOA_ID) — pairing of two NOAs in a single action.
• GHR_NOAC_LAS, GHR_NOAC_REMARKS, GHR_NOA_FAMILIES, and GHR_MASS_AWARDS — each references NATURE_OF_ACTION_ID for classification, remarks, grouping, and mass award processing.

These relationships confirm the table's role as a central reference hub within the GHR Federal HR data model.