Search Results pay_shadow_element_types

Overview

The PAY_SHADOW_ELEMENT_TYPES table is a core technical table within the Oracle E-Business Suite Payroll (PAY) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master definition table for shadow element types, which are specialized, system-generated element types created from element templates. These shadow elements are not directly defined by users but are instantiated during payroll processing to execute the rules and formulas defined in their source template. The table's primary role is to store the metadata that defines these processing entities, linking a template to its runtime components such as formulas and exclusion rules, thereby enabling the dynamic and rule-based calculation logic central to Oracle Payroll.

Key Information Stored

While the full column list is not detailed in the provided metadata, the foreign key relationships and primary key define its critical structure. The table's primary key is the ELEMENT_TYPE_ID, which uniquely identifies each shadow element type instance. Essential foreign key columns establish its operational dependencies: TEMPLATE_ID links back to the source PAY_ELEMENT_TEMPLATES, PAYROLL_FORMULA_ID references the associated calculation logic in PAY_SHADOW_FORMULAS, and EXCLUSION_RULE_ID connects to conditional rules in PAY_TEMPLATE_EXCLUSION_RULES. Other columns would typically store attributes controlling processing behavior, classification, and effective dates.

Common Use Cases and Queries

This table is primarily accessed for diagnostic, audit, and support purposes rather than direct transactional use. Common scenarios include troubleshooting payroll calculation errors by tracing a problematic element back to its template definition and related rules, or analyzing the impact of a template change. A typical query would join to related tables to get a comprehensive view of a shadow element's configuration.

Sample Query: Retrieve Shadow Element Details for a Template
SELECT sht.element_type_id,
    tmp.template_name,
    frm.formula_name
FROM pay_shadow_element_types sht,
    pay_element_templates tmp,
    pay_shadow_formulas frm
WHERE sht.template_id = tmp.template_id
AND sht.payroll_formula_id = frm.payroll_formula_id
AND tmp.template_name = '<Template_Name>';

Related Objects

As indicated by its extensive foreign key relationships, PAY_SHADOW_ELEMENT_TYPES is a central hub in the shadow element architecture. Key related objects include:

• PAY_ELEMENT_TEMPLATES: The source definition table.
• PAY_SHADOW_FORMULAS: Holds the calculation formula for the shadow element.
• PAY_TEMPLATE_EXCLUSION_RULES: Defines rules for when the element should not be processed.
• PAY_SHADOW_INPUT_VALUES: Stores the input values (e.g., rates, hours) for the shadow element.
• PAY_SHADOW_FORMULA_RULES, PAY_SHADOW_ITERATIVE_RULES, PAY_SHADOW_SUB_CLASSI_RULES: Tables governing specific advanced processing rules.
• PAY_SHADOW_ELE_TYPE_USAGES: Links the shadow element type to its usage contexts.
• PAY_SHADOW_GU_BAL_EXCLUSIONS: Manages global balance exclusions for the shadow element.