Results for “pqh_worksheet_fund_srcs”

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

Overview

The PQH_WORKSHEET_FUND_SRCS table resides in the HR schema and belongs to the PQH – Public Sector HR product family within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores cost allocation and funding source detail for budget elements processed through the Public Sector budgeting worksheet flow. Each row associates a worksheet budget element with a distribution percentage, a cost allocation key flexfield, and, where applicable, project, award, task, and expenditure type attribution.

The object is classified as VALID in the ETRM repository and is documented as a link-style entity in the mined Data Vault classification. From a modeling perspective, this classification reflects the table's role as an associative construct: it resolves the many-to-many relationship between worksheet budget elements and cost allocation definitions, rather than acting as a standalone aggregation hub. This heuristic classification is a modeling suggestion and should be validated against the functional design during implementation.

Key Information Stored

The table contains fifteen documented columns. The most significant are summarized below.

• WORKSHEET_FUND_SRC_ID — The surrogate primary key, enforced by the unique index PQH_WORKSHEET_FUND_SRCS_PK. It uniquely identifies each funding source row.
• WORKSHEET_BDGT_ELMNT_ID — Foreign key to PQH_WORKSHEET_BDGT_ELMNTS; identifies the parent budget element. This column also participates in the unique index PQH_WORKSHEET_FUND_SRCS_UK, making it a business-key candidate in combination with the cost allocation keyflex.
• COST_ALLOCATION_KEYFLEX_ID — Foreign key to PAY_COST_ALLOCATION_KEYFLEX; identifies the cost allocation keyflex combination to which the distribution applies. It forms the second component of the documented unique key.
• DISTRIBUTION_PERCENTAGE — The percentage of the budget element amount allocated to this funding source or cost allocation combination.
• PROJECT_ID, AWARD_ID, TASK_ID, EXPENDITURE_TYPE, ORGANIZATION_ID — Optional award and project accounting attributes. AWARD_ID references IGF_AW_AWARD_ALL, and these columns support grants and project costing integration.
• OBJECT_VERSION_NUMBER — The optimistic locking column used by the Oracle Applications Framework to detect concurrent updates.
• Audit columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE) — Standard WHO columns capturing row creation and modification metadata.

Common Use Cases and Queries

Typical usage centers on reviewing how worksheet budget amounts are distributed across cost allocation structures and awards. A representative join retrieves budget element funding detail:

SELECT f.WORKSHEET_FUND_SRC_ID,
       f.WORKSHEET_BDGT_ELMNT_ID,
       f.COST_ALLOCATION_KEYFLEX_ID,
       f.DISTRIBUTION_PERCENTAGE,
       f.AWARD_ID,
       f.PROJECT_ID
FROM   HR.PQH_WORKSHEET_FUND_SRCS f
WHERE  f.WORKSHEET_BDGT_ELMNT_ID = :p_budget_element_id;

Reporting scenarios include validating that distributions sum to one hundred percent per budget element, reconciling funding sources against award records in IGF_AW_AWARD_ALL, and extracting cost allocation keyflex identifiers for downstream cost distribution. Auditors frequently query the WHO columns to trace the last user who modified a distribution percentage.

Related Objects

• PQH_WORKSHEET_BDGT_ELMNTS — Parent table; joined on PQH_WORKSHEET_FUND_SRCS.WORKSHEET_BDGT_ELMNT_ID = PQH_WORKSHEET_BDGT_ELMNTS.WORKSHEET_BDGT_ELMNT_ID.
• PAY_COST_ALLOCATION_KEYFLEX — Cost allocation keyflex definition; joined on COST_ALLOCATION_KEYFLEX_ID.
• IGF_AW_AWARD_ALL — Award master for grants-funded distributions; joined on AWARD_ID.
• HR.PQH_WORKSHEET_FUND_SRCS — Base table referenced directly by the Public Sector budgeting worksheet pages and concurrent processes that post allocations.

Because the FK to awards is not present in the primary key definition, referential integrity must be validated at the application layer when reconciling grants-related distributions.