audit log best practices

[shutzy]

i am wanting to create an audit log. i have already started but stopped when i had a few questions.

i am wanting to know what kind of tbl structure i should have.

should i have just a master tbl that stores

uniqueID | tblName | UniqueID(of tbl) | type of change(delete etc) | date and time | employee id

or should i go more in depth with having an audit log for each table. recording before and after updates. what was deleted. i would prefer to be able to see as much as possible when i run reports. it shouldnt be very often when i do run reports but when i do i want the data there to see. is this somehing that is quite common or an i thinking too much into it.

i do have a program that logs all pc activity. programs, clicks, internet etc. it also takes a screen shot on all those occasions.

so if i went with the master tbl i would still have access to the data in a way but i wanting to know what everyone else does.

i have seen the allen browne website, and that got me started really.

thanks