I found this article interesting and useful.

The only thing I noticed is that the code for Listing 4 and Listing 7 are the wrong way round.

I too favour separate triggers for Audit and business logic/other.

Also, at one firm, we had a third party case management system which had no auditing, an ineffective control mechanism for...