Search Results pay_element_type_extra_info_pk




Overview
Explore in AI Chat

Overview

PAY_ELEMENT_TYPE_EXTRA_INFO is a Payroll (PAY) module table owned by the HR schema in Oracle E-Business Suite 12.1.1 and 12.2.2. As its name and ETRM description indicate, it stores supplementary or descriptive information attached to an element type. Element types are the fundamental building blocks of Oracle Payroll and Oracle Compensation Workbench, defining how earnings, deductions, and other pay components are processed. Where the core attributes of an element reside in PAY_ELEMENT_TYPES, this table captures the extensible, user-defined detail that a legislator or implementer chooses to associate with each element via a defined information type.

The table is a child (detail) entity. Its primary key is ELEMENT_TYPE_EXTRA_INFO_PK, uniquely identified by the surrogate column ELEMENT_TYPE_EXTRA_INFO_ID. The single documented foreign key, INFORMATION_TYPE, references PAY_ELEMENT_TYPE_INFO_TYPES, which governs the category and structure of the extra information being stored. From a Data Vault modeling perspective, this table leans toward a satellite: it holds descriptive, time-variant attributes dependent on a parent business key rather than true relationship links.

Key Information Stored

The table contains 65 documented columns. The most significant are:

The surrogate key ELEMENT_TYPE_EXTRA_INFO_ID is distinct from the business key: the meaningful identity of a row is the combination of ELEMENT_TYPE_ID and INFORMATION_TYPE, while the surrogate simply guarantees a stable technical identifier.

Common Use Cases and Queries

Typical uses include retrieving all extra information attached to a given element, driving descriptive-flexfield reporting, and validating which information types are populated for legislative or statutory reporting. A representative query joins the table to its parent information types:

  • SELECT e.ELEMENT_TYPE_ID, e.INFORMATION_TYPE, e.EEI_INFORMATION_CATEGORY, e.EEI_INFORMATION1 FROM PAY_ELEMENT_TYPE_EXTRA_INFO e WHERE e.ELEMENT_TYPE_ID = :p_element_type_id;
  • SELECT e.*, t.NAME FROM PAY_ELEMENT_TYPE_EXTRA_INFO e JOIN PAY_ELEMENT_TYPE_INFO_TYPES t ON e.INFORMATION_TYPE = t.INFORMATION_TYPE;

These patterns support reporting on element configuration, auditing changes to element classification, and extracting DFF data for downstream payroll interfaces. Because the DFF columns are generically named, queries should be parameterized by INFORMATION_TYPE or INFORMATION_CATEGORY to return meaningful values.

Related Objects

In the Oracle Payroll data model, PAY_ELEMENT_TYPE_EXTRA_INFO is best treated as the extensible satellite of the element type hub, enabling flexible, customer-specific detail without altering the core element definition.