Results for “pay_run_result_values_pk”

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

Overview

PAY_RUN_RESULT_VALUES is a core payroll processing table owned by the HR schema in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It stores the calculated result values produced when a payroll run processes a single element entry. Each record represents the outcome of evaluating one input value for one element entry during a payroll run, capturing the numeric or textual result generated by the payroll engine. Because payroll calculations drive salary, deductions, taxes, and statutory reporting, this table forms a foundational component of the Oracle Payroll (PAY) module's data model.

From a dimensional modeling perspective, the documented foreign key structure suggests a hub-leaning classification. Its primary key is composed of two natural business identifiers rather than a single surrogate sequence, which is consistent with the pattern of a Data Vault hub where the composite key defines the unique identity of the business concept — here, the pairing of an input value with its run result.

Key Information Stored

The table is documented with five columns. The most significant are described below:

• INPUT_VALUE_ID — Part of the composite primary key. Identifies the specific input value of the element entry being processed. This links the result back to the element's input definition.
• RUN_RESULT_ID — The second component of the composite primary key. References the run result header that groups results for a particular assignment action and payroll run.
• RESULT_VALUE — Holds the actual calculated result produced by the payroll engine for the corresponding input value. This is the primary payload column and is the value most frequently retrieved for reporting.
• FORMULA_RESULT_FLAG — Indicates whether the stored result originated from a formula evaluation, providing a lineage and audit distinction between direct input and calculated output.
• INSTANCE_ID — Provides an instance-level identifier used to disambiguate results where an element entry is processed multiple times within a run cycle.

The surrogate primary key is the composite PAY_RUN_RESULT_VALUES_PK, defined over INPUT_VALUE_ID and RUN_RESULT_ID. Because the unique index is built on these two business columns, both are the documented business-key candidates — there is no separate single-column surrogate identifier.

Common Use Cases and Queries

Payroll analysts and technical consultants query this table to verify element calculations, reconcile payroll run outputs, and build custom payslip or costing reports. A typical pattern joins PAY_RUN_RESULT_VALUES to its parent run result header to obtain assignment and payroll context:

• Auditing a specific element's calculated results for a payroll period by filtering on RUN_RESULT_ID.
• Reconciling formula-derived values (where FORMULA_RESULT_FLAG is set) against expected outcomes.
• Building fast-formula or BI Publisher extracts that expose RESULT_VALUE per input value.
• Joining to PAY_COSTS to trace how a result value was distributed to cost centers and general ledger accounts.

A representative query retrieves all results for a given run result identifier:

SELECT INPUT_VALUE_ID, RESULT_VALUE, FORMULA_RESULT_FLAG
FROM HR.PAY_RUN_RESULT_VALUES
WHERE RUN_RESULT_ID = :run_result_id;

Related Objects

The documented foreign key relationships and key structure link this table to the following significant objects:

• PAY_COSTS — Referenced through the composite foreign key on INPUT_VALUE_ID and RUN_RESULT_ID. This is the primary documented dependent, linking calculated results to cost allocations.
• PAY_RUN_RESULTS — The implied parent of RUN_RESULT_ID, providing the run, assignment action, and payroll context for each result value.
• PAY_ELEMENT_ENTRY_VALUES — Source of the input value definitions identified by INPUT_VALUE_ID.
• PAY_ELEMENT_ENTRIES / PAY_ELEMENT_TYPES_F — Define the elements and entries whose processing generated these results.
• PAY_PAYROLL_ACTIONS and PAY_ASSIGNMENT_ACTIONS — Supply the higher-level payroll run context for reporting and reconciliation.

Together these relationships position PAY_RUN_RESULT_VALUES as the detailed result store connecting element input definitions to payroll cost distribution within the Oracle Payroll data model.