Say one of your employees has transferred to another department, so the change to their pay rate needs to become effective on a certain date. Once you make this change to their employee profile, it is not updated in the audit log, so you’ll have to go in there and update it yourself. The log will show every single action that has taken place for an employee, so when you double click into a row, it will open that record and show you what changed for that action.
Within this view, the effective date field is editable. You can go in and change the effective date, so once you’ve put in the right one, save the changes and everything should be reflected in the log. Now when you look at that employee, you can take a look at their work assignment and see what impact that had on the audit log. Remember that this has no effect on the export table – if you have a record that's a past effective date, it's probably already made it to S3.