Transactions Log

The Payroll transactions log stores information about all changes made to database tables. User actions like creating, deleting, modifying a table record are recorded in the log.

Action: Recorded action on a table (Add, Update, Delete)

Table Name: The table that was affected by the user's action.

Primary key: The primary key identifies the table's record that was affected by the user's action.

Primary key name: The primary key name helps to identify visually the table's record that was affected.

Event details: The details of the user's action on the table's record. This is blank when action is Delete.

In the example for log id 4, user gdi has updated employee 10 - Lecoq Gilles master record,
by changing the monthly basic from 3500 to 3799, and transaction type from 0 to 4.

Two foreign currencies USD and EUR were added to the ForeignCurrency table.

Logs generated by the system internal libraries are categorised under System.
Logs generated by the running application are categorised under Application.
Logs generated by the running application or internal libraries and related to a security issue are categorised under Security.

To identify a record with a primary key consisting of multiple fields the system stores each field one after the other separated by a semi-colon.