Search Results hxt_earn_groups




Overview
Explore in AI Chat

Overview

HXT_EARN_GROUPS is an Oracle E-Business Suite Time and Labor (HXT) schema table that stores the definition details of earn groups. In the Oracle EBS Time and Labor model, earn groups are the transactional bridge that maps an element type (a payroll earnings element) to an earn group type, establishing which earning elements belong to a given grouping used for time entry, retrieval, and processing rules. Because the table records the association between an earn group type and a specific element type, it functions as an intersection or mapping construct rather than a standalone descriptive entity.

Under a heuristic Data Vault classification derived from the foreign-key structure, HXT_EARN_GROUPS is satellite-leaning. In practice this means it is best modeled as an attribute-bearing relationship table that hangs off the HXT_EARN_GROUP_TYPES parent, carrying the descriptive and audit attributes of the earn group definition rather than acting as a pure hub or link. This classification is a modeling suggestion, not a documented constraint, and should be validated against the specific reporting or ETL requirement at hand.

Key Information Stored

The documented physical schema for release 12.2.2 contains seven columns owned by the HXT schema. The most significant are the composite key columns and the standard audit columns:

  • EGT_ID — the earn group type identifier. This is the leading column of the primary key and the foreign key that references HXT_EARN_GROUP_TYPES.EGT_ID, anchoring the row to its parent earn group type.
  • ELEMENT_TYPE_ID — the element type identifier, identifying the payroll earnings element that is associated with the earn group. This is the second column of the composite primary key and serves as the primary business-key candidate.
  • CREATED_BY — the user or process that inserted the row.
  • CREATION_DATE — the timestamp when the row was created.
  • LAST_UPDATED_BY — the user or process that most recently modified the row.
  • LAST_UPDATE_DATE — the timestamp of the most recent modification, commonly used for incremental extraction and change detection.
  • LAST_UPDATE_LOGIN — the login identifier associated with the last update, useful for audit tracing.

The surrogate primary key is defined by the unique index HXT_EARN_GROUPS_PK on the composite of EGT_ID and ELEMENT_TYPE_ID. Because this unique index also defines the natural business-key candidate, there is no separate single-column surrogate key documented; the primary key itself is the business key. The audit columns support standard Oracle EBS "Who" column conventions.

Common Use Cases and Queries

Typical usage centers on identifying which element types are grouped under a given earn group type, and on validating that a time-entry session resolves to the correct earnings element. A representative query joining the mapping to its parent type is:

  • SELECT eg.EGT_ID, eg.ELEMENT_TYPE_ID, egt.NAME FROM hxt_earn_groups eg, hxt_earn_group_types egt WHERE eg.EGT_ID = egt.EGT_ID — retrieves earn group definitions with descriptive type names.
  • Filtering by ELEMENT_TYPE_ID to determine which earn groups reference a specific payroll element before element changes are made.
  • Extracting rows where LAST_UPDATE_DATE exceeds a high-water mark to feed incremental data-warehouse loads.
  • Reconciling Time and Labor earn group configuration against Payroll element definitions during implementation or upgrade validation.

Related Objects

The following objects are the most significant dependencies for HXT_EARN_GROUPS:

  • HXT_EARN_GROUP_TYPES — the parent table, joined via HXT_EARN_GROUPS.EGT_ID = HXT_EARN_GROUP_TYPES.EGT_ID. This is the only documented foreign-key relationship and the primary join path.
  • PAY_ELEMENT_TYPES_F / element type definitions — referenced indirectly through the element type identifier to supply element names and classifications.
  • Time and Labor time-entry and retrieval APIs — consume earn group membership when resolving earning elements for submitted time.
  • Payroll element and earnings processing objects — use earn group definitions to determine which elements apply during calculation.
  • Standard HXT audit and reporting views — surface earn group configuration for administrative inquiry and reporting.