About Audit

[Supriya]

I want to get a list of all fields(and records they are contained in) that are being audited and the audit property selected such as, field change,field delete and field add. Is there a table in PS HRMS system tables? How will i write a query to retrieve such data in 7.5 and/or 8.3????????? (I know that PSAUDIT has audit info but it only has information for the fields modified whose audit property is selected)

[ralaparthi]

Supriya,

USEEDIT is the field where u can get the reqd info.
Everything is o(false) or 1(True).

If MSS try this...to get all fields in any record with audit actions

select
RECNAME,
FIELDNAME,
((USEEDIT/8) - (USEEDIT/16) * 2) AUDIT_ADD,
((USEEDIT/128) - (USEEDIT/256) * 2) AUDIT_CHANGE,
((USEEDIT/1024) - (USEEDIT/2048) * 2) AUDIT_DELETE
from psrecfield

select
RECNAME,
FIELDNAME

from psrecfield
where ((USEEDIT/8) - (USEEDIT/16) * 2) = 1
Gives all the fields with Audit Add...

Similarly try other Audits.

If u r on oracle......
(TRUNC(USEEDIT/8) - TRUNC(USEEDIT/16) * 2) AUDIT_ADD

Mail me if u need anything else.

Raja
Ralaparthi@earthlink.net

[krunetha]

Is auditing part of gaining salvation in Scientology? In Scientology, does the auditing process have to do with the process of gaining salvation?

[krunetha]

Is auditing part of gaining salvation in Scientology? In Scientology, does the auditing process have to do with the process of gaining salvation?