Results for “distribution_percentage”

50+ results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The PQH_WORKSHEET_BDGT_ELMNTS table is a Public Sector HR (PQH) transactional table that stores the element-wise distribution of measurement units within a worksheet budget set. In Oracle EBS 12.1.1 and 12.2.2, it sits within the Position Control and budget worksheet model used by public sector and government organizations to allocate full-time-equivalent (FTE) positions, funding, and measurement quantities against specific budget elements during the position budget preparation cycle. Each row represents a single budget element distribution line tied to a parent worksheet budget set, enabling the system to quantify how positions or resources are spread across defined element types such as salary, fringe, or other costing components.

Its role is fundamentally associative: it holds the detail lines that a worksheet budget set comprises, and those lines are in turn consumed by fund source records. The metadata classifies the object heuristically as satellite-leaning under a Data Vault modeling lens. This is a reasonable suggestion because the table carries descriptive and measurable attributes (notably DISTRIBUTION_PERCENTAGE) that evolve over time and describe the distribution rather than acting purely as an intersection of two hubs. Analysts constructing a dimensional or Data Vault representation should treat it as a satellite attached to the worksheet budget set business key, rather than a pure link.

Key Information Stored

The table is documented with ten physical columns in the HR schema. The most important of these are described below.

  • WORKSHEET_BDGT_ELMNT_ID — the surrogate primary key, enforced by the unique index PQH_WORKSHEET_BDGT_ELMNTS_PK. It uniquely identifies each element distribution line.
  • WORKSHEET_BUDGET_SET_ID — foreign key to the parent worksheet budget set; identifies the budget worksheet context to which the line belongs.
  • ELEMENT_TYPE_ID — identifies the budget element type being distributed. Together with WORKSHEET_BUDGET_SET_ID it forms the documented business key, enforced by the unique index PQH_WORKSHEET_BDGT_ELMNTS_UK. This unique constraint guarantees that any given budget set carries at most one distribution line per element type.
  • DISTRIBUTION_PERCENTAGE — the measurement quantity that expresses how the element is distributed, representing the percentage or proportional allocation for that element within the budget set.
  • OBJECT_VERSION_NUMBER — the optimistic locking column used by the framework to detect concurrent updates.
  • Audit columns LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, and CREATION_DATE — standard WHO columns recording creation and modification metadata.

Separating the surrogate key from the business key is critical in integrations: the surrogate key is the physical join target, whereas the (WORKSHEET_BUDGET_SET_ID, ELEMENT_TYPE_ID) pair is the stable natural identifier to reconcile when data is merged across environments.

Common Use Cases and Queries

The primary use case is budget worksheet reporting: determining how a given budget set distributes its measurement units across element types. A typical query joins the element lines to their parent budget set and their downstream fund sources.

  • Retrieving the element distribution for a worksheet budget set, filtering on WORKSHEET_BUDGET_SET_ID and ordering by ELEMENT_TYPE_ID.
  • Validating that the sum of DISTRIBUTION_PERCENTAGE for a budget set does not exceed expected totals — a common budget integrity check.
  • Joining to PQH_WORKSHEET_FUND_SRCS on WORKSHEET_BDGT_ELMNT_ID to trace which fund sources are associated with each element distribution line.
  • Audit reporting, comparing CREATION_DATE and LAST_UPDATE_DATE to identify recently modified distributions.

A representative pattern is a correlated or aggregate query grouping by WORKSHEET_BUDGET_SET_ID and summing DISTRIBUTION_PERCENTAGE, then comparing that total against the overall budget allocation. Because the unique key permits one row per element type per set, SUM checks are deterministic and reliable.

Related Objects

  • PQH_WORKSHEET_BUDGET_SETS — parent object; joined via PQH_WORKSHEET_BDGT_ELMNTS.WORKSHEET_BUDGET_SET_ID = PQH_WORKSHEET_BUDGET_SETS.WORKSHEET_BUDGET_SET_ID.
  • PQH_WORKSHEET_FUND_SRCS — child object referencing this table; joined via PQH_WORKSHEET_FUND_SRCS.WORKSHEET_BDGT_ELMNT_ID = PQH_WORKSHEET_BDGT_ELMNTS.WORKSHEET_BDGT_ELMNT_ID.
  • Element type definition tables referenced by ELEMENT_TYPE_ID — the owning lookup source for the element classification.

Together these objects form the worksheet budget hierarchy: budget sets partition into element distributions, which are then funded through source records. Any extraction or report on position budgeting in Public Sector HR will depend on this table alongside its parent and child objects.