Search Results psb_worksheets

Overview

The PSB_WORKSHEETS table is a core data definition table within the Oracle E-Business Suite Public Sector Budgeting (PSB) module, which is documented as obsolete. This table serves as the master repository for worksheet definitions. A worksheet in PSB is a fundamental budgeting construct, acting as a template or a specific instance where detailed budget data—such as position assignments, pay element rates, and distribution rules—is entered, calculated, and managed before being finalized into the official budget. Its primary role is to centralize the configuration and identity of these budgeting worksheets, linking them to associated budget sets, groups, and workflow stages.

Key Information Stored

While the provided metadata does not list all columns, the primary and foreign keys define its critical structure. The central column is WORKSHEET_ID, the unique primary key identifier for each worksheet record. The table stores foreign key relationships that define the worksheet's context and associations. Key among these are GL_BUDGET_SET_ID (linking to the PSB_GL_BUDGET_SETS table to associate the worksheet with a specific General Ledger budget set), BUDGET_GROUP_ID (linking to PSB_BUDGET_GROUPS), and STAGE_SET_ID (linking to PSB_BUDGET_STAGE_SETS to define applicable budget stages). These relationships position the worksheet within the broader budget preparation and control framework.

Common Use Cases and Queries

This table is primarily accessed for administrative configuration, audit reporting, and data integrity validation within the PSB module. Common operational queries involve listing all worksheets associated with a specific budget group or GL budget set to understand the budgeting landscape. Technical and support queries often trace data lineage by joining PSB_WORKSHEETS to its numerous child tables to analyze the completeness of budget data or troubleshoot issues. A typical reporting query might join worksheet definitions to their related position assignments and service packages to provide a summary view of budget preparation status.

SELECT w.WORKSHEET_ID, bg.NAME BUDGET_GROUP, gbs.NAME BUDGET_SET
FROM PSB_WORKSHEETS w
JOIN PSB_BUDGET_GROUPS bg ON w.BUDGET_GROUP_ID = bg.BUDGET_GROUP_ID
JOIN PSB_GL_BUDGET_SETS gbs ON w.GL_BUDGET_SET_ID = gbs.GL_BUDGET_SET_ID
WHERE bg.NAME = '&BUDGET_GROUP_NAME';

Related Objects

The PSB_WORKSHEETS table has extensive relationships, acting as a central hub for detailed budgeting data. As documented by its foreign keys, it is referenced by numerous transactional and setup tables:

• Parent References (Foreign Keys in PSB_WORKSHEETS): PSB_GL_BUDGET_SETS (GL_BUDGET_SET_ID), PSB_BUDGET_GROUPS (BUDGET_GROUP_ID), PSB_BUDGET_STAGE_SETS (STAGE_SET_ID).
• Child References (Foreign Keys referencing PSB_WORKSHEETS.WORKSHEET_ID): PSB_PAY_ELEMENT_RATES, PSB_POSITION_ASSIGNMENTS, PSB_WORKFLOW_PROCESSES, PSB_WS_LINES_POSITIONS, PSB_WS_DISTRIBUTIONS, PSB_WS_SUBMIT_SERVICE_PACKAGES.
• Global Worksheet References: PSB_SERVICE_PACKAGES and PSB_WS_DISTRIBUTION_DETAILS also reference a GLOBAL_WORKSHEET_ID from this table, indicating its use for shared, template-like worksheets.