Search Results worksheet_period_id




Overview
Explore in AI Chat

Overview

The table PQH_WORKSHEET_PERIODS_EFC is a specialized data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Public Sector HR (PQH) module. Its primary role is to serve as a functional currency conversion repository. As documented, it is a direct copy of the base table PQH_WORKSHEET_PERIODS, populated exclusively by the EFC (Euro as Functional Currency) process. This process is critical for organizations operating in the Eurozone, enabling them to convert and store transactional HR data, specifically related to worksheet periods, in Euros for consistent financial and managerial reporting, regardless of the original transaction currency.

Key Information Stored

The table stores a Euro-converted replica of data concerning budget worksheet periods. Its structure is defined by the primary key constraint PQH_WORKSHEET_PERIODS_EFC_PK, which is a composite key based on two columns. The first, WORKSHEET_PERIOD_ID, is the primary identifier linking each record back to its source record in the original PQH_WORKSHEET_PERIODS table. The second, EFC_ACTION_ID, is a foreign key that links to the HR_EFC_ACTIONS table, which tracks and controls the execution of the EFC conversion process. This linkage ensures traceability and auditability for each converted record. Other columns in the table mirror those in the base table, holding period details such as start and end dates, status, and associated budget entity information, but with monetary values represented in Euros.

Common Use Cases and Queries

The primary use case is generating financial reports and analyses where all figures must be presented in a single functional currency (Euro). Common queries involve joining this table with other EFC-converted tables to produce consolidated Euro-based reports. For instance, to retrieve all converted worksheet periods for a specific EFC conversion run, a query would filter on the EFC_ACTION_ID. Developers and DBAs may also query this table to verify data population post-conversion or to troubleshoot discrepancies between the base and converted data sets.

  • Sample Query: Retrieving converted periods for a specific action:
    SELECT worksheet_period_id, period_name, start_date, end_date FROM pqh_worksheet_periods_efc WHERE efc_action_id = &action_id;
  • Sample Query: Comparing base and converted records for validation:
    SELECT b.worksheet_period_id, b.period_name, e.period_name FROM pqh_worksheet_periods b, pqh_worksheet_periods_efc e WHERE b.worksheet_period_id = e.worksheet_period_id;

Related Objects

This table has direct dependencies within the EBS HR schema. Its core relationship is with the source table, PQH_WORKSHEET_PERIODS, from which its structure and data are derived. As per the foreign key constraint, it is dependent on the HR_EFC_ACTIONS table, which governs the EFC process lifecycle. It is part of a broader ecosystem of EFC tables (e.g., PQH_BUDGET_PERIODS_EFC, PQH_BUDGET_VERSIONS_EFC) that together provide a comprehensive Euro-converted view of Public Sector HR budgeting data. Integration with these related objects is essential for complete Euro-based reporting and compliance.