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 PSAUDIT
table.
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 PSPROJECTDEFN
:
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
.
The record 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 KEY1
... KEY15
.
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 (
AUDIT_OPRID
) - The date/time of the change (
AUDIT_STAMP
) - The audit action of change (
C
) (AUDIT_ACTN
) - The record name of
PSPROJECTDEFN
- The field name of
LASTUPDOPRID
- The old value of
LASTUPDOPRID
before the change - The new value
LASTUPDOPRID
after the change - The project name (
PROJECTNAME
field) inKEY1
as this is the first (and only) key of thePSPROJECTDEFN
record.
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.
No Comments