Create Your Own Audit Record

So PSAUDIT is not cutting it and you need to log new, modified, or deleted rows of a specific record?

Then you need your own audit record.

First, identify your key fields.

For EMAIL_ADDRESSES, we have

• EMPLID
• E_ADDR_TYPE

For PERSONAL_PHONE, we have

• EMPLID
• PHONE_TYPE

Second, identify the fields to be audited.

Let's say I only want to audit 

• EMAIL_ADDR
• EXTENSION

You audit record should look like this.

Build the record. Then attach it to EMAIL_ADDRESSES and PERSONAL_PHONE like so

That's it. Audit away.