14.1 sp500_gantt_audit

Table Definition

Field	Type	Default	Nullable
timestamp	date
sequence	number
username	varchar2(256)
osuser	varchar2(50)
machine	varchar2(64)
resp_unit_ref	varchar2(8)
action	varchar2(20)
activity_no	number(9)
activity_type	number(2)
job_ref	varchar2(50)
employee_ref	varchar2(25)
name	varchar2(30)
old_value	varchar2(50)
new_value	varchar2(50)
transaction_id	number(9)

foreign key (action) references sp501_gantt_actions (action)

Field	Description
timestamp	Date and time at which these details were saved. Uses the time zone in sp083.tz_ts_gantt_audit, or sysdate if this is empty/null.
sequence	Unique identifier : the sequence number of the action.
username	DBMS user.
osuser	Gantt client's login name (sp085_users.user_id).
machine	Hostname or IP address of machine being used by osuser.
resp_unit_ref	Name of responsibility unit.
action	The type of action that has occurred.
activity_no	If acting on a job or Standard Activity, a number identifying the current activity.
activity_type	If acting on a job or Standard Activity, the type of activity being processed (as in sp105.activity_type).
job_ref	Job identifier (as in sp111.job_ref) if a job is being acted on.
employee_ref	As in sp210_employees.employee_ref. If a job or Standard Activity is being moved to a new employee, this will be the reference for the new employee.
name	The name of a field with a changed value.
old_value	The value of the named field before the action. Format of date/times as in sp083.tz_fm_gantt_audit. Override times shown in the employee's time zone. All other times shown in the Responsibility Unit's time zone.
new_value	The value of the named field after the action. Format and time zone as for old_value. transaction_id. See SP599_TRANSACTION_AUDIT for details.