Results for “hr_efc_worker_audits”

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

Overview

HR_EFC_WORKER_AUDITS is an HR schema table within the PER (Human Resources) product of Oracle E-Business Suite, documented as VALID in both 12.1.1 and 12.2.2. The table stores audit information generated during EFC (Employee FastFormula / Global Payroll currency conversion) update processing. Specifically, it holds one row for each HR_EFC_WORKER row per currency code processed, and it is populated exclusively by update scripts rather than by routine online transactions. Because it captures the state and volume of worker rows touched during currency-specific operations, it functions as a change-tracking companion to the primary worker staging table.

From a Data Vault modeling perspective, the mined relationship structure classifies this table as satellite-leaning. It carries a single foreign key to HR_EFC_WORKERS, its parent entity, and surrounds that parent with descriptive, per-currency audit attributes. This makes it a natural candidate for design as a satellite table attached to the worker business key, rather than as a standalone hub or a many-to-many link.

Key Information Stored

The table contains ten documented columns. The surrogate primary key is EFC_WORKER_AUDIT_ID, enforced through the unique index HR_EFC_WORKER_AUDITS_PK, which is the object users most frequently search for. This column provides the unique identifier for every audit row and is the only documented unique business-key candidate; no separate natural-key composite index is recorded beyond the primary key.

• EFC_WORKER_AUDIT_ID — Surrogate primary key and unique index column for each audit record.
• EFC_WORKER_ID — Foreign key referencing HR_EFC_WORKERS; identifies the worker row being audited.
• COLUMN_NAME — The specific column or element processed during the update script run.
• CURRENCY_CODE — The currency under which the worker row was processed.
• NUMBER_OF_ROWS — Count of rows affected or processed for the associated worker and currency.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns recording when, by whom, and through which login the row was last changed.
• CREATED_BY, CREATION_DATE — Standard WHO columns capturing row creation details.

The composite of EFC_WORKER_ID, COLUMN_NAME, and CURRENCY_CODE provides the practical business context, while the WHO columns support change-history reporting and DBA troubleshooting.

Common Use Cases and Queries

Typical scenarios include reconciling which worker rows were touched by a currency-conversion update script, verifying row counts per currency, and tracing who executed a batch update. A straightforward join retrieves audit context alongside worker reference data:

• SELECT a.EFC_WORKER_AUDIT_ID, a.EFC_WORKER_ID, a.CURRENCY_CODE, a.NUMBER_OF_ROWS FROM HR.HR_EFC_WORKER_AUDITS a WHERE a.CURRENCY_CODE = :code;
• SELECT a.*, w.* FROM HR.HR_EFC_WORKER_AUDITS a JOIN HR.HR_EFC_WORKERS w ON a.EFC_WORKER_ID = w.EFC_WORKER_ID;
• Aggregate row counts by currency: SELECT CURRENCY_CODE, SUM(NUMBER_OF_ROWS) FROM HR.HR_EFC_WORKER_AUDITS GROUP BY CURRENCY_CODE;

Reporting use cases focus on audit trails for update scripts, validation of conversion completeness, and support diagnostics when an update script under- or over-processes workers.

Related Objects

• HR_EFC_WORKERS — Parent table referenced by EFC_WORKER_ID; the primary relationship documented.
• HR_EFC_WORKER_AUDITS_PK — Unique index enforcing the surrogate primary key.
• PER EFC / Global Payroll update scripts — The batch processes that populate this audit table.
• FND WHO audit columns — Standard application framework attributes shared with related HR tables.
• Additional HR staging tables used in the same conversion flows provide secondary context, though only HR_EFC_WORKERS is formally documented as a foreign-key target.