Results for “pay_shadow_input_values”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PAY_SHADOW_INPUT_VALUES is a core configuration table in the Oracle EBS Payroll (PAY) module, owned by the HR schema. It stores the definition of each input value attached to an element template, capturing the metadata that controls how payroll elements accept, validate, and default input data during element creation and processing. In effect, it is the canonical definition layer that determines the behavior of every input a template exposes.

The table sits at the intersection of element templates, validation formulas, and rule processing. It is referenced heavily by downstream rule and feed tables that consume input value definitions for balance feeds, formula processing, and iterative computations.

Based on the foreign key topology, the heuristic Data Vault classification assigned to this table is hub-leaning. In a Data Vault model, this suggests PAY_SHADOW_INPUT_VALUES would serve as a hub entity, with its surrogate INPUT_VALUE_ID acting as the durable business key and dependent attributes distributed to satellites. This classification is a modeling suggestion only and should be validated against actual usage patterns.

Key Information Stored

The table contains 24 documented columns. The most significant are grouped below:

• INPUT_VALUE_ID — the surrogate primary key, uniquely identifying each shadow input value row (PAY_SHADOW_INPUT_VALUES_PK).
• ZD_EDITION_NAME — participates with INPUT_VALUE_ID in the unique index PAY_SHADOW_INPUT_VALUES_PK, functioning as the business-key candidate.
• ELEMENT_TYPE_ID — foreign key to PAY_SHADOW_ELEMENT_TYPES, linking the input value to its parent element template.
• NAME and DISPLAY_SEQUENCE — the input value label and its ordering on the element form.
• UOM and LOOKUP_TYPE — unit of measure and lookup validation source.
• DEFAULT_VALUE, DEFAULT_VALUE_COLUMN, MIN_VALUE, MAX_VALUE — default population and range constraints.
• MANDATORY_FLAG, HOT_DEFAULT_FLAG, GENERATE_DB_ITEMS_FLAG — behavioral flags controlling required entry, defaulting, and DB item generation.
• WARNING_OR_ERROR — controls whether a validation breach raises a warning or a hard error.
• FORMULA_ID and INPUT_VALIDATION_FORMULA — the formula driving value derivation and input validation.
• EXCLUSION_RULE_ID — foreign key to PAY_TEMPLATE_EXCLUSION_RULES, governing template applicability.
• OBJECT_VERSION_NUMBER and the standard WHO columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE, etc.) — concurrency control and audit trail.

Common Use Cases and Queries

The primary use case is interrogating element template configuration — identifying which input values exist for a given element type, their validation rules, and their downstream rule consumers.

• Listing all input values for an element template:

  SELECT v.INPUT_VALUE_ID, v.NAME, v.MANDATORY_FLAG, v.UOM FROM PAY_SHADOW_INPUT_VALUES v WHERE v.ELEMENT_TYPE_ID = :element_type_id ORDER BY v.DISPLAY_SEQUENCE;

• Finding validations attached to inputs: filter on FORMULA_ID or INPUT_VALIDATION_FORMULA being non-null to audit formula-driven validation.
• Impact analysis: join to PAY_TEMPLATE_EXCLUSION_RULES via EXCLUSION_RULE_ID to determine which templates exclude a given input.
• Reporting on defaults and constraints: query DEFAULT_VALUE, MIN_VALUE, and MAX_VALUE for documentation or migration scripting.

Related Objects

The table participates in a defined set of referential relationships:

• PAY_SHADOW_ELEMENT_TYPES — parent via ELEMENT_TYPE_ID; the element template owning each input value.
• PAY_TEMPLATE_EXCLUSION_RULES — referenced via EXCLUSION_RULE_ID.
• PAY_SHADOW_BALANCE_FEEDS — references INPUT_VALUE_ID; links inputs to balance feed definitions.
• PAY_SHADOW_FORMULA_RULES — references INPUT_VALUE_ID; associates input values with formula rules.
• PAY_SHADOW_ITERATIVE_RULES — references INPUT_VALUE_ID; associates input values with iterative processing rules.

Together these relationships make PAY_SHADOW_INPUT_VALUES the definition hub from which balance feeds and formula/iterative rule processing derive their input semantics.