Audit Trail

I prefer below 2 solutions each has there own pros and cons

Implementing Audit Trail Using dedicated Table lets say History and manually making the entry in History table wherever required
e.g
Employee
empId
name

EmployeeHistory
empHistoryId
empId
name
dateAdded

Pros:
1. As you are adding the data in EmployeeHistory table you have tight control over what data you need in EmployeeHistory

Cons
1. Implementing this for all records and updating all process models may increase development and Testing efforts


Database Triggers
1. Implement the database trigger to log the change in history table

Pros
1. Easy to implement

Cons
1. There might be performance hit if you try to update/insert bulk data. Also if production support team executing any data fix script for large volume of data, you may need to switch off the trigger at that time

Thanks
Pratiksha