Results for “priority_code”

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

Overview

IEU_UWQM_PRIORITIES_B is the base (non-translated) table within the IEU — Universal Work Queue (UWQ) module that stores the priority definitions used by UWQ Metaphor prioritization. In Oracle E-Business Suite 12.1.1 and 12.2.2, the Universal Work Queue framework aggregates work items from multiple source applications (Service, TeleSales, Collections, and similar) into a single agent-facing queue. Each item presented to an agent is scored and ordered according to a priority, and IEU_UWQM_PRIORITIES_B supplies those priority definitions, their levels, and their codes. The "_B" suffix indicates that descriptive, language-dependent text is held separately in the companion translation table IEU_UWQM_PRIORITIES_TL, while this table carries the language-independent attributes.

The ETRM metadata assigns a heuristic Data Vault classification of hub-leaning to this object. As a modeling suggestion, this reflects the fact that PRIORITY_ID is a surrogate identifier that stands on its own as a business entity, with dependents (items and translations) hanging from it as satellites and links rather than participating in a many-to-many association.

Key Information Stored

The table is narrow, comprising eleven documented columns, and is organized around a single surrogate primary key plus several business-key and referential attributes.

• PRIORITY_ID — the surrogate primary key, enforced by the constraint/index IEU_UWQM_PRIORITIES_B_PK. This is the value referenced by dependent tables and is the most frequently queried column.
• PRIORITY_LEVEL — the ordinal ranking used to sequence work items within the queue; exposed as a candidate business key through the unique index IEU_UWQM_PRIORITIES_B_U1 (PRIORITY_LEVEL, ZD_EDITION_NAME).
• PRIORITY_CODE — the stored, language-independent code for the priority; a second candidate business key via IEU_UWQM_PRIORITIES_B_U2 (PRIORITY_CODE, ZD_EDITION_NAME).
• SECURITY_GROUP_ID — the multi-tenant security grouping column, with a foreign key to FND_SECURITY_GROUPS.
• OBJECT_VERSION_NUMBER — optimistic locking column used to detect concurrent updates.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle EBS WHO audit columns.
• ZD_EDITION_NAME — the editioning column present in the 12.2.2 online-editioning model, and itself part of all three unique indexes.

The unique index IEU_UWQM_PRIORITIES_B_U3 (PRIORITY_ID, ZD_EDITION_NAME) reinforces the primary key under the editioned architecture. Notably, the table stores no descriptive name; the display name lives in IEU_UWQM_PRIORITIES_TL.

Common Use Cases and Queries

Priority data supports queue ordering, agent workload balancing, and SLA-driven escalation. A common lookup joins the base table to its translation table and the item table:

SELECT p.priority_id, t.priority_name, p.priority_code, p.priority_level
FROM   ieu.ieu_uwqm_priorities_b p,
       ieu.ieu_uwqm_priorities_tl t,
       ieu.ieu_uwqm_items i
WHERE  p.priority_id = t.priority_id
AND    i.priority_id = p.priority_id
AND    t.language = USERENV('LANG')
ORDER BY p.priority_level;

Typical reports list all active priorities ordered by PRIORITY_LEVEL, verify that each priority is referenced by at least one work item, or audit security-group segregation by counting priorities per SECURITY_GROUP_ID. Resolving a priority code back to its ID, or vice versa, is the most frequent single-row lookup, driven by the user search term "priority_id".

Related Objects

The following objects are the most significant dependents and references documented in the ETRM metadata:

• IEU_UWQM_ITEMS — references this table via IEU_UWQM_ITEMS.PRIORITY_ID; the principal consumer of priority definitions.
• IEU_UWQM_PRIORITIES_TL — the translation table, joined on PRIORITY_ID, supplying language-specific names and descriptions.
• FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID, governing access within the multi-tenant model.
• IEU_UWQM_PRIORITIES_B_PK / _U1 / _U2 / _U3 — the primary-key and unique indexes that enforce identity and business-key uniqueness (each including ZD_EDITION_NAME).

These relationships establish IEU_UWQM_PRIORITIES_B as a small but central reference entity in the Universal Work Queue priority model.