Field Level Auditing
There are two types of delivered auditing in PeopleSoft:
- Field level auditing
- Record level auditing
Field level auditing tracks changes to one or more fields on a PeopleSoft record and stores the results in the delivered
Like record level auditing, field level auditing only applies to data updated through PeopleSoft and not directly through the database. So auditing will not apply to data updated by SQL scripts, SQRs and COBOLs unless they are specifically designed to update the audit table.
To enable field level auditing, simply update the record-field properties of the relevant fields on the PeopleSoft record. For instance, the following screenshot shows how to audit field add, change and delete, on the
PROJECTNAME field of
Once enabled, make changes to the relevant field of the relevant PeopleSoft record online and confirm your changes are audited by querying the table
PSAUDIT stores the old and new values of the field along with the audit action (e.g.
A for Add,
D for Delete and
C for Change). It also stores the record name and key fields of of row in the PeopleSoft record that was modified so that you can track back to it. These are the values that appear in the fields
So for example, if you had field level auditing enabled on the field
LASTUPDOPRID of the record
PSPROJECTDEFN and the
LASTUPDOPRID was changed, you would see:
- The person that made the change (
- The date/time of the change (
- The audit action of change (
- The record name of
- The field name of
- The old value of
LASTUPDOPRIDbefore the change
- The new value
LASTUPDOPRIDafter the change
- The project name (
KEY1as this is the first (and only) key of the
Field auditing is good for tracking a few fields on a record. It becomes cumbersome to track when you have many fields on a particular record being audited. This is where record level auditing is more appropriate, particularly when you want to audit many or all changes on a record.
Record level auditing also uses its own audit table while field level auditing uses the delivered
PSAUDIT record which can get very large if a lot of auditing is enabled.