Results for “entry_process_path”

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

Overview

PAY_ENTRY_PROCESS_DETAILS is an Oracle Payroll (PAY) transactional table residing in the HR schema, described in the ETRM as holding "internal processing details for certain element entries." It is a supporting, low-level table used by the payroll engine to track how specific element entries are processed — particularly in scenarios involving retroactive recalculations, assignment action sourcing, time definitions, and tax unit association. It is not a user-facing configuration table; it is populated and consumed by internal payroll processing logic and should be treated as system-managed.

Under a heuristic Data Vault classification mined from its foreign-key structure, this object leans toward satellite. It carries descriptive and referential processing attributes keyed to a central business entity (the element entry / run result context), which is characteristic of satellite behavior. This classification is a modeling suggestion only and should be validated against the full key topology before being relied upon architecturally.

Key Information Stored

The table exposes 11 documented columns in the 12.2.2 physical schema. The most significant for interpretation are:

• ELEMENT_ENTRY_ID — The principal business-key candidate; identifies the element entry whose processing detail is being recorded, tying the row back to the payroll element entry entity.
• SOURCE_ELEMENT_TYPE_ID / SOURCE_ENTRY_ID — Identify the originating element type and source entry that generated this processing record, essential for tracing retro or adjustment lineage.
• SOURCE_ASG_ACTION_ID — Foreign key to PAY_ASSIGNMENT_ACTIONS; links the detail to the assignment action that triggered the entry.
• RETRO_COMPONENT_ID — Identifies the retroactive component associated with the processing detail.
• RUN_RESULT_ID — Foreign key to PAY_RUN_RESULTS; ties the row to the payroll run result that produced or consumed it.
• TAX_UNIT_ID — Associates the entry with the relevant tax unit for statutory processing.
• TIME_DEFINITION_ID — Foreign key to PAY_TIME_DEFINITIONS; links time-related processing definitions.
• PROCESS_PATH / ENTRY_PROCESS_PATH — Encode the processing path taken by the payroll engine for this entry, used internally to determine calculation routing.
• ADJUSTMENT_TYPE — Classifies the nature of any adjustment applied to the entry.

No explicit surrogate primary key column is documented in the metadata excerpt; ELEMENT_ENTRY_ID functions as the strongest business-key candidate, though internal uniqueness is typically enforced through a composite of the entry and source identifiers.

Common Use Cases and Queries

Because the table supports internal payroll processing, its primary uses are diagnostic, audit, and reconciliation rather than reporting. Typical scenarios include investigating why a particular element entry was calculated a certain way, tracing the source of a retroactive adjustment, and reconciling run results against their originating assignment actions.

A representative diagnostic query joins the detail to its run results and assignment actions:

• SELECT p.run_result_id, p.element_entry_id, p.adjustment_type, a.action_type
• FROM pay_entry_process_details p
• JOIN pay_run_results r ON r.run_result_id = p.run_result_id
• JOIN pay_assignment_actions a ON a.assignment_action_id = p.source_asg_action_id
• WHERE p.element_entry_id = :entry_id;

Such queries support payroll troubleshooting, retro lineage analysis, and validation that statutory tax unit and time definition links were correctly applied during processing.

Related Objects

The following objects are most significant, based on documented foreign-key relationships:

• PAY_RUN_RESULTS — joined via RUN_RESULT_ID; the run result context for the detail.
• PAY_ASSIGNMENT_ACTIONS — joined via SOURCE_ASG_ACTION_ID; the originating assignment action.
• PAY_TIME_DEFINITIONS — joined via TIME_DEFINITION_ID; time definition linkage.
• PAY_ELEMENT_ENTRIES — parent entity referenced through ELEMENT_ENTRY_ID and source entry identifiers.
• PAY_RETRO_COMPONENTS — referenced through RETRO_COMPONENT_ID for retroactive processing.
• PAY_TAX_UNITS — referenced through TAX_UNIT_ID for statutory association.

Together these relationships position the table as a connective detail store within the payroll calculation engine.