Search Results psb_attributes_pk

Overview

The PSB_ATTRIBUTES table is a core metadata repository within the Oracle E-Business Suite Public Sector Budgeting (PSB) module. It functions as the master definition table for position attributes, which are user-defined characteristics used to categorize, analyze, and control budget positions. In the context of public sector or complex organizational budgeting, positions often require classification beyond standard accounting flexfields. This table enables the creation and management of a flexible framework for these additional dimensions, such as funding source, program, or geographic location, allowing for granular budgetary control and reporting. Its role is foundational, as it defines the attributes that are subsequently assigned values and linked to specific budget positions throughout the PSB application.

Key Information Stored

While the provided metadata does not list specific columns, the table's primary key and foreign key relationships indicate its critical data elements. The central column is ATTRIBUTE_ID, which serves as the unique identifier (Primary Key: PSB_ATTRIBUTES_PK) for each defined attribute. Other columns typically found in such a metadata table would include fields to define the attribute's name, data type (e.g., character, number, date), validation rules, display prompt, and enabled status. The table essentially stores the configuration blueprint for the extensible attribute framework, dictating what attributes are available for use across the budgeting system.

Common Use Cases and Queries

This table is primarily accessed for setup, maintenance, and integration purposes. Common operational scenarios include the initial configuration of the budgeting system, where administrators define the required position attributes. It is also critical for reporting and data validation, ensuring consistency in how attributes are applied. A typical query would retrieve the list of all active attributes for a setup review or to populate a list of values in an interface.

Sample Query:
SELECT attribute_id, attribute_name, data_type, prompt
FROM psb.psb_attributes
WHERE enabled_flag = 'Y'
ORDER BY attribute_name;

Another common pattern involves joining PSB_ATTRIBUTES with PSB_ATTRIBUTE_VALUES to analyze the defined attributes alongside their assigned values for specific positions or accounts, forming the basis for detailed budgetary analysis reports.

Related Objects

As indicated by the foreign key relationships, PSB_ATTRIBUTES is a parent table to several key transactional and setup tables within the PSB module:

• PSB_ACCOUNT_POSITION_SET_LINES: Links attributes to specific account and position set definitions.
• PSB_ATTRIBUTE_VALUES and PSB_ATTRIBUTE_VALUES_I: Store the actual instance values assigned to budget positions for each defined attribute.
• PSB_POSITION_ASSIGNMENTS: References the attribute definitions when assigning attribute values to specific positions.

These relationships underscore that PSB_ATTRIBUTES is the source of truth for attribute definitions, which are then propagated and utilized throughout the position and account assignment processes in Public Sector Budgeting.