Search This Blog

Wednesday, July 10, 2013

PeopleSoft Audit: Record Level , Field Level , Database Level

To help us keep track of changes done to sensitive data by appropriate user, we use Audit.
Later we can query the Audit record to see the list of changes happened.

In PeopleSoft, we can set Audit at
1. Record Level
2. Field Level
3. Database Level.

For Option 1 and 2, Audit captures changes done to data for the online page. If the data is changed by any program using a SQL statement then Audit is not captured.

For Option 3, It covers both online and database changes done to the transaction record.

Now lets see how to implement these 3 types of Audits:

1. Record Level Audit.
Open the record definiton and then Record Properties. You will find the section where you enter Audit Record Name and Type of Actions(Add/Delete/Selective/Change) which needs to be captured.
For any change done to the fields in the record, a row will be inserted into Audit record.

2. Field Level Audit.
Open the record definiton and then Record Field Properties for any of the field for which Audit needs to be captured. In the Audit section , you select the type of Action that needs to be audited.
For any change in the field, there will be mutilpe rows inserted in the Audit record.

3. Database level Audit.
There is navigation available in PIA to generate trigger script which is then excuted in the database. This kind of Audit captures the changes  done to the record at database level also.

Audit record should start with AUDIT_XXX  and should contain below fields as Key fields.
  • AUDIT_OPRID -- Captures Info on who changed the data
  • AUDIT_STAMP -- Captures the TimeStamp
  • AUDIT_ACTN  -- Captures the Type of Transaction done (Insert/Delete/Update..)
In next post , we will see each of these in detail.

No comments: