Document toolboxDocument toolbox

14.1 sp825_smaudit_empshiftass

Owned by Billy Sewell (Unlicensed)
Jan 26, 2024

This table records ServiceManager user updates to the shift assignments 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)
spec_namevarchar2(30) (error)
old_startdate (tick)
new_startdate (tick)
old_enddate (tick)
new_enddate (tick)

Keys

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

Column Descriptions

FieldDescription
audit_seq_no Unique identifier : the sequence number of the action.
spec_nameThe name the of shift specification.
old_start_date The previous start date of the shift specification assignment.
new_start_date The new start date of the shift specification assignment.
old_end_date The previous end date of the shift specification assignment.
new_end_date The new end date of the shift specification assignment.