The Audit Table

Column

Type

Description

audit_date

Date

Date and time of change

table_name

String(30)

Table Name

pk1, pk2, pk3, pk4

String(255)

Primary key values for audited record

oper

String(1)

I=Insert, U=Update, D=Delete

prm_user_name

String(32)

P6 Professional user name if the change was made in P6 Professional applications

audit_info

String(4000)

Column changes up to 4000 characters (Level 2 and 3 only)

audit_info_extended

BLOB

Blob changes and overflow from audit_info (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

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

* Values will differ for depending on your database.