Search Results hr_s_input_values_f




Overview
Explore in AI Chat

Overview

The HR_S_INPUT_VALUES_F table resides in the HR schema and belongs to the PER (Human Resources) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the definition of input values associated with element types used by Oracle Payroll, Oracle HRMS compensation, and related benefits processing. Input values represent the configurable parameters that feed payroll element formulas — earning rates, deduction amounts, hours, units, and similar values — and this table captures their metadata, validation boundaries, defaults, and sequencing.

The ETRM metadata marks this object as "Retrofitted," indicating that it was added to the repository to support legacy or localized configuration scenarios rather than being part of the original core HRMS data model. The heuristic Data Vault classification derived from the FK structure is standalone. This suggests the table operates as an independent reference-style entity rather than participating in a hub-and-satellite or link structure. From a modeling perspective, it can be treated as a self-contained lookup dimension, though the presence of EFFECTIVE_START_DATE and EFFECTIVE_END_DATE gives it date-tracked (Type 2) characteristics that a satellite classification could also reasonably accommodate.

Key Information Stored

The table contains 28 documented columns. The most operationally significant are:

Common Use Cases and Queries

Typical reporting scenarios include listing all input values for a given element type, auditing validation ranges, and identifying input values tied to a specific value set or legislation.

  • Retrieve active input values for an element type:
    SELECT input_value_id, name, uom, default_value FROM hr_s_input_values_f WHERE element_type_id = :p_etid AND SYSDATE BETWEEN effective_start_date AND effective_end_date;
  • Find input values bound to a value set:
    SELECT * FROM hr_s_input_values_f WHERE value_set_id = :p_vsid;
  • Audit boundary validations:
    SELECT name, min_value, max_value, warning_or_error FROM hr_s_input_values_f WHERE mandatory_flag = 'Y';
  • Legislation-specific extraction:
    SELECT * FROM hr_s_input_values_f WHERE legislation_code = 'US' AND business_group_id = :p_bgid;

These queries support payroll configuration audits, migration validation, and element entry screen design reviews.

Related Objects

  • FRM_PART_VALUE_SETS — referenced via VALUE_SET_ID; provides the value set definition used to validate input values.
  • PAY_ELEMENT_TYPES_F — parent element type referenced by ELEMENT_TYPE_ID, supplying the owning payroll element.
  • FF_FORMULAS_F — referenced through FORMULA_ID for derived input values.
  • FND_LOOKUPS — resolves LOOKUP_TYPE into valid values.
  • HR_S_INPUT_VALUES (or locale-specific variants) — the corresponding view or translated sibling used by the forms layer.
  • PAY_INPUT_VALUES_F — payroll-facing counterpart in the PAY schema.
  • HR_API element configuration APIs — programmatic creation and maintenance of input values.

Together these objects form the configuration backbone for payroll element entry and calculation in EBS 12.1.1 and 12.2.2.