Table Definition

Field	Type	Default	Nullable
audit_seq_no	number(9)
region_ref	varchar2(26)
old_local_knowledge	number(2)
new_local_knowledge	number(2)
day_number	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.
region_ref	The region for which the local knowledge rating has been changed.
old_local_knowledge	The previous local knowledge rating for this region .
new_local_knowledge	The new local knowledge rating for this region .
day_number	When provided (i.e. when a non-null value is given) specifies the single day number in the Operative's working pattern that this region update applied to.