Results for “psb_attributes_u2”

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

Overview

PSB.PSB_ATTRIBUTES is a configuration and metadata table within the Oracle Public Sector Budgeting (PSB) module of Oracle E-Business Suite. It defines the position attributes that are relevant to budgeting activities and, critically, stores the metadata describing where each attribute's value can be retrieved from Oracle Human Resources Management Systems (HRMS). Because position attribute data in HRMS may reside in a Key Flexfield, a Descriptive Flexfield, QuickCodes, or another table depending on the customer's HRMS configuration, PSB_ATTRIBUTES acts as the mapping and control layer that tells PSB how to locate, display, and validate each attribute. The table is owned by the PSB schema, resides in the APPS_TS_TX_DATA tablespace (PCT Free 10), and carries FND Design Data reference PSB.PSB_ATTRIBUTES. Its status is VALID in both 12.1.1 and 12.2.2.

From a dimensional modeling perspective, the mined Data Vault classification for this object is hub-leaning. PSB_ATTRIBUTES functions principally as a durable registry of business entities (position attributes) keyed by a stable identifier, and it is referenced by multiple downstream tables rather than itself holding transactional events. This classification should be treated as a suggestion; in practice the table behaves as a reference or setup master, with no link semantics of its own.

Key Information Stored

The table contains 24 documented columns. The most significant are:

• ATTRIBUTE_ID — NUMBER(20), the surrogate primary key and unique identifier for each position attribute (PSB_ATTRIBUTES_PK).
• NAME — VARCHAR2(30), the position attribute name. Together with BUSINESS_GROUP_ID, it forms the business-key candidate enforced by unique index PSB_ATTRIBUTES_U2.
• BUSINESS_GROUP_ID — NUMBER(20), the business group that owns the attribute; the leading column of non-unique index PSB_ATTRIBUTES_N1 and the second column of PSB_ATTRIBUTES_U2.
• DISPLAY_IN_WORKSHEET — flag controlling whether the attribute appears in the summary block of the position worksheet.
• DISPLAY_SEQUENCE — NUMBER, the ordering of the attribute in the Position Worksheet window.
• DISPLAY_PROMPT — VARCHAR2(30), the prompt label presented to the user.
• REQUIRED_FOR_IMPORT_FLAG — indicates whether a value must be assigned before a position can be imported from HRMS.
• REQUIRED_FOR_POSITIONS_FLAG — indicates whether the attribute is mandatory when defining a position.
• ALLOW_IN_POSITION_SET_FLAG — determines whether the attribute may be used within a position set; when not allowed, the modify worksheet module restricts its inclusion.
• VALUE_TABLE_FLAG — indicates whether the attribute's allowable values are sourced from a table.
• DEFINITION_TYPE, DEFINITION_STRUCTURE, DEFINITION_TABLE, DEFINITION_COLUMN — the metadata coordinates describing precisely where in HRMS the attribute value is located.
• ATTRIBUTE_TYPE_ID — foreign key to PSB_ATTRIBUTE_TYPES, classifying the attribute.
• DATA_TYPE and SYSTEM_ATTRIBUTE_TYPE — the value's data type and any system-defined type classification.
• APPLICATION_ID — the owning application; PROTECTED_FLAG — whether the attribute definition is protected from modification.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard EBS audit columns.

Common Use Cases and Queries

Typical uses include identifying which attributes drive the position worksheet layout, determining mandatory attributes prior to HRMS position import, and auditing how position attributes map back to HRMS flexfield segments.

• Retrieving worksheet display attributes: SELECT NAME, DISPLAY_PROMPT, DISPLAY_SEQUENCE FROM PSB.PSB_ATTRIBUTES WHERE DISPLAY_IN_WORKSHEET = 'Y' AND BUSINESS_GROUP_ID = :bg_id ORDER BY DISPLAY_SEQUENCE;
• Listing attributes required for position import: filter on REQUIRED_FOR_IMPORT_FLAG = 'Y'.
• Resolving HRMS source metadata: SELECT NAME, DEFINITION_TYPE, DEFINITION_STRUCTURE, DEFINITION_TABLE, DEFINITION_COLUMN FROM PSB.PSB_ATTRIBUTES;
• Joining to the attribute type classification: SELECT a.NAME, t.NAME FROM PSB.PSB_ATTRIBUTES a, PSB.PSB_ATTRIBUTE_TYPES t WHERE a.ATTRIBUTE_TYPE_ID = t.ATTRIBUTE_TYPE_ID;
• Reporting on attributes actually used, by joining to PSB_ATTRIBUTE_VALUES or PSB_POSITION_ASSIGNMENTS on ATTRIBUTE_ID.

Related Objects

• PSB_ATTRIBUTE_TYPES — referenced via PSB_ATTRIBUTES.ATTRIBUTE_TYPE_ID, providing attribute classification.
• PSB_ATTRIBUTE_VALUES — references PSB_ATTRIBUTES.ATTRIBUTE_ID; stores attribute values assigned to positions.
• PSB_ATTRIBUTE_VALUES_I — the interface (open-interface) counterpart, also keyed by ATTRIBUTE_ID.
• PSB_POSITION_ASSIGNMENTS — references PSB_ATTRIBUTES.ATTRIBUTE_ID, linking attributes to position assignments.
• PSB_ACCOUNT_POSITION_SET_LINES — references PSB_ATTRIBUTES.ATTRIBUTE_ID, tying attributes into account position sets.

These relationships confirm the hub-leaning role of PSB_ATTRIBUTES as a central reference object in the PSB schema.