Search Results pqh_worksheet_details_efc

Overview

The table PQH_WORKSHEET_DETAILS_EFC is a specialized data object within the Oracle E-Business Suite (EBS) Public Sector HR (PQH) module. It serves as a functional copy of the core PQH_WORKSHEET_DETAILS table, created and populated specifically by the Euro as Functional Currency (EFC) process. This process is critical for organizations operating in the Eurozone, as it facilitates the conversion and storage of financial and budgetary data from legacy national currencies into the Euro. The table's existence is tied to compliance and reporting requirements, ensuring that historical and transactional data related to HR worksheets is accurately maintained in the functional currency for audit trails, reconciliation, and comparative analysis.

Key Information Stored

The table's structure is defined by its composite primary key, which consists of two columns. The WORKSHEET_DETAIL_ID is the core identifier, linking each record back to its source entry in the original PQH_WORKSHEET_DETAILS table, which stores detailed line items for HR budgeting or planning worksheets. The EFC_ACTION_ID is a crucial column that ties this converted data to a specific run of the EFC conversion process. This foreign key references the HR_EFC_ACTIONS table, which logs metadata about each conversion event, such as the execution date and parameters. While the ETRM excerpt does not list all columns, the table inherently holds a copy of the relevant financial and descriptive data from the source worksheet details, with amounts presumably stored in Euros post-conversion.

Common Use Cases and Queries

The primary use case is historical reporting and auditing of HR worksheet data in the functional Euro currency. Analysts can run reports to compare pre- and post-Euro conversion figures or trace the impact of currency conversion on budget lines. A common query pattern involves joining this table to the EFC actions log to understand the context of the converted data.

• Retrieving Converted Worksheet Details for a Specific EFC Run:
  SELECT wd_efc.* FROM pqh_worksheet_details_efc wd_efc WHERE wd_efc.efc_action_id = <action_id>;
• Comparing Source and Converted Data for Audit:
  SELECT src.worksheet_detail_id, src.amount as src_amount, efc.amount as efc_amount FROM pqh_worksheet_details src JOIN pqh_worksheet_details_efc efc ON src.worksheet_detail_id = efc.worksheet_detail_id WHERE efc.efc_action_id = <action_id>;

Related Objects

This table has defined dependencies within the HR schema, primarily through its foreign key relationship.

• HR_EFC_ACTIONS (Table): This is the parent table referenced by the foreign key. The column PQH_WORKSHEET_DETAILS_EFC.EFC_ACTION_ID joins to HR_EFC_ACTIONS, providing the context for the currency conversion action that populated the record.
• PQH_WORKSHEET_DETAILS (Table): As a direct copy, this is the source table. While not a formally documented foreign key in the provided metadata, the WORKSHEET_DETAIL_ID column semantically originates from and corresponds to the primary key of PQH_WORKSHEET_DETAILS, enabling data lineage analysis.