Document toolboxDocument toolbox

sp832_smaudit_empoverride

Owned by Jason Andrew
Oct 02, 2024
2 min read

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

 

****** NOTE THAT THIS TABLE IS CURRENTLY NOT USED ******

HouseKeeping

This table is tidied by sp_dbtidy's Audit group.

 

Table Definition

Field
Type
Default
Nullable
audit_seq_nonumber(9) (error)
override_datedate (error)
startloc_type number(1) (tick)
endloc_type number(1) (tick)
lkcloc_type number(1) (tick)
startloc_postcodevarchar2(30) (tick)
endloc_postcodevarchar2(30) (tick)
lkcloc_postcodevarchar2(30) (tick)
break_earliest_startnumber(4)  (deprecated)
break_latest_startnumber(4)  (deprecated)
break_durationnumber(4)  (deprecated)
start_timenumber(4)  (tick)
end_timenumber(4)  (tick)
adj_shiftnumber(1) (tick)
vehicle_capacitynumber(9) (tick)
capacity_shiftnumber(1) (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.
override_dateThe date to which this shift override applies.
startloc_typeIs the type of the operative's start location as specified in the shift override:
0 - Home
1 - Work
2 - Depot
3 - Specified
endloc_typeIs the type of the operative's end location as specified in the shift override:
0 - Home
1 - Work
2 - Depot
3 - Specified
lkcloc_typeIs the type of the location from which the operative's range local knowledge is calculated:
0 - Home
1 - Work
2 - Depot
3 - Specified
startloc_postcode  Is the start location (postcode) specified for the operative in this shift override when startloc_type (above) is 'Specified'.
endloc_postcode  Is the end location (postcode) specified for the operative in this shift override when endloc_type (above) is 'Specified'.
lkcloc_postcode  Is the location (postcode) from which the operative's range local knowledge is calculated, as specified in this shift override, when lkcloc_type (above) is 'Specified'.
start_timeThe time of day at which the shift override period starts. See sp115_shifts (start_time). 
end_timeThe time of day at which the shift override period ends. See sp115_shifts (start_time). 
adj_shiftIndicates whether this override allows All Day jobs to be allocated automatically in this period. See sp115_shifts (ADJ_shift). 
vehicle_capacityThis is the vehicle capacity for the specified override date. A null value indicates that the underlying sp210_employees.vehicle_capacity value should be used. A value of 0 indicates that the day is explicitly overridden to have no vehicle capacity. 
capacity_shiftIndicates whether this override period is to be taken into account in capacity management. See sp115_shifts (capacity_shift)Â