sp511_audit_sp206

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)
employee_no	number(9)
old_resource_no	number(9)
old_start_date	date
old_end_date	date
old_skill_level	number(2)
old_is_derived	number(1)
new_resource_no	number(9)
new_start_date	date
new_end_date	date
new_skill_level	number(2)
new_is_derived	number(1)

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.
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.
employee_no	Employee identifier.
old_resource_no	Old identifier of the resource.
old_start_date	Old date on which the employee or work location acquires the resource. Uses employee's Time Zone.
old_end_date	Old date on which the employee or work location gives up the resource. Uses employee's Time Zone.
old_skill_level	Old skill level.
old_is_derived	Old is_derived flag - a value of 1 indicates that the skill was derived from the crew members' skills; 0 that it was not.
new_resource_no	Identifier of the resource.
new_start_date	Date on which the employee or work location acquires the resource. Uses employee's Time Zone.
new_end_date	Date on which the employee or work location gives up the resource. Uses employee's Time Zone.
new_skill_level	Skill level.
new_is_derived	Flag - a value of 1 indicates that the skill was derived from the crew members' skills; 0 that it was not.