Search Results pay_input_values_f




Overview
Explore in AI Chat

Overview

The PAY_INPUT_VALUES_F table is a core data definition table within the Oracle E-Business Suite Payroll module (PAY). It stores the master definitions for input values, which are the specific units of data entry and calculation linked to payroll elements. Each input value represents a distinct piece of information, such as hours, a monetary amount, or a rate, that is required to process an element's earnings or deductions. The table is effective-dated (indicated by the '_F' suffix), meaning it maintains a history of changes to input value definitions over time. Its primary role is to provide the structural metadata that defines what data can be entered for an element, how it is validated, and how it participates in payroll calculations, forming a critical link between element definitions (PAY_ELEMENT_TYPES_F) and the actual entered data (PAY_ELEMENT_ENTRIES_F).

Key Information Stored

The table's structure centers on identifying the input value and its relationship to a specific element, governed by effective dates and legislative or business group context. Key columns include INPUT_VALUE_ID, the unique primary identifier, and ELEMENT_TYPE_ID, which foreign keys to PAY_ELEMENT_TYPES_F to establish the parent element. The EFFECTIVE_START_DATE and EFFECTIVE_END_DATE columns manage the validity period of each definition row. The NAME column stores the descriptive identifier for the input value (e.g., 'Regular Hours', 'Deduction Amount'). Other significant columns, implied by its function, typically include DATA_TYPE (to define if the value is number, date, or text), UOM (Unit of Measure), and DEFAULT_VALUE. The BUSINESS_GROUP_ID and LEGISLATION_CODE columns provide the security and legislative context for the definition, as enforced by the documented unique key PAY_INPUT_VALUES_F_UK2.

Common Use Cases and Queries

This table is fundamental for payroll configuration analysis, data validation, and troubleshooting. Common scenarios include identifying all input values for a specific element to understand its data requirements, or tracing changes to an input value's definition over time. A typical query retrieves the current effective definition for a known element.

  • Sample Query: Find input values for an element:
    SELECT pivf.name, pivf.uom, pivf.effective_start_date
    FROM pay_input_values_f pivf
    WHERE pivf.element_type_id = (SELECT element_type_id FROM pay_element_types_f WHERE element_name = 'Regular Salary')
    AND SYSDATE BETWEEN pivf.effective_start_date AND pivf.effective_end_date
    ORDER BY pivf.name;
  • Reporting Use Case: Generating a master list of all elements with their associated input values, units of measure, and default values for configuration documentation or audit purposes.

Related Objects

PAY_INPUT_VALUES_F is a central hub within the Payroll data model. Its primary relationship is with PAY_ELEMENT_TYPES_F, which holds the parent element definition. The input values defined here are directly referenced by PAY_ELEMENT_ENTRY_VALUES_F, which stores the actual entered or calculated amounts for employees. It is also closely related to PAY_BALANCE_FEEDS_F, as input values often feed balances. Key APIs that likely create or modify data in this table include the Element Description and Element Link APIs. The table's primary key (PAY_INPUT_VALUES_F_PK) and unique key (PAY_INPUT_VALUES_F_UK2) ensure referential integrity with these dependent objects.