Search Results pqh_worksheets_pk




Overview
Explore in AI Chat

Overview

PQH_WORKSHEETS is a Public Sector HR (PQH) table owned by the HR schema that stores transaction data used when working on a budget version. In Oracle EBS 12.1.1 and 12.2.2, it functions as the working-area header for budget worksheet activity, capturing the definitional context of a worksheet — which budget, which version, which date range, and which transaction category — so that individual line-level transactions can be accumulated against a draft budget version before it is finalized. The table is registered as VALID in the ETRM dictionary with eighteen documented columns in the 12.2.2 physical schema.

The mined Data Vault classification for PQH_WORKSHEETS is satellite-leaning. As a modeling suggestion rather than a delivered characteristic, this indicates the table behaves primarily as a descriptive, context-carrying record whose identity is defined by its parent budget and budget version, with a child detail table holding the granular activity. It is not a pure hub, since it has no natural business key documented outside its surrogate, and it is not a pure link, since it carries substantial descriptive attributes of its own.

Key Information Stored

The surrogate primary key is WORKSHEET_ID, enforced through the unique index PQH_WORKSHEETS_PK. This is the sole documented unique index, and therefore the only business-key candidate identified in the metadata; consumers should treat it as a system-generated identifier rather than a user-meaningful key.

Common Use Cases and Queries

Reporting on budget worksheet activity typically begins at the header and joins down to detail. A representative pattern retrieves worksheets for an active budget version:

  • List worksheets by version: SELECT w.worksheet_id, w.worksheet_name, w.transaction_status FROM pqh_worksheets w WHERE w.budget_version_id = :p_version;
  • Resolve the owning budget and version: join PQH_BUDGETS on BUDGET_ID and PQH_BUDGET_VERSIONS on BUDGET_VERSION_ID.
  • Aggregate worksheet lines: join PQH_WORKSHEET_DETAILS on WORKSHEET_ID and group by worksheet.
  • Classify transactions: join PQH_TRANSACTION_CATEGORIES on WF_TRANSACTION_CATEGORY_ID.
  • Audit stale working areas by filtering DATE_TO or LAST_UPDATE_DATE.

The reference to a workbook such as "kt Sheet - 2026 DT.xlsx" is external to the database; the table itself stores no file or attachment columns. Workbook content reaches PQH only after it is loaded or interfaced into worksheet and detail rows.

Related Objects

  • PQH_BUDGETS — parent budget, joined via PQH_WORKSHEETS.BUDGET_ID.
  • PQH_BUDGET_VERSIONS — parent version, joined via PQH_WORKSHEETS.BUDGET_VERSION_ID.
  • PQH_TRANSACTION_CATEGORIES — transaction classification, joined via WF_TRANSACTION_CATEGORY_ID.
  • PQH_WORKSHEET_DETAILS — child table referencing PQH_WORKSHEETS.WORKSHEET_ID, holding the granular worksheet lines.
  • Oracle Application Framework (OAF) pages — the worksheet maintenance UI, which relies on OBJECT_VERSION_NUMBER for concurrent-update control.