Search Results pqh_copy_entity_attribs_pk




Overview
Explore in AI Chat

Overview

The PQH_COPY_ENTITY_ATTRIBS table is a core data structure within the Oracle E-Business Suite Public Sector Human Resources (PQH) module. It serves as the repository for the detailed criteria and change lists that drive mass process functionality. In the context of HR operations, particularly for public sector entities, this table is essential for defining and storing the specific attribute-level rules and modifications to be applied during bulk data operations, such as mass updates, transfers, or copying of employee or position data. Its role is to persist the granular configuration for these processes, enabling complex, rule-based transformations across multiple records.

Key Information Stored

While the provided metadata does not list individual columns beyond the keys, the table's structure is defined by its primary and foreign key relationships. The central column is COPY_ENTITY_ATTRIB_ID, which serves as the unique primary key identifier for each stored attribute rule. The COPY_ENTITY_TXN_ID is a critical foreign key column that links each attribute rule to its parent transaction or process definition stored in the PQH_COPY_ENTITY_TXNS table. Other columns, implied by the table's description, would store the specific criteria for selecting records (e.g., based on job, grade, location) and the detailed list of attributes to be changed (e.g., salary basis, working hours, assignment category) along with their target values for the mass process.

Common Use Cases and Queries

This table is directly queried in scenarios involving the execution, audit, or troubleshooting of mass HR processes. A common use case is reviewing all attribute-level changes configured for a specific mass transaction. For example, an HR analyst might run a query to see every field being modified by a pending mass salary update. A typical SQL pattern would join this table to its parent transaction table to provide context.

SELECT ctat.*
FROM   pqh_copy_entity_attribs ctat,
       pqh_copy_entity_txns cet
WHERE  ctat.copy_entity_txn_id = cet.copy_entity_txn_id
AND    cet.txn_name = '<Process_Name>';

Reporting use cases include generating change logs for compliance, validating process configurations before execution, and analyzing historical mass update patterns.

Related Objects

The table maintains a strict hierarchical relationship within the mass process framework, as documented in the provided metadata.

  • PQH_COPY_ENTITY_TXNS: This is the primary parent table. Each record in PQH_COPY_ENTITY_ATTRIBS must belong to a single, higher-level transaction defined in PQH_COPY_ENTITY_TXNS. The relationship is enforced via the foreign key: PQH_COPY_ENTITY_ATTRIBS.COPY_ENTITY_TXN_ID references PQH_COPY_ENTITY_TXNS.
  • PQH_COPY_ENTITY_ATTRIBS_PK: This is the primary key constraint on the COPY_ENTITY_ATTRIB_ID column, guaranteeing the uniqueness of each attribute rule record.

This table is likely referenced by the application's processing engine and related APIs (such as those in the PQH_COPY_ENTITY_PKG) that read its stored rules to execute the defined mass operations.