Search Results ghr_pa_request_info_types




Overview
Explore in AI Chat

Overview

The GHR_PA_REQUEST_INFO_TYPES table is a core reference table within the Oracle E-Business Suite US Federal Human Resources (GHR) module. It functions as a master definition table for categorizing and structuring supplemental data, known as "Extra Information," that can be attached to personnel action (PA) requests. In the context of federal HR processes, a personnel action request is a formal proposal for a change in an employee's status, such as a promotion, reassignment, or termination. This table defines the distinct types or categories of this ancillary information, enabling a flexible and structured method to capture data beyond the standard transaction fields, which is often required for complex federal reporting and compliance.

Key Information Stored

The primary data stored in this table is the definition of each valid information type. Based on the provided metadata, the key column is INFORMATION_TYPE, which serves as the table's primary key (GHR_PA_REQUEST_INFO_TYPES_PK). This column uniquely identifies each category of extra information, such as "Justification Details," "Regulatory Citations," or "Funding Source." The table also includes a foreign key relationship via the NOA_FAMILY_CODE column to the GHR_FAMILIES table. This link associates an information type with a specific family of Notices of Action (NOA), indicating that certain extra information categories may only be relevant or required for particular types of personnel actions.

Common Use Cases and Queries

The primary use case is to control and validate the entry of extra information on personnel action request forms within the GHR application. When a user is prompted to enter supplemental data, the application references this table to present a validated list of information types. Common operational and reporting queries involve joining this master table to the transactional tables that store the actual data. For instance, to report on all personnel actions that have a specific type of extra information attached, a query would join GHR_PA_REQUEST_INFO_TYPES to GHR_PA_REQUEST_EXTRA_INFO. A sample SQL pattern to list all defined information types and their associated NOA families would be:

  • SELECT inf.INFORMATION_TYPE, fam.MEANING AS FAMILY
  • FROM HR.GHR_PA_REQUEST_INFO_TYPES inf,
  • HR.GHR_FAMILIES fam
  • WHERE inf.NOA_FAMILY_CODE = fam.FAMILY_CODE(+);

Related Objects

As indicated by the foreign key constraints, GHR_PA_REQUEST_INFO_TYPES is centrally linked to several key transactional tables. The GHR_PA_REQUEST_EXTRA_INFO table stores the actual values entered for each information type on a request. The GHR_PA_REQUEST_EI_SHADOW table, typically used for data integrity and audit purposes during transaction processing, also references the INFORMATION_TYPE. Furthermore, the relationship with GHR_FAMILIES ties the information type definitions to the broader framework of personnel action classifications. These relationships ensure data consistency and enforce business rules governing what supplemental information is applicable for different action scenarios.