Search Results hr_efc_worker_audits_pk

Overview

The HR_EFC_WORKER_AUDITS table is a supporting audit table within the Oracle E-Business Suite Human Resources (PER) module, specifically for versions 12.1.1 and 12.2.2. Its primary role is to track the processing of worker-related data during specific currency conversion or update operations. As indicated by its description, it holds one audit record for each corresponding row in the HR_EFC_WORKERS table per currency code processed, but exclusively for operations executed by update scripts. This table functions as a critical logging mechanism, ensuring data integrity and providing an audit trail for financial data maintenance tasks related to employees (workers) across different currencies, which is essential for multi-currency and global payroll environments.

Key Information Stored

While the provided metadata does not list all columns, the structure centers on a unique audit identifier and a link to the source worker data. The primary key column, EFC_WORKER_AUDIT_ID, uniquely identifies each audit record. The foreign key column, EFC_WORKER_ID, establishes a direct relationship to the HR_EFC_WORKERS table, pinpointing the specific worker record that was processed. The table's definition implies the presence of a column to store the CURRENCY_CODE, as it records one row per currency processed. Additional columns likely include timestamps for the update, identifiers for the process or script run, and possibly status flags to indicate the outcome of the processing operation.

Common Use Cases and Queries

This table is primarily accessed for audit and troubleshooting purposes related to batch updates of worker financial information. Common scenarios include verifying the completion and scope of a specific currency conversion job or diagnosing issues where worker data may not have been updated as expected. A typical query would join to the HR_EFC_WORKERS table to retrieve contextual details.

Sample Query: Find all audit records for a specific worker:
SELECT aud.*, wor.*
FROM hr_efc_worker_audits aud,
     hr_efc_workers wor
WHERE aud.efc_worker_id = wor.efc_worker_id
AND wor.worker_identifier = '<EMPLOYEE_NUMBER>';
ORDER BY aud.efc_worker_audit_id;

Use Case for Reporting: Generating a summary report of all currency update scripts processed in a given timeframe, counting the number of worker records audited per currency code.

Related Objects

The HR_EFC_WORKER_AUDITS table has a documented, direct dependency on a core worker table. The relationships are as follows:

• Primary Key: HR_EFC_WORKER_AUDITS_PK on column EFC_WORKER_AUDIT_ID.
• Foreign Key (References): The table HR_EFC_WORKER_AUDITS contains a foreign key on column EFC_WORKER_ID that references the HR_EFC_WORKERS table. This ensures every audit record is associated with a valid, existing worker record in the system.

Given its function, this table is also conceptually related to other EFC (likely "Enterprise Fusion Currency" or similar) and payroll audit tables within the HR schema, though the provided metadata confirms only the relationship with HR_EFC_WORKERS.