Document toolboxDocument toolbox

14.1 sp830_smaudit_emppattlocs

Owned by Billy Sewell (Unlicensed)
Jan 26, 2024

This table records ServiceManager user updates to the working pattern locations 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)
day_numbernumber(2) (error)
old_startloc_type number(1) (tick)
new_startloc_type number(1) (tick)
old_endloc_type number(1) (tick)
new_endloc_type number(1) (tick)
old_lkcloc_type number(1) (tick)
new_lkcloc_type number(1) (tick)
old_startloc_postcodevarchar2(30) (tick)
new_startloc_postcodevarchar2(30) (tick)
old_endloc_postcodevarchar2(30) (tick)
new_endloc_postcodevarchar2(30) (tick)
old_lkcloc_postcodevarchar2(30) (tick)
new_lkcloc_postcodevarchar2(30) (tick)

Keys

Column Descriptions

FieldDescription
audit_seq_noUnique identifier : the sequence number of the action.
day_numberWhen provided (not null) specifies the single day number in the Operative's working pattern that this region update applied to.
old_startloc_typeIs the previous location of the operative at the start of their shift.
0 - Home
1 - Work
2 - Depot
3 - Specified 
new_startloc_typeIs the new location of the operative at the start of their shift.
0 - Home
1 - Work
2 - Depot
3 - Specified 
old_endloc_typeIs the previous location of the operative at the end of their shift.
0 - Home
1 - Work
2 - Depot
3 - Specified 
new_endloc_typeIs the new location of the operative at the end of their shift.
0 - Home
1 - Work
2 - Depot
3 - Specified 
old_lkcloc_typeIs the previous location of the operative from which range local knowledge is calculated.
0 - Home
1 - Work
2 - Depot
3 - Specified
new_lkcloc_typeIs the new location of the operative from which range local knowledge is calculated.
0 - Home
1 - Work
2 - Depot
3 - Specified
old_startloc_postcode  Is the previous location (postcode) of the operative at the start of their shift when old_startloc_type (above) is 'Specified'.
new_startloc_postcode  Is the new location (postcode) of the operative at the start of their shift when old_startloc_type (above) is 'Specified'.
old_endloc_postcode  Is the previous location (postcode) of the operative at the end of their shift when old_startloc_type (above) is 'Specified'.
new_endloc_postcode  Is the new location (postcode) of the operative at the end of their shift when old_startloc_type (above) is 'Specified'.
old_lkcloc_postcode Is the previous location (postcode) from which range local knowledge is calculated when old_lkcloc_type (above) is 'Specified'.
new_lkcloc_postcode Is the new location (postcode) from which range local knowledge is calculated when old_lkcloc_type (above) is 'Specified'.