Search Results hr_h2pi_element_names




Overview
Explore in AI Chat

Overview

The HR.HR_H2PI_ELEMENT_NAMES table is a Human Resources (PER) module object in Oracle E-Business Suite 12.1.1 and 12.2.2. The "H2PI" naming convention indicates its association with the HR-to-Payroll Information (H2PI) integration, a mechanism used to synchronize element definitions and related reference data between a source system and the Oracle Payroll element model. In practice, this table serves as a reference repository of element type names and their corresponding reporting names, keyed by business group, so that payroll-to-general-ledger and HR-to-Payroll interfaces can resolve element identifiers to human-readable labels without traversing the full PAY_ELEMENT_TYPES definition hierarchy.

From a data-modeling perspective, the metadata classifies this object heuristically as a standalone entity, meaning no foreign keys are documented to or from other tables. This suggests modeling the table as an independent reference or lookup structure rather than as a hub, link, or satellite within a Data Vault construct. Any integration with the core element model would be implicit, driven by the ELEMENT_TYPE_ID value rather than by a declared referential constraint.

Key Information Stored

The table contains seven documented columns. The composite primary key, enforced by HR.HR_H2PI_ELEMENT_NAMES_PK, comprises ELEMENT_TYPE_ID, BUSINESS_GROUP_ID, and CLIENT_ID. These three columns together form the surrogate identifying key for a given row and also serve as the principal business-key candidates, since the combination is guaranteed unique within the table.

  • ELEMENT_TYPE_ID — Surrogate identifier of the payroll element type being named; the primary correlation point to the broader element definition model.
  • BUSINESS_GROUP_ID — Owns the row within a specific business group or legislative data group, ensuring multi-tenant isolation of element naming.
  • CLIENT_ID — Multi-tenant discriminator, typically populated consistently per installation or data partition.
  • ELEMENT_NAME — The display or functional name of the element as presented to users and interfaces.
  • REPORTING_NAME — The alternate label used for reporting and extract purposes, frequently the name printed on statutory or management reports where the primary element name is unsuitable.
  • STATUS — Lifecycle indicator reflecting whether the naming record is active or obsolete.
  • LAST_UPD_DATE — Timestamp of the most recent modification, used for incremental synchronization and audit.

Common Use Cases and Queries

The most frequent requirement is resolving an element type to its reporting label for extracts and reconciliation reports. A typical query joins the naming table to element assignments through ELEMENT_TYPE_ID, filtered by business group:

  • Reporting extracts: select ELEMENT_NAME and REPORTING_NAME for all rows where BUSINESS_GROUP_ID equals a given legislative group and STATUS is active.
  • Interface validation: detect element types present in other tables but absent from HR_H2PI_ELEMENT_NAMES, highlighting naming gaps before a payroll run or GL transfer.
  • Change tracking: use LAST_UPD_DATE to extract names modified since the previous synchronization cycle, supporting delta loads between HR and Payroll or between environments.
  • Duplicate-name analysis: group by ELEMENT_NAME to identify collisions that could confuse users or interface mappings within a business group.

Related Objects

Because the metadata documents no foreign keys, all relationships are implicit through ELEMENT_TYPE_ID and BUSINESS_GROUP_ID. The most significant associated objects include:

  • PAY_ELEMENT_TYPES_F — the principal element definition table, joined on ELEMENT_TYPE_ID and BUSINESS_GROUP_ID.
  • PAY_ELEMENT_TYPES_TL — translated element names, useful for comparison against ELEMENT_NAME and REPORTING_NAME.
  • PAY_ELEMENT_CLASSIFICATIONS — classification rules that determine how named elements are processed in payroll calculations.
  • PAY_ELEMENT_LINKS_F — link definitions that reference ELEMENT_TYPE_ID when elements are assigned to payrolls or assignment sets.
  • PAY_RUN_RESULTS — run results keyed by element type, where reporting names are required for output presentation.
  • HR_H2PI_* staging and interface tables — sibling H2PI objects that consume the naming data during HR-to-Payroll Information transfers.