Search Results ghr_noac_las_uk

Overview

The GHR_NOAC_LAS table is a core data object within the Oracle E-Business Suite US Federal Human Resources (GHR) module. Its primary function is to establish and store the relationship between Nature of Action (NOA) codes and their associated Legal Authorities. In the context of U.S. federal personnel actions, a Nature of Action defines the type of personnel transaction (e.g., hire, promotion, termination), while a Legal Authority is the specific statute, executive order, or regulation that permits or mandates that action. This table acts as a critical junction, ensuring that every personnel action processed in the system is linked to a valid, governing legal authority as required by federal compliance standards.

Key Information Stored

The table's structure is designed to enforce unique and valid associations between its key entities. The primary identifier for each record is the NOAC_LA_ID column. The table's uniqueness is governed by a composite key constraint (GHR_NOAC_LAS_UK) on two critical foreign key columns: NATURE_OF_ACTION_ID and LAC_LOOKUP_CODE. The NATURE_OF_ACTION_ID column references a specific action code defined in the GHR_NATURE_OF_ACTIONS table. The LAC_LOOKUP_CODE column stores the code for the associated Legal Authority, which is typically sourced from a standard Oracle EBS Lookup type specific to the GHR module. This design prevents duplicate links between the same action and authority.

Common Use Cases and Queries

This table is essential for data validation during the creation or modification of federal personnel actions. A common operational use case is to validate that a user-selected Nature of Action is permitted under a chosen Legal Authority before saving a personnel action. For reporting and compliance, it is used to audit the legal basis for personnel transactions. A typical query would join this table to the nature of actions and lookup tables to produce a list of all valid NOA-Legal Authority combinations.

• Validation Query: SELECT 1 FROM ghr_noac_las WHERE nature_of_action_id = :p_noa_id AND lac_lookup_code = :p_la_code;
• Reporting Query: SELECT gnal.lac_lookup_code, gna.name FROM ghr_noac_las gnal JOIN ghr_nature_of_actions gna ON gnal.nature_of_action_id = gna.nature_of_action_id ORDER BY gna.name;

Related Objects

The GHR_NOAC_LAS table has a direct and fundamental relationship with the GHR_NATURE_OF_ACTIONS table, as defined by its foreign key. This ensures referential integrity, meaning a record in GHR_NOAC_LAS cannot exist without a corresponding valid Nature of Action. The LAC_LOOKUP_CODE column is dependent on a seeded lookup type (likely named something similar to 'GHR_LEGAL_AUTHORITY_CODE'), which provides the list of valid legal authority codes. This table is also a likely reference point for other GHR transactional tables and forms that process personnel actions, ensuring the NOA-Authority link is maintained throughout the business process.