Results for “concatenated_account”

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

Overview

PSB_WS_LINE_BALANCES_I is an interface table within the Public Sector Budgeting (PSB) module of Oracle E-Business Suite, historically available in releases 12.1.1 and 12.2.2. Its documented purpose is to serve as the staging area for exporting and importing account line information to and from a spreadsheet-based budgeting worksheet. The table therefore functions as a bridge between the PSB application and an external worksheet environment where budget analysts manipulate position, salary, and account balance data before it is uploaded back into the budgeting engine.

The metadata classifies this table, using a heuristic mined from its foreign key structure, as standalone. This is a modeling suggestion rather than a definitive Data Vault designation; it indicates that the table does not participate in a classic hub-and-satellite pattern and instead behaves as a self-contained staging entity whose rows reference multiple master objects through foreign keys. Notably, the ETRM documentation records that this table is "Not implemented in this database" for the environment from which the metadata was extracted, and the PSB product itself is marked obsolete. Consequently, in current EBS implementations the table may exist only as a legacy artifact or may be absent entirely.

Key Information Stored

The documented physical schema comprises 253 columns owned by the PSB schema. Among these, the most operationally significant are the identifiers and descriptive attributes that tie each worksheet line to a budgeting context:

• EXPORT_ID — Correlates a batch of exported or imported worksheet rows to a single spreadsheet exchange session.
• EXPORT_WORKSHEET_TYPE — Distinguishes the worksheet category being processed (for example, position, salary, or account line).
• CODE_COMBINATION_ID and CONCATENATED_ACCOUNT — The accounting flexfield reference and its human-readable concatenated form.
• ACCOUNT_TYPE and ACCOUNT_DESCRIPTION — Classification and narrative for the account line.
• BUDGET_GROUP_ID — Foreign key to PSB_BUDGET_GROUPS, identifying the budget group owning the line.
• SERVICE_PACKAGE_ID and SERVICE_PACKAGE_NAME — Foreign key to PSB_SERVICE_PACKAGES, linking the line to its service package.
• POSITION_LINE_ID, POSITION_ID, POSITION_SEGMENTS, and POSITION_NAME — Position reference data; POSITION_LINE_ID is a foreign key to PSB_WS_POSITION_LINES.
• EMPLOYEE_ID, EMPLOYEE_NUMBER, and EMPLOYEE_NAME — Foreign key EMPLOYEE_ID references PSB_EMPLOYEES.
• PAY_ELEMENT_ID and PAY_ELEMENT_NAME — Foreign key to PSB_PAY_ELEMENTS, identifying the salary or pay component.
• CURRENCY_CODE, VALUE_TYPE, and MODIFIED_FLAG — Currency denomination, the measure type being carried, and whether the row was altered during import.
• AMOUNT1 through AMOUNT220 — A wide repeating set of numeric columns holding period or scenario amounts across the budgeting horizon.
• Standard WHO audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, and CREATED_DATE.

The metadata does not document a surrogate primary key or unique business key for this table; EXPORT_ID combined with the foreign key columns (BUDGET_GROUP_ID, POSITION_LINE_ID, EMPLOYEE_ID, PAY_ELEMENT_ID) would be the natural business-key candidates in practice.

Common Use Cases and Queries

Typical usage centers on extracting lines for spreadsheet editing and validating returned rows before loading them back into the budgeting engine. A representative extraction query joins the interface table to its parent groups and positions:

SELECT l.export_id, l.budget_group_id, l.position_name,
       l.employee_name, l.pay_element_name,
       l.concatenated_account, l.amount1, l.amount2
FROM   psb_ws_line_balances_i l
WHERE  l.export_id = :p_export_id
AND    l.budget_group_id = :p_group;

Post-import validation commonly filters on MODIFIED_FLAG to isolate user-edited rows, or reconciles CURRENCY_CODE and VALUE_TYPE values to ensure consistency:

SELECT export_id, COUNT(*), SUM(amount1)
FROM   psb_ws_line_balances_i
WHERE  modified_flag = 'Y'
GROUP  BY export_id;

Reconciliation reports also join back to PSB_WS_POSITION_LINES to confirm that imported lines correspond to valid worksheet positions.

Related Objects

• PSB_BUDGET_GROUPS — Referenced via BUDGET_GROUP_ID; the parent container for budget lines.
• PSB_SERVICE_PACKAGES — Referenced via SERVICE_PACKAGE_ID; defines the service package context.
• PSB_WS_POSITION_LINES — Referenced via POSITION_LINE_ID; the worksheet position universe.
• PSB_EMPLOYEES — Referenced via EMPLOYEE_ID; the employee master for position lines.
• PSB_PAY_ELEMENTS — Referenced via PAY_ELEMENT_ID; the pay element definitions used in salary lines.
• PSB_WS_* interface tables — Sibling worksheet staging tables sharing the EXPORT_ID convention.
• PSB budget worksheet concurrent programs — The upload/download processes that populate and consume this interface.