Search Results pqh_bdgt_cmmtmnt_elmnts




Overview
Explore in AI Chat

Overview

The table PQH_BDGT_CMMTMNT_ELMNTS is a core data object within the Oracle E-Business Suite (EBS) Public Sector HR (PQH) module, specifically for versions 12.1.1 and 12.2.2. It serves as a master repository for defining the compensation elements used to calculate budget commitments. In the context of public sector budgeting, a commitment represents a formal obligation of funds for future personnel costs. This table is therefore critical for configuring how the system projects salary and benefit expenses for budget positions, enabling accurate financial forecasting and control. It acts as a link between the detailed compensation structures in HR and the high-level budget planning processes.

Key Information Stored

The table's primary purpose is to define which elements (e.g., salary, allowances, bonuses) are considered in commitment calculations and to specify their default behavior. The key identifier is the BDGT_CMMTMNT_ELMNT_ID, which is the table's primary key. A critical column is DFLT_ELMNT_FREQUENCY, which stores a foreign key reference to the PER_TIME_PERIOD_TYPES table. This defines the default frequency (e.g., monthly, annually) for the associated element's payments when computing commitments. While the provided metadata does not list all columns, typical data would include the element name, a description, flags to indicate if the element is active or mandatory for commitments, and potentially a reference to the specific HR element from the PAY_ELEMENT_TYPES_F table.

Common Use Cases and Queries

This table is primarily accessed during budget setup and commitment generation processes. A common operational use case is an administrator querying all active elements configured for budget commitments to validate setup before a new fiscal year's budget cycle. For reporting, analysts may join this table to budget transaction tables to analyze which compensation components drive the largest projected commitments. A fundamental sample query would retrieve the list of commitment elements with their default frequencies:

SELECT bce.bdgt_cmmtmnt_elmnt_id,
bce.element_name,
ptp.period_name AS default_frequency
FROM hr.pqh_bdgt_cmmtmnt_elmnts bce,
per_time_period_types ptp
WHERE bce.dflt_elmnt_frequency = ptp.time_period_type_id
AND bce.active_flag = 'Y';

This table is also central to the batch processes that compute and generate budget commitment amounts for positions.

Related Objects

The table maintains defined relationships with other EBS objects, as per the provided metadata. The primary key constraint PQH_BDGT_CMMTMNT_ELMNTS_PK ensures uniqueness of the BDGT_CMMTMNT_ELMNT_ID. The documented foreign key relationship is:

  • Foreign Key Reference: The column DFLT_ELMNT_FREQUENCY in PQH_BDGT_CMMTMNT_ELMNTS references the PER_TIME_PERIOD_TYPES table. This join is used to decode the frequency code into a meaningful description (e.g., 'Monthly').

While not listed in the excerpt, this table is logically a parent to transactional tables such as PQH_BDGT_POS_ELMNTS (which would store the specific element and rate assigned to a budgeted position) and is referenced by budget commitment calculation engines within the PQH module.