Search Results ghr_pa_request_ei_shadow




Overview
Explore in AI Chat

Overview

The GHR_PA_REQUEST_EI_SHADOW table is a core data object within the US Federal Human Resources (GHR) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. As indicated by its name and documented description, this table functions as a shadow or mirror table. Its primary role is to store a complete copy of the columns from a corresponding record in the GHR_PA_REQUEST_EXTRA_INFO table. This architectural pattern is commonly used in EBS to support complex data operations, such as maintaining historical snapshots, facilitating audit trails, or enabling specific data processing workflows within the Personnel Action (PA) request functionality for US federal government entities.

Key Information Stored

The table's structure is designed to replicate the columns of its parent table. While the specific column list is not detailed in the provided metadata, the documented primary and foreign keys reveal its critical identifiers. The primary key is PA_REQUEST_EXTRA_INFO_ID, which uniquely identifies each shadow record. Two essential foreign key columns establish its relational integrity: PA_REQUEST_ID links the shadow data to a specific personnel action request in the GHR_PA_REQUESTS table, and INFORMATION_TYPE categorizes the extra information by linking to the GHR_PA_REQUEST_INFO_TYPES lookup table. These relationships ensure that every record in the shadow table is associated with a valid request and a defined information type.

Common Use Cases and Queries

This table is typically accessed for auditing, data reconciliation, and troubleshooting purposes within federal HR processes. Common scenarios include comparing current extra information against its shadow copy to identify changes made during a personnel action lifecycle or generating reports on historical data states. A typical query would join the shadow table to its parent and request tables to analyze data evolution. For example:

  • Retrieving all shadow records for a specific request to audit changes: SELECT * FROM hr.ghr_pa_request_ei_shadow WHERE pa_request_id = &request_id ORDER BY pa_request_extra_info_id;
  • Comparing a specific record with its current counterpart: SELECT * FROM hr.ghr_pa_request_extra_info WHERE pa_request_extra_info_id = &id UNION ALL SELECT * FROM hr.ghr_pa_request_ei_shadow WHERE pa_request_extra_info_id = &id;

Related Objects

The GHR_PA_REQUEST_EI_SHADOW table is integral to a cluster of objects within the GHR module, as defined by its documented foreign key relationships.

  • GHR_PA_REQUESTS: This is the master table for personnel action requests. The shadow table references it via the PA_REQUEST_ID column, anchoring each piece of shadowed extra information to a specific personnel transaction.
  • GHR_PA_REQUEST_INFO_TYPES: This lookup table defines the valid types of extra information that can be associated with a request. The shadow table references it via the INFORMATION_TYPE column, classifying the data stored in each shadow record.
  • GHR_PA_REQUEST_EXTRA_INFO: As explicitly stated in the documentation, this is the primary table for which GHR_PA_REQUEST_EI_SHADOW stores corresponding column data. They share the same primary key (PA_REQUEST_EXTRA_INFO_ID), forming a direct record-to-record relationship.