Search Results pay_shadow_input_values

Overview

The PAY_SHADOW_INPUT_VALUES table is a core technical repository within the Oracle E-Business Suite Payroll module (PAY). It functions as a staging or shadow table for input values associated with element templates. Its primary role is to manage the configuration and propagation of input values when element templates are created, modified, or applied across legislative contexts. This object is integral to the element template architecture, ensuring that changes to input value definitions—such as their names, units of measure, and default values—are systematically tracked and can be consistently applied to related payroll entities like balance feeds, formula rules, and iterative rules before being finalized in the production tables.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the documented primary and foreign key relationships define its critical structure. The table's primary key is INPUT_VALUE_ID, which uniquely identifies each shadow input value record. The ELEMENT_TYPE_ID column is a foreign key linking the input value to its parent shadow element type in the PAY_SHADOW_ELEMENT_TYPES table. The EXCLUSION_RULE_ID column links to the PAY_TEMPLATE_EXCLUSION_RULES table, defining conditions under which the input value should be excluded from template application. Other typical columns in such a shadow table would mirror those in the main PAY_INPUT_VALUES_F table, storing details like the input value name, database item suffix, units of measure, and default values, all in a provisional state for template management.

Common Use Cases and Queries

This table is primarily accessed during the design and maintenance of payroll element templates. Common use cases include auditing the configuration of a template before activation, troubleshooting issues with template propagation, and generating reports on pending input value changes. A typical query would join this table to its parent shadow element type to review all input values for a specific template. For example: SELECT psiv.* FROM pay_shadow_input_values psiv, pay_shadow_element_types pset WHERE psiv.element_type_id = pset.element_type_id AND pset.template_name = 'MY_TEMPLATE'; Another critical scenario involves validating dependencies before deleting a template draft, which requires checking for existing references in related shadow tables like PAY_SHADOW_BALANCE_FEEDS.

Related Objects

The PAY_SHADOW_INPUT_VALUES table is centrally connected within the element template shadow schema. Based on the documented foreign key relationships:

• References (Parent Tables):
  • PAY_SHADOW_ELEMENT_TYPES: Linked via PAY_SHADOW_INPUT_VALUES.ELEMENT_TYPE_ID. This is the primary parent table.
  • PAY_TEMPLATE_EXCLUSION_RULES: Linked via PAY_SHADOW_INPUT_VALUES.EXCLUSION_RULE_ID.
• Referenced By (Child Tables):
  • PAY_SHADOW_BALANCE_FEEDS: References this table via PAY_SHADOW_BALANCE_FEEDS.INPUT_VALUE_ID.
  • PAY_SHADOW_FORMULA_RULES: References this table via PAY_SHADOW_FORMULA_RULES.INPUT_VALUE_ID.
  • PAY_SHADOW_ITERATIVE_RULES: References this table via PAY_SHADOW_ITERATIVE_RULES.INPUT_VALUE_ID.

These relationships enforce data integrity during the template configuration process, ensuring input values are correctly associated with balance calculations, formula invocations, and iterative processing rules.