Results for “psb_attributes”

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

Overview

PSB_ATTRIBUTES is a metadata table within the Oracle E-Business Suite Public Sector Budgeting (PSB) module. It stores the definition and configuration of position attributes — the descriptive characteristics (such as grade, job code, location, or any user-defined qualifier) that budgets and position records can carry. Rather than holding the attribute values themselves, PSB_ATTRIBUTES acts as the catalog that describes each attribute: its display behavior, whether it is required, how it is validated, and where its valid values are sourced. In release 12.1.1 the table is owned by the PSB schema and contains 24 documented columns.

The table sits at the center of the attribute subsystem. It is referenced by the tables that hold actual attribute assignments and values (PSB_ATTRIBUTE_VALUES, PSB_ATTRIBUTE_VALUES_I, PSB_POSITION_ASSIGNMENTS, and PSB_ACCOUNT_POSITION_SET_LINES), while itself referencing PSB_ATTRIBUTE_TYPES through ATTRIBUTE_TYPE_ID. Given its role as a stable, descriptive reference entity referenced by multiple downstream tables, the heuristic Data Vault classification is hub-leaning; from a modeling standpoint it is best treated as a hub (or reference table) rather than a transactional satellite, with dependent value and assignment tables as the surrounding satellites and links.

Key Information Stored

The surrogate primary key is ATTRIBUTE_ID, enforced by the PSB_ATTRIBUTES_PK constraint. Two unique indexes document the business-key candidates: PSB_ATTRIBUTES_U1 on ATTRIBUTE_ID and PSB_ATTRIBUTES_U2 on the combination of NAME and BUSINESS_GROUP_ID. The NAME/BUSINESS_GROUP_ID pair effectively defines the human-readable identity of an attribute within a given business group, reflecting EBS multi-tenant partitioning.

The most significant descriptive columns include:

• NAME — the user-facing attribute name, unique within a business group.
• BUSINESS_GROUP_ID — the owning business group, scoping attribute definitions.
• ATTRIBUTE_TYPE_ID — foreign key to PSB_ATTRIBUTE_TYPES, classifying the attribute.
• DISPLAY_IN_WORKSHEET and DISPLAY_SEQUENCE — control whether and in what order the attribute appears on budgeting worksheets.
• DISPLAY_PROMPT — the label presented to users.
• REQUIRED_FOR_IMPORT_FLAG and REQUIRED_FOR_POSITIONS_FLAG — indicate whether a value is mandatory during import or when defining positions.
• ALLOW_IN_POSITION_SET_FLAG — governs eligible use within position sets.
• VALUE_TABLE_FLAG — signals whether valid values come from a validation table.
• DEFINITION_TYPE, DEFINITION_STRUCTURE, DEFINITION_TABLE, and DEFINITION_COLUMN — describe the lookup source used to populate or validate attribute values.
• DATA_TYPE and SYSTEM_ATTRIBUTE_TYPE — specify the value's data type and whether the attribute is system-seeded.
• PROTECTED_FLAG — marks attributes that must not be modified or deleted.
• Standard audit columns such as LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, and CREATION_DATE.

Common Use Cases and Queries

Typical reporting concerns the active attribute catalog: which attributes display on worksheets, in what sequence, and which are mandatory. A representative query lists defined attributes per business group:

SELECT attribute_id, name, display_prompt, display_sequence, data_type
FROM psb.psb_attributes
WHERE business_group_id = :p_bg_id
ORDER BY display_sequence;

Identifying mandatory attributes combines the required flags, while reconciling attribute definitions against their values joins PSB_ATTRIBUTE_VALUES on ATTRIBUTE_ID. Administrators also use this table to detect protected or system-seeded attributes before attempting configuration changes, and to trace validation sources through the DEFINITION_TABLE and DEFINITION_COLUMN columns.

Related Objects

The following objects are the most significant dependencies:

• PSB_ATTRIBUTE_TYPES — referenced by PSB_ATTRIBUTES.ATTRIBUTE_TYPE_ID, providing the attribute classification.
• PSB_ATTRIBUTE_VALUES — child table joined on ATTRIBUTE_ID; stores attribute values.
• PSB_ATTRIBUTE_VALUES_I — interface table joined on ATTRIBUTE_ID; used for value import/validation.
• PSB_POSITION_ASSIGNMENTS — references ATTRIBUTE_ID; associates attributes with position assignments.
• PSB_ACCOUNT_POSITION_SET_LINES — references ATTRIBUTE_ID; links attributes into position sets.

Together these tables form the PSB attribute model, with PSB_ATTRIBUTES serving as the central definitional hub for position attribute metadata in Oracle EBS 12.1.1 and 12.2.2.