Results for “routing_group_id”

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

Overview

GHR_ROUTING_GROUPS is a table in the HR schema belonging to the GHR — US Federal Human Resources product family within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores routing group definitions, which serve as logical containers that determine how Federal HR documents, position descriptions, and personnel action requests are routed through approval and distribution workflows. In US Federal implementations, routing groups are a foundational configuration element: they group users, group boxes, and routing lists so that a document such as a position description or a personnel action request is directed to the correct reviewing officials, approval chains, and distribution points.

The table is a low-volume, configuration-oriented entity. The documented physical schema contains eight columns, and the table participates in several downstream foreign key relationships as the referenced parent. Following Data Vault modeling heuristics derived from the foreign key structure, GHR_ROUTING_GROUPS can be characterized as hub-leaning: it holds a stable business entity keyed by a surrogate identifier, and other GHR tables act as dependent or associative structures that reference it. A Data Vault implementation would typically model it as a hub with the surrounding routing and request tables treated as links or satellites.

Key Information Stored

Of the eight documented columns, the most significant are:

• ROUTING_GROUP_ID — The surrogate primary key, enforced by the GHR_ROUTING_GROUPS_PK index. This numeric identifier is the value propagated to all child tables via foreign keys and should never be exposed as a user-facing key.
• NAME — The routing group name. This column is protected by the GHR_ROUTING_GROUPS_UK unique index, making it the documented business-key candidate. It is the value users select and report against.
• DESCRIPTION — Free-text explanation of the routing group's purpose, useful for administration and audit.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard Oracle EBS audit columns recording when and by which user/application session the row was last modified.
• CREATED_BY, CREATION_DATE — Standard audit columns recording row creation context.

The distinction between the surrogate key (ROUTING_GROUP_ID) and the business key (NAME) is important for integration and conversion work: external systems should map on NAME where a stable human-readable identifier is required, while all internal joins rely on ROUTING_GROUP_ID.

Common Use Cases and Queries

Typical scenarios include resolving routing groups for a specific position description, auditing which routing groups are referenced by pending personnel action requests, and listing routing group memberships for configuration reporting.

• Resolve a routing group by business key: SELECT routing_group_id, name, description FROM ghr_routing_groups WHERE name = :name;
• List routing groups used by personnel action requests: SELECT r.name, COUNT(*) FROM ghr_routing_groups r, ghr_pa_requests p WHERE p.routing_group_id = r.routing_group_id GROUP BY r.name;
• Identify routing groups attached to position descriptions: SELECT pd.position_description_id, rg.name FROM ghr_position_descriptions pd, ghr_routing_groups rg WHERE pd.routing_group_id = rg.routing_group_id;
• Orphan/coverage checks using the GHR_ROUTING_LISTS and GHR_GROUPBOXES relationships to confirm each group has the expected routing lists and group boxes.

Because volume is low, queries against this table are inexpensive, but joins into GHR_PA_REQUESTS can be large; index-driven lookups on ROUTING_GROUP_ID are recommended.

Related Objects

The documented foreign keys identify four dependent objects that reference GHR_ROUTING_GROUPS via ROUTING_GROUP_ID:

• GHR_GROUPBOXES.ROUTING_GROUP_ID — Group box definitions associated with each routing group.
• GHR_PA_REQUESTS.ROUTING_GROUP_ID — Personnel action requests routed through the group.
• GHR_POSITION_DESCRIPTIONS.ROUTING_GROUP_ID — Position descriptions assigned to the group for routing.
• GHR_ROUTING_LISTS.ROUTING_GROUP_ID — Routing list entries that define the ordered recipients for a group.

Together these objects form the Federal HR routing subsystem, with GHR_ROUTING_GROUPS acting as the central configuration parent.