Document toolboxDocument toolbox

sp828_smaudit_emplkrange

Owned by Jason Andrew
Oct 02, 2024
1 min read

This table records ServiceManager user updates to the local knowledge ranges 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)
local_knowledgenumber(2) (error)
old_travel_rangenumber(3) (tick)
new_travel_rangenumber(3) (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.
local_knowledge The local knowledge rating.
old_travel_range The previous travel range associated with this local knowledge rating.
new_travel_range The new travel range associated with this local knowledge rating.