Search Results pay_shadow_iterative_rules




Overview
Explore in AI Chat

Overview

The PAY_SHADOW_ITERATIVE_RULES table is a core data object within the Oracle E-Business Suite Payroll (PAY) module, specifically for versions 12.1.1 and 12.2.2. It functions as a shadow or staging table in the element template framework. Its primary role is to temporarily hold iterative rule definitions during the creation or modification of element templates before they are finalized and applied to the main payroll element structures. This design supports a controlled, multi-step configuration process, ensuring data integrity and validation before changes impact live payroll calculations.

Key Information Stored

The table stores the linkage between an element template, an input value, and a specific iterative or exclusion rule. Its structure is defined by key foreign key relationships. The primary identifier is the ITERATIVE_RULE_ID column. The ELEMENT_TYPE_ID column references the shadow element type being configured in the PAY_SHADOW_ELEMENT_TYPES table. The INPUT_VALUE_ID column links to a specific input value for that element type within the PAY_SHADOW_INPUT_VALUES table. Crucially, the EXCLUSION_RULE_ID column references a predefined rule in the PAY_TEMPLATE_EXCLUSION_RULES table, defining the condition under which the iterative calculation for the linked input value should be excluded or governed.

Common Use Cases and Queries

This table is primarily accessed during the backend processing of the Element Template user interface. Common operational scenarios include validating rule assignments before template submission and debugging template configuration issues. A typical diagnostic query would join to related shadow tables to list all iterative rules for a specific template draft:

  • SELECT psir.iterative_rule_id, pset.element_name, psiv.name input_value_name, pter.rule_name FROM pay_shadow_iterative_rules psir JOIN pay_shadow_element_types pset ON psir.element_type_id = pset.element_type_id JOIN pay_shadow_input_values psiv ON psir.input_value_id = psiv.input_value_id JOIN pay_template_exclusion_rules pter ON psir.exclusion_rule_id = pter.exclusion_rule_id WHERE pset.element_type_id = <ID>;

Direct reporting or manipulation by end-users or functional consultants is uncommon, as interaction is channeled through dedicated Oracle Payroll forms and APIs.

Related Objects

PAY_SHADOW_ITERATIVE_RULES is centrally connected to several other shadow and master tables in the payroll template architecture, as defined by its foreign keys.

  • PAY_SHADOW_ELEMENT_TYPES: The parent shadow table for the element template being configured.
  • PAY_SHADOW_INPUT_VALUES: Contains the shadow input values for the element type to which the rule is applied.
  • PAY_TEMPLATE_EXCLUSION_RULES: The master reference table containing the definition of the exclusion or iterative rules themselves.
  • PAY_SHADOW_ITERATIVE_RULES_PK: The primary key constraint on the ITERATIVE_RULE_ID column.