Results for “dflt_elmnt_frequency”

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

Overview

PQH_BDGT_CMMTMNT_ELMNTS is a Public Sector HR (PQH) table owned by the HR schema in Oracle EBS 12.1.1 and 12.2.2. It stores the elements used to compute commitments against a budget. In Public Sector budgeting workflows, a commitment represents an anticipated financial obligation tied to an element such as a salary basis, an element input value, a formula, or an overhead percentage. This table defines which of those components participate in the commitment calculation and how their default frequency is derived.

The table carries 17 documented columns and is keyed by the surrogate primary key PQH_BDGT_CMMTMNT_ELMNTS_PK on BDGT_CMMTMNT_ELMNT_ID. Its only documented foreign key references PER_TIME_PERIOD_TYPES through the DFLT_ELMNT_FREQUENCY column, meaning each commitment element draws its default timing cadence from the shared time period type definitions. Based on the foreign key structure mined from the metadata, the heuristic Data Vault classification is satellite-leaning: the table behaves as a descriptive, dependent structure attached to a parent budget entity rather than as an independent hub or an associative link.

Key Information Stored

The surrogate primary key is BDGT_CMMTMNT_ELMNT_ID, which uniquely identifies each commitment element row. The column BUDGET_ID anchors the record to its owning budget, while ELEMENT_TYPE_ID identifies the kind of element being configured.

• BDGT_CMMTMNT_ELMNT_ID — surrogate primary key for the commitment element.
• BUDGET_ID — the budget to which the element belongs.
• ELEMENT_TYPE_ID — classifies the element used in the commitment computation.
• SALARY_BASIS_FLAG — indicates whether a salary basis drives the commitment.
• ELEMENT_INPUT_VALUE_ID — the input value associated with the element.
• FREQUENCY_INPUT_VALUE_ID — input value governing frequency.
• FORMULA_ID — the formula applied when computing the commitment.
• DFLT_ELMNT_FREQUENCY — default frequency, keyed to PER_TIME_PERIOD_TYPES.
• OVERHEAD_PERCENTAGE — overhead uplift applied to the element.
• ACTUAL_COMMITMENT_TYPE — categorizes the actual commitment.
• BALANCE_TYPE_ID — links the element to a balance type.
• OBJECT_VERSION_NUMBER and the CREATED_BY / CREATION_DATE / LAST_UPDATED_BY / LAST_UPDATE_DATE / LAST_UPDATE_LOGIN audit columns — standard EBS concurrency and auditing attributes.

The only documented unique index is the primary key; no separate business-key unique index is defined, so BDGT_CMMTMNT_ELMNT_ID remains the sole guaranteed-unique identifier.

Common Use Cases and Queries

Typical reporting retrieves all commitment elements for a given budget, resolves the default frequency against the time period types, and summarises overhead configuration. A representative query pattern joins back to the parent budget and to PER_TIME_PERIOD_TYPES:

• List elements and their default frequencies: select e.BDGT_CMMTMNT_ELMNT_ID, e.BUDGET_ID, e.OVERHEAD_PERCENTAGE, t.time_period_type from HR.PQH_BDGT_CMMTMNT_ELMNT_TYPES t where e.DFLT_ELMNT_FREQUENCY = t.time_period_type;
• Filter by element type or salary basis flag to audit which components contribute to a budget.
• Aggregate overhead percentages across all elements of a budget for cost modelling.
• Reconcile commitment element definitions against balance types for financial reporting.

Related Objects

• PER_TIME_PERIOD_TYPES — referenced via DFLT_ELMNT_FREQUENCY; the sole documented foreign key.
• PQH_BDGT_CMMTMNT_ELMNTS_PK — the primary key constraint on BDGT_CMMTMNT_ELMNT_ID.
• The parent budget table implied by BUDGET_ID, which owns these element rows.
• Element type and element input value reference tables keyed by ELEMENT_TYPE_ID and ELEMENT_INPUT_VALUE_ID.
• Formula and balance type definitions referenced by FORMULA_ID and BALANCE_TYPE_ID.

Together these relationships position PQH_BDGT_CMMTMNT_ELMNTS as a configuration satellite supporting Public Sector budget commitment calculations.