Table Definition

Field	Type	Default	Nullable
audit_seq_no	number(9)
team_name	varchar2(40)
old_start	date
new_start	date
old_end	date
new_end	date

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.
team_name	The name of the team.
old_start_date	The previous start date of the shift specification assignment.
new_start_date	The new start date of the shift specification assignment.
old_end_date	The previous end date of the shift specification assignment.
new_end_date	The new end date of the shift specification assignment.