Document toolboxDocument toolbox

14.1 sp824_smaudit_empskill

Owned by Billy Sewell (Unlicensed)
Jan 26, 2024

This table records ServiceManager user updates to the skills 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)
resource_idvarchar2(30) (error)
old_startdate (tick)
new_startdate (tick)
old_enddate (tick)
new_enddate (tick)
old_skill_level number(2) (tick)
new_skill_level number(2) (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.
resource_id The identifier of the skill type.
old_start_dateThe previous start date of the skill assignment.
new_start_dateThe new start date of the skill assignment.
old_end_date The previous end date of the skill assignment.
new_end_date The new end date of the skill assignment.
old_skill_level The previous level of the skill assignment.
old_skill_level The new level of the skill assignment.