Results for “psb_attribute_values”

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

Overview

PSB_ATTRIBUTE_VALUES is a table within the Public Sector Budgeting (PSB) module of Oracle E-Business Suite, documented in ETRM for releases 12.1.1 and 12.2.2. The PSB module is identified in the documentation as obsolete, and the object is flagged as "Not implemented in this database," meaning it does not exist in all EBS installations and is retained primarily for historical or compatibility reference. The table stores position attribute value sets — the discrete, selectable values associated with position attributes used during budget preparation and position control workflows.

Functionally, the table acts as a value repository that qualifies the attributes defined in PSB_ATTRIBUTES. Each row binds a specific value (for example, a grade, labor category, or assignment qualifier) to a parent attribute definition, and those values are then consumed by position assignment and position set line records during budget formulation. Based on the foreign key structure, the heuristic Data Vault classification is hub-leaning: ATTRIBUTE_VALUE_ID behaves as a stable surrogate key referenced by multiple dependent tables, making PSB_ATTRIBUTE_VALUES a plausible hub candidate with a strong descriptive payload. This classification is a modeling suggestion derived from the FK topology, not a documented architectural statement.

Key Information Stored

The documented physical schema under the PSB owner contains 42 columns. The columns of greatest analytical significance are:

• ATTRIBUTE_VALUE_ID — the surrogate primary key defined by PSB_ATTRIBUTE_VALUES_PK and also enforced through the unique index PSB_ATTRIBUTE_VALUES_U1. This is the column referenced by downstream position assignment and position set line records.
• ATTRIBUTE_ID — foreign key to PSB_ATTRIBUTES, establishing the parent attribute to which the value belongs.
• ATTRIBUTE_VALUE — the actual value text or code presented to users during budgeting.
• DESCRIPTION — the descriptive label associated with the value.
• HR_VALUE_ID — a reference linking the value to the corresponding value in Oracle HR, enabling synchronization between PSB attribute values and human resources lookup values.
• DATA_EXTRACT_ID — foreign key to PSB_DATA_EXTRACTS, indicating the extraction batch through which the row was populated.
• CONTEXT — the descriptive flexfield context identifier that governs the ATTRIBUTE1 through ATTRIBUTE30 segments.
• ATTRIBUTE1–ATTRIBUTE30 — the descriptive flexfield value columns, available for client-specific extensions.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — the standard EBS audit columns supporting change tracking and concurrency.

The surrogate key is ATTRIBUTE_VALUE_ID; the unique index on the same column is the only documented business-key candidate, so no natural composite key is defined in the metadata.

Common Use Cases and Queries

Typical reporting resolves attribute values together with their parent attribute definitions and their consumers.

• Retrieving the values for a given attribute: SELECT attribute_value_id, attribute_value, description FROM psb_attribute_values WHERE attribute_id = :attribute_id;
• Joining to the attribute master: SELECT a.attribute_name, v.attribute_value FROM psb_attributes a, psb_attribute_values v WHERE a.attribute_id = v.attribute_id;
• Identifying values used on a position assignment via PSB_POSITION_ASSIGNMENTS.ATTRIBUTE_VALUE_ID.
• Auditing rows loaded by a specific extraction run through DATA_EXTRACT_ID.

Because the module is obsolete and the object is not implemented in every database, queries should be preceded by an existence check against ALL_TABLES before being included in production reports.

Related Objects

• PSB_ATTRIBUTES — parent table joined on ATTRIBUTE_ID.
• PSB_DATA_EXTRACTS — joined on DATA_EXTRACT_ID.
• PSB_POSITION_ASSIGNMENTS — references PSB_ATTRIBUTE_VALUES.ATTRIBUTE_VALUE_ID.
• PSB_POSITION_SET_LINE_VALUES — references PSB_ATTRIBUTE_VALUES.ATTRIBUTE_VALUE_ID.