Results for “psb_ws_account_lines”

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

Overview

PSB_WS_ACCOUNT_LINES is a transaction table within the Public Sector Budgeting (PSB) module, a legacy component of Oracle E-Business Suite that is now designated obsolete. The table stores actual, budget, and estimate balances for a General Ledger code combination as it appears on a budgeting worksheet for a given budget year. In practical terms, each row represents a single account line on a worksheet position, holding the amount and period-by-period distribution associated with that code combination.

From a Data Vault modeling perspective, the metadata classifies this object heuristically as a link. This classification is inferred from its foreign key structure, which resolves multiple independent business entities — General Ledger code combinations, worksheet position lines, service packages, budget periods, budget groups, awards, and element sets — through a shared surrogate identifier. In the EBS PSB schema the table belongs to the PSB owner and was documented with 94 columns under release 12.1.1. The implementation note in the ETRM metadata indicates the table is not implemented in the reference database used for documentation, which reflects the obsolescence of the PSB module rather than a functional limitation of environments still running it.

Key Information Stored

The surrogate primary key is ACCOUNT_LINE_ID, which is also the sole documented unique index candidate (PSB_WS_ACCOUNT_LINES_U1). No separate business-key unique index is recorded, so ACCOUNT_LINE_ID is the canonical identifier for joins and lookups.

• CODE_COMBINATION_ID — the General Ledger account combination to which the line balances apply.
• BUDGET_YEAR_ID — the budget year (from PSB_BUDGET_PERIODS) that scopes the balance figures.
• POSITION_LINE_ID — the worksheet position line on which this account line appears.
• SERVICE_PACKAGE_ID, BUDGET_GROUP_ID — the service package and budget group owning the worksheet context.
• POSITION_ID, ORGANIZATION_ID — position and organization attribution for the line.
• ACCOUNT_TYPE, BALANCE_TYPE — classification of the line and the nature of the amount held.
• YTD_AMOUNT — the year-to-date balance summarized for the line.
• PERIOD1_AMOUNT through PERIOD60_AMOUNT — the period-by-period amount spread across up to sixty budgeting periods.
• CURRENCY_CODE — the currency in which the amounts are expressed.
• ANNUAL_FTE — the annualized full-time-equivalent measure tied to the line.
• AWARD_ID, ELEMENT_SET_ID — grant award and pay element set references for integrated budgeting.
• Standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) and the concurrency columns REQUEST_ID and FUNCTIONAL_TRANSACTION.

Common Use Cases and Queries

Typical reporting extracts the period spread for a code combination within a worksheet, reconciles worksheet balances against GL actuals, or compares budgeted versus estimated amounts for a budget year. A representative query joins the account line to GL_CODE_COMBINATIONS to resolve the account and to PSB_BUDGET_PERIODS for the period context:

• Extract all account lines for a budget group and year: select ACCOUNT_LINE_ID, CODE_COMBINATION_ID, YTD_AMOUNT from PSB_WS_ACCOUNT_LINES where BUDGET_GROUP_ID = :group and BUDGET_YEAR_ID = :year.
• Resolve the GL account: join PSB_WS_ACCOUNT_LINES to GL_CODE_COMBINATIONS on CODE_COMBINATION_ID to obtain the segment values behind the balance.
• Worksheet rollups: group YTD_AMOUNT or the PERIODn_AMOUNT columns by POSITION_LINE_ID to reconcile worksheet totals.
• Award-based reporting: join to IGF_AW_AWARD_ALL on AWARD_ID to report account balances by grant.
• Audit tracing: filter on REQUEST_ID or FUNCTIONAL_TRANSACTION to trace which concurrent process created or modified the line.

Related Objects

The table is a link hub whose most significant related objects are the foreign key parents and dependent entities:

• PSB_WS_POSITION_LINES — joined on POSITION_LINE_ID; supplies the worksheet position line context.
• GL_CODE_COMBINATIONS — joined on CODE_COMBINATION_ID; resolves the account segments.
• PSB_SERVICE_PACKAGES — joined on SERVICE_PACKAGE_ID; identifies the budgeting service package.
• PSB_BUDGET_PERIODS — joined on BUDGET_YEAR_ID; defines the budget year and period calendar.
• PSB_BUDGET_GROUPS — joined on BUDGET_GROUP_ID; groups worksheets for budgeting.
• IGF_AW_AWARD_ALL — joined on AWARD_ID; links lines to grant awards.
• PAY_ELEMENT_SETS — joined on ELEMENT_SET_ID; links lines to pay element sets for salary budgeting.
• PSB_WS_ACCOUNT_LINES_PK — the primary key constraint on ACCOUNT_LINE_ID, enabling reliable joins to child or dependent records.

Because PSB is obsolete in current EBS releases, customizations and reports referencing this table should be reviewed for migration to supported budgeting functionality, but the relationships above remain the authoritative join paths for retained historical data.