Table Definition

Field	Type	Default	Nullable
audit_seq_no	number(9)
resource_id	varchar2(30)
old_start	date
new_start	date
old_end	date
new_end	date
old_skill_level	number(2)
new_skill_level	number(2)

Keys

primary key (audit_seq_no)
foreign key (audit_seq_no) references sp822_smaudit (audit_seq_no)

Field	Description
audit_seq_no	Unique identifier : the sequence number of the action.
resource_id	The identifier of the skill type.
old_start_date	The previous start date of the skill assignment.
new_start_date	The new start date of the skill assignment.
old_end_date	The previous end date of the skill assignment.
new_end_date	The new end date of the skill assignment.
old_skill_level	The previous level of the skill assignment.
old_skill_level	The new level of the skill assignment.