Auditing record creation and modification?

[El_Pablo]

Hi,

I was wandering if my method was a good practice to audit record modification and creation.

In most of my tables, I have 5 basic fields.

pkTableNameID (usually number)<-- primary key

creator (text) <-- Account name of the record creator concatenated with SystemNICAddress (eg : Nick;001D09891122)

modifier (text) <-- Account name of the record modifier concatenated with SystemNICAddress (eg Math;001D098211F2)

timestampCreation <-- Obvious

timestampModification <-- Obvious

Is that a good approach or there are better ways?

Thanks for your opinion

[El_Pablo]

So, I'll guess that my approach is good?