Results for “psb_position_accounts”

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

Overview

PSB_POSITION_ACCOUNTS is a Public Sector Budgeting (PSB) table that stores position control account distributions within Oracle E-Business Suite 12.1.1 and 12.2.2. The table persists the accounting distributions associated with budgeted positions, linking each position to the code combination, budget group, and budget revision under which its salary and related costs are budgeted. Position control is a core capability of Public Sector Budgeting, allowing agencies to plan, fund, and monitor authorized headcount against defined appropriation accounts.

From a Data Vault modeling perspective, the mined foreign-key structure suggests classifying this object as a link table. It resolves relationships among positions, budget groups, and budget revisions, with a small number of descriptive attributes carried on the link. This classification is a heuristic modeling suggestion rather than an Oracle-prescribed design, since the table is physically implemented as a conventional third-normal-form relational table.

Key Information Stored

The table contains 18 documented columns. The most significant include the following:

• POSITION_ACCOUNT_LINE_ID — surrogate primary key enforcing PSB_POSITION_ACCOUNTS_PK. It is also the sole documented unique index (PSB_POSITION_ACCOUNTS_U1), making it the effective business-key candidate in the documented schema.
• POSITION_ID — foreign key to PSB_POSITIONS, identifying the position whose account distribution is recorded.
• CODE_COMBINATION_ID — the General Ledger account combination (the distribution account) charged by the position.
• BUDGET_GROUP_ID — foreign key to PSB_BUDGET_GROUPS, associating the distribution with a specific budget group.
• BUDGET_REVISION_ID — foreign key to PSB_BUDGET_REVISIONS, associating the distribution with a budget revision.
• START_DATE and END_DATE — the effective date range for the account distribution.
• AMOUNT and CURRENCY_CODE — the monetary value distributed and its currency.
• BASE_LINE_VERSION — versioning indicator used to track changes across budget lines.
• HR_POSITION_ID and HR_BUDGET_ID — cross-references to Oracle HRMS position and budget identifiers.
• TRANSFER_TO_PC_FLAG — flag governing transfer of the distribution to Position Control.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, and CREATION_DATE, consistent with standard EBS WHO-column conventions.

Common Use Cases and Queries

Typical use cases include budget-versus-actual reconciliation for authorized positions, appropriation-line reporting by account and budget group, and auditing of revision history for position funding. A representative query joining to the position master is:

• SELECT pp.position_name, pac.amount, pac.currency_code, pac.start_date, pac.end_date FROM psb_position_accounts pac, psb_positions pp WHERE pac.position_id = pp.position_id AND pac.budget_group_id = :group_id;
• Aggregate distributions by code combination for a given revision: SELECT pac.code_combination_id, SUM(pac.amount) FROM psb_position_accounts pac WHERE pac.budget_revision_id = :revision_id GROUP BY pac.code_combination_id;
• Identify active distributions as of a date using START_DATE and END_DATE predicates.

Report writers commonly join PSB_POSITION_ACCOUNTS to GL_CODE_COMBINATIONS to resolve segment values, and filter on TRANSFER_TO_PC_FLAG when isolating records already pushed into Position Control.

Related Objects

The documented foreign keys and primary key define the following principal relationships:

• PSB_POSITIONS — joined on POSITION_ID (PAC.POSITION_ID = PSB_POSITIONS.POSITION_ID); the position master.
• PSB_BUDGET_GROUPS — joined on BUDGET_GROUP_ID.
• PSB_BUDGET_REVISIONS — joined on BUDGET_REVISION_ID.
• GL_CODE_COMBINATIONS — referenced indirectly through CODE_COMBINATION_ID to resolve account segments.
• HR position and budget entities — referenced through HR_POSITION_ID and HR_BUDGET_ID.
• PSB_POSITION_ACCOUNTS_PK / _U1 — the primary key constraint and unique index that enforce row uniqueness on POSITION_ACCOUNT_LINE_ID.