When you realise that you need to employ auditing in a certain situation, you have got to decide between Record-level audit and field-level audit. This post aims to help you choose the right one.
Field-level and Record level auditing differ mainly on the following fronts.
Choice of Audit Record
Record level auditing provides the option to chose from the delivered PSAUDIT record or a custom-built audit record. But this is not the case with Field level auditing; here PSAUDIT is your only option.
Manageability
Field-level auditing is manageable when you are interested in auditing one or two fields. Beyond that, the complexity increases drastically. That’s certainly not the case with Record level auditing where you can easily manage entire records.
Situation
Based on the factors outlined above, it would be wise to choose Record-level auditing when the situation demands the auditing of several fields or a record as a whole. However, you always have another option in Field-level audit when you are chasing just a field or two.
