Results for “hr_h2pi_pay_bases”

50+ results




Overview
Explore in AI Chat

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

Overview

HR_H2PI_PAY_BASES is a table owned by the HR schema within the PER (Human Resources) product module of Oracle E-Business Suite. It is a VALID object in both EBS 12.1.1 and 12.2.2. The table supports the H2PI (Human Resources to Payroll Interface) integration layer, whose purpose is to translate human resources assignments and related attributes into payroll-processable structures. In that architecture, HR_H2PI_PAY_BASES records the pay basis definitions used when payroll is derived from HR assignment data, allowing the interface to resolve which pay basis applies to a given assignment, element, or payroll relationship.

The documented physical schema for ETRM 12.2.2 lists 7 columns: LAST_UPD_DATE, PAY_BASIS_ID, BUSINESS_GROUP_ID, CLIENT_ID, NAME, PAY_BASIS, and STATUS. The primary key is HR_H2PI_PAY_BASES_PK, composed of PAY_BASIS_ID, BUSINESS_GROUP_ID, and CLIENT_ID, making it a composite key rather than a single-column surrogate. The heuristic Data Vault classification mined from the foreign-key structure is standalone; from a modeling perspective, this suggests the object behaves as a reference or lookup entity without a documented hub-and-satellite dependency chain, and could be modeled as an independent hub-style dimension if a Data Vault representation were constructed.

Key Information Stored

The table's most significant columns fall into identifier, descriptive, and lifecycle categories.

  • PAY_BASIS_ID — Surrogate numeric identifier for each pay basis row; part of the composite primary key HR_H2PI_PAY_BASES_PK.
  • BUSINESS_GROUP_ID — Multi-tenant partitioning key that scopes the record to a specific enterprise business group; part of the primary key.
  • CLIENT_ID — Additional partitioning identifier used by HR tables to distinguish logical data sets; part of the primary key.
  • PAY_BASIS — The coded value representing the pay basis (for example, a periodic frequency or payroll-relevant basis indicator). This is the principal business attribute.
  • NAME — Descriptive label for the pay basis, used for display in forms and reports.
  • STATUS — Lifecycle/validity indicator controlling whether the pay basis is active and usable by the interface.
  • LAST_UPD_DATE — Audit timestamp recording the most recent modification, supporting incremental extraction and change tracking.

The documented surrogate primary key is the three-part HR_H2PI_PAY_BASES_PK. No separate unique index is documented in the ETRM metadata, so PAY_BASIS_ID, BUSINESS_GROUP_ID, and CLIENT_ID together are the only documented uniqueness constraint. Business-key candidates such as NAME or PAY_BASIS are not documented as unique and should be treated as descriptive attributes.

Common Use Cases and Queries

Typical usage centers on resolving pay basis definitions during HR-to-payroll data conversion, validating active pay bases, and reporting on configuration.

  • Retrieving active pay bases for a business group: 
    SELECT pay_basis_id, name, pay_basis, status
FROM   hr.hr_h2pi_pay_bases
WHERE  business_group_id = :p_bg_id
AND    status = 'A';
  • Joining pay bases to assignments or payroll interface staging tables using PAY_BASIS_ID and BUSINESS_GROUP_ID as the join path.
  • Incremental extraction using LAST_UPD_DATE to capture newly added or modified pay basis definitions for downstream warehouses.
  • Multi-tenant filtering by CLIENT_ID in shared or consolidated reporting environments.
  • Data-quality checks confirming that referenced PAY_BASIS_ID values exist and are active before payroll processing.

Related Objects

Because the heuristic classification is standalone, no formal foreign keys are documented. Related objects are identified by shared key columns and module context.

  • HR.HR_H2PI_PAY_BASES_PK — The primary key constraint on (PAY_BASIS_ID, BUSINESS_GROUP_ID, CLIENT_ID).
  • PAY_PAY_BASES and related payroll pay-basis definitions — share the pay basis identifier space used by the interface.
  • PER_ASSIGNMENTS / PER_ALL_ASSIGNMENTS_F — join on BUSINESS_GROUP_ID to resolve the pay basis applicable to an assignment.
  • PAY_ELEMENT_TYPES_F and PAY_ELEMENTS_F — payroll elements that reference pay basis configuration.
  • HR.HR_H2PI-prefixed interface staging tables — the H2PI integration layer consuming these definitions.
  • FND_LOOKUP_VALUES — where coded values such as STATUS or PAY_BASIS may be validated against lookup types.