Document toolboxDocument toolbox

sp829_smaudit_emplkregion

Owned by Jason Andrew
Oct 02, 2024
1 min read

This table records ServiceManager user updates to the local knowledge regions of an Operative. The date and time the change was made, who made it, and the Operative modified are stored in sp822_smaudit.

HouseKeeping

This table is tidied by sp_dbtidy's Audit group.

 

Table Definition

Field
Type
Default
Nullable
audit_seq_nonumber(9) (error)
region_refvarchar2(26) (error)
old_local_knowledgenumber(2) (tick)
new_local_knowledgenumber(2) (tick)
day_numbernumber(2) (tick)

Keys

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

Column Descriptions

FieldDescription
audit_seq_noUnique identifier : the sequence number of the action. 
region_refThe region for which the local knowledge rating has been changed.
old_local_knowledgeThe previous local knowledge rating for this region .
new_local_knowledgeThe new local knowledge rating for this region .
day_numberWhen 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.