Table Definition

Field	Type	Default	Nullable
timestamp	date
sequence	number
username	varchar2(256)
osuser	varchar2(256)
machine	varchar2(64)
program	varchar2(256)
session_id	number
process_id	varchar2(22)
job_no	number(9)
job_ref	varchar2(50)
old_job_status	number(2)
new_job_status	number(2)
old_importance	number(1)
new_importance	number(1)
old_on_hold	number(1)
new_on_hold	number(1)
transaction_id	number(9)

Keys

None.

Field	Description
timestamp	Date and time at which these details were saved. Uses the time zone of the DBMS server machine.
sequence	Unique identifier: the sequence number of the update.
username	DBMS user.
osuser	Operating system user.
machine	Machine logged onto.
program	Program name.
session_id	DBMS session id of the session performing the update.
process_id	Unix process id (pid) - a number.
job_no	Identifier of job.
job_ref	End user's unique identifier.
old_job_status	Job status before update.
new_job_status	Job status after update.
old_importance	Importance before update.
new_importance	Importance after update.
old_on_hold	On Hold status before update.
new_on_hold	On Hold status after update.
transaction_id	See SP599_TRANSACTION_AUDIT for details.