Results for “psb_worksheets”

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

Overview

PSB_WORKSHEETS is the central definition table for the Public Sector Budgeting (PSB) module in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the header-level definition of each budgeting worksheet created by an agency, capturing the parameters that govern how budget data is extracted, staged, calculated, and submitted through the budgeting workflow. Although the PSB product is now classified as obsolete in the ETRM documentation, the table remains part of the documented physical schema and continues to appear in historical installations and migration assessments.

From a Data Vault modeling perspective, the table is best characterized as a hub. Its primary key, WORKSHEET_ID, serves as the surrogate identifier around which numerous dependent tables cluster, and the table anchors a wide fan-out of foreign key relationships. In ETRM terms, PSB_WORKSHEETS is the parent of record for worksheet lines, distributions, position assignments, service packages, pay element rates, and workflow processes.

Key Information Stored

The table contains 63 documented columns. The most operationally significant are:

• WORKSHEET_ID — surrogate primary key (PSB_WORKSHEET_PK) and the join key used by every dependent child table. A unique index (PSB_WORKSHEETS_U1) reinforces its uniqueness.
• NAME — the user-facing worksheet name; the second business-key candidate, enforced by unique index PSB_WORKSHEETS_U2.
• WORKSHEET_TYPE — distinguishes worksheet categories (for example, position-based versus non-position budgeting).
• BUDGET_GROUP_ID, STAGE_SET_ID, BUDGET_CALENDAR_ID — foreign keys to PSB_BUDGET_GROUPS, PSB_BUDGET_STAGE_SETS, and PSB_BUDGET_CALENDARS that define the budgeting organizational context and staging rules.
• GL_BUDGET_SET_ID — links the worksheet to the General Ledger budget set used for extraction.
• DATA_EXTRACT_ID and PARAMETER_SET_ID — control which data extraction and parameter set drive worksheet generation.
• FLEX_MAPPING_SET_ID and CONSTRAINT_SET_ID — govern account derivation and validation constraints.
• GLOBAL_WORKSHEET_ID, GLOBAL_WORKSHEET_FLAG, GLOBAL_WORKSHEET_OPTION, LOCAL_COPY_FLAG, COPY_OF_WORKSHEET_ID — support global worksheet sharing and local copy semantics.
• CURRENT_STAGE_SEQ, WS_CREATION_COMPLETE, FREEZE_FLAG, DATE_SUBMITTED, SUBMITTED_BY — track workflow state and submission history.
• BUDGET_VERSION_ID and the various INCLUDE_GL_* / INCLUDE_CBC_* flags — determine which GL and commitment budget balance types are brought into the worksheet.
• Standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY) and ten descriptive flexfield attribute columns (ATTRIBUTE1–10, CONTEXT).

Common Use Cases and Queries

The most frequent reporting need is to enumerate worksheets with their organizational and staging context. A representative query joins PSB_WORKSHEETS to PSB_BUDGET_GROUPS and PSB_BUDGET_STAGE_SETS:

• List active worksheets: SELECT w.WORKSHEET_ID, w.NAME, w.WORKSHEET_TYPE, w.CURRENT_STAGE_SEQ FROM PSB_WORKSHEETS w WHERE w.FREEZE_FLAG = 'N';
• Identify worksheets pending submission by joining on DATE_SUBMITTED and SUBMITTED_BY.
• Trace all child records for a given worksheet by joining on WORKSHEET_ID across PSB_WS_DISTRIBUTIONS, PSB_POSITION_ASSIGNMENTS, and PSB_WS_LINES_POSITIONS.
• Audit global worksheet propagation using GLOBAL_WORKSHEET_ID and GLOBAL_WORKSHEET_FLAG.
• Validate extraction configuration by joining to PSB_GL_BUDGET_SETS and PSB_DATA_EXTRACTS.

Related Objects

PSB_WORKSHEETS is referenced by nine child tables, each carrying WORKSHEET_ID (or GLOBAL_WORKSHEET_ID) as a foreign key:

• PSB_POSITION_ASSIGNMENTS — positions assigned within the worksheet.
• PSB_WS_LINES_POSITIONS — worksheet line detail for position-based lines.
• PSB_WS_DISTRIBUTIONS — distribution records generated by the worksheet.
• PSB_WS_DISTRIBUTION_DETAILS — detail rows, referencing both WORKSHEET_ID and GLOBAL_WORKSHEET_ID.
• PSB_PAY_ELEMENT_RATES — pay element rate definitions tied to the worksheet.
• PSB_SERVICE_PACKAGES and PSB_WS_SUBMIT_SERVICE_PACKAGES — service package processing linked via GLOBAL_WORKSHEET_ID and WORKSHEET_ID respectively.
• PSB_WORKFLOW_PROCESSES — workflow instances generated for the worksheet.

Parent-side foreign keys reference PSB_BUDGET_GROUPS, PSB_BUDGET_STAGE_SETS, PSB_GL_BUDGET_SETS, PSB_BUDGET_CALENDARS, PSB_DATA_EXTRACTS, PSB_FLEX_MAPPING_SETS, and GMP_PROCESS_PARAMETER_SET_B, defining the scheduling and allocation context for each worksheet definition.