Search Results psb_ws_account_lines




Overview
Explore in AI Chat

Overview

The PSB_WS_ACCOUNT_LINES table is a core data repository within the Oracle E-Business Suite's Public Sector Budgeting (PSB) module, specifically for versions 12.1.1 and 12.2.2. As indicated by its description, this table stores actual, budget, and estimate balances for a General Ledger (GL) code combination within a specific budget worksheet for a given budget year. Its primary role is to facilitate the detailed line-item budgeting process, enabling government and public sector entities to plan, track, and reconcile financial data at the account level during budget preparation cycles. It is critical to note that the PSB module is marked as obsolete in the provided documentation, indicating its functional replacement by other Oracle solutions in later releases, though it remains operational in the specified EBS versions.

Key Information Stored

While the full column list is not provided in the metadata, the documented foreign key relationships and primary key define the table's essential structure. The central column is ACCOUNT_LINE_ID, which serves as the unique primary key for each record. Each record is fundamentally tied to a specific GL account via CODE_COMBINATION_ID, linking to the GL_CODE_COMBINATIONS table. The financial context is established through BUDGET_YEAR_ID, which references PSB_BUDGET_PERIODS. For integrated budgeting that includes personnel costs, a link to position data is maintained via POSITION_LINE_ID, referencing PSB_WS_POSITION_LINES. Furthermore, the SERVICE_PACKAGE_ID column allows for the alignment of budget figures with specific program or service packages defined in the PSB_SERVICE_PACKAGES table, supporting performance-based budgeting. The table's core data would include monetary amount columns (not explicitly named) for actuals, budget, and estimate figures.

Common Use Cases and Queries

The primary use case for PSB_WS_ACCOUNT_LINES is the generation of detailed budget worksheets and reports that compare planned budgets against actual expenditures and revised estimates. A typical query would join this table to its related dimensions to produce a comprehensive budget-to-actual report for a specific department, fund, or service package. For instance, a financial analyst might execute a SQL query to retrieve all account lines for a particular budget year and service package, summarizing amounts by GL account segment. Another common operational query involves validating or rolling up worksheet balances before final budget submission, ensuring that the sum of account line items aligns with higher-level budget control totals. Data from this table is also foundational for variance analysis and historical budget trend reporting within the PSB module.

Related Objects

The PSB_WS_ACCOUNT_LINES table is integral to the Public Sector Budgeting schema, with documented relationships to several key tables. The following list details its foreign key dependencies as provided in the ETRM metadata:

  • PSB_WS_POSITION_LINES: Joined via PSB_WS_ACCOUNT_LINES.POSITION_LINE_ID. This links account-level budget figures to specific position or personnel budget lines.
  • GL_CODE_COMBINATIONS: Joined via PSB_WS_ACCOUNT_LINES.CODE_COMBINATION_ID. This provides the chart of accounts context for every financial balance stored.
  • PSB_SERVICE_PACKAGES: Joined via PSB_WS_ACCOUNT_LINES.SERVICE_PACKAGE_ID. This associates budget lines with defined programs or services for performance management.
  • PSB_BUDGET_PERIODS: Joined via PSB_WS_ACCOUNT_LINES.BUDGET_YEAR_ID. This establishes the fiscal time period for the budget data.

As the child table in these relationships, PSB_WS_ACCOUNT_LINES is a central fact table that draws its dimensional context from these referenced master tables.