14.1 sp831_smaudit_empact

Table Definition

Field	Type	Default	Nullable
audit_seq_no	number(9)
activity_no	number(9)
old_activity_type	number(2)
new_activity_type	number(2)
old_expected_start	date
new_expected_start	date
old_expected_end	date
new_expected_end	date
old_postcode	varchar2(30)
new_postcode	varchar2(30)

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.
activity_no	A number identifying the activity.
old_activity_type	The previous type of this activity.
new_activity_type	The new type of this activity.
old_expected_start	The previous expected start of this activity.
new_expected_start	The new expected start of this activity.
old_expected_end	The previous expected end of this activity.
new_expected_end	The new expected end of this activity.
old_postcode	The previous location (postcode) of this activity.
new_postcode	The new location (postcode) of this activity.