Record-level Auditing vs Database-Level Auditing
We created a record-level audit table for PS_NAMES.
It seems that when you add a new name record, the audit table contains the new name (shouldn't it contain the old name?)
It seems that when you correct an existing name record, the audit table contains the old name.
I opened a Peoplesoft Service Request and was told to use database-level auditing.
What is the difference and why would database-level auditing work in this scenario, even though record-level auditing is not working for PS_NAMES?