The Audit Table

Audit records are inserted into the PAUDIT table. One record is inserted into the audit table for each row changed in the database.


PAUDIT Table
Column	Type	Description
`AUDIT_TS`	`TIMESTAMP(6)`	Date and time of change
`TABLE_NAME`	`STRING(30)`	Table Name
`PK1, PK2, PK3, PK4`	`STRING(255)`	Primary key values for audited record
`PROJ_ID`	`NUMBER`	Unique object id of the audited project.
`OPER`	`STRING(1)`	I=Insert, U=Update, D=Delete
`PRM_USER_NAME`	`STRING(32)`	P6 EPPM user name if the change was made in P6 EPPM applications
`AUDIT_OLD`	`STRING(4000)`	Column changes up to 4000 characters (Level 2 and 3 only)
`AUDIT_NEW`	`STRING(4000)`	Column changes up to 4000 characters (Level 2 and 3 only)
`AUDIT_EXT_OLD`	`BLOB`	Blob changes and overflow from audit_old (Level 2 and 3 only)
`AUDIT_EXT_NEW`	`BLOB`	Blob changes and overflow from audit_new (Level 2 and 3 only)
`LOGICAL_DELETE_FLAG`	`STRING(1)`	Flag for deletes that are logical (marked) rather than a physical delete
`RDBMS_USER_NAME*`	`STRING(255)`	Database user name (usually privuser)
`OS_USER_NAME*`	`STRING(255)`	Operating system user name of connected session Note: When auditing is enabled against a SQL Server database, `PAUDIT.os_user_name` will always return a null value. This is because the value for `os_user_name` in `PAUDIT` table is taken from the `nt_username` column in `master.sys.sysprocesses` view and the `nt_username` value in `master.sys.sysprocesses` view is empty for the P6 Professional program because P6 is connected to SQL DB using SQL authentication. The `nt_username` field is filled only when we connect to SQL DB using Windows authentication.
`PROGRAM*`	`STRING(255)`	Name of program connecting to the database
`HOST_NAME*`	`STRING(255)`	Computer name of connected session
`APP_NAME*`	`STRING(25)`	Name of application connected to the database
`NETADDRESS*`	`STRING(24)`	IP or MAC address of connected session

Note: Grant select privileges to the administrative user on V_$SESSION to ensure correct values for several auditing table values.

Related Topics