Audits in PeopleSoft (Record level & Filed level)

Auditing enables us to know if any new rows added,updated or deleted 
PeopleSoft has two approaches of auditing data they are 

1)Field level auditing
2)Record level auditing

1) Field level auditing : Field-level audits record when you insert, update, or delete a field value. The system writes a row of audit data to the PSAUDIT table for each field marked for audit. You may write multiple rows of audit data for a single transaction.

The PSAUDIT table contains the following fields:

• AUDIT_OPRID
• AUDIT_STAMP
• AUDIT_ACTN
• RECNAME
• FIELDNAME
• OLDVALUE
• NEWVALUE
• KEY1, KEY2, …

Performing Field Level Audits

A field level audit is a record field property. To configure a field level audit:
1. Open the desired record.
2. Double click the field you would like to audit.
3. In the Audit section, select Field Add, Field Change, or Field Delete.

4. Click the OK button.



Now use the following sql to observe the Auditing in DB

> SELECT * FROM PSAUDIT;

> SELECT * FROM PSAUDIT WHERE RECNAME='YOUR RECORD';

> SELECT * FROM PSAUDIT WHERE RECNAME='YOUR RECORD' AND FIELDNAME ='FIELD NAME';










2)Record level auditing:  Here Auditing will be done in the whole record level

The simple steps are 

1) Open your  record that about to audit , Just save as the record with prefix  'audit_<your record name'

2)Insert the Audit fields as the first three fields (i.e.) following fields
       AUDIT_OPRID
       AUDIT_STAMP
       AUDIT_ACTN

Note: For AUDIT_STAMP, select the Auto-Update check box in the Record Field Properties dialog box otherwise the audit record doesn't receive a date and time stamp.

3)Clear all the keys and build the table.

4)Now Open the main record that you are about to audit 
  File - Definition Properties - Use tab

5)Select the correct audit record definition from the Record Name drop-down list box

6) Select the Audit actions

7)Test the Auditing process
   Check in DB  

SELECT * FROM PS_PRO_STUDENT;
SELECT * FROM PS_AUDIT_PRO_STUD;