Results for “psb_position_pay_distrs_v”

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

Overview

APPS.PSB_POSITION_PAY_DISTRS_V is a database view within the Public Sector Budgeting (PSB) product family used by Oracle E-Business Suite releases 12.1.1 and 12.2.2. Its purpose is to present the pay distributions attached to budget positions in a form that reflects the currently active worksheet context. Rather than exposing every distribution record unconditionally, the view applies worksheet-sensitive filtering logic so that consumers retrieve the distribution rows that are relevant to the worksheet being processed at the time of the query.

The view is not a simple pass-through of a single table. It joins the pay distribution entity to the position entity and further limits results using position-based PL/SQL package functions that resolve worksheet flags and identifiers. This design makes it the reporting and integration surface through which budget position compensation distributions—such as funding splits across code combinations—are surfaced for a given worksheet and extract.

Underlying Base Objects

The view is defined over two documented base tables:

• PSB_POSITION_PAY_DISTRIBUTIONS (aliased PYD) — the primary source of distribution records.
• PSB_POSITIONS (aliased POS) — joined to constrain distributions to valid positions within the same data extract.

The join condition links PYD.POSITION_ID to POS.POSITION_ID and PYD.DATA_EXTRACT_ID to POS.DATA_EXTRACT_ID. A mandatory predicate requires CODE_COMBINATION_ID IS NOT NULL, so distributions without an assigned account combination are excluded. The filter also depends on the private package PSB_POSITIONS_PVT, invoking GET_WORKSHEET_FLAG, GET_WORKSHEET_ID, and GET_END_DATE, and on a correlated NOT EXISTS subquery against PSB_POSITION_PAY_DISTRIBUTIONS to suppress superseded or overlapping distribution versions.

Key Columns

The view exposes the following attributes, each sourced from the pay distributions table:

• ROW_ID, DISTRIBUTION_ID — the row identifier and primary distribution key.
• POSITION_ID, DATA_EXTRACT_ID — the position and extract context of the distribution.
• EFFECTIVE_START_DATE, EFFECTIVE_END_DATE — the effective dating window for the distribution.
• CODE_COMBINATION_ID, CHART_OF_ACCOUNTS_ID — the account combination receiving the distributed pay and its chart of accounts.
• DISTRIBUTION_PERCENT — the share of pay allocated to the combination.
• GLOBAL_DEFAULT_FLAG, DISTRIBUTION_DEFAULT_RULE_ID — indicators and rule references governing default distribution behavior.
• WORKSHEET_ID — the worksheet to which the distribution belongs, where applicable.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE.

Common Use Cases and Queries

Typical uses include reporting funding distributions for budget positions, validating that distribution percentages reconcile to one hundred percent, and extracting distribution data for integration with costing or general ledger processes. A representative query lists active distributions for a position and extract:

• SELECT distribution_id, position_id, code_combination_id, distribution_percent, effective_start_date FROM psb_position_pay_distrs_v WHERE position_id = :position_id AND data_extract_id = :data_extract_id;
• SELECT position_id, SUM(distribution_percent) FROM psb_position_pay_distrs_v WHERE data_extract_id = :data_extract_id GROUP BY position_id HAVING SUM(distribution_percent) <> 100;

Because the result set depends on session-level worksheet state resolved through PSB_POSITIONS_PVT, queries should be executed in the correct worksheet context to ensure that the intended distribution rows are returned.