Search Results ghr_pa_request_extra_info

Overview

The GHR_PA_REQUEST_EXTRA_INFO table is a core data structure within the Oracle E-Business Suite US Federal Human Resources (GHR) module. It functions as a flexible extension table designed to store supplemental, type-specific information related to personnel action (PA) requests. Its primary role is to support the complex and highly regulated requirements of U.S. federal personnel management by allowing for the attachment of diverse data elements to a standard personnel action transaction, which is centrally managed in the GHR_PA_REQUESTS table.

Key Information Stored

The table's design centers on a key-value pair model, where the information type dictates the nature of the data stored. The critical columns include PA_REQUEST_EXTRA_INFO_ID, which serves as the unique primary key identifier for each record. The PA_REQUEST_ID is a foreign key that links the supplemental data to its parent personnel action request in the GHR_PA_REQUESTS table. The INFORMATION_TYPE column, also a foreign key, categorizes the extra information and references valid types defined in the GHR_PA_REQUEST_INFO_TYPES table. Additional columns, not fully detailed in the provided metadata but typical for such structures, would store the actual information value (e.g., INFORMATION1, INFORMATION2, or a CLOB field) and standard Who columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) for auditing.

Common Use Cases and Queries

This table is essential for reporting, data validation, and process automation within federal HR workflows. A common use case is retrieving all supplemental information for a specific personnel action request for audit or review purposes. For example, a query might join this table to its parent to extract a complete request dossier. Another frequent scenario involves validating that required supplemental data, based on the action's type and subtype, has been provided before a request can be approved. Sample SQL to find all extra information for a given request would be:

• SELECT e.* FROM hr.ghr_pa_request_extra_info e, hr.ghr_pa_requests r WHERE e.pa_request_id = r.pa_request_id AND r.request_number = 'PA-12345';

Reporting use cases include generating lists of requests that contain specific types of extra information, such as all actions with a particular justification code or clearance level attached.

Related Objects

The table exists within a defined relational framework, primarily linking to two other key GHR tables. The documented foreign key relationships are as follows:

• GHR_PA_REQUESTS: The PA_REQUEST_ID column in GHR_PA_REQUEST_EXTRA_INFO references the primary key of the GHR_PA_REQUESTS table. This establishes the core parent-child relationship, ensuring all extra information is tied to a valid personnel action request.
• GHR_PA_REQUEST_INFO_TYPES: The INFORMATION_TYPE column in GHR_PA_REQUEST_EXTRA_INFO references the GHR_PA_REQUEST_INFO_TYPES table. This relationship controls data integrity by ensuring that only predefined and valid information types can be used to categorize the stored extra data.

The table's primary key constraint, GHR_PA_REQUEST_EXTRA_INFO_PK, ensures the uniqueness of each record via the PA_REQUEST_EXTRA_INFO_ID column.