Search Results pay_element_type_info_types_pk




Overview
Explore in AI Chat

Overview

PAY_ELEMENT_TYPE_INFO_TYPES is a Payroll (PAY) module reference table owned by the HR schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It defines the categories of additional (extra) information that can be captured against a payroll element type. In the Oracle Payroll data model, an element represents a component of pay or a deduction, and many elements require supplementary attributes beyond the standard element definition — for example, a text field, a code, or a date associated with the element. This table enumerates the permissible "information types" that govern those supplementary attributes, providing the classification and behavioral rules that downstream extra information records must obey.

The table carries a Data Vault classification noted heuristically in the ETRM metadata as hub-leaning. Modelled in Data Vault terms, it functions as a hub: a stable, uniquely identified business concept keyed by INFORMATION_TYPE, with descriptive and audit attributes behaving like satellite data. This classification is a modelling suggestion derived from the foreign-key topology rather than a structural mandate.

Key Information Stored

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

Common Use Cases and Queries

This table is typically queried to discover which extra information types are available for elements, to drive dynamic forms, or to validate configuration against legislation. A representative query listing active types for a legislation is:

SELECT information_type, description, legislation_code
FROM hr.pay_element_type_info_types
WHERE active_inactive_flag = 'Y'
AND legislation_code = :leg_code;

A join to the associated extra-information records uses the foreign key from PAY_ELEMENT_TYPE_EXTRA_INFO:

SELECT ei.element_type_id, it.information_type, it.description
FROM hr.pay_element_type_extra_info ei,
hr.pay_element_type_info_types it
WHERE ei.information_type = it.information_type;

Reporting scenarios include auditing configured information types, identifying legacy or inactive types during cleanup, and reconciling element configuration across legislative environments.

Related Objects

  • PAY_ELEMENT_TYPE_EXTRA_INFO — references this table via INFORMATION_TYPE; holds the actual extra-information values per element type.
  • PAY_ELEMENT_TYPES_F — the element type definitions that the extra information ultimately enriches.
  • PAY_ELEMENT_TYPES_VL and associated views — expose element type data joined with information types for reporting.
  • Payroll element configuration forms and the element-type definition UI consume this table to render available extra-information options.
  • Legislation-related lookup and validation routines reference LEGISLATION_CODE to scope types correctly.

The object is defined as VALID in ETRM 12.2.2 and follows standard HR-schema conventions for audit and editioning columns.