Auditing tables and mechanisms

Infor Workforce Management uses an auditing framework to record data changes across the system.

Some mechanisms are always active, while others require configuration. This table describes the available audit mechanisms, the user actions that trigger them, and the tables that store the resulting records.


User action	Audit mechanism	Controllable	Audit table
User inserts, updates, or deletes a record on a maintenance form that has auditing enabled	Maintenance form auditing	Yes. Set the `audit="Y"` attribute on the MFRM definition to enable.	AUDIT_LOG The AUDLOG_TABLENAME column identifies the source table. The audit log is visible through the Audit Tracking Report. See System reports in the Infor Workforce Management Reports User Guide .
User views or performs any action on an admin maintenance form	Admin maintenance form auditing	No. Always active for admin maintenance forms.	AUDIT_LOG Logs all queries regardless of user or audit flag. Members of the SYSTEM ADMIN security group trigger logging on all forms.
User modifies payroll export task configuration	Payroll export task auditing	Yes. Toggle the `audit="Y"` attribute on the MFRM to enable.	AUDIT_LOG Records appear with AUDLOG_TABLENAME = PAYROLL_EXPORT_TSK. To view audit data, use the Audit Tracking Report in Cognos. See System reports in the Infor Workforce Management Reports User Guide .
User saves calculation group changes	Calculation group changes	No. Always active. Written by calc-group save logic to a dedicated table.	CALC_GROUP_AUDIT Use the CALC_GROUP_AUDIT_PERIOD_CHANGE_ONLY registry parameter to control scope. See Enabling rule auditing for all changes in the Infor Workforce Management Time and Attendance Implementation and Administration Guide .
Migration tool processes data changes	Data migration operations	No. Always active when migration runs.	MIGRATION_TRANSACTION tracks the user who is running the report. MIGRATION_TRANSACTION_DTL is for the data-level changes. Data-level changes are also logged in AUDIT_LOG with a MIGDAT_ID reference. Legacy systems use MT_AUDIT_TX. The user must be able to access the MIGRATION_AUDIT registry parameter. See MIGRATION_AUDIT in the Infor Workforce Management Registry Parameter Reference Guide. Data-level changes are also available through the Audit Tracking Report. See System reports in the Infor Workforce Management Reports User Guide .