Document toolboxDocument toolbox

14.1 sp826_smaudit_empholiday

Owned by Billy Sewell (Unlicensed)
Jan 26, 2024

This table records ServiceManager user updates to the Public holiday 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)

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 of the public holiday set.