Results for “psb_entity”

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

Overview

PSB_ENTITY is the central definition table within the Public Sector Budgeting (PSB) module of Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. The table stores parameter, constraint, and allocation rule definitions used by the budgeting engine to describe how budget data is extracted, calculated, constrained, and distributed across an organization's budgeting model. Each row represents a named budgeting entity, distinguished by an entity type and subtype, that governs the behavior of downstream formulas and allocation logic.

From a modeling perspective, the FK topology mined from the schema suggests PSB_ENTITY behaves as a hub in a Data Vault classification. It carries the ENTITY_ID surrogate key and is referenced by multiple dependent tables, while itself referencing a small set of parent lookups (PSB_DATA_EXTRACTS, PSB_BUDGET_GROUPS, PSB_BUDGET_YEAR_TYPES). This hub-and-spoke pattern is characteristic of a master definition table that anchors transactional and rule-bearing satellites.

Key Information Stored

PSB_ENTITY contains 36 documented columns. The most significant are:

• ENTITY_ID — surrogate primary key (PSB_ENTITY_PK); the join key for all dependent tables.
• NAME and ENTITY_TYPE — business-key candidates, enforced by unique index PSB_ENTITY_U2. Together they identify an entity uniquely.
• ENTITY_SUBTYPE — narrows the behavioral category of the entity.
• DATA_EXTRACT_ID — FK to PSB_DATA_EXTRACTS, linking the entity to its source data extraction.
• BUDGET_GROUP_ID — FK to PSB_BUDGET_GROUPS, scoping the entity to a budget group.
• BUDGET_YEAR_TYPE_ID — FK to PSB_BUDGET_YEAR_TYPES, tying the entity to a budget year classification.
• SET_OF_BOOKS_ID — accounting set of books context.
• ALLOCATION_TYPE and BALANCE_TYPE — control how allocation rules and balances are interpreted.
• FTE_CONSTRAINT — constraint applied to full-time-equivalent budgeting.
• PARAMETER_AUTOINC_RULE and PARAMETER_COMPOUND_ANNUALLY — parameter behavior flags.
• CURRENCY_CODE — currency context for monetary parameters.
• CONSTRAINT_DETAILED_FLAG — indicates detailed constraint handling.
• APPLY_ACCOUNT_SET_FLAG and BALANCE_ACCOUNT_SET_FLAG — account set application controls.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — date-effective range for the definition.
• ATTRIBUTE1–10 and CONTEXT — DFF/descriptive flexfield support.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard audit columns.

Common Use Cases and Queries

Typical usage centers on retrieving entity definitions and joining to the rule tables that consume them. A common reporting query lists entities with their parameter formulas:

• List all allocation-rule entities for a budget group:
  SELECT e.ENTITY_ID, e.NAME, e.ENTITY_TYPE, e.ALLOCATION_TYPE FROM PSB_ENTITY e WHERE e.BUDGET_GROUP_ID = :group_id AND e.ENTITY_TYPE = 'ALLOCATION_RULE';
• Join entities to their constraint formulas:
  SELECT e.NAME, c.* FROM PSB_ENTITY e JOIN PSB_CONSTRAINT_FORMULAS c ON c.CONSTRAINT_ID = e.ENTITY_ID;
• Resolve parameter definitions with set relations:
  SELECT e.NAME, s.* FROM PSB_ENTITY e JOIN PSB_SET_RELATIONS s ON s.PARAMETER_ID = e.ENTITY_ID;

These patterns support budget model validation, impact analysis before changing a definition, and audit reporting on parameter and constraint configuration.

Related Objects

The following are the most significant objects referencing or referenced by PSB_ENTITY, per documented FK relationships:

• PSB_ALLOCRULE_PERCENTS — references PSB_ENTITY via ALLOCATION_RULE_ID; holds allocation percentages.
• PSB_CONSTRAINT_FORMULAS — references via CONSTRAINT_ID; stores constraint formula definitions.
• PSB_PARAMETER_FORMULAS — references via PARAMETER_ID; stores parameter formula definitions.
• PSB_ENTITY_ASSIGNMENT — references via ENTITY_ID; assigns entities to organizational units.
• PSB_SET_RELATIONS — references via PARAMETER_ID, CONSTRAINT_ID, and ALLOCATION_RULE_ID; defines set relationships.
• PSB_DATA_EXTRACTS — parent lookup referenced by DATA_EXTRACT_ID.
• PSB_BUDGET_GROUPS — parent lookup referenced by BUDGET_GROUP_ID.
• PSB_BUDGET_YEAR_TYPES — parent lookup referenced by BUDGET_YEAR_TYPE_ID.

Because PSB_ENTITY anchors these dependent rule tables, it should be treated as the master definition object when analyzing Public Sector Budgeting configuration.