Document toolboxDocument toolbox

sp826_smaudit_empholiday

Owned by Jason Andrew
Oct 02, 2024
1 min read

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.