Results for “copy_of_position_line_id”

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

Overview

PSB_WS_POSITION_LINES is a core table within the Public Sector Budgeting (PSB) module of Oracle E-Business Suite, valid across 12.1.1 and 12.2.2. It stores the instance of a position as it appears within a budgeting worksheet. Whereas a position definition carries the master attributes of a job or role, PSB_WS_POSITION_LINES records how that position is instantiated for a specific worksheet, budget group, and budgeting cycle. This distinction allows the same underlying position to participate in multiple worksheets with independent distributions, FTE amounts, and account assignments without altering the base position record.

Within the PSB data model the table functions structurally as the hub around which worksheet-level detail lines revolve. Account lines, element lines, FTE lines, and line-balance records all attach to a specific position line rather than to the position master, enabling budget analysts to spread salary and benefit costs across organizations, accounts, and periods. The documented foreign-key topology—with this table referenced by five dependent tables and itself referencing PSB_BUDGET_GROUPS—supports a hub-leaning Data Vault classification. As a modeling suggestion, it may be treated as a hub entity whose satellite detail resides in the dependent line tables.

Key Information Stored

The documented physical schema for 12.1.1 comprises 21 columns. The most operationally significant include:

• POSITION_LINE_ID — the surrogate primary key, uniquely identifying each position instance. It is also the single-column unique index PSB_WS_POSITION_LINES_U1, making it the de facto business-key candidate for joins.
• POSITION_ID — references the underlying position definition that this line instantiates.
• BUDGET_GROUP_ID — the sole documented outbound foreign key, tying the line to a budget group in PSB_BUDGET_GROUPS and therefore to a worksheet context.
• COPY_OF_POSITION_LINE_ID — records the source line when a position is copied, supporting worksheet versioning and "what-if" scenarios.
• DESCRIPTION — free-text descriptor for the position instance.
• ATTRIBUTE1 through ATTRIBUTE10 and CONTEXT — the standard Oracle EBS descriptive-flexfield columns, enabling client-specific extensibility without schema changes.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — the standard WHO audit columns used for change tracking, concurrency, and reconciliation.

Note that the primary key is the surrogate POSITION_LINE_ID; no composite business key is documented beyond the unique index on that column.

Common Use Cases and Queries

Typical usage centers on extracting worksheet position detail for budget preparation, cost distribution analysis, and reconciliation against approved budgets. Analysts frequently join position lines to their dependent account, element, and FTE records to produce a complete cost picture.

A representative query to list all positions in a worksheet:

• SELECT p.POSITION_LINE_ID, p.POSITION_ID, p.DESCRIPTION FROM PSB_WS_POSITION_LINES p WHERE p.BUDGET_GROUP_ID = :budget_group_id;

To relate a position line to its FTE details, join on POSITION_LINE_ID:

• SELECT p.POSITION_LINE_ID, f.FTE, f.AMOUNT FROM PSB_WS_POSITION_LINES p, PSB_WS_FTE_LINES f WHERE p.POSITION_LINE_ID = f.POSITION_LINE_ID;

Copy lineage can be traced by self-referencing COPY_OF_POSITION_LINE_ID. Reporting typically aggregates by budget group, position, and account line for budget-versus-actual comparisons and FTE headcount summaries.

Related Objects

The following objects reference or are referenced by PSB_WS_POSITION_LINES through documented foreign-key relationships:

• PSB_BUDGET_GROUPS — referenced by BUDGET_GROUP_ID; defines the budget group and worksheet context.
• PSB_WS_ACCOUNT_LINES — references this table via POSITION_LINE_ID; holds account distributions for the position.
• PSB_WS_ELEMENT_LINES — references this table via POSITION_LINE_ID; stores salary/benefit element detail.
• PSB_WS_FTE_LINES — references this table via POSITION_LINE_ID; holds FTE and effort amounts.
• PSB_WS_LINES_POSITIONS — references this table via POSITION_LINE_ID; links worksheet lines to positions.
• PSB_WS_LINE_BALANCES_I — references this table via POSITION_LINE_ID; holds balance amounts at the position-line level.

Together these tables form the worksheet position hierarchy, with PSB_WS_POSITION_LINES functioning as the central hub for position-level budgeting data.