Search Results psb_attribute_values




Overview
Explore in AI Chat

Overview

The PSB_ATTRIBUTE_VALUES table is a core data object within the Oracle E-Business Suite Public Sector Budgeting (PSB) module. It functions as a master repository for position attribute value sets. In the context of public sector and complex organizational budgeting, positions (e.g., job roles) are often classified using detailed attributes, such as funding source, program, or function. This table stores the discrete, valid values for these user-defined attributes, enabling structured categorization and granular budgetary control and reporting for position assignments.

Key Information Stored

While the full column list is not detailed in the provided metadata, the structure centers on the primary and foreign key relationships. The core identifier is the ATTRIBUTE_VALUE_ID, a unique system-generated key serving as the table's primary key. A critical foreign key is ATTRIBUTE_ID, which links each value to its parent definition in the PSB_ATTRIBUTES table. This relationship defines which attribute a specific value belongs to. The table would typically contain columns for the value itself (e.g., VALUE or MEANING), a description, and control columns like ENABLED_FLAG, START_DATE_ACTIVE, and END_DATE_ACTIVE to manage the lifecycle of the value within the application.

Common Use Cases and Queries

This table is central to maintaining the valid value lists for budgetary position attributes. Common operational use cases include administering the list of available funding codes or program codes for assignment to budgeted positions. For reporting and data validation, queries often join this table to its related entities. A typical pattern is to retrieve all active values for a specific attribute to populate a list of values (LOV) in the application interface. Another common query involves validating position assignments by joining through PSB_POSITION_ASSIGNMENTS to ensure assigned attribute values are still active and valid.

  • Sample SQL to find values for a specific attribute: SELECT pav.attribute_value_id, pav.value FROM psb_attribute_values pav, psb_attributes pa WHERE pav.attribute_id = pa.attribute_id AND pa.attribute_name = 'FUNDING_SOURCE' AND SYSDATE BETWEEN pav.start_date_active AND NVL(pav.end_date_active, SYSDATE+1);

Related Objects

The PSB_ATTRIBUTE_VALUES table sits at the center of a key data model for position attribute management, with documented relationships to several other PSB tables.

  • PSB_ATTRIBUTES: This table is the parent, defining the attribute itself. The relationship is PSB_ATTRIBUTE_VALUES.ATTRIBUTE_ID → PSB_ATTRIBUTES.
  • PSB_POSITION_ASSIGNMENTS: This table references PSB_ATTRIBUTE_VALUES, indicating that a specific position assignment is linked to a chosen attribute value. The relationship is PSB_POSITION_ASSIGNMENTS.ATTRIBUTE_VALUE_ID → PSB_ATTRIBUTE_VALUES.
  • PSB_POSITION_SET_LINE_VALUES: This table also references PSB_ATTRIBUTE_VALUES, linking attribute values to lines within position sets, which are used for grouping and budgeting. The relationship is PSB_POSITION_SET_LINE_VALUES.ATTRIBUTE_VALUE_ID → PSB_ATTRIBUTE_VALUES.