Oracle Fusion/HCM/Payroll

PAY_RUN_RESULTS

Element run results — one row per element processed for a person in a payroll run.

Key Columns

RUN_RESULT_IDELEMENT_TYPE_IDPAYROLL_REL_ACTION_IDELEMENT_ENTRY_IDSTATUSRESULT_TYPE

Parent Table

PAY_PAYROLL_REL_ACTIONS

Per-person payroll processing rows — the result of a payroll action for one payroll relationship.

Child Tables

PAY_RUN_RESULT_VALUES

Run result values — the numeric results (Pay Value, Hours, Rate) behind each element run result.

Common Joins

PAY_RUN_RESULT_VALUESvia RUN_RESULT_ID

The input and output values (pay value, hours, rate) for this run result.

PAY_ELEMENT_TYPES_Fvia ELEMENT_TYPE_ID

The earning / deduction element definition.

Used In

Payroll

Fusion Payroll run results data model

A payroll process is a payroll action (PAY_PAYROLL_ACTIONS) with a per-person row (PAY_PAYROLL_REL_ACTIONS) for each payroll relationship. Each element processed becomes a run result (PAY_RUN_RESULTS) whose numbers are in PAY_RUN_RESULT_VALUES. Elements are defined in PAY_ELEMENT_TYPES_F and assigned via PAY_ELEMENT_ENTRIES_F.