Results for “pay_payroll_actions_efc”

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

Overview

The PAY_PAYROLL_ACTIONS_EFC table is an HR-schema payroll object in the Oracle E-Business Suite PAY (Payroll) module. According to the documented ETRM metadata, it is a physical copy of the PAY_PAYROLL_ACTIONS table, populated specifically by the EFC (Euro as a Functional Currency) process. Its purpose is to preserve the relationship between original payroll actions, recorded in PAY_PAYROLL_ACTIONS, and their euro-converted counterparts created during the EFC conversion exercise that accompanied the euro adoption. Rather than overwriting existing payroll action records, the EFC process archives converted equivalents in this shadow table, allowing historical and euro-denominated payroll data to coexist. The table is owned by HR and is documented as VALID in both 12.1.1 and 12.2.2 releases. Its heuristic Data Vault classification is standalone — meaning ETRM's FK-mining did not identify it as a hub, link, or satellite participating in a conventional Data Vault chain, but rather as a self-contained mapping/reference artifact. Modelers should treat it accordingly: it functions less as a transactional fact and more as a conversion cross-reference table.

Key Information Stored

The documented physical schema under ETRM 12.2.2 contains exactly four columns, all of which are relevant:

• PAYROLL_ACTION_ID — The identifier of the payroll action being mapped. It participates in the composite primary key and refers conceptually back to a row in PAY_PAYROLL_ACTIONS.
• EFC_ACTION_ID — The identifier of the euro-converted (EFC) payroll action produced by the conversion process. Together with PAYROLL_ACTION_ID it forms the composite primary key and therefore acts as a business-key candidate for the conversion pairing.
• PAYMENT_TYPE_ID — The payment type associated with the action. This column is documented as a foreign key referencing PAY_PAYMENT_TYPES, giving the table its only outward relationship.
• CURRENCY_CODE — The currency in which the converted action is expressed, retained to disambiguate the converted amounts (typically EUR) from the original action's currency.

The surrogate primary key is PAY_PAYROLL_ACTIONS_EFC_PK, defined as (PAYROLL_ACTION_ID, EFC_ACTION_ID). Both constituent columns are also the sole unique-index (business-key) candidate documented for the table. There is no separately generated surrogate numeric column; identity is expressed through the natural pairing of original and converted action IDs.

Common Use Cases and Queries

The principal reporting scenario is reconciling pre-euro and post-euro payroll history, verifying that every affected payroll action was correctly converted, and identifying payment types where conversion occurred. A typical join pattern resolves the conversion linkage:

• Joining PAY_PAYROLL_ACTIONS_EFC.PAYROLL_ACTION_ID to PAY_PAYROLL_ACTIONS.PAYROLL_ACTION_ID to retrieve the original action's dates, period, and payroll association.
• Joining EFC_ACTION_ID back to PAY_PAYROLL_ACTIONS to retrieve the euro-equivalent action's attributes for side-by-side comparison.
• Joining PAYMENT_TYPE_ID to PAY_PAYMENT_TYPES to obtain payment type names for break-down reporting.
• Filtering CURRENCY_CODE = 'EUR' to isolate converted records.
• Counting conversions per payment type or validating that no original action lacks an EFC counterpart via an outer join.

Because it is a narrow mapping table, queries should generally treat it as a bridge and avoid using it as a source of payroll amounts or balances, which reside in the parent payroll action and run result tables.

Related Objects

• PAY_PAYROLL_ACTIONS — The source table this copy is derived from; both PAYROLL_ACTION_ID and EFC_ACTION_ID resolve to rows here.
• PAY_PAYMENT_TYPES — Referenced by the documented foreign key on PAYMENT_TYPE_ID; supplies payment type descriptions.
• PAY_PAYROLL_ACTIONS_EFC_PK — The composite unique index enforcing identity on (PAYROLL_ACTION_ID, EFC_ACTION_ID).
• PAY_ASSIGNMENT_ACTIONS / PAY_RUN_RESULTS — Downstream payroll action consumers used when reporting converted action effects.
• PAY_PAYROLL_REL_ACTIONS — Often joined to navigate the hierarchy of related payroll actions for the same payroll run.
• PAY_ELEMENT_ENTRIES / PAY_RUN_RESULT_VALUES — Sources of monetary values examined alongside the conversion mapping.

Practically, PAY_PAYROLL_ACTIONS_EFC is best understood as a euro-conversion cross-reference supporting audit and reconciliation of payroll history rather than as an operational payroll table.