Results for “psb_parameter_sets_v”

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

Overview

PSB_PARAMETER_SETS_V is an Oracle E-Business Suite view owned by the APPS schema within the Public Sector Budgeting (PSB) product family. It is a filtered, presentation-layer view defined over the PSB_ENTITY_SET base table, exposing only those rows where ENTITY_TYPE equals 'PARAMETER'. In practical terms, the view presents the set of parameter sets available to the budgeting and entity-setup functions of Public Sector Budgeting.

PSB provides budgeting capabilities for public sector and government organizations, allowing budget analysts to define, extract, and manipulate budget data by parameter. A "parameter set" is the header-level definition that groups parameters used by PSB processing, such as a budget group, a set of books, and a data extract definition. Because the underlying PSB_ENTITY_SET table stores multiple entity types (for example, parameters, entities, and other budgeting constructs), the view exists to isolate the parameter subset so that forms, reports, and integration programs do not need to reapply the ENTITY_TYPE filter.

For reporting and integration purposes, the view is typically used to resolve a parameter set name and description from a numeric identifier, and to join parameter sets to set of books and budget group context. This makes it useful in custom reports, conversions, and diagnostic queries that must identify which parameter set drives a given budgeting configuration.

Underlying Base Objects

The view is defined over a single base table, PSB_ENTITY_SET, aliased PES in the view text. It exposes the table's ROWID, the ENTITY_SET_ID identifier, the descriptive columns NAME and DESCRIPTION, the foreign-key-style references BUDGET_GROUP_ID, SET_OF_BOOKS_ID, and DATA_EXTRACT_ID, the ten generic ATTRIBUTE columns, the CONTEXT column, and the standard audit columns LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE, and LAST_UPDATE_LOGIN.

The sole restriction in the definition is the predicate ENTITY_TYPE = 'PARAMETER', which reduces the full entity-set population to parameter-set records. ETRM documentation lists no further referenced base objects, so the view is a straightforward single-table projection rather than a join-based construct.

Key Columns

• ROWID — the physical row identifier of the underlying PSB_ENTITY_SET row.
• ENTITY_SET_ID — the primary identifier of the parameter set; this is the column most commonly joined to budgeting transaction and setup tables.
• NAME / DESCRIPTION — the user-facing label and description of the parameter set, used in lists of values and report headings.
• BUDGET_GROUP_ID — identifies the budget group with which the parameter set is associated.
• SET_OF_BOOKS_ID — the ledger (set of books) context for the parameter set, relevant in multi-organization or multi-ledger configurations.
• DATA_EXTRACT_ID — references the data extract definition used to populate budget data for the parameter set.
• ATTRIBUTE1–ATTRIBUTE10, CONTEXT — descriptor-flexfield columns for client-specific extensions.
• Audit columns — creation and last-update metadata, useful for troubleshooting who changed a parameter set and when.

The documentation for the view lists the second column as PARAMETER_SET_ID while the view text selects ENTITY_SET_ID; the two refer to the same logical identifier, and queries should reference ENTITY_SET_ID as physically exposed by the view.

Common Use Cases and Queries

Typical uses include validating parameter-set configuration before running PSB budget extracts, producing listings of parameter sets by ledger or budget group, and joining the view to budget data to attribute amounts to a named parameter set. A representative query is:

SELECT ENTITY_SET_ID, NAME, DESCRIPTION, BUDGET_GROUP_ID, SET_OF_BOOKS_ID, DATA_EXTRACT_ID FROM APPS.PSB_PARAMETER_SETS_V ORDER BY NAME;

To resolve a single parameter set from a known identifier:

SELECT NAME, DESCRIPTION FROM APPS.PSB_PARAMETER_SETS_V WHERE ENTITY_SET_ID = :p_entity_set_id;

To report parameter sets for a specific ledger:

SELECT ENTITY_SET_ID, NAME FROM APPS.PSB_PARAMETER_SETS_V WHERE SET_OF_BOOKS_ID = :p_set_of_books_id;

Because the view is a simple filtered projection, it can be treated as a read-only source in custom reports and conversions without concern for aggregation or duplicate-row behavior beyond what exists in PSB_ENTITY_SET.